-
Incident report
-
Resolution: Fixed
-
Blocker
-
1.8.6, 1.8.7, 1.8.8
-
Two Environment Types:
Debian - Linux version 2.6.32-bpo.5-amd64 (Debian 2.6.32-15~bpo50+1) ([email protected]) (gcc version 4.3.2 (Debian 4.3.2-1.1) ) #1 SMP Fri Jun 11 08:42:31 UTC 2010
Ubuntu - Linux version 2.6.32-24-server (buildd@yellow) (gcc version 4.4.3 (Ubuntu 4.4.3-4ubuntu5) ) #39-Ubuntu SMP Wed Jul 28 06:21:40 UTC 2010
These are running on mysql 5.1.58 installed in /opt/mysql-5.1.58 and here is the configure command I used to build.
./configure --enable-server --enable-agent --with-mysql=/opt/mysql-5.1.58/bin/mysql_config --with-net-snmp --with-libcurl
These are zabbix servers running in distributed mode.Two Environment Types: Debian - Linux version 2.6.32-bpo.5-amd64 (Debian 2.6.32-15~bpo50+1) ( [email protected] ) (gcc version 4.3.2 (Debian 4.3.2-1.1) ) #1 SMP Fri Jun 11 08:42:31 UTC 2010 Ubuntu - Linux version 2.6.32-24-server ( buildd@yellow ) (gcc version 4.4.3 (Ubuntu 4.4.3-4ubuntu5) ) #39-Ubuntu SMP Wed Jul 28 06:21:40 UTC 2010 These are running on mysql 5.1.58 installed in /opt/mysql-5.1.58 and here is the configure command I used to build. ./configure --enable-server --enable-agent --with-mysql=/opt/mysql-5.1.58/bin/mysql_config --with-net-snmp --with-libcurl These are zabbix servers running in distributed mode.
Upgrade from 1.8.5 to 1.8.
{6,7,8}has a bug with the last value queries. There is a missing semicolon or a break. After upgrading, I immediately get the following errors:
4872:20111003:074928.225 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'items set lastclock=1317653367,prevorgvalue='58802703590.000000',prevvalue=lastv' at line 1 [update items set lastclock=1317653365,prevorgvalue='1703127541535.000000',prevvalue=lastvalue,lastvalue='17.171170' where itemid=10610600000018440update items set lastclock=1317653367,prevorgvalue='58802703590.000000',prevvalue=lastvalue,lastvalue='1967.664167' where itemid=10610600000018442update items set lastclock=1317653368,prevorgvalue='90080447591.000000',prevvalue=lastvalue,lastvalue='10.273673' where itemid=10610600000018443update items set lastclock=1317653365,prevorgvalue='58802700681.000000',prevvalue=lastvalue,lastvalue='1969.819588' where itemid=10610600000018445update items set lastclock=1317653367,prevvalue=lastvalue,lastvalue='0.000000' where itemid=10610600000018467update items set lastclock=1317653368,prevvalue=lastvalue,lastvalue='0.000000' where itemid=10610600000018468update items set lastclock=1317653364,prevvalue=lastvalue,lastvalue='0.016636' where itemid=10610600000018474update items set lastclock=1317653364,prevvalue=lastvalue,lastvalue='75.598191' where itemid=10610600000018514update items set lastclock=1317653365,prevvalue=lastvalue,lastvalue='24.401809' where itemid=10610600000018515update items set lastclock=1317653367,prevvalue=lastvalue,lastvalue='6431547392' where itemid=10610600000018517update items set lastclock=1317653368,prevvalue=lastvalue,lastvalue='19925299200' where itemid=10610600000018518]
4873:20111003:074933.227 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'items set lastclock=1317653372,prevorgvalue='58802712303.000000',prevvalue=lastv' at line 1 [update items set lastclock=1317653370,prevorgvalue='1703127541535.000000',prevvalue=lastvalue,lastvalue='17.170907' where itemid=10610600000018440update items set lastclock=1317653372,prevorgvalue='58802712303.000000',prevvalue=lastvalue,lastvalue='1967.196258' where itemid=10610600000018442update items set lastclock=1317653373,prevorgvalue='90080447689.000000',prevvalue=lastvalue,lastvalue='10.276075' where itemid=10610600000018443update items set lastclock=1317653370,prevorgvalue='58802709404.000000',prevvalue=lastvalue,lastvalue='1969.806333' where itemid=10610600000018445update items set lastclock=1317653371,prevvalue=lastvalue,lastvalue='130' where itemid=10610600000018461update items set lastclock=1317653373,prevvalue=lastvalue,lastvalue='0.000000' where itemid=10610600000018468update items set lastclock=1317653369,prevvalue=lastvalue,lastvalue='0.000000' where itemid=10610600000018469update items set lastclock=1317653370,prevvalue=lastvalue,lastvalue='99.858604' where itemid=10610600000018470update items set lastclock=1317653371,prevvalue=lastvalue,lastvalue='0.016638' where itemid=10610600000018471update items set lastclock=1317653372,prevvalue=lastvalue,lastvalue='0.066550' where itemid=10610600000018472update items set lastclock=1317653373,prevvalue=lastvalue,lastvalue='0.033281' where itemid=10610600000018473update items set lastclock=1317653369,prevvalue=lastvalue,lastvalue='1620974' where itemid=10610600000018489update items set lastclock=1317653370,prevvalue=lastvalue,lastvalue='93.962099' where itemid=10610600000018490update items set lastclock=1317653372,prevvalue=lastvalue,lastvalue='1620974' where itemid=10610600000018492update items set lastclock=1317653373,prevvalue=lastvalue,lastvalue='93.962099' where itemid=10610600000018493update items set lastclock=1317653369,prevvalue=lastvalue,lastvalue='75.598160' where itemid=10610600000018519update items set lastclock=1317653370,prevvalue=lastvalue,lastvalue='24.401840' where itemid=10610600000018520update items set lastclock=1317653372,prevvalue=lastvalue,lastvalue='6431555584' where itemid=10610600000018522update items set lastclock=1317653373,prevvalue=lastvalue,lastvalue='19925291008' where itemid=10610600000018523]
I have attached an excerpt of the log file from today currently running 1.8.8