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

Issues with a parallel install/Upgrade

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Minor Minor
    • None
    • 2.0.3
    • Frontend (F)
    • 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]

            Unassigned Unassigned
            dbaker Darryl Baker
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: