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/CACxychHQDPhv%3DvdoVoNJg%3DBbSgox7qF2mWbxd_cFcpq22Van2w%40mail.gmail.com.
