Hello,
I downloaded and complied with Trace with IntelliJ, built with Gradle, and ran the Server correctly, but I get a bdd error in database.trace.db log:
org.h2.jdbc.JdbcSQLSyntaxErrorException: Function "VERSION" not found; SQL statement:
select version() [90022-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:576)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.command.Parser.readJavaFunction(Parser.java:3565)
at org.h2.command.Parser.readFunction(Parser.java:3770)
at org.h2.command.Parser.readTerm(Parser.java:4305)
at org.h2.command.Parser.readFactor(Parser.java:3343)
at org.h2.command.Parser.readSum(Parser.java:3330)
at org.h2.command.Parser.readConcat(Parser.java:3305)
at org.h2.command.Parser.readCondition(Parser.java:3108)
at org.h2.command.Parser.readExpression(Parser.java:3059)
at org.h2.command.Parser.parseSelectExpressions(Parser.java:2931)
at org.h2.command.Parser.parseSelect(Parser.java:2952)
at org.h2.command.Parser.parseQuerySub(Parser.java:2817)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2649)
at org.h2.command.Parser.parseQuery(Parser.java:2620)
at org.h2.command.Parser.parsePrepared(Parser.java:868)
at org.h2.command.Parser.parse(Parser.java:843)
at org.h2.command.Parser.parse(Parser.java:815)
at org.h2.command.Parser.prepareCommand(Parser.java:738)
at org.h2.engine.Session.prepareLocal(Session.java:657)
at org.h2.engine.Session.prepareCommand(Session.java:595)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:78)
at liquibase.database.core.CockroachDatabase.isCorrectDatabaseImplementation(CockroachDatabase.java:38)
at liquibase.database.DatabaseFactory.findCorrectDatabaseImplementation(DatabaseFactory.java:101)
at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:141)
at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:286)
at org.traccar.database.DataManager.<init>(DataManager.java:91)
at org.traccar.Context.init(Context.java:298)
at org.traccar.Main.run(Main.java:120)
at org.traccar.Main.main(Main.java:106)
Can you help me please?
Thank you so much.
Did you change any code or configuration?
Hi Anton,
No, I haven't changed anything, just a one moment it's worked fine, but it then stopped working again.
Could it be a some problem bdd blocking ?
Thanks a lot,
It's the bbdd itself embedded in Traccar.
I try to load the web at http: // localhost: 8082 / but it keeps loading with the Traccar spinner
This is the event log, at the beginning:
2021-10-16 19:13:16 INFO: HikariPool-1 - Starting...
2021-10-16 19:13:16 INFO: HikariPool-1 - Added connection conn0: url=jdbc:h2:./target/database user=SA
2021-10-16 19:13:16 INFO: HikariPool-1 - Start completed.
...
You mean db (database)? I'm not familiar with term bdd? What does it stand for?
Sorry, yes, I mean the database.
I'm not able to reproduce it on master. Are you sure you haven't changed anything?
Hi Anton,
sorry, this was not a problem with the database, debugging the JS I saw that the repository is missing some .js files that are in the executable version of Traccar (in the /lib folder). I copied the folder to /traccar-web/web/lib and everything is ok.
Thanks a lot,
Hello,
I downloaded and complied with Trace with IntelliJ, built with Gradle, and ran the Server correctly, but I get a bdd error in database.trace.db log:
Can you help me please?
Thank you so much.