-
Type:
Incident report
-
Resolution: Fixed
-
Priority:
Blocker
-
Affects Version/s: 1.9.8 (beta)
-
Component/s: Server (S)
-
Environment:FreeBSD srv-zabbix01.trendeiras 8.2-RELEASE-p4 FreeBSD 8.2-RELEASE-p4 #5: Mon Dec 5 07:57:08 BRST 2011 [email protected]:/usr/obj/usr/src/sys/TREND amd64
FreeBSD inside vmware, typical instalation.
(root@srv-zabbix01 - ~ @14:29:40)
1: pkg_info |grep mysql
mysql-client-5.5.17 Multithreaded SQL database (client)
mysql-server-5.5.17 Multithreaded SQL database (server)
php5-mysql-5.3.8 The mysql shared extension for php
./configure --prefix=/usr/local --sysconfdir=/usr/local/etc/zabbix --enable-server --enable-agent --with-mysql --with-libcurl --with-net-snmp --with-ssh2 --with-ldap --with-openipmiFreeBSD srv-zabbix01.trendeiras 8.2-RELEASE-p4 FreeBSD 8.2-RELEASE-p4 #5: Mon Dec 5 07:57:08 BRST 2011 [email protected] :/usr/obj/usr/src/sys/TREND amd64 FreeBSD inside vmware, typical instalation. ( root@srv-zabbix01 - ~ @14:29:40) 1: pkg_info |grep mysql mysql-client-5.5.17 Multithreaded SQL database (client) mysql-server-5.5.17 Multithreaded SQL database (server) php5-mysql-5.3.8 The mysql shared extension for php ./configure --prefix=/usr/local --sysconfdir=/usr/local/etc/zabbix --enable-server --enable-agent --with-mysql --with-libcurl --with-net-snmp --with-ssh2 --with-ldap --with-openipmi
Strange behavior of log /tmp/zabbix_server.log
I always get strange network errors when running Zabbix on FreeBSD.
Below the error:
98798:20111205:143001.507 [Z3005] query failed: [1690] BIGINT UNSIGNED value is out of range in '(`zabbix`.`ids`.`nextid` + -(5256))' [update ids set nextid=nextid+-5256 where nodeid=0 and table_name='events' and field_name='eventid']
zabbix_server [98798]: ERROR file:db.c,line:1464 Something impossible has just happened.
98798:20111205:143031.469 [Z3005] query failed: [1690] BIGINT UNSIGNED value is out of range in '(`zabbix`.`ids`.`nextid` + -(5256))' [update ids set nextid=nextid+-5256 where nodeid=0 and table_name='events' and field_name='eventid']