SQL query errors involving a comma.

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Blocker
    • None
    • Affects Version/s: 1.8.8
    • Component/s: Server (S)
    • Environment:
      RHEL5.4_x86_64, postrgres 8.1.23, zabbix 1.8.8.

      Here's a sample of the zabbix_server.log errors I'm getting.

      [select distinct t.triggerid,t.type,t.value,t.error,t.expression,f.itemid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and t.status=0 and f.itemid in (22273,22193,22168,22278,22438,22198,22468,22484,23308,22539,22274,22169,22434,22344,22254,23304,22554,22374,22464,22495,23305,22555,22345,22255,22465,22225,23391,22496,22466,22286,22556,22256,22347,22257,22557,23335,23423,22258,22558,22348,22229,22559,22499,22379,22349,22259,22500,22350,22560,22290,22440,22260,22561,22261,22351,22501,22441,23311,22231,23399,22262,22232,22202,22472,22562,22352,22442,22233,22443,22473,22203,22563,22383,22474,22564,22204,22384,22444,22354,22475,22565,22325,22235,22445,22476,22566,22356,22236,23343,22567,22357,22237,22568,23318,22238,22328,22358,23375,22269,22179,22359,22330,22450,22240,22390,22241,22451,22481,22361,22391,23439,23407,23322,22332,22362,22242,22452,22542,22183,22543,22243,22393,22453,22363,23351,22394,23383,22338,22458,22199,22569,22469,23309,22284,22224,22404,22405,22285,22287,22288,22228,22289,22410,22411,22291,22292,22413,22293,22294,22414,22415,22416,22477,22478,22479,22480,22180,22181,22422,22182,22184,22185,22186,22187,22488,22494,22375,22315,22536,22171,22166,22276,22376,22377,22378,22300,22380,22540,22275,22435,23307,22277,22437,22482,22537,22323,22503,22324,22505,22331,22386,22512,22392,22327,22513,22208,22305,22195,22196,22306,22307,22467,22197,22245,22545,22365,22485,22455,22456,22336,23296,22366,22546,22486,22367,22457,22247,22397,22547,23431,22335,22515,22216,22516,22517,22217,22572,22302,22471,22571,22381,22570,22470,22200,22192,22497,22207,22551,22299,22314,23314,22449,22395) order by t.triggerid]
      25865:20111007:130149.116 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at or near ","
      LINE 1: ...192,1317819600,2,1310965511,1310965511,1310965511),(22497,13...

            Assignee:
            Unassigned
            Reporter:
            Jason Zejfert
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: