Problem upgarde zabbix 2.2.12 to 2.2.3

[bnajem]

i ipgraded zabbix (server ,agent frontend ) to 2.2.3 version like mention on zabbix site , the probelem is zabbix-server can't do upgrade of database like bellow :
54508:20140530:112608.691 query [txnlev:1] [alter table httptest drop foreign key c_httptest_1]
54508:20140530:112609.093 [Z3005] query failed: [1025] Error on rename of './zabbixdb/httptest' to './zabbixdb/#sql2-217c-781' (errno: 152) [alter table httptest drop foreign key c_httptest_1]
54508:20140530:112609.093 query [alter table httptest drop foreign key c_httptest_1] failed, setting transaction as failed
54508:20140530:112609.093 query [txnlev:1] [rollback;]
54508:20140530:112609.093 database upgrade failed
54508:20140530:112609.094 End of DBcheck_version():FAIL

Now i can't start the server and the interface
The frontend does not match Zabbix database. Current database version (mandatory/optional): 2010000/2010000. Required mandatory version: 2020000. Contact your system administrator.

do you know how to resolved ? i search the mysql patch for zabbix2.2.3 but i didn't found it
any help

[aib]

Sorry, you have only two options:
1) If you have a backup: restore DB from backup, give more free space for server and start convertation againю
2) If you don't have any backup: create and empty database and start from scratch.

[bnajem]

for the first sollution i applied in the same day i used the restaured database and start the server but the database upgrade failed and

service zabbix-server status
* zabbix_server is not running

any helps ?

[kloczek]

Sorry, you have only two options:
1) If you have a backup: restore DB from backup, give more free space for server and start convertation againю
2) If you don't have any backup: create and empty database and start from scratch.

This why one of the best ways of testing upgrade is setup slave database and test first on copy of DB whole upgrade process.

[bnajem]

thank u for your response but the upgrade process stop in the same step :

21413:20140602:094127.811 completed 8% of database upgrade
21413:20140602:094127.811 query [txnlev:1] [begin;]
21413:20140602:094127.811 query [txnlev:1] [alter table httptest drop foreign key c_httptest_1]
21413:20140602:094128.077 [Z3005] query failed: [1025] Error on rename of './zabbixBefUp/httptest' to './zabbixBefUp/#sql2-508-ff4' (errno: 152) [alter table httptest drop foreign key c_httptest_1]
21413:20140602:094128.077 query [alter table httptest drop foreign key c_httptest_1] failed, setting transaction as failed
21413:20140602:094128.077 query [txnlev:1] [rollback;]
21413:20140602:094128.077 database upgrade failed
21413:20140602:094128.077 End of DBcheck_version():FAIL

i think that i must downgrade zabbix-frontend because in the interface i have:
The frontend does not match Zabbix database. Current database version (mandatory/optional): 2010016/2010016. Required mandatory version: 2020000. Contact your system administrator.