Upgraded to traccar 4.8 but not working
It looks like your have some issues with changelog order. I suspect you haven't really followed the guide. Restore the database from the backup and try again step by step.
Hi Anton,
I have restored the database and tried again according to mentioned document in traccar for upgrade.
Now i got following error
2020-04-28 11:07:22 ERROR: Main method error - Duplicate column name 'always' - SQLSyntaxErrorException (... < DataManager:314 < *:92 < Context:292 < Main:132 < ...)here is my notification table with values in mysql as there is only one column "always"
id type attributes always calendarid notificators
1 alarm {} 1 NULL web
2 commandResult {} 1 NULL web
3 deviceConnected {} 1 NULL web
4 deviceDisconnected {} 1 NULL web
5 ignitionOff {} 1 NULL web
6 ignitionOn {} 1 NULL web,sms
7 geofenceExit {} 1 NULL web
8 geofenceEnter {} 1 NULL web
9 deviceUnknown {} 1 NULL web
10 deviceStopped {} 1 NULL web
11 deviceOverspeed {} 1 NULL web
12 deviceOnline {} 1 NULL web,sms
13 deviceOffline {} 1 NULL web,sms
14 deviceMoving {} 1 NULL web
15 deviceFuelDrop {} 1 NULL web
16 lockedDeviceMoving {} 1 NULL web,mail,smsHere is the full detail of traccar-server.log file.
2020-04-28 11:07:17 INFO: HikariPool-1 - Starting...
2020-04-28 11:07:17 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-04-28 11:07:17 INFO: HikariPool-1 - Start completed.
2020-04-28 11:07:18 INFO: Clearing database change log checksums
2020-04-28 11:07:18 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2020-04-28 11:07:18 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2020-04-28 11:07:18 INFO: SELECT `LOCKED` FROM traccar.DATABASECHANGELOGLOCK WHERE ID=1
2020-04-28 11:07:18 INFO: Successfully acquired change log lock
2020-04-28 11:07:18 INFO: SELECT MD5SUM FROM traccar.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2020-04-28 11:07:18 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = NULL
2020-04-28 11:07:18 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = NULL
2020-04-28 11:07:18 INFO: Successfully released change log lock
2020-04-28 11:07:18 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2020-04-28 11:07:18 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2020-04-28 11:07:18 INFO: SELECT `LOCKED` FROM traccar.DATABASECHANGELOGLOCK WHERE ID=1
2020-04-28 11:07:18 INFO: Successfully acquired change log lock
2020-04-28 11:07:18 INFO: Can not use class liquibase.parser.core.yaml.YamlChangeLogParser as a Liquibase service because org.yaml.snakeyaml.constructor.BaseConstructor is not in the classpath
2020-04-28 11:07:18 INFO: Can not use class liquibase.parser.core.json.JsonChangeLogParser as a Liquibase service because org.yaml.snakeyaml.constructor.BaseConstructor is not in the classpath
2020-04-28 11:07:20 INFO: SELECT MD5SUM FROM traccar.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2020-04-28 11:07:20 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOG
2020-04-28 11:07:20 INFO: Reading from traccar.DATABASECHANGELOG
2020-04-28 11:07:20 INFO: SELECT * FROM traccar.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:ea6f202534dc7845fd1a49e1d8384d9c' WHERE ID = 'changelog-3.3' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.3'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:194e3ae7ec6d201917136e04a26e237b' WHERE ID = 'changelog-3.5' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.5'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:1ec7941b03749f24e365bc6126b07e1a' WHERE ID = 'changelog-3.6' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.6'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:2e444e379f31d0b8e09273ec7ffe87a0' WHERE ID = 'changelog-3.7' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:974c33d2fb399ef6477c3897450fb078' WHERE ID = 'changelog-3.7-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:74d68027951f8d2ae6bb2e24df8365bc' WHERE ID = 'changelog-3.8' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.8'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:34822842d65deb843a7d16f857d52ecc' WHERE ID = 'changelog-3.9' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.9'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:e1ddbe83e1ecf856a912755fc118f82e' WHERE ID = 'changelog-3.10' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:191c21d8f0f921845cf93bbc9d0639b9' WHERE ID = 'changelog-3.10-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:ad1f63566e8d08812fbf0b93a118ef6e' WHERE ID = 'changelog-3.10-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:127b36b9d32a9d236df51d19b18c3766' WHERE ID = 'changelog-3.7-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:7800f890b9706a480bd5a79b591b6ca7' WHERE ID = 'changelog-3.11' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.11'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:5ce520811d626ad325a014b9fcbb1a13' WHERE ID = 'changelog-3.12' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:a3bf7fabcde29e106fe2f89829a76a84' WHERE ID = 'changelog-3.12-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2020-04-28 11:07:20 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:cfc881bd2dadb561aa9c1a467bc8cc1c' WHERE ID = 'changelog-3.12-pgsql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2020-04-28 11:07:20 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOG
2020-04-28 11:07:20 INFO: Reading from traccar.DATABASECHANGELOG
2020-04-28 11:07:20 INFO: SELECT * FROM traccar.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-04-28 11:07:21 INFO: Marking ChangeSet: changelog-4.0-clean::changelog-4.0-clean::author ran despite precondition failure due to onFail='MARK_RAN':
./schema/changelog-master.xml : Not precondition failed
2020-04-28 11:07:21 INFO: SELECT MAX(ORDEREXECUTED) FROM traccar.DATABASECHANGELOG
2020-04-28 11:07:21 INFO: INSERT INTO traccar.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-4.0-clean', 'author', 'changelog-4.0-clean', NOW(), 18, '8:d59fa93049c031a8bcfbc02958c1942c', 'createTable tableName=tc_attributes; createTable tableName=tc_calendars; createTable tableName=tc_commands; createTable tableName=tc_device_attribute; createTable tableName=tc_device_command; createTable tableName=tc_device_driver; createTable tab...', '', 'MARK_RAN', NULL, NULL, '3.8.5', '8052240968')
2020-04-28 11:07:21 INFO: Marking ChangeSet: changelog-4.0-clean::changelog-4.0-clean-common::author ran despite precondition failure due to onFail='MARK_RAN':
./schema/changelog-master.xml : Not precondition failed
2020-04-28 11:07:21 INFO: INSERT INTO traccar.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-4.0-clean-common', 'author', 'changelog-4.0-clean', NOW(), 19, '8:1adabae3238e02ccc97cc422359a58a0', 'addForeignKeyConstraint baseTableName=tc_groups, constraintName=fk_groups_groupid, referencedTableName=tc_groups; addForeignKeyConstraint baseTableName=tc_user_user, constraintName=fk_user_user_manageduserid, referencedTableName=tc_users', '', 'MARK_RAN', NULL, NULL, '3.8.5', '8052240968')
2020-04-28 11:07:21 INFO: CREATE TABLE traccar.drivers (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, uniqueid VARCHAR(128) NOT NULL, attributes VARCHAR(4000) NOT NULL, CONSTRAINT PK_DRIVERS PRIMARY KEY (id))
2020-04-28 11:07:21 INFO: Table drivers created
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.drivers ADD CONSTRAINT uk_driver_uniqueid UNIQUE (uniqueid)
2020-04-28 11:07:21 INFO: Unique constraint added to drivers(uniqueid)
2020-04-28 11:07:21 INFO: CREATE TABLE traccar.user_driver (userid INT NOT NULL, driverid INT NOT NULL)
2020-04-28 11:07:21 INFO: Table user_driver created
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.user_driver ADD CONSTRAINT fk_user_driver_userid FOREIGN KEY (userid) REFERENCES traccar.users (id) ON DELETE CASCADE
2020-04-28 11:07:21 INFO: Foreign key constraint added to user_driver (userid)
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.user_driver ADD CONSTRAINT fk_user_driver_driverid FOREIGN KEY (driverid) REFERENCES traccar.drivers (id) ON DELETE CASCADE
2020-04-28 11:07:21 INFO: Foreign key constraint added to user_driver (driverid)
2020-04-28 11:07:21 INFO: CREATE TABLE traccar.group_driver (groupid INT NOT NULL, driverid INT NOT NULL)
2020-04-28 11:07:21 INFO: Table group_driver created
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.group_driver ADD CONSTRAINT fk_group_driver_groupid FOREIGN KEY (groupid) REFERENCES traccar.`groups` (id) ON DELETE CASCADE
2020-04-28 11:07:21 INFO: Foreign key constraint added to group_driver (groupid)
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.group_driver ADD CONSTRAINT fk_group_driver_driverid FOREIGN KEY (driverid) REFERENCES traccar.drivers (id) ON DELETE CASCADE
2020-04-28 11:07:21 INFO: Foreign key constraint added to group_driver (driverid)
2020-04-28 11:07:21 INFO: CREATE TABLE traccar.device_driver (deviceid INT NOT NULL, driverid INT NOT NULL)
2020-04-28 11:07:21 INFO: Table device_driver created
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.device_driver ADD CONSTRAINT fk_device_driver_deviceid FOREIGN KEY (deviceid) REFERENCES traccar.devices (id) ON DELETE CASCADE
2020-04-28 11:07:21 INFO: Foreign key constraint added to device_driver (deviceid)
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.device_driver ADD CONSTRAINT fk_device_driver_driverid FOREIGN KEY (driverid) REFERENCES traccar.drivers (id) ON DELETE CASCADE
2020-04-28 11:07:21 INFO: Foreign key constraint added to device_driver (driverid)
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.server RENAME traccar.servers
2020-04-28 11:07:21 INFO: Table server renamed to servers
2020-04-28 11:07:21 INFO: ChangeSet changelog-3.14::changelog-3.14::author ran successfully in 321ms
2020-04-28 11:07:21 INFO: INSERT INTO traccar.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-3.14', 'author', 'changelog-3.14', NOW(), 20, '8:1be7e6c0520f8be53ef1b099d96afba5', 'createTable tableName=drivers; addUniqueConstraint constraintName=uk_driver_uniqueid, tableName=drivers; createTable tableName=user_driver; addForeignKeyConstraint baseTableName=user_driver, constraintName=fk_user_driver_userid, referencedTableNam...', '', 'EXECUTED', NULL, NULL, '3.8.5', '8052240968')
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.attribute_aliases DROP FOREIGN KEY fk_attribute_aliases_deviceid
2020-04-28 11:07:21 INFO: Foreign key fk_attribute_aliases_deviceid dropped
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.attribute_aliases DROP KEY uk_deviceid_attribute
2020-04-28 11:07:21 INFO: Unique constraint uk_deviceid_attribute dropped from attribute_aliases
2020-04-28 11:07:21 INFO: DROP TABLE traccar.attribute_aliases
2020-04-28 11:07:21 INFO: Table attribute_aliases dropped
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.servers DROP COLUMN timezone
2020-04-28 11:07:21 INFO: Column servers.timezone dropped
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.servers DROP COLUMN speedunit
2020-04-28 11:07:21 INFO: Column servers.speedunit dropped
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.servers DROP COLUMN distanceunit
2020-04-28 11:07:21 INFO: Column servers.distanceunit dropped
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.users DROP COLUMN timezone
2020-04-28 11:07:21 INFO: Column users.timezone dropped
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.users DROP COLUMN speedunit
2020-04-28 11:07:21 INFO: Column users.speedunit dropped
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.users DROP COLUMN distanceunit
2020-04-28 11:07:21 INFO: Column users.distanceunit dropped
2020-04-28 11:07:21 INFO: CREATE TABLE traccar.commands (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, textchannel BIT(1) DEFAULT 0 NOT NULL, attributes VARCHAR(4000) NOT NULL, CONSTRAINT PK_COMMANDS PRIMARY KEY (id))
2020-04-28 11:07:21 INFO: Table commands created
2020-04-28 11:07:21 INFO: CREATE TABLE traccar.user_command (userid INT NOT NULL, commandid INT NOT NULL)
2020-04-28 11:07:21 INFO: Table user_command created
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.user_command ADD CONSTRAINT fk_user_command_userid FOREIGN KEY (userid) REFERENCES traccar.users (id) ON DELETE CASCADE
2020-04-28 11:07:21 INFO: Foreign key constraint added to user_command (userid)
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.user_command ADD CONSTRAINT fk_user_command_commandid FOREIGN KEY (commandid) REFERENCES traccar.commands (id) ON DELETE CASCADE
2020-04-28 11:07:21 INFO: Foreign key constraint added to user_command (commandid)
2020-04-28 11:07:21 INFO: CREATE TABLE traccar.group_command (groupid INT NOT NULL, commandid INT NOT NULL)
2020-04-28 11:07:21 INFO: Table group_command created
2020-04-28 11:07:21 INFO: ALTER TABLE traccar.group_command ADD CONSTRAINT fk_group_command_groupid FOREIGN KEY (groupid) REFERENCES traccar.`groups` (id) ON DELETE CASCADE
2020-04-28 11:07:22 INFO: Foreign key constraint added to group_command (groupid)
2020-04-28 11:07:22 INFO: ALTER TABLE traccar.group_command ADD CONSTRAINT fk_group_command_commandid FOREIGN KEY (commandid) REFERENCES traccar.commands (id) ON DELETE CASCADE
2020-04-28 11:07:22 INFO: Foreign key constraint added to group_command (commandid)
2020-04-28 11:07:22 INFO: CREATE TABLE traccar.device_command (deviceid INT NOT NULL, commandid INT NOT NULL)
2020-04-28 11:07:22 INFO: Table device_command created
2020-04-28 11:07:22 INFO: ALTER TABLE traccar.device_command ADD CONSTRAINT fk_device_command_deviceid FOREIGN KEY (deviceid) REFERENCES traccar.devices (id) ON DELETE CASCADE
2020-04-28 11:07:22 INFO: Foreign key constraint added to device_command (deviceid)
2020-04-28 11:07:22 INFO: ALTER TABLE traccar.device_command ADD CONSTRAINT fk_device_command_commandid FOREIGN KEY (commandid) REFERENCES traccar.commands (id) ON DELETE CASCADE
2020-04-28 11:07:22 INFO: Foreign key constraint added to device_command (commandid)
2020-04-28 11:07:22 INFO: ALTER TABLE traccar.servers ADD limitcommands BIT(1) DEFAULT 0 NULL
2020-04-28 11:07:22 INFO: Columns limitcommands(BOOLEAN) added to servers
2020-04-28 11:07:22 INFO: ALTER TABLE traccar.users ADD limitcommands BIT(1) DEFAULT 0 NULL
2020-04-28 11:07:22 INFO: Columns limitcommands(BOOLEAN) added to users
2020-04-28 11:07:22 INFO: ALTER TABLE traccar.notifications ADD always BIT(1) DEFAULT 0 NOT NULL
2020-04-28 11:07:22 ERROR: Change Set changelog-3.15::changelog-3.15::author failed. Error: Duplicate column name 'always' [Failed SQL: (1060) ALTER TABLE traccar.notifications ADD always BIT(1) DEFAULT 0 NOT NULL]
2020-04-28 11:07:22 INFO: Successfully released change log lock
2020-04-28 11:07:22 ERROR: Main method error - Duplicate column name 'always' - SQLSyntaxErrorException (... < DataManager:314 < *:92 < Context:292 < Main:132 < ...)Please suggest any solution at earliest.
You database schema is invalid.
Hi Anton, after correcting the database schema.
Server runs successfully. But no device reporting started.
This is the latest logs for tracker-server.log.
Is everything ok?
2020-04-29 20:56:49 INFO: HikariPool-1 - Starting...
2020-04-29 20:56:49 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-04-29 20:56:49 INFO: HikariPool-1 - Start completed.
2020-04-29 20:56:50 INFO: Clearing database change log checksums
2020-04-29 20:56:50 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
...
2020-04-29 20:57:14 INFO: ALTER TABLE traccar.user_notification RENAME traccar.tc_user_notification
2020-04-29 20:57:14 INFO: Table user_notification renamed to tc_user_notification
2020-04-29 20:57:14 INFO: ALTER TABLE traccar.user_user RENAME traccar.tc_user_user
2020-04-29 20:57:14 INFO: Table user_user renamed to tc_user_user
2020-04-29 20:57:14 INFO: ALTER TABLE traccar.users RENAME traccar.tc_users
2020-04-29 20:57:14 INFO: Table users renamed to tc_users
2020-04-29 20:57:14 INFO: ChangeSet changelog-4.0::changelog-4.0-renaming::author ran successfully in 253ms
2020-04-29 20:57:14 INFO: INSERT INTO traccar.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-4.0-renaming', 'author', 'changelog-4.0', NOW(), 29, '8:90aedfa378aa717f8d8ae541f97b87b2', 'renameTable newTableName=tc_attributes, oldTableName=attributes; renameTable newTableName=tc_calendars, oldTableName=calendars; renameTable newTableName=tc_commands, oldTableName=commands; renameTable newTableName=tc_device_attribute, oldTableName...', '', 'EXECUTED', NULL, NULL, '3.8.5', '8174013139')
2020-04-29 20:57:14 INFO: Marking ChangeSet: changelog-4.1::changelog-4.1-mssql::author ran despite precondition failure due to onFail='MARK_RAN':
./schema/changelog-master.xml : DBMS Precondition failed: expected mssql, got mysql
2020-04-29 20:57:14 INFO: INSERT INTO traccar.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-4.1-mssql', 'author', 'changelog-4.1', NOW(), 30, '8:b148f52efe9c6a3e74a56e33e257a3e2', 'sql; sql; sql; sql', '', 'MARK_RAN', NULL, NULL, '3.8.5', '8174013139')
2020-04-29 20:57:14 INFO: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_schema='traccar' and const.table_name='tc_user_device' and const.constraint_name='user_devicecol_UNIQUE'order by ordinal_position
2020-04-29 20:57:14 INFO: CREATE TABLE TMP_YNKIBWUDSQPNKSPR (
id INT PRIMARY KEY,
self_ref INT NOT NULL,
CONSTRAINT c_self_ref FOREIGN KEY(self_ref) REFERENCES TMP_YNKIBWUDSQPNKSPR(id)
)
2020-04-29 20:57:14 INFO: DROP TABLE TMP_YNKIBWUDSQPNKSPR
2020-04-29 20:57:14 INFO: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_schema='traccar' and const.table_name='tc_devices' and const.constraint_name='uk_device_uniqueid'order by ordinal_position
2020-04-29 20:57:14 INFO: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_schema='traccar' and const.table_name='tc_users' and const.constraint_name='uk_user_email'order by ordinal_position
2020-04-29 20:57:14 INFO: Marking ChangeSet: changelog-4.7::changelog-4.7::author ran despite precondition failure due to onFail='MARK_RAN':
./schema/changelog-master.xml : Not precondition failed
2020-04-29 20:57:14 INFO: INSERT INTO traccar.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-4.7', 'author', 'changelog-4.7', NOW(), 31, '8:a23040cfc84d4b8021f40ee214a9d78b', 'createIndex indexName=user_device_user_id, tableName=tc_user_device; createIndex indexName=position_deviceid_fixtime, tableName=tc_positions', '', 'MARK_RAN', NULL, NULL, '3.8.5', '8174013139')
2020-04-29 20:57:14 INFO: Successfully released change log lock
2020-04-29 20:57:15 INFO: Logging initialized @26352ms to org.eclipse.jetty.util.log.Slf4jLog
2020-04-29 20:57:15 INFO: Your platform does not provide complete low-level API for accessing direct buffers reliably. Unless explicitly requested, heap buffer will always be preferred to avoid potential system instability.
2020-04-29 20:57:16 INFO: Operating system name: Linux version: 4.15.0-1057-aws architecture: amd64
2020-04-29 20:57:16 INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 11.0.5+10-LTS
2020-04-29 20:57:16 INFO: Memory limit heap: 986mb non-heap: 0mb
2020-04-29 20:57:16 INFO: Character encoding: UTF-8 charset: UTF-8
2020-04-29 20:57:16 INFO: Version: 4.8
2020-04-29 20:57:16 INFO: Starting server...
2020-04-29 20:57:16 INFO: jetty-9.4.26.v20200117; built: 2020-01-17T12:35:33.676Z; git: 7b38981d25d14afb4a12ff1f2596756144edf695; jvm 11.0.5+10-LTS
2020-04-29 20:57:16 INFO: Started o.t.w.@2b2b7e3c{/,null,AVAILABLE}
2020-04-29 20:57:16 INFO: DefaultSessionIdManager workerName=node0
2020-04-29 20:57:16 INFO: No SessionScavenger set, using defaults
2020-04-29 20:57:16 INFO: node0 Scavenging every 600000ms
2020-04-29 20:57:17 INFO: Started o.e.j.s.ServletContextHandler@1e3dc24f{/,null,AVAILABLE}
2020-04-29 20:57:17 INFO: Started ServerConnector@2921199d{HTTP/1.1,[http/1.1]}{0.0.0.0:8082}
2020-04-29 20:57:17 INFO: Started @28500msFollow troubleshooting guide.
Upgraded from traccar 3.12 to traccar 4.8 with following link
https://www.traccar.org/upgrading-traccar/
but when view logs found error in database tables