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

Exiting trigger causes error.

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Won't fix
    • 1.8.3
    • 1.8.4
    • Frontend (F)
    • None
    • Centos 5.5, PHP 5.3.3, Postgres 8.4.4.

    Description

      After upgrading to version 1.8.3 can not create new groups.

      In the browser displays the following error:

      • include(schema.inc.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory[/etc/zabbix/db.inc.php:944]
      • include() [<a href='function.include'>function.include</a>]: Failed opening 'schema.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php')[/etc/zabbix/db.inc.php:944]
      • pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: function max() does not exist at character 8 HINT: No function matches the given name and argument types. You might need to add explicit type casts.[/etc/zabbix/db.inc.php:408]
      • Error in query [SELECT max() AS id FROM groups WHERE >=0 AND <=99999999999] [ERROR: function max() does not exist at character 8 HINT: No function matches the given name and argument types. You might need to add explicit type casts.]
      • pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/etc/zabbix/db.inc.php:550]
      • pg_free_result() expects parameter 1 to be resource, boolean given[/etc/zabbix/db.inc.php:552]
      • pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/etc/zabbix/db.inc.php:491]
      • Error in query [INSERT INTO ids (nodeid,table_name,field_name,nextid) VALUES (0,'groups','',1)] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      • DBEXECUTE_ERROR

      And in the log database:
      ERROR: function max() does not exist at character 8
      HINT: No function matches the given name and argument types. You might need to add explicit type casts.
      STATEMENT: SELECT max() AS id FROM groups WHERE >=0 AND <=99999999999
      ERROR: current transaction is aborted, commands ignored until end of transaction block
      STATEMENT: INSERT INTO ids (nodeid,table_name,field_name,nextid) VALUES (0,'groups','',1)

      In version 1.8.2 it works fine.

      Attachments

        Activity

          People

            Unassigned Unassigned
            weaselkkeper Jim Richardson
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: