I have been trying to upgrade my server to 2.0. In order to preserve my current running instance, I have created a copy of the database, and run the script in mysql/patch.sql. During the run, I received the following error:
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`zabbix`.<result 2 when explaining filename '#sql-5fa0_26c76'>, CONSTRAINT `c_items_2` FOREIGN KEY (`templateid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE)
When I attempted to start the zabbix server, it ran, but nothing got updated, and the following appear in the log:
where httptestid=30]
11028:20130318:101733.188 [Z3005] Query failed: [1054] Unknown column 'lastcheck' in 'field list' [update httptest set lastcheck=1363619853 where httptestid=31]
11028:20130318:101733.189 [Z3005] Query failed: [1054] Unknown column 'curstep' in 'field list' [update httptest set curstep=1,curstate=1 where httptestid=31]
11028:20130318:101733.201 [Z3005] Query failed: [1054] Unknown column 'curstep' in 'field list' [update httptest set curstep=2,curstate=1 where httptestid=31]
11028:20130318:101733.261 [Z3005] Query failed: [1054] Unknown column 'curstep' in 'field list' [update httptest set curstep=0,curstate=0,lastcheck=1363619853,nextchec k=1363619853+delay,lastfailedstep=2,time=0.010113, error='Page didn\'t match' where httptestid=31]
Suggestions?
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`zabbix`.<result 2 when explaining filename '#sql-5fa0_26c76'>, CONSTRAINT `c_items_2` FOREIGN KEY (`templateid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE)
When I attempted to start the zabbix server, it ran, but nothing got updated, and the following appear in the log:
where httptestid=30]
11028:20130318:101733.188 [Z3005] Query failed: [1054] Unknown column 'lastcheck' in 'field list' [update httptest set lastcheck=1363619853 where httptestid=31]
11028:20130318:101733.189 [Z3005] Query failed: [1054] Unknown column 'curstep' in 'field list' [update httptest set curstep=1,curstate=1 where httptestid=31]
11028:20130318:101733.201 [Z3005] Query failed: [1054] Unknown column 'curstep' in 'field list' [update httptest set curstep=2,curstate=1 where httptestid=31]
11028:20130318:101733.261 [Z3005] Query failed: [1054] Unknown column 'curstep' in 'field list' [update httptest set curstep=0,curstate=0,lastcheck=1363619853,nextchec k=1363619853+delay,lastfailedstep=2,time=0.010113, error='Page didn\'t match' where httptestid=31]
Suggestions?