-
Incident report
-
Resolution: Fixed
-
Blocker
-
1.8.6
-
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