Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-6853

Got SQL error, while configure nodes

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Minor
    • Resolution: Won't fix
    • 2.1.2
    • None
    • None
    • Revision: 37518

    Description

      Got MySQL error, while make simple node configuration, as described in documentation https://www.zabbix.com/documentation/1.8/manual/distributed_monitoring/configuration.

      [email protected]:~/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.
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            guntis.zarins Guntis Zarins (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: