Hey Guys,
Can anyone explain me the error occuring in the log files in the last as I think due to them my localhost is not establishing a connection and showing me error localhost refused to connect. Let me know a solution for it also.
2019-08-27 15:21:32 INFO: HikariPool-1 - Starting...
2019-08-27 15:21:32 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2019-08-27 15:21:33 INFO: HikariPool-1 - Start completed.
2019-08-27 15:21:34 INFO: Clearing database change log checksums
2019-08-27 15:21:34 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2019-08-27 15:21:34 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2019-08-27 15:21:34 INFO: SELECT `LOCKED` FROM traccar.DATABASECHANGELOGLOCK WHERE ID=1
2019-08-27 15:21:34 INFO: Successfully acquired change log lock
2019-08-27 15:21:35 INFO: SELECT MD5SUM FROM traccar.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2019-08-27 15:21:35 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = NULL
2019-08-27 15:21:35 INFO: Successfully released change log lock
2019-08-27 15:21:35 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2019-08-27 15:21:35 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2019-08-27 15:21:35 INFO: SELECT `LOCKED` FROM traccar.DATABASECHANGELOGLOCK WHERE ID=1
2019-08-27 15:21:35 INFO: Successfully acquired change log lock
2019-08-27 15:21:40 INFO: SELECT MD5SUM FROM traccar.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2019-08-27 15:21:40 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOG
2019-08-27 15:21:40 INFO: Reading from traccar.DATABASECHANGELOG
2019-08-27 15:21:40 INFO: SELECT * FROM traccar.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2019-08-27 15:21:40 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:d59fa93049c031a8bcfbc02958c1942c' WHERE ID = 'changelog-4.0-clean' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0-clean'
2019-08-27 15:21:40 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOG
2019-08-27 15:21:40 INFO: Reading from traccar.DATABASECHANGELOG
2019-08-27 15:21:40 INFO: SELECT * FROM traccar.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2019-08-27 15:21:40 INFO: 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: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 < ...)
You have some problem with the database schema.
Hi Anton,
Do you advice creating a new connection or is it possible if I can solve the error in the existing database ?
It might be possible to fix the database if understand the schema and have enough SQL experience.
Hey Guys,
Can anyone explain me the error occuring in the log files in the last as I think due to them my localhost is not establishing a connection and showing me error localhost refused to connect. Let me know a solution for it also.