Zabbix fail to upgrade from standaonle to node1

[andrea.consadori]

the script fail with this errore code:

[root@zabbix zabbix]# zabbix_server -n1 -c /etc/zabbix/zabbix_server.conf
Dropping foreign keys zabbix_server [13128]: Error: [Z3005] query failed: [1025] Error on rename of './zabbix/hosts' to './zabbix/#sql2-2359-1a9' (errno: 152) [ALTER TABLE `hosts` DROP FOREIGN KEY `c_hosts_1`]
.................................................. .................................................. ..................... done.
Converting tables .................................................. .................................................. ...Conversion failed.

there's a way to recover my installation?
now i cannot logon.. and it a test install so actually i've no backup, i've little config, there's a way to export it or not?

[andrea.consadori]

i see that bug --> ZBX-5404

so i follow the info

mysql> SELECT * FROM nodes;
Empty set (0.00 sec)

mysql> SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid;
Empty set (0.00 sec)

mysql> insert into nodes (nodeid,name,ip,port,nodetype,masterid) values ('1','zabbix.lais.local','127.0.0.1','10051','1',N ULL);
Query OK, 1 row affected (0.17 sec)

mysql> SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid; +--------+-------------------+-----------+-------+----------+----------+
| nodeid | name | ip | port | nodetype | masterid |
+--------+-------------------+-----------+-------+----------+----------+
| 1 | zabbix.local | 127.0.0.1 | 10051 | 1 | NULL |
+--------+-------------------+-----------+-------+----------+----------+
1 row in set (0.00 sec)

and i fix it