Nagios Support Forum

Posted: **Wed Oct 16, 2013 2:43 pm**

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.

Posted: **Wed Oct 16, 2013 3:52 pm**

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

Posted: **Thu Oct 17, 2013 10:53 am**

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

Posted: **Thu Oct 17, 2013 3:45 pm**

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

Posted: **Wed Oct 23, 2013 3:30 pm**

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.

Posted: **Wed Oct 23, 2013 3:35 pm**

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

Nagios Support Forum

backup command hanging

backup command hanging

Re: backup command hanging

Re: backup command hanging

Re: backup command hanging

Re: backup command hanging

Re: backup command hanging