zabbix 1.7.x import problem

[Danila]

Import crashes on importing GRAPHS info (hosts without graphs are being importred successfully)

Error is:

* Added new host [Template_AP_Canopy]
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* Added new item Template_AP_Canopy:ifInOctets1
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* Added new item Template_AP_Canopy:ifInUcastPkts.1
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* Added new item Template_AP_Canopy:ifOutOctets1
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* Added new item Template_AP_Canopy:ifOutUcastPkts.1
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* Undefined index: hostid[/var/www/new/api/classes/class.citem.php:549]
* pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: ошибка синтаксиса в конце ввода LINE 1: ...temid FROM items i WHERE i.key_='ifOutOctets1' AND i.hostid= ^[/var/www/new/include/db.inc.php:406]
* Error in query [SELECT DISTINCT i.itemid FROM items i WHERE i.key_='ifOutOctets1' AND i.hostid=] [ERROR: ошибка синтаксиса в конце ввода LINE 1: ...temid FROM items i WHERE i.key_='ifOutOctets1' AND i.hostid= ^]
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object[/var/www/new/include/export.inc.php:847]
* Undefined index: hostid[/var/www/new/api/classes/class.citem.php:549]
* pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: ошибка синтаксиса в конце ввода LINE 1: ...itemid FROM items i WHERE i.key_='ifInOctets1' AND i.hostid= ^[/var/www/new/include/db.inc.php:406]
* Error in query [SELECT DISTINCT i.itemid FROM items i WHERE i.key_='ifInOctets1' AND i.hostid=] [ERROR: ошибка синтаксиса в конце ввода LINE 1: ...itemid FROM items i WHERE i.key_='ifInOctets1' AND i.hostid= ^]
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object[/var/www/new/include/export.inc.php:847]
* 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/new/include/db.inc.php:406]
* Error in query [SELECT g.graphid FROM graphs g, graphs_items gi, items i WHERE g.graphid=gi.graphid AND gi.itemid=i.itemid AND g.name='Ethernet Traffic' AND i.hostid=10049] [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/new/include/db.inc.php:547]
* Undefined index: hostid[/var/www/new/api/classes/class.citem.php:549]
* pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: ошибка синтаксиса в конце ввода LINE 1: ...d FROM items i WHERE i.key_='ifOutUcastPkts.1' AND i.hostid= ^[/var/www/new/include/db.inc.php:406]
* Error in query [SELECT DISTINCT i.itemid FROM items i WHERE i.key_='ifOutUcastPkts.1' AND i.hostid=] [ERROR: ошибка синтаксиса в конце ввода LINE 1: ...d FROM items i WHERE i.key_='ifOutUcastPkts.1' AND i.hostid= ^]
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object[/var/www/new/include/export.inc.php:847]
* Undefined index: hostid[/var/www/new/api/classes/class.citem.php:549]
* pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: ошибка синтаксиса в конце ввода LINE 1: ...id FROM items i WHERE i.key_='ifInUcastPkts.1' AND i.hostid= ^[/var/www/new/include/db.inc.php:406]
* Error in query [SELECT DISTINCT i.itemid FROM items i WHERE i.key_='ifInUcastPkts.1' AND i.hostid=] [ERROR: ошибка синтаксиса в конце ввода LINE 1: ...id FROM items i WHERE i.key_='ifInUcastPkts.1' AND i.hostid= ^]
* pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/new/include/db.inc.php:547]
* reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object[/var/www/new/include/export.inc.php:847]
* Undefined index: gitems[/var/www/new/api/classes/class.cgraph.php:447]
* Missing items for graph "IP Traffic"


XML attached

[Danila]

I'm using debian lenny and postgresql 8.3.8

[richlv]

could you please test with latest trunk and report on the tracker if the problem is still present ?

[Danila]

could you please test with latest trunk and report on the tracker if the problem is still present ?

In trunk versions import works. 3 buggable moments exsit:

1. # Item '_1801:ifInOctets.1' updated
# pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/trunk/include/db.inc.php:547]

2. Undefined index: graphid[/var/www/trunk/api/classes/class.cgraph.php:595]

3. New hostgroups are not created automaticaly with hosts. This feature was not inclued in 1.6 versions but it'd be very useful to have it in 1.7.

is it possible to use frontend from trunk with 1.7.2 database?

thnx!

[richlv]

1. # Item '_1801:ifInOctets.1' updated
# pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/var/www/trunk/include/db.inc.php:547]

2. Undefined index: graphid[/var/www/trunk/api/classes/class.cgraph.php:595]

could you report these on the tracker, indicating exact revision and attaching test import file ?

3. New hostgroups are not created automaticaly with hosts. This feature was not inclued in 1.6 versions but it'd be very useful to have it in 1.7.

please search feature requests, if not present, add one

is it possible to use frontend from trunk with 1.7.2 database?

ouch... that's a huge font.
while it should be mostly possible, there might be some changes to the database schema.
compare the two revisions, and check this thread for any (unsupported ) patches :

http://www.zabbix.com/forum/showthread.php?t=12317&page=3