[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: 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: | zabbix_log_query_failed.txt | ||||
Issue Links: |
|
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] 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. |