Ad Widget

Collapse

Ошибка при импорте графиков

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • costas
    Senior Member
    • Aug 2009
    • 201

    #1

    Ошибка при импорте графиков

    CentOS 5.4 x86_64
    Zabbix Server v1.8.2 (revision 10556) (27 January 2010)
    PostgreSQL 8.4.2

    При импорте шаблона с графиками вылетает ошибка:

    pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: invalid input syntax for type boolean: "if1" at character 104[/var/www/vhosts/zabbix/html/include/db.inc.php:408]
    Error in query [SELECT DISTINCT g.* FROM graphs g WHERE ((g.graphid BETWEEN 000000000000000 AND 099999999999999)) AND 'if1'] [ERROR: invalid input syntax for type boolean: "if1" at character 104]
    pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/vhosts/zabbix/html/include/db.inc.php:558]
    pg_free_result(): supplied argument is not a valid PostgreSQL result resource[/var/www/vhosts/zabbix/html/include/db.inc.php:560]
    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[/var/www/vhosts/zabbix/html/include/db.inc.php:408]
    Error in query [SELECT DISTINCT h.* FROM hosts h WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (0,1) AND h.host='t_switch_50_copy'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
    pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/vhosts/zabbix/html/include/db.inc.php:558]
    pg_free_result(): supplied argument is not a valid PostgreSQL result resource[/var/www/vhosts/zabbix/html/include/db.inc.php:560]
    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[/var/www/vhosts/zabbix/html/include/db.inc.php:408]
    Error in query [SELECT h.* FROM hosts h WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status=3 AND h.host='t_switch_50_copy'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
    pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/vhosts/zabbix/html/include/db.inc.php:558]
    pg_free_result(): supplied argument is not a valid PostgreSQL result resource[/var/www/vhosts/zabbix/html/include/db.inc.php:560]
    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[/var/www/vhosts/zabbix/html/include/db.inc.php:408]
    Error in query [SELECT DISTINCT h.* FROM hosts h WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (0,1) AND h.host='t_switch_50_copy'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
    pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/vhosts/zabbix/html/include/db.inc.php:558]
    pg_free_result(): supplied argument is not a valid PostgreSQL result resource[/var/www/vhosts/zabbix/html/include/db.inc.php:560]
    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[/var/www/vhosts/zabbix/html/include/db.inc.php:408]
    Error in query [SELECT h.* FROM hosts h WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status=3 AND h.host='t_switch_50_copy'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
    pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/vhosts/zabbix/html/include/db.inc.php:558]
    pg_free_result(): supplied argument is not a valid PostgreSQL result resource[/var/www/vhosts/zabbix/html/include/db.inc.php:560]
    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[/var/www/vhosts/zabbix/html/include/db.inc.php:408]
    Error in query [SELECT DISTINCT h.* FROM hosts h WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (0,1) AND h.host='t_switch_50_copy'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
    pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/vhosts/zabbix/html/include/db.inc.php:558]
    pg_free_result(): supplied argument is not a valid PostgreSQL result resource[/var/www/vhosts/zabbix/html/include/db.inc.php:560]
    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[/var/www/vhosts/zabbix/html/include/db.inc.php:408]
    Error in query [SELECT h.* FROM hosts h WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status=3 AND h.host='t_switch_50_copy'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
    pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/vhosts/zabbix/html/include/db.inc.php:558]
    pg_free_result(): supplied argument is not a valid PostgreSQL result resource[/var/www/vhosts/zabbix/html/include/db.inc.php:560]
    Missing items for graph "if1"
    Тоже самое если просто сделать экспорт готового тимплита и этот же файл импортировать.
    Last edited by costas; 23-03-2010, 09:54.
    CentOS-5.5 i386, Zabbix 1.8.4 (stable), MySQL 5.0.92, PHP 5.2.17 (cli)

    ...эта проверка бесполезная, вредная, и она зло.
  • costas
    Senior Member
    • Aug 2009
    • 201

    #2
    Собрал от сегодняшнего числа, проблема исчезла, только апдейт базы не проходит и дамп базы в чистую инсталяцию тож, получается что апдейтить с версии на версии невозможно?

    И как будут обстоять дела с выходом 1.8.2? С версии 1.8.1 обновиться без потери данных не получится?
    CentOS-5.5 i386, Zabbix 1.8.4 (stable), MySQL 5.0.92, PHP 5.2.17 (cli)

    ...эта проверка бесполезная, вредная, и она зло.

    Comment

    Working...