-
Incident report
-
Resolution: Won't fix
-
Minor
-
None
-
2.0.3
-
None
-
Ubuntu 12.04 LTS
MySql 5.5.24-0ubuntu0.12.04.1
Zabbix 1.8.15 Running using a db named zabbix
Zabbix 2.0.3 running just frontend using a db named zabbix2
I tried a post to the forum but got no useful responses.
We are using Zabbix to do production monitoring and performance tracking. I wanted to test the upgrade procedure and minimize the monitoring outage. I decided to use a parallel installation as a test before moving the data gathering, monitoring, and alerting to the new version.
I dumped my existing database and restored it to a new db called zabbix2, a 4.5 hour process. Then I ran patch.sql against my new database copy, a 4 hour process. When I bring up the new GUI I am getting the following errors and others on the monitoring->dashboard page. Image attached. What is wrong?
Error in query [SELECT DISTINCT t.*,hg.groupid FROM triggers t,functions f,items i,hosts_groups hg WHERE hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND (hg.groupid IN ('25','26','27','28','29','34','31','15','24','30' ,'21','18','11','33','13','8','20','23','12','32', '2','17','6','16','7','14','5','19','9','3','4')) AND NOT EXISTS ( SELECT ff.functionid FROM functions ff WHERE ff.triggerid=t.triggerid AND EXISTS ( SELECT ii.itemid FROM items ii,hosts hh WHERE ff.itemid=ii.itemid AND hh.hostid=ii.hostid AND ( ii.status<>0 OR hh.status<>0 ) ) ) AND t.status=0 AND ( (t.value IN ('1')) AND (t.flags IN ('0','4')) ) ORDER BY lastchange DESC,t.lastchange DESC] [Unknown column 't.flags' in 'where clause']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]
Error in query [SELECT DISTINCT h.hostid,h.name,f.triggerid FROM hosts h,functions f,items i WHERE 1=0 AND h.hostid=i.hostid AND f.itemid=i.itemid AND h.status IN (0,1,3)] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]