I have linked my MySQL Workbench with Traccar and tables are being stored over it, recently I faced an issue due to which I think localhost is not establishing a connection and showing me error LocalHost refused to connect. I checked log files for the error and I was shown an error which I assume is related to foreign key but still I cannot get the solution for it.
I’ll attach the piece of error from the log here.
I did find out the table from the schema and foreign key linked with it, I have checked the other similar tables created also but no other tables has the same foreign key.
2019-08-27 15:21:40 ERROR: Change Set changelog-4.0-clean::changelog-4.0-clean-common::author failed. Error: Duplicate foreign key constraint name ‘fk_groups_groupid’ [Failed SQL: ALTER TABLE traccar.tc_groups ADD CONSTRAINT fk_groups_groupid FOREIGN KEY (groupid) REFERENCES traccar.tc_groups (id) ON UPDATE RESTRICT ON DELETE SET NULL] 2019-08-27 15:21:41 INFO: Successfully released change log lock 2019-08-27 15:21:41 ERROR: Main method error - Duplicate foreign key constraint name ‘fk_groups_groupid’ - SQLException (… < DataManager:312 < *:90 < Context:292 < Main:110 < …) 2019-08-27 15:21:41 WARN: JNA: Callback org.traccar.WindowsService$ServiceMain@6e2aa843 threw the following exception - Duplicate foreign key constraint name ‘fk_groups_groupid’ - SQLException (… < DataManager:312 < *:90 < Context:292 < Main:110 < …)
Localhost should establish a connection and giving an info over the logs.