-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Minor
-
None
-
Affects Version/s: 2.1.2
-
Component/s: Installation (I), Server (S)
-
None
-
Environment:Revision: 37518
Got MySQL error, while make simple node configuration, as described in documentation https://www.zabbix.com/documentation/1.8/manual/distributed_monitoring/configuration.
guntis@dm:~/zabbix$ /home/guntis/zabbix/zabbix_trunk/sbin/zabbix_server -n 1 -c /home/guntis/zabbix/zabbix_server.conf Dropping foreign keys ............................................................................................................................ done. Converting tables ......................................................................................................... done. Creating foreign keys ......................................................................................................................zabbix_server [19824]: Error: [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`guntis_zabbix_test/#sql-e23_a88423`, CONSTRAINT `c_sessions_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE) [ALTER TABLE `sessions` ADD CONSTRAINT `c_sessions_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE] ......Conversion failed.