Separate instance for traccar

Ashok Chandra10 months ago

i installed the traccar and make separate mysql instance but getting error

2024-01-13 11:47:09  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@68ba310d
2024-01-13 11:47:09  INFO: HikariPool-1 - Start completed.
2024-01-13 11:47:09  INFO: Clearing database change log checksums
2024-01-13 11:47:09  INFO: Successfully acquired change log lock
2024-01-13 11:47:09  INFO: Creating database history table with name: defaultdb.DATABASECHANGELOG
2024-01-13 11:47:10  INFO: Successfully released change log lock
2024-01-13 11:47:10 ERROR: Main method error - Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting. - SQLException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < MainModule:126 < ...)
Anton Tananaev10 months ago

Looks like your database configuration is not compatible with traccar.

Ashok Chandra10 months ago

thanks for response. This issue from hosting side now it's resolve.