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