org.h2.jdbc.JdbcSQLSyntaxErrorException

JCC 4 years ago

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.

Anton Tananaev 4 years ago

Did you change any code or configuration?

JCC 4 years ago

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,

Anton Tananaev 4 years ago

What is bdd?

JCC 4 years ago

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

JCC 4 years ago

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.
...
Anton Tananaev 4 years ago

You mean db (database)? I'm not familiar with term bdd? What does it stand for?

JCC 4 years ago

Sorry, yes, I mean the database.

Anton Tananaev 4 years ago

I'm not able to reproduce it on master. Are you sure you haven't changed anything?

JCC 4 years ago

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,