backup issue

[cskang]

We are experiencing ERROR during backup.
We have two separate NagiosXI server running and the ERROR message getting from them are slightly different.

In first NagiosXI server, pg_dump failed due to some sort of permission problem - see attachment 'backupERROR-pg_dump.JPG'.
In second NagiosXI server, mysqldump failed - see attachment 'backupERROR-mysqldump.JPG'.

Is there any preventive measure that we should take?
Also, what action should we take to fix the error and backup NagiosXI?

Thanks in advance.

[scottwilkerson]

It looks like the system you are backing up has crashed tables in MySQL

Please run this procedure and perform the backup again
http://library.nagios.com/library/produ ... i-database

[cskang]

Hi Scott,
Thanks for the prompt response.
Yes, it looks like mysql database failed on one incident.

On the other incident, it looks like that mysql back has been passed and it went on to backup PostgressQL database.
But, pg_dump failed with the following ERROR message from pg_dump:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for relation xi_session
pg_dump: The command was: LOCK TABLE public.xi_session IN ACCESS SHARE MODE

Could you take a look at this error?

The pdf from the URL
http://library.nagios.com/library/produ ... i-database

handles only mysql table corruption and does not have anything to clear pg_dump error.

Thx.

[scottwilkerson]

Have you change postgres account information?

Can you run the following on that machine

Code: Select all

echo "vacuum;vacuum analyse;vacuum full;"|psql nagiosxi postgres

[cskang]

I did not change Postgres account, but let me ask my co-workers to make sure.

For the command you ask me to try, I got the following:

[root@localhost ~]# echo "vacuum;vacuum analyse;vacuum full;"|psql nagiosxi postgres
VACUUM
VACUUM
VACUUM
[root@localhost ~]#

[scottwilkerson]

What version of Nagios XI are you running?

[cskang]

Hi Scott,
We found the cause and we are looking into resolving it.
Thanks for the prompt support.

BTW, We are still running NagiosXI 1.7 currently.