[ZBX-7640] Upgrade from zabbix 2.0.8 to 2.2.1 Created: 2014 Jan 10  Updated: 2017 May 30  Resolved: 2014 Oct 03

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.2.1
Fix Version/s: None

Type: Incident report Priority: Blocker
Reporter: César Augusto Ferreira Filho Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: dbpatches, upgrade
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

When I upgrade from 2.0.8 to 2.2.1, I got this error :
-----------------------------------------------
1278:20140110:163343.225 [Z3005] query failed: [1005] Can't create table 'zabbix.#sql-355_4' (errno: 150) [alter table application_template add constraint c_application_template_1 foreign key (applicationid) references applications (applicationid) on delete cascade]
1278:20140110:163343.225 database upgrade failed
---------------------/----------
What can I do to solve it?



 Comments   
Comment by Oleksii Zagorskyi [ 2014 Jan 13 ]

You could try to google the "errno: 150" - there a lot of things to be checked.
For example http://stackoverflow.com/questions/1749332/mysql-cant-create-table-errno-150

Comment by Alexander Vladishev [ 2014 Jan 20 ]

What MySQL version?

Also attach scheme of the 2.0.8 database before an upgrade. Do you have any custom changes of the database?

Comment by richlv [ 2014 Feb 10 ]

possibly related to having myisam tables : https://www.zabbix.com/forum/showthread.php?t=43161

Comment by Alexander Vladishev [ 2014 Oct 03 ]

I close the issue. We have no enough information to reproduce this issue.
Feel free to reopen.

Comment by Oleksii Zagorskyi [ 2014 Nov 24 ]

Just in case - similar error also was noticed in ZBX-4729

Generated at Fri Mar 29 15:58:54 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.