TRACCAR MYSQL migration

Sreelakshmi K S6 years ago

Im not able to start traccar service after mysql configuration changes. error is

2019-05-18 13:19:05 ERROR: Change Set changelog-4.0-clean::changelog-4.0-clean::author failed.  Error: Table 'tc_calendars' already exists [Failed SQL: CREATE TABLE traccar.tc_calendars (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, data MEDIUMBLOB NOT NULL, attributes VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_CALENDARS PRIMARY KEY (id))]
2019-05-18 13:19:05  INFO: Successfully released change log lock
2019-05-18 13:19:05 ERROR: Main method error - Table 'tc_calendars' already exists - SQLSyntaxErrorException (... < DataManager:312 < *:90 < Context:292 < Main:110 < ...)
                                                                                 399,1         Bot

Please help me

Slawek6 years ago

show your config file

Sreelakshmi K S6 years ago

thank you for the reply. resolved it myself. In my case the problem was i did not grant all permissions to the mysql db user.
After doing that when i started the service, everything went fine.