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

Postrgre SQL query problem.

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6
    • Fix Version/s: 1.6
    • Component/s: Frontend (F)
    • Labels:
      None

      Description

      Using 1.6.2pre on ubuntu (updated from 1.6) with postgres-8.3
      When I try to delete a template I get this errormessage:

      Code:
      2009-01-15 13:36:39 CET ERROR: operator does not exist: character varying = integer at character 78
      2009-01-15 13:36:39 CET HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
      2009-01-15 13:36:39 CET STATEMENT: SELECT DISTINCT actionid FROM conditions WHERE conditiontype=1 AND (value IN (10102))
      2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
      2009-01-15 13:36:39 CET STATEMENT: UPDATE actions SET status=1 WHERE (actionid IN (-1))
      2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
      2009-01-15 13:36:39 CET STATEMENT: DELETE FROM conditions WHERE conditiontype=1 AND (value IN (10102))
      2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
      2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts_profiles WHERE (hostid IN (10102))
      2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
      2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts_profiles_ext WHERE (hostid IN (10102))
      2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
      2009-01-15 13:36:39 CET STATEMENT: SELECT DISTINCT ht.* FROM httptest ht, applications ap WHERE (ap.hostid IN (10102)) AND ht.applicationid=ap.applicationid
      2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
      2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts WHERE (hostid IN (10102))

      http://www.zabbix.com/forum/showthread.php?t=11519

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            aly Artem Suharev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: