Octopus server linux pod not picking up existing database

Hello,
I have restored an octopus database from another instance but the pod is trying to create a database instead of using the restored database. We did this on our test system and it worked but the prod environment is not picking it up. I have checked and the master key is correct and the only difference between the test and prod env is the DB name and they are both hosted on the same DB instance. Could something have gone wrong with the restore?

# PROD OUTPUT
======== Initializing DB ========
Using supplied Master Key
Setting master key
Setting database connection string to: server=server;database=P_OCTOPUS;user=USER;password=********
========== SQL Database Connection Details ========
SQL Server: server
SQL Database: P_OCTOPUS
Authentication Type: SQL Server Credentials
User: USER

===================================================
Testing connection to the 'master' database...
Successfully connected to 'master' database!
Creating database 'P_OCTOPUS' on the SQL Server at 'server'
# TEST OUTPUT
======== Initializing DB ========
Using supplied Master Key
Setting master key
Setting database connection string to: server=server;database=T_OCTOPUS;user=USER;password=********
========== SQL Database Connection Details ========
SQL Server: server
SQL Database: T_OCTOPUS
Authentication Type: SQL Server Credentials
User: USER

===================================================
Testing connection to the 'master' database...
Successfully connected to 'master' database!
Database 'T_OCTOPUS' already exists on SQL Server at 'server', no need to create it.

I also did some sql queries on the DB and the information is the same on both P_OCTOPUS and T_OCTOPUS.

Best,
Ian

Hi Ian,

Thank you for reaching out to us with your query.

There doesn’t appear to be anything obviously wrong from the information that you have provided so we’ll need to investigate this in more depth. Could you please advise on the following?

  • Are the two instances connecting using the same username and password?
  • Are any permissions configured on the databases themselves?
  • What happens after the “Creating database” message? Does it fail as it exists or something else?
  • Can you try restoring the database again (maybe with a different name) and retesting?

Please let me know if you have any questions.

Best Regards,

Charles

Thanks for the advice Charles.
It was a typo error on the DB Admins side and it is sorted now!
Cheers,
Ian

1 Like

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.