Thank you, Sriram.
I managed to launch the new container alongside the old one. As you use the Elastic Agents plugin, can I ask you a question please. I'm encountering some issues with the way agents are launched, assigned, and terminated. Despite setting the maximum agent count to two, both agents launch sequentially, with only the first being assigned to the job. Here's where it gets tricky: when the staging job completes and triggers the production job, I expect one of the active agents to take over. Instead, the production job attempts to launch new agents, fails due to the max count limit, and runs without any agents, leading to failure. Additionally, some agent instances remain active for an extended period, requiring manual termination. This disrupts the workflow significantly. Have you experienced similar issues, or do you have any suggestions for a workaround? Thanks in advance ! On Tue, Apr 23, 2024 at 4:13 PM Sriram Narayanan <sriram...@gmail.com> wrote: > > > On Tue, Apr 23, 2024 at 10:22 PM Satya Elipe <satya.el...@gmail.com> > wrote: > >> Hi All >> >> I'm dockerizing our static/standalone GoCD server. >> >> Hence copied the content from the static GoCD server to EFS and mounted >> that EFS content into the container (GoCD server container). >> >> And with that, container starts and runs but it can't fetch any data, and >> I see the below in the log: >> >> ```jvm 2 | Caused by: >> org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already >> in use: null. Possible solutions: close all other connection(s); use the >> server mode [90020-200] >> >> jvm 2 | Caused by: java.lang.IllegalStateException: The file is >> locked: nio:/godata/db/h2db/cruise.mv.db [1.4.200/7]``` >> >> Looks like the static/old server acquired the lock and when the data from >> that server copied to EFS lock is still maintained and hence the new server >> has the db file locked and couldn't fetch any data. >> >> Wonder, how are the people handling this situation ? >> We need the old server running as well when the new server is being >> brought up within the docker container. >> >> Any inputs will be of great help. >> > > If this is an important GoCD instance, then I urge you to move off H2DB to > PostgreSQL. > > We recently migrated a GoCD instance that has about 6 years of data in > H2DB to use RDS and hosted GoCD itself as a Container. We are running on an > EKS cluster and are making use of the Elastic Agent plugin. > > The H2DB that GoCD uses does not allow multiple processes to share the > same database file. I recommend that you stop the original GoCD process > (the jobs will keep running and will wait for the server to come back), > rsync the DB contents to the EFS store to speed up the copy and remove the > locks, and then start the new GoCD instance as a container with the DB > mounted via EFS. > > If you could consider moving off H2DB and using postgres, then use the DB > Migrator tool and do so. You process would then be: > 1. Stop the older GoCD server > 2. Use the DB Migrator tool to migrate from the H2DB file to a PostgreSQL > instance. > 3. Start the GoCD instance as a Container process with the configuration > to point it to the PostgreSQL instance. > > You may want to triel this once and then perform the actual switch. > > > >> >> Many thanks, >> Satya >> >> -- >> 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/CADKEDRoqGkWLv6%3DUG8CA-NAD6sRETHiE6bB5Q2crf2Ezbn-cMw%40mail.gmail.com >> <https://groups.google.com/d/msgid/go-cd/CADKEDRoqGkWLv6%3DUG8CA-NAD6sRETHiE6bB5Q2crf2Ezbn-cMw%40mail.gmail.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/CANiY96af882MjPPSVFowz9hNqakLNS7xF%2Bu7mLWb_2FXQ8fQrg%40mail.gmail.com > <https://groups.google.com/d/msgid/go-cd/CANiY96af882MjPPSVFowz9hNqakLNS7xF%2Bu7mLWb_2FXQ8fQrg%40mail.gmail.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/CADKEDRpg_6YdfCGt7_sOp%3DkOyb6DVSf19mAuJdzeXbvgk76VAA%40mail.gmail.com.
