Retore Problems with GitLab CE, Synology, Docker

Has anyone successfully restored a backup to a new Container ?

I have been trying to do one single task

  • install new image in container, put in some data & backup.
  • run this command gitlab-rake gitlab:backup:restore BACKUP=1xxx_xx_08_04_17.2.1

I have tried restoring to over 10 different brand new containers and get a variety of error each time.

Here are some of the errors -

This is the current error I am stumped on
** rake aborted!
** ActiveRecord::Deadlocked: PG::TRDeadlockDetected: ERROR: deadlock detected

I got by this error by changing global timeout is postgresql
*rake aborted!
*ActiveRecord::QueryCanceled: PG::QueryCanceled: ERROR: canceling statement due to statement timeout

Just deleted the container - only saw this once.
*rake aborted!
*Interrupt:
/*opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `public_send’

I think maybe my container had not fully built yet, but after so many failures.
*rake aborted!
*ActiveRecord::IrreversibleOrderError: Relation has no current order and table has no *primary key to be used as default order

The Backup is from a Docker instance created last week. I have 7 sample projects loaded in so a very small database size. All Containers are from the exact some image all on the same Synology. I just wanted to practice recovering a server before I put any real data in the system.

Configuration

Gitlab CE version 17.2
Synology with Container Manager

These are the instructions I have been following

I have been not able to find anything on: ActiveRecord::Deadlocked: