Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-4194

query failed: missing semicolon or break

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.8.6, 1.8.7, 1.8.8
    • Fix Version/s: 1.8.9
    • Component/s: Server (S)
    • Labels:
    • Environment:

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mikedavis Mike Davis
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: