Hi everyone,
I really need your help. Previously we were using GoCD 20.1.0 and we
upgraded to 22.1.0 recently, including database migration. Everthing went
well and the server is running as usual. However, every now and then (no
clue how to reproduce that) the database is locked and errors like these
add up:
Hibernate operation: could not inspect JDBC autocommit mode; ... Database
may be already in use: null. Possible solutions: close all other
connection(s); use the server mode [90020-200]; nested exception is
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already
in use: null. Possible solutions: close all other connection(s); use the
server mode [90020-200]
Hibernate operation: could not execute query; ... Database may be already
in use: null. Possible solutions: close all other connection(s); use the
server mode [90020-200]
Could not open JDBC Connection for transaction; nested exception is
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already
in use: null. Possible solutions: close all other connection(s); use the
server mode [90020-200]
Additionally I can see that in the database directory, two traces are
written, the old and the new one. Is that "works as designed"?
[image: trace.png]
Both traces contain stacktraces like this one:
database: flush
org.h2.message.DbException: General error:
"java.lang.IllegalStateException: The file is locked:
nio:/var/lib/go-server/db/h2db/cruise.mv.db [1.4.200/7]" [50000-200]...
...
What's wrong with the installation? Is there any option or setting in H2
that we could change to fix the issue? Is it correct that two trace files
are written? Any idea or help is highly appreciated, otherwise I don't
think we can get rid of the issue without a complete new installation.
Thanks in advance!
Julia
--
You received this message because you are subscribed to the Google Groups
"go-cd" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/go-cd/f2255549-a517-48a8-b9d0-db6f22eea980n%40googlegroups.com.
