Error running backup_xi.sh script

[Sampath.Basireddy]

Am getting below error when running backup_xi.sh script. Please help!!

Code: Select all

Backing up NagiosQL...
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/share/perfdata/brpsssotst01.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/int01aumsint01.ux.corp.local/Main_Memory_Usage.rrd: file changed as we read it
tar: /usr/local/nagios/share/perfdata/int01aumsint01.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/brmsappcaa21.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/brpsappqec2.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/stg01brmsapp01.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/brmsapppre20.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/stg01brmsint01.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/qen02brwfaapp01.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/breaappqeb1.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/val01brmsben02.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/qen01brwfaapp01.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/bratappsb1.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/brgswebcab2.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/pre01brmsmsg04.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/vbrdbs29.ux.corp.local/Load.rrd: file changed as we read it
tar: /usr/local/nagios/share/perfdata/vbrdbs29.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/vbrdbs26.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/brfrwebcaa2.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/oxddev1-scan.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/share/perfdata/slejappls1.ux.corp.local: file changed as we read it
tar: /usr/local/nagios/nagiosxi/var/event_handler.lock: File removed before we read it
tar: /usr/local/nagios/nagiosxi/var/eventman.log: file changed as we read it
tar: /usr/local/nagios/nagiosxi/var: file changed as we read it
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
Copying ramdisk configuration...
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up the SNMP trap interface configuration files...
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up Nagvis...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 144: "Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed" when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

[Sampath.Basireddy]

Checked the passwords as suggested in a different post:

Code: Select all

root@nagios1:[/store/mysql/nagiosxi]: mysql -uroot -pnagiosxi
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4720828
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> quit
Bye

Code: Select all

root@nagios1:[/store/mysql/nagiosxi]: mysql -unagiosxi -pn@gweb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4720850
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> Ctrl-C -- exit!
Aborted

Code: Select all

root@nagios1:[/store/mysql/nagiosxi]: mysql -undoutils -pn@gweb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4720853
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> Ctrl-C -- exit!
Aborted
root@brnagios1:[/store/mysql/nagiosxi]:

Also, the disk has enough space:

Code: Select all

root@nagios1:[/store/mysql/nagiosxi]: df -h /store
Filesystem                    Size  Used Avail Use% Mounted on
/dev/mapper/vg_apps-lv_store   34G   21G   14G  61% /store

[scottwilkerson]

There is a crashed table in the database that needs to be repaired.

Run the following procedure
https://assets.nagios.com/downloads/nag ... tabase.pdf

[Sampath.Basireddy]

Thanks @scottwilkerson, looks good now. Please close this topic.

[scottwilkerson]

Thanks @scottwilkerson, looks good now. Please close this topic.

Great!

Locking thread