OK - sounds good. Yeah, more memory will help given the additional errors you mention there.
On Mon, Dec 5, 2022 at 3:27 PM Adrien DEFOSSÉ <adrien.defo...@gmail.com> wrote: > Hi, > Actually we've found out two errors that might explain our problem: > > jvm 2 | [332115.956s][warning][gc,alloc] MVStore background writer > nio:/godata/db/h2db/cruise.mv.db: Retried waiting for GCLocker too often > allocating 256 words > jvm 2 | [332115.976s][warning][gc,alloc] MVStore background writer > nio:/godata/db/h2db/cruise.mv.db: Retried waiting for GCLocker too often > allocating 4 words > [...] > jvm 2 | Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: > Out of memory.; SQL statement: > > When examining the configuration, we think we'v found an error in our > configuration that makes us use a heap memory of 1Go instead of 10Go. We've > change the config and now, well wait and see... > > As for your questions: > > - Our cruise.mv.db is 1.6Gb > - We're on GoD 22.2.0 > > Thanks a lot > > Le vendredi 2 décembre 2022 à 16:31:32 UTC+1, Chad Wilson a écrit : > >> You might want to check the full stack trace for other errors that might >> be happening before this, which might indicate corruption, and share those >> too. Sometimes errors about the DB being closed are the end result another >> failure, but not the root cause. >> >> Other than that >> >> - What size is your H2 database on disk? >> >> >> - Which GoCD version are you running? >> >> >> If it's very large (multiple GB) and/or there are other errors in the >> stack traces that indicate something like H2 DB corruption you might want >> to consider trying exporting the DB and re-importing it to a fresh DB. >> There's a guideline of how to do this at >> https://gist.github.com/arvindsv/c7934bee26ce1c47e9d24f0a493d3c87 if you >> want to give it a go. >> >> -Chad >> >> On Tue, Nov 29, 2022 at 12:19 AM Adrien DEFOSSÉ <adrien....@gmail.com> >> wrote: >> >>> Hi, >>> >>> Since a few weeks, we have got a recurring problem with our GoCD server. >>> Some times, it restart with the error: >>> >>> org.h2.jdbc.JdbcSQLNonTransientConnectionException: The database has >>> been closed [90098-200] >>> >>> In the last two weeks, it already happened three times. We tried to add >>> more memory to our service (a swarm service) but it doesn't seems to >>> resolve anything. >>> >>> I didn't see anyone with the same problem. Some advice? >>> >>> Thanks a lot. >>> >>> -- >>> 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 go-cd+un...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/go-cd/0728fa08-d408-4006-bb5f-787f7c3525b0n%40googlegroups.com >>> <https://groups.google.com/d/msgid/go-cd/0728fa08-d408-4006-bb5f-787f7c3525b0n%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 go-cd+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/go-cd/41395abd-4c62-48d5-9518-889f57605e76n%40googlegroups.com > <https://groups.google.com/d/msgid/go-cd/41395abd-4c62-48d5-9518-889f57605e76n%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 go-cd+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/CAA1RwH8S7b_xox4F6USEZWBAFM9afn-DvUnPpaKYZcBDxyesgQ%40mail.gmail.com.
