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

Truncate queries to DB

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 1.8.6
    • 1.8.6
    • Server (S)
    • None
    • PostgreSQL, Gentoo 38-r4,

      9895:20110513:203217.607 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: unterminated quoted string at or near "'bs00711.is74."
      LINE 1: ...is74.ru' and i.key_='ifOperStatus.15') or (h.host='bs00711.i...
      ^
      [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime from hosts h,items i where h.hostid=i.hostid and h.status=0 and i.status=0 and ((h.host='bs00711.is74.ru' and i.key_='ifOperStatus.26') or (h.host='bs00711.is74.ru' and i.key_='ifOperStatus.24') or (h.host='bs00711.is74.ru' and i.key_='ifOperStatus.23') or (h.host='bs00711.is74.ru' and i.key_='ifOperStatus.22') or (h.host='bs00711.is74.ru' and i.key_='ifOperStatus.21') or (h.host='bs00711.is74.ru' and i.key_='ifOperStatus.20') or (h.host='bs00711.is74.ru' and i.key_='ifOperStatus.19') or (h.host='bs00711.is
      9895:20110513:203217.611 Item [bs00711.is74.ru:ifaces.up] is not supported
      9895:20110513:203217.614 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: unterminated quoted string at or near "'bs01623.is74."
      LINE 1: ...is74.ru' and i.key_='ifOperStatus.15') or (h.host='bs01623.i...
      ^
      [select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime from hosts h,items i where h.hostid=i.hostid and h.status=0 and i.status=0 and ((h.host='bs01623.is74.ru' and i.key_='ifOperStatus.26') or (h.host='bs01623.is74.ru' and i.key_='ifOperStatus.24') or (h.host='bs01623.is74.ru' and i.key_='ifOperStatus.23') or (h.host='bs01623.is74.ru' and i.key_='ifOperStatus.22') or (h.host='bs01623.is74.ru' and i.key_='ifOperStatus.21') or (h.host='bs01623.is74.ru' and i.key_='ifOperStatus.20') or (h.host='bs01623.is74.ru' and i.key_='ifOperStatus.19') or (h.host='bs01623.is

      after rev19527

            Unassigned Unassigned
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: