Error upgrading mysql database 4.0 -> 4.1
Are you using official Traccar without any modifications to anything other than database URL and login?
Try to set logger.fullStackTraces to true.
Yes all official, here are again server log and traccar conf:
2018-10-21 13:33:34 INFO: HikariPool-1 - Starting...
2018-10-21 13:33:36 INFO: HikariPool-1 - Start completed.
2018-10-21 13:33:39 INFO: Clearing database change log checksums
2018-10-21 13:33:44 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2018-10-21 13:33:44 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2018-10-21 13:33:44 INFO: SELECT `LOCKED` FROM traccar.DATABASECHANGELOGLOCK WHERE ID=1
2018-10-21 13:33:44 INFO: Successfully acquired change log lock
2018-10-21 13:33:45 INFO: SELECT MD5SUM FROM traccar.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2018-10-21 13:33:45 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = NULL
2018-10-21 13:33:45 INFO: Successfully released change log lock
2018-10-21 13:33:45 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2018-10-21 13:33:45 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
2018-10-21 13:33:45 INFO: SELECT `LOCKED` FROM traccar.DATABASECHANGELOGLOCK WHERE ID=1
2018-10-21 13:33:45 INFO: Successfully acquired change log lock
2018-10-21 13:33:56 INFO: SELECT MD5SUM FROM traccar.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2018-10-21 13:33:56 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOG
2018-10-21 13:33:56 INFO: Reading from traccar.DATABASECHANGELOG
2018-10-21 13:33:56 INFO: SELECT * FROM traccar.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2018-10-21 13:33:56 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:ea6f202534dc7845fd1a49e1d8384d9c' WHERE ID = 'changelog-3.3' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.3'
2018-10-21 13:33:56 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:194e3ae7ec6d201917136e04a26e237b' WHERE ID = 'changelog-3.5' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.5'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:1ec7941b03749f24e365bc6126b07e1a' WHERE ID = 'changelog-3.6' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.6'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:2e444e379f31d0b8e09273ec7ffe87a0' WHERE ID = 'changelog-3.7' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:974c33d2fb399ef6477c3897450fb078' WHERE ID = 'changelog-3.7-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.7'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:74d68027951f8d2ae6bb2e24df8365bc' WHERE ID = 'changelog-3.8' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.8'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:34822842d65deb843a7d16f857d52ecc' WHERE ID = 'changelog-3.9' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.9'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:e1ddbe83e1ecf856a912755fc118f82e' WHERE ID = 'changelog-3.10' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:191c21d8f0f921845cf93bbc9d0639b9' WHERE ID = 'changelog-3.10-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:ad1f63566e8d08812fbf0b93a118ef6e' WHERE ID = 'changelog-3.10-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:127b36b9d32a9d236df51d19b18c3766' WHERE ID = 'changelog-3.7-mssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.10'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:7800f890b9706a480bd5a79b591b6ca7' WHERE ID = 'changelog-3.11' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.11'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:5ce520811d626ad325a014b9fcbb1a13' WHERE ID = 'changelog-3.12' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:a3bf7fabcde29e106fe2f89829a76a84' WHERE ID = 'changelog-3.12-notmssql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:cfc881bd2dadb561aa9c1a467bc8cc1c' WHERE ID = 'changelog-3.12-pgsql' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.12'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:1be7e6c0520f8be53ef1b099d96afba5' WHERE ID = 'changelog-3.14' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.14'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:ac8ccec176027e98bbf45dc6c15d9b05' WHERE ID = 'changelog-3.15' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.15'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:b59407d70bfe9bf57bc9968adfbbdf1c' WHERE ID = 'changelog-3.16' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.16'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:3f14c3b08068eb7628d0d3e2941eb2d3' WHERE ID = 'changelog-3.3-admin' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.17'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:8aa3e56afe6ba86cd004fa801507bc28' WHERE ID = 'changelog-3.17' AND AUTHOR = 'author' AND FILENAME = 'changelog-3.17'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:90aedfa378aa717f8d8ae541f97b87b2' WHERE ID = 'changelog-4.0-renaming' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-21 13:33:57 INFO: UPDATE traccar.DATABASECHANGELOG SET MD5SUM = '8:2dc212cd1449b38fd8bb5038d199f720' WHERE ID = 'changelog-4.0' AND AUTHOR = 'author' AND FILENAME = 'changelog-4.0'
2018-10-21 13:33:57 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOG
2018-10-21 13:33:57 INFO: Reading from traccar.DATABASECHANGELOG
2018-10-21 13:33:57 INFO: SELECT * FROM traccar.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2018-10-21 13:33:58 INFO: Successfully released change log lock
2018-10-21 13:33:58 ERROR: Main method error -
java.lang.ArrayIndexOutOfBoundsException: 1
at liquibase.datatype.DataTypeFactory.fromDescription(DataTypeFactory.java:251)
at liquibase.change.core.CreateTableChange.generateStatements(CreateTableChange.java:70)
at liquibase.change.AbstractChange.generateStatementsVolatile(AbstractChange.java:287)
at liquibase.change.AbstractChange.warn(AbstractChange.java:358)
at liquibase.changelog.visitor.ValidatingVisitor.visit(ValidatingVisitor.java:109)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:269)
at liquibase.Liquibase.update(Liquibase.java:198)
at liquibase.Liquibase.update(Liquibase.java:179)
at liquibase.Liquibase.update(Liquibase.java:175)
at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:306)
at org.traccar.database.DataManager.<init>(DataManager.java:91)
at org.traccar.Context.init(Context.java:382)
at org.traccar.Main.run(Main.java:110)
at org.traccar.Main.main(Main.java:104)
<entry key='database.driver'>com.mysql.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://localhost:3306/traccar?useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>****</entry>
<entry key='database.password'>****</entry>
<entry key="web.port">****</entry>
<entry key='mail.smtp.host'>***</entry>
<entry key='mail.smtp.port'>465</entry>
<entry key='mail.smtp.ssl.enable'>true</entry>
<entry key='mail.smtp.from'>***</entry>
<entry key='mail.smtp.auth'>true</entry>
<entry key='mail.smtp.username'>***</entry>
<entry key='mail.smtp.password'>***</entry>
<entry key='web.url'>http://***:****/</entry>
<entry key='logger.fullStackTraces'>true</entry>
having the same problem
Can I access the server to take a look?
Sorry, I couldn't read your post till now.
After read a post from a telegram group I've tried downloading changelog-4.1.xml, changelog-4.0.xml and changelog-4.0-clean.xml from github and it worked fine for me.
Thanks
Hi guys. I have the same problem but I do not understand how you fixed Xabi TO. Thanks in advance. Greetings. Enrique
I could solve it by guiding myself by the comments of Xabi O
What I did was replace the contents of the changelogs:
- opt / traccar / schema / changelog-4.0-clean.xml
- opt / traccar / schema / changelog-4.0.xml
- opt / traccar / schema / changelog-4.1.xml
- opt / traccar / schema / changelog-master.xml
With those who are on github
https://github.com/traccar/traccar/tree/master/schema
Apart from that add in opt / traccar / conf / traccar.xml
<entry key = 'logger.fullStackTraces'> true </ entry>
This work for me.
In case someone has the same problem.
Thank you Anton for this incredible development.
Thanks Xabi O for the comments
Greetings.
Enrique
Sorry I coulnd't answer you untill now. Great this work for you!
I think the line <entry key = 'logger.fullStackTraces'> true </ entry> is for debuging purpouses, I don't use it after upgrading the xml files.
Thank you Xabi O. for the response.
I will delete the entry:
<entry key = 'logger.fullStackTraces'> true </ entry>
Regards.
it worked for me, thank you Enrique
You welcome Jaoued
Update to 4.1 doesn't work for my raspi, this is the server log: