Hello all
The company im working for is expanding to a new remote office, so I wanted to convert our existing Zabbix Server 1.6.4 to a master note - so I changed zabbix_server.conf "NodeID=1" and executed the command "zabbix_server -n 1 -c /etc/zabbix/zabbix_server.conf" and it began "Converting tables .............". After ~2 hours I lost all connections to the server, and hard reboot was my only option and now i cant login in zabbix.
Im stuck with some database error, i think:
ZABBIX_SERVER.LOG:
2682:20090517:092607 Starting zabbix_server. ZABBIX 1.6.4.
2682:20090517:092608 **** Enabled features ****
2682:20090517:092608 SNMP monitoring: YES
2682:20090517:092608 WEB monitoring: YES
2682:20090517:092608 Jabber notifications: YES
2682:20090517:092608 ODBC: NO
2682:20090517:092608 IPv6 support: YES
2682:20090517:092608 **************************
2682:20090517:092608 [Z3001] Connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
/usr/sbin/zabbix_server [2789]: Semaphore [0] error in semctl(SETVAL)
/usr/sbin/zabbix_server [2789]: Unable to create mutex for log file
SYSLOG:
May 17 09:26:13 DKZA01 mysqld[2223]: InnoDB: Apply batch completed
May 17 09:26:13 DKZA01 mysqld[2223]: InnoDB: Starting in background the rollback of uncommitted transactions
May 17 09:26:13 DKZA01 mysqld[2223]: 090517 9:26:13 InnoDB: Rolling back trx with id 0 1221384230, 5598832 rows to undo
May 17 09:26:13 DKZA01 mysqld[2223]:
May 17 09:26:13 DKZA01 mysqld[2223]: InnoDB: Progress in percents: 1090517 9:26:13 InnoDB: Started; log sequence number 95 713288259
May 17 09:26:13 DKZA01 mysqld[2223]: 090517 9:26:13 [Note] /usr/sbin/mysqld: ready for connections.
May 17 09:26:13 DKZA01 mysqld[2223]: Version: '5.0.75-1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
MySQL is running and I can select tables from the zabbix database manually. So if anyone knows how to fix this or how to revert the effects of the "zabbix_server -n 1 -c /etc/zabbix/zabbix_server.conf" command it would be much appreciated.
Best Regards
Ivan
The company im working for is expanding to a new remote office, so I wanted to convert our existing Zabbix Server 1.6.4 to a master note - so I changed zabbix_server.conf "NodeID=1" and executed the command "zabbix_server -n 1 -c /etc/zabbix/zabbix_server.conf" and it began "Converting tables .............". After ~2 hours I lost all connections to the server, and hard reboot was my only option and now i cant login in zabbix.
Im stuck with some database error, i think:
ZABBIX_SERVER.LOG:
2682:20090517:092607 Starting zabbix_server. ZABBIX 1.6.4.
2682:20090517:092608 **** Enabled features ****
2682:20090517:092608 SNMP monitoring: YES
2682:20090517:092608 WEB monitoring: YES
2682:20090517:092608 Jabber notifications: YES
2682:20090517:092608 ODBC: NO
2682:20090517:092608 IPv6 support: YES
2682:20090517:092608 **************************
2682:20090517:092608 [Z3001] Connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
/usr/sbin/zabbix_server [2789]: Semaphore [0] error in semctl(SETVAL)
/usr/sbin/zabbix_server [2789]: Unable to create mutex for log file
SYSLOG:
May 17 09:26:13 DKZA01 mysqld[2223]: InnoDB: Apply batch completed
May 17 09:26:13 DKZA01 mysqld[2223]: InnoDB: Starting in background the rollback of uncommitted transactions
May 17 09:26:13 DKZA01 mysqld[2223]: 090517 9:26:13 InnoDB: Rolling back trx with id 0 1221384230, 5598832 rows to undo
May 17 09:26:13 DKZA01 mysqld[2223]:
May 17 09:26:13 DKZA01 mysqld[2223]: InnoDB: Progress in percents: 1090517 9:26:13 InnoDB: Started; log sequence number 95 713288259
May 17 09:26:13 DKZA01 mysqld[2223]: 090517 9:26:13 [Note] /usr/sbin/mysqld: ready for connections.
May 17 09:26:13 DKZA01 mysqld[2223]: Version: '5.0.75-1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
MySQL is running and I can select tables from the zabbix database manually. So if anyone knows how to fix this or how to revert the effects of the "zabbix_server -n 1 -c /etc/zabbix/zabbix_server.conf" command it would be much appreciated.
Best Regards
Ivan