Statement error processing log - open continued .jmix/hsqldb/erp.log line: 95

Support
#1

We start on our debian server the jmix application with

nohup java -jar ERP-0.01.jar

to stop, we have to kill this process

kill 422588

we have the feeling, the shutdown is successfull

2023-07-28 18:57:20.588  INFO 622936 --- [ionShutdownHook] i.j.d.impl.JmixEntityManagerFactoryBean  : Closing JPA EntityManagerFactory for persistence unit 'main'
2023-07-28 18:57:20.589  INFO 622936 --- [ionShutdownHook] i.j.d.impl.JmixEntityManagerFactoryBean  : Closing JPA EntityManagerFactory for persistence unit 'erp'
2023-07-28 18:57:20.589  INFO 622936 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Shutdown initiated...
2023-07-28 18:57:20.624  INFO 622936 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Shutdown completed.
2023-07-28 18:57:20.645  INFO 622936 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2023-07-28 18:57:20.652  INFO 622936 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.

But if we restart the application, we get the error

2023-07-28 19:03:08.390 ERROR 652925 --- [ main] hsqldb.db.HSQLDB898C59F899.ENGINE : statement error processing log - open continued .jmix/hsqldb/erp.log line: 95

We have to delete the .jmix directory to restart the application.

So far this might be ok; but, we loose all userdata ( logins etc ).

How to handle this correctly ?

#2

Konstantin Krivopustov replied me

Hi Felix,

It seems that you use HSQL database in production.
This is highly unrecommended. The default HSQL database should be used for demo and prototyping only.

You can easily switch to a standalone database like Postgres, just create a new database and connect to it in the Main Data Store properties. The application will run the same set of Liquibase changelogs and the database schema will be ready.

Please let me know if you have any trouble with the switch, or if you still want to use HSQL. In the latter case, we’ll give you recommendations on how to shut down the database correctly.

Regards,
Konstantin