[ZBX-4194] query failed: missing semicolon or break Created: 2011 Oct 03  Updated: 2017 May 30  Resolved: 2011 Oct 04

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.8.6, 1.8.7, 1.8.8
Fix Version/s: 1.8.9

Type: Incident report Priority: Blocker
Reporter: Mike Davis Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: distributed, query
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

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.


Attachments: Text File zabbix_log_query_failed.txt    
Issue Links:
Duplicate

 Description   

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



 Comments   
Comment by Aleksandrs Saveljevs [ 2011 Oct 04 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4194 .

Mike, apparently, you were the only one running 1.8.6 or higher with a three digit node number. I shall be doing that, too, now.

Comment by Aleksandrs Saveljevs [ 2011 Oct 05 ]

Fixed in pre-1.8.9 in r22146.

Generated at Thu Apr 25 13:26:34 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.