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:
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: