Hi all,

I was wondering if anyone had seen anything similar to this before, and 
help greatly appreciated.

The background is we're doing a lift and shift of a GoCD instance with a 
Postgres DB from one location to another. The version of GoCD on either end 
is 17.11.0 (old I know) and we've followed the instructions on taking the 
DB backup.

The issue is that GoCD seems to hang on startup when this DB import is done 
(but not with a clean db). The connection itself seems OK as we see these 
logs:

2021-03-15 17:13:04,136 INFO  [main] GoServer:94 - Including addons: 
addons/go-postgresql-17.10.0-5380-2282ba5.jar
2021-03-15 17:13:09,788 INFO  [main] PostgresqlDatabase:93 - [DB] Using 
connection configuration jdbc:postgresql://localhost:5432/cruisedb1 [User: 
cruisedb1] [Password Encrypted: false]
2021-03-15 17:13:10,499 INFO  [main] PostgresqlDatabase:71 - [DB] Changelog 
exists. Skipping creation of a new table.

However, the go-server log's last lines of logging are:

2021-03-15 17:13:31,065 INFO  [main] BuildAssignmentService:253 - 
[Configuration Changed] Removing jobs for pipelines that no longer exist in 
configuration.
2021-03-15 17:13:31,167 INFO  [main] PipelineRepository:86 - Start updating 
pipeline timeline

This seems to be a Hibernate task - 
see 
https://github.com/gocd/gocd/blob/17.11.0/server/src/com/thoughtworks/go/server/persistence/PipelineRepository.java#L86.
 
It just sits there though. The Java process is running, but there's no 
logging, and nothing I can see from top suggests there is any activity 
going on.

I notice a lot of the backup and restore docs speak about backup and 
restoring the db but it isn't clear whether there is any data that would 
stop you loading that dump up in a different location or not - something 
specific to the 'old home' of the db data that you'd need to amend before 
you could use that as the database for a newer system.

I'm bumping up logback logging in a number of classes but there's nothing I 
can get to log out post that line above.

Again any pointers would be massively appreciated.

Many thanks
Michael


-- 
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/903e6dd3-7c0a-4ff3-86d3-ece5a063c7acn%40googlegroups.com.

Reply via email to