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

Syntax error logged in systemlog by PostgreSQL

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:
      None

      Description

      In setting up Web monitoring, an syntax error logged in systemlog.
      This looks same as ZBX-2947.
      Cause in version 2.2.7.

      Logged messages is follows:

      Aug 24 14:51:16 pro-mon11 postgres[5670]: [5-1] < 2016-08-24 14:51:16.579 JST >ERROR:  ")"?????????????(???? 115) Aug 24 14:51:16 pro-mon11 postgres[5670]: [5-2] < 2016-08-24 14:51:16.579 JST >???????:  INSERT INTO profiles (profileid, userid, idx, value_int, type, idx2) VALUES (871, 1, 'web.latest.toggle', '1', 2, )
      

      Follows are extracted logs from /var/log/httpd/access.log.

      10.176.101.85 - - [24/Aug/2016:18:14:47 +0900] "GET /zabbix/jsLoader.php?ver=2.2.7-1&lang=ja_JP&showGuiMessaging=1 HTTP/1.1" 304 - "http://pro-mon11/zabbix/httpconf.php?hostid=10161&sid=14b6f9ff34dade6a" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36"
      10.176.101.85 - - [24/Aug/2016:18:14:47 +0900] "GET /zabbix/jsLoader.php?ver=2.2.7-1&lang=ja_JP&showGuiMessaging=1&files[]=servercheck.js HTTP/1.1" 304 - "http://pro-mon11/zabbix/httpconf.php?hostid=10161&sid=14b6f9ff34dade6a" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36"
      10.176.101.85 - - [24/Aug/2016:18:14:47 +0900] "GET /zabbix/httpconf.php?hostid=10161&sid=14b6f9ff34dade6a HTTP/1.1" 200 23144 "http://pro-mon11/zabbix/templates.php?form=update&templateid=10161&groupid=1&sid=14b6f9ff34dade6a" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36"
      10.176.101.85 - - [24/Aug/2016:18:14:48 +0900] "POST /zabbix/jsrpc.php?output=json-rpc HTTP/1.1" 200 383 "http://pro-mon11/zabbix/httpconf.php?hostid=10161&sid=14b6f9ff34dade6a" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36"
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              zabbix.dev Zabbix Development Team
              Reporter:
              JunichiKarikomi Junichi Karikomi
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: