backup command hanging

[sheld0r]

I'm attempting to backup my Nagios XI build, but it appears to hang at tar: Removing leading `/' from member names I came across a post where the possible cause could be database corruption *yikes* So I ran the following

psql nagiosxi nagiosxi
VACUUM;
VACUUM ANALYZE;
VACUUM FULL;
\q

Results:

Code: Select all

[root@nagios /]# psql nagiosxi nagiosxi
psql (8.4.13)
Type "help" for help.

nagiosxi=> VACUUM;
WARNING:  skipping "pg_authid" --- only superuser can vacuum it
WARNING:  skipping "pg_database" --- only superuser can vacuum it
WARNING:  skipping "pg_tablespace" --- only superuser can vacuum it
WARNING:  skipping "pg_pltemplate" --- only superuser can vacuum it
WARNING:  skipping "pg_shdepend" --- only superuser can vacuum it
WARNING:  skipping "pg_shdescription" --- only superuser can vacuum it
WARNING:  skipping "pg_auth_members" --- only superuser can vacuum it
VACUUM
nagiosxi=> VACUUM ANALYZE;
WARNING:  skipping "pg_authid" --- only superuser can vacuum it
WARNING:  skipping "pg_database" --- only superuser can vacuum it
WARNING:  skipping "pg_tablespace" --- only superuser can vacuum it
WARNING:  skipping "pg_pltemplate" --- only superuser can vacuum it
WARNING:  skipping "pg_shdepend" --- only superuser can vacuum it
WARNING:  skipping "pg_shdescription" --- only superuser can vacuum it
WARNING:  skipping "pg_auth_members" --- only superuser can vacuum it
VACUUM
nagiosxi=> VACUUM FULL;
WARNING:  skipping "pg_authid" --- only superuser can vacuum it
WARNING:  skipping "pg_database" --- only superuser can vacuum it
WARNING:  skipping "pg_tablespace" --- only superuser can vacuum it
WARNING:  skipping "pg_pltemplate" --- only superuser can vacuum it
WARNING:  skipping "pg_shdepend" --- only superuser can vacuum it
WARNING:  skipping "pg_shdescription" --- only superuser can vacuum it
WARNING:  skipping "pg_auth_members" --- only superuser can vacuum it
VACUUM

Not sure where to go from here.

[sreinhardt]

There is always the mysql repairs as well. Do you have a log pointing to where exactly in the process of backup it failed? http://assets.nagios.com/downloads/nagi ... tabase.pdf

[sheld0r]

I ran the mysql repairs too and it's still hanging at tar: Removing leading `/' from member names

[sreinhardt]

Are you running the backup from the /usr/local/nagiosxi/scripts directory?

[sheld0r]

Yes I am. It actually finally ran, it just took a long time. Any reason for the delay? I would say about 5+ hours. We only have 50 hosts and 266 services running.

[abrist]

What is your disk i/o speed and disk usage? For that number of objects it should not take that long.