Thanks! I was struggling with getting the message posted, as it has always been deleted right after posting. It took me several tries to find out that the SQL statements in the stacktraces were "evil". ;-) So, sorry for spamming.
Aravind SV schrieb am Samstag, 21. Mai 2022 um 20:05:10 UTC+2: > Apologies if you all see duplicate messages. It's because some of these > messages were caught in a Spam filter, and marking these as not spam will > likely have re-sent them. > > Cheers, > Aravind > > On Sat, May 21, 2022 at 7:03 PM AquilaNiger <[email protected]> wrote: > >> 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; SQL [???]; >> 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; SQL [SELECT materials.id >> FROM pipelineMaterialRevisions INNER JOIN pipelines ON >> pipelineMaterialRevisions.pipelineId = pipelines.id INNER JOIN >> modifications on modifications.id = >> pipelineMaterialRevisions.torevisionId INNER JOIN materials on >> modifications.materialId = materials.id WHERE materials.id = ? AND >> pipelineMaterialRevisions.toRevisionId >= ? AND >> pipelineMaterialRevisions.fromRevisionId <= ? AND pipelines.name = ? >> GROUP BY materials.id;]; 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] > > >> >> 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"? >> >> Both traces contain stacktraces like this one: >> >> 2022-05-19 06:39:25 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] >> > at org.h2.message.DbException.get(DbException.java:194) >> at org.h2.message.DbException.convert(DbException.java:347) >> at >> org.h2.mvstore.db.MVTableEngine$1.uncaughtException(MVTableEngine.java:93) > > >> ... >> >> 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/915480f5-af9f-4a12-b6db-acf16066bec6n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/go-cd/915480f5-af9f-4a12-b6db-acf16066bec6n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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/4f991f70-83c1-48a2-bcf8-3645d98ffddbn%40googlegroups.com.
