PDA

View Full Version : Error creating data: 1.9.3

exkg
30-03-2011, 14:31
Hi,

We have errors loading first data in zabbix-1.9.3:

[root@CentOS tmp]# mysqladmin create zbx193
[root@CentOS tmp]# mysql zbx193 < /tmp/zabbix-1.9.3/create/schema/mysql.sql

[root@CentOS tmp]# mysql zbx193 < /tmp/zabbix-1.9.3/create/data/data.sql
ERROR 1452 (23000) at line 12215: Cannot add or update a child row: a foreign key constraint fails (`zbx193/sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))

[root@CentOS tmp]# mysql zbx193 < /tmp/zabbix-1.9.3/create/data/images_mysql.sql


[]s,
Luciano
exkg
30-03-2011, 15:16
Hi,

The same error in trunk (revision 18803):


[root@CentOS zabbix-1.9.4]# mysql zbx193 < /tmp/zabbix-1.9.4/create/schema/mysql.sql

[root@CentOS zabbix-1.9.4]# mysql zbx193 < /tmp/zabbix-1.9.4/create/data/data.sql
ERROR 1452 (23000) at line 12215: Cannot add or update a child row: a foreign key constraint fails (`zbx193/sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))

[root@CentOS zabbix-1.9.4]# mysql zbx193 < /tmp/zabbix-1.9.4/create/data/images_mysql.sql
zalex_ua
30-03-2011, 16:09
Sequence of DB creation is changed, read this (https://support.zabbix.com/browse/ZBX-3020).
Documentation page is updated (http://www.zabbix.com/documentation/2.0/manual/installation/install), but i think need to add a huge note to this page (http://www.zabbix.com/documentation/2.0/manual/introduction/whatsnew200) too.
zalex_ua
30-03-2011, 16:18
heh, additional note added.
exkg
30-03-2011, 17:44
:eek: my fault ...

[root@CentOS ~]# mysqladmin drop zbx193
[root@CentOS ~]# mysqladmin create zbx193
[root@CentOS ~]# mysql zbx193 < /tmp/zabbix-1.9.4/create/schema/mysql.sql
[root@CentOS ~]# mysql zbx193 < /tmp/zabbix-1.9.4/create/data/images_mysql.sql
[root@CentOS ~]# mysql zbx193 < /tmp/zabbix-1.9.4/create/data/data.sql

All things are ok ... after read a little.


[]s,
Luciano