Migrating Continua to new Server

Hi,

we want to migrating the Continua Server. When we restore the database there are a lot of errors. Is this normal?

A part of the Output:
(1 row)

COPY 0
COPY 0
ERROR:  insert or update on table “builds_stage” violates foreign key constraint "fk_builds_stage_to_builds_build"
DETAIL:  Key (buildid)=(20011) is not present in table “builds_build”.
ERROR:  insert or update on table “builds_stagedefinition” violates foreign key constraint "fk_builds_stagedefinition_to_core_project"
DETAIL:  Key (projectid)=(d76e7b8c-f438-40fc-995d-a46d00b1138f) is not present in table “core_project”.
ERROR:  insert or update on table “builds_stagedefinitionpromotecondition” violates foreign key constraint "fk_builds_stagedefinitionpromotecondition_to_builds_stagedefini"
DETAIL:  Key (stagedefinitionid)=(6ef45b67-7a31-4b4a-8b23-a619011188a9) is not present in table “builds_stagedefinition”.
ERROR:  insert or update on table “builds_stagedefinitionsharedresourcelock” violates foreign key constraint "fk_builds_stagedefinitionsharedresourcelock_to_builds_stagedefi"
DETAIL:  Key (stagedefinitionid)=(865e271d-5a25-4a45-b957-a69000932428) is not present in table “builds_stagedefinition”.
ERROR:  insert or update on table “builds_stagedefinitionskipcondition” violates foreign key constraint "fk_builds_stagedefinitionskipcondition_to_builds_stagedefinitio"
DETAIL:  Key (stagedefinitionid)=(a86d9858-b4a3-4122-8c40-a59100ddc4f5) is not present in table “builds_stagedefinition”.
ERROR:  insert or update on table “builds_stagedefinitionversiongatecondition” violates foreign key constraint "fk_builds_stagedefinitionversiongatecondition_to_builds_stagede"
DETAIL:  Key (stagedefinitionid)=(841f8786-3522-4ea3-b9e8-a46d00e2d256) is not present in table “builds_stagedefinition”.
ERROR:  insert or update on table “builds_stagedefinitionversionrequirement” violates foreign key constraint "fk_builds_stagedefinitionversionrequirement_to_builds_stagedefi"
DETAIL:  Key (stagedefinitionid)=(1f68050b-3dc6-4937-9f0a-a4f300de7a38) is not present in table “builds_stagedefinition”.
ERROR:  insert or update on table “builds_stagemetric” violates foreign key constraint "fk_builds_stagemetric_to_builds_stage"
DETAIL:  Key (stageid)=(afe8579d-00fb-4683-ac25-a68d0139f8a9) is not present in table “builds_stage”.
ERROR:  insert or update on table “builds_trigger” violates foreign key constraint "fk_builds_trigger_to_builds_configuration"
DETAIL:  Key (configurationid)=(7acfa591-fb53-4a8a-8e95-a47400b11450) is not present in table “builds_configuration”.
ERROR:  insert or update on table “builds_triggercondition” violates foreign key constraint "fk_builds_triggercondition_to_builds_trigger"
DETAIL:  Key (triggerid)=(ff3a4cac-ef12-4687-9f9a-a5d900ec008e) is not present in table “builds_trigger”.
COPY 540
 setval
--------
    541
(1 row)

ERROR:  insert or update on table “builds_triggervariable” violates foreign key constraint "fk_builds_triggervariable_to_builds_trigger"
DETAIL:  Key (triggerid)=(77a57d98-c2c7-460d-9550-a47c0097cf1d) is not present in table “builds_trigger”.



ERROR:  multiple primary keys for table “core_sharedresourceitem” are not allowed
ERROR:  multiple primary keys for table “core_sharedresourceitemquota” are not allowed
ERROR:  multiple primary keys for table “core_subscription” are not allowed
ERROR:  multiple primary keys for table “core_user” are not allowed
ERROR:  multiple primary keys for table “core_userproperty” are not allowed
ERROR:  multiple primary keys for table “core_variable” are not allowed
ERROR:  multiple primary keys for table “core_variablenamespace” are not allowed
ERROR:  multiple primary keys for table “versioninfo” are not allowed
ERROR:  relation “ix_build_configuration_namesortcode” already exists
ERROR:  relation “ix_builds_agent_hostname” already exists
ERROR:  relation “ix_builds_agent_lastactive” already exists
ERROR:  relation “ix_builds_agentauthorization_userid” already exists
ERROR:  relation “ix_builds_agentcachedrepository_agentid” already exists
ERROR:  relation “ix_builds_agentcachedrepository_repositoryid” already exists
ERROR:  relation “ix_builds_agentfault_agentid” already exists
ERROR:  relation “ix_builds_agentproperty_agentid” already exists
ERROR:  relation “ix_builds_agentproperty_agentid_namespace_name” already exists
ERROR:  relation “ix_builds_agentproperty_name” already exists
ERROR:  relation “ix_builds_agentproperty_namespace” already exists
ERROR:  relation “ix_builds_artifact_buildid” already exists
ERROR:  relation “ix_builds_build_configurationid” already exists
ERROR:  relation “ix_builds_build_configurationversionid” already exists
ERROR:  relation “ix_builds_build_configurationversionid_summarystate_id_finished” already exists
ERROR:  relation “ix_builds_build_finished” already exists
ERROR:  relation “ix_builds_build_started” already exists
ERROR:  relation “ix_builds_build_summarystate” already exists
ERROR:  relation “ix_builds_build_summarystate_id_finished_configurationid” already exists
ERROR:  relation “ix_builds_build_summarystate_id_finished_configurationversionid” already exists

Hi Marcel,

No. This is not normal. Which backup and restore options are you using? If you are restoring to an existing database ensure that you have included drop and create database statements in you backup.

Hi Dave,

Thanks, this was the problem.