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

WARNING: nonstandard use of \\ in a string literal - zabbix-2.0.2 + postgresql

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.2
    • Fix Version/s: 2.0.11, 2.2.2, 2.3.0
    • Component/s: Proxy (P), Server (S)
    • Environment:
      Scientific Linux release 6.3 (Carbon)
      postgresql92-9.2-beta4_1PGDG.rhel6.x86_64
      zabbix-proxy

      Description

      cut from debug log of zabbix-proxy:

       29846:20120831:093726.059 query [txnlev:1] [begin;]
       29846:20120831:093726.059 In DCmass_proxy_add_history()
       29846:20120831:093726.060 query [txnlev:1] [insert into proxy_history (itemid,clock,ns,value,status) values (23781,1346391441,904778055,'99.933775',0),(23661,1346391441,905176630,'0.000000',0),(23541,1346391441,905587324,'0.597015',0),(23421,1346391441,905979616,'94.204979',0),(23841,1346391441,907285562,'{
      	"data":[
      		{
      			"{#IFNAME}":"lo"},
      		{
      			"{#IFNAME}":"eth0"},
      		{
      			"{#IFNAME}":"eth1"},
      		{
      			"{#IFNAME}":"venet0"}]}',0),(23782,1346391442,909865709,'0.000000',0),(23662,1346391442,910839557,'0.000000',0),(23842,1346391442,912319331,'{
      	"data":[
      		{
      			"{#FSNAME}":"\\/",
      			"{#FSTYPE}":"ext3"},
      		{
      			"{#FSNAME}":"\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/proc\\/bus\\/usb",
      			"{#FSTYPE}":"usbfs"},
      		{
      			"{#FSNAME}":"\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/boot",
      			"{#FSTYPE}":"ext2"},
      		{
      			"{#FSNAME}":"\\/dev\\/shm",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/401",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/401\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/401\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/402",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/402\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/402\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/401\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/401\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/401\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/403",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/403\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/403\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/402\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/402\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/404",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/404\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/404\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/403\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/403\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/405",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/405\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/405\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/404\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/406",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/406\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/406\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/404\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/405\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/405\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/405\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/406\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/406\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/406\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/410",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/410\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/410\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/410\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/410\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/410\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/411",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/411\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/411\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/411\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/411\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/411\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/407",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/407\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/407\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/407\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/407\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/407\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/408",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/408\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/408\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/408\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/408\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/408\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/409",
      			"{#FSTYPE}":"simfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/409\\/proc",
      			"{#FSTYPE}":"proc"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/409\\/sys",
      			"{#FSTYPE}":"sysfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/409\\/dev",
      			"{#FSTYPE}":"tmpfs"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/409\\/dev\\/pts",
      			"{#FSTYPE}":"devpts"},
      		{
      			"{#FSNAME}":"\\/vz\\/root\\/409\\/proc\\/sys\\/fs\\/binfmt_misc",
      			"{#FSTYPE}":"binfmt_misc"}]}',0),(23542,1346391442,912731552,'0.298458',0),(23902,1346391442,913194342,'868589568',0),(23482,1346391442,913641604,'1',0),(23663,1346391443,915720694,'0.000000',0),(23783,1346391443,916320170,'0.000000',0),(23423,1346391443,918359603,'1244475392',0),(23784,1346391444,920555567,'0.000000',0),(23664,1346391444,920970744,'0.016626',0),(23544,1346391444,922628816,'1346391444',0),(23964,1346391444,924782093,'891518558208',0),(23665,1346391445,925090834,'0.016626',0),(23785,1346391445,925522246,'0.000000',0),(23545,1346391445,929711368,'1072775168',0),(23903,1346391446,3127196,'238439161577',0);
      ]
      WARNING:  nonstandard use of \\ in a string literal
      LINE 10: ...91442,910839557,'0.000000',0),(23842,1346391442,912319331,'{
                                                                            ^
      HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
       29846:20120831:093726.062 End of DCmass_proxy_add_history()
      
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              umask00 Ilyas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: