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

Syntax error logged in systemlog by PostgreSQL

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • None
    • Frontend (F)
    • None

      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"
      

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

              Created:
              Updated:
              Resolved: