org.h2.jdbc.JdbcSQLSyntaxErrorException

JCC4 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 Tananaev4 years ago

Did you change any code or configuration?

JCC4 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 Tananaev4 years ago

What is bdd?

JCC4 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

JCC4 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 Tananaev4 years ago

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

JCC4 years ago

Sorry, yes, I mean the database.

Anton Tananaev4 years ago

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

JCC4 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,