I installed openproject on a windows based docker, now i want to migrate all data to another new host, can anybody give me some help on this, thanks in advance.
yes i have checked that topic and it is for the "Note: this guide only applies if you’ve installed OpenProject using our DEB/RPM packages.", my openproject is a docker based in a windows system.
I did that as well, and then i got this message when I try to access the openproject with chrome
Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your OpenProject administrator for assistance.
If you are the OpenProject administrator, check your log files for details about the error.
OCI runtime exec failed: exec failed: container_linux.go:349: starting container process caused "exec: \"openproject.sql\": executable file not found in $PATH": unknown
Replies (6)
Hello Kuma,
have you already found our documentation regarding this topic? https://docs.openproject.org/installation-and-operations/misc/migration
I hope it helps.
Hello Mattias
yes i have checked that topic and it is for the "Note: this guide only applies if you’ve installed OpenProject using our DEB/RPM packages.", my openproject is a docker based in a windows system.
Thanks for your reply.
Kuma
Hi Kuma,
you will need to move the contents of mounted volumes to the new host. For the database, you can simply use the Backup & Restore guide.
Best
Oliver
Hello Mattias
I did that as well, and then i got this message when I try to access the openproject with chrome
Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your OpenProject administrator for assistance.
If you are the OpenProject administrator, check your log files for details about the error.
Back
Regards,
Kuma
Hello Kuma,
have you tried this multiple times? Did you clear the browser cache and cookies inbetween? Does this error message appear every time?
Could you please send us a screnshot of the browser console (you can access it pressing the F12 key).
Thanks!
Hi Mattias
here I attached the full process of how i tried to restoring the database on a new computer.
by the way the command line on the guide is not correct, i bolded it in below message.
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ docker exec -it openproject_db_1 psql -U postgres -c 'drop database openprojct;'
the input device is not a TTY. If you are using mintty, try prefixing the command with 'winpty'
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ winpty docker exec -it openproject_db_1 psql -U postgres -c 'drop database openprojct;'
ERROR: database "openprojct" does not exist
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ winpty docker exec -it openproject_db_1 psql -U postgres -c 'drop database openproject;'
DROP DATABASE
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ winpty docker exec -it openproject_db_1 psql -U postgres -c 'create database openproject owner openproject;'
CREATE DATABASE
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ docker cp openproject.sql openproject_db_1:/
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ winpty docker exec -it openproject_db_1 psql -U postgres
psql (10.14 (Debian 10.14-1.pgdg90+1))
Type "help" for help.
postgres=# \i openproject.sql
SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
psql:openproject.sql:43: ERROR: type "delayed_job_status" already exists
SET
SET
psql:openproject.sql:61: ERROR: relation "announcements" already exists
psql:openproject.sql:74: ERROR: relation "announcements_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:93: ERROR: relation "ar_internal_metadata" already exists
psql:openproject.sql:105: ERROR: relation "attachable_journals" already exists
psql:openproject.sql:118: ERROR: relation "attachable_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:145: ERROR: relation "attachment_journals" already exists
psql:openproject.sql:158: ERROR: relation "attachment_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:190: ERROR: relation "attachments" already exists
psql:openproject.sql:203: ERROR: relation "attachments_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:224: ERROR: relation "attribute_help_texts" already exists
psql:openproject.sql:237: ERROR: relation "attribute_help_texts_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:270: ERROR: relation "auth_sources" already exists
psql:openproject.sql:283: ERROR: relation "auth_sources_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:303: ERROR: relation "bcf_comments" already exists
psql:openproject.sql:315: ERROR: relation "bcf_comments_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:339: ERROR: relation "bcf_issues" already exists
psql:openproject.sql:351: ERROR: relation "bcf_issues_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:373: ERROR: relation "bcf_viewpoints" already exists
psql:openproject.sql:385: ERROR: relation "bcf_viewpoints_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:406: ERROR: relation "categories" already exists
psql:openproject.sql:419: ERROR: relation "categories_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:442: ERROR: relation "changes" already exists
psql:openproject.sql:455: ERROR: relation "changes_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:480: ERROR: relation "changeset_journals" already exists
psql:openproject.sql:493: ERROR: relation "changeset_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:517: ERROR: relation "changesets" already exists
psql:openproject.sql:530: ERROR: relation "changesets_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:547: ERROR: relation "changesets_work_packages" already exists
psql:openproject.sql:560: ERROR: relation "colors" already exists
psql:openproject.sql:573: ERROR: relation "colors_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:595: ERROR: relation "comments" already exists
psql:openproject.sql:608: ERROR: relation "comments_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:640: ERROR: relation "cost_entries" already exists
psql:openproject.sql:653: ERROR: relation "cost_entries_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:676: ERROR: relation "cost_object_journals" already exists
psql:openproject.sql:689: ERROR: relation "cost_object_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:713: ERROR: relation "cost_objects" already exists
psql:openproject.sql:726: ERROR: relation "cost_objects_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:749: ERROR: relation "cost_queries" already exists
psql:openproject.sql:762: ERROR: relation "cost_queries_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:783: ERROR: relation "cost_types" already exists
psql:openproject.sql:796: ERROR: relation "cost_types_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:816: ERROR: relation "custom_actions" already exists
psql:openproject.sql:829: ERROR: relation "custom_actions_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:847: ERROR: relation "custom_actions_projects" already exists
psql:openproject.sql:860: ERROR: relation "custom_actions_projects_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:878: ERROR: relation "custom_actions_roles" already exists
psql:openproject.sql:891: ERROR: relation "custom_actions_roles_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:909: ERROR: relation "custom_actions_statuses" already exists
psql:openproject.sql:922: ERROR: relation "custom_actions_statuses_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:940: ERROR: relation "custom_actions_types" already exists
psql:openproject.sql:953: ERROR: relation "custom_actions_types_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:987: ERROR: relation "custom_fields" already exists
psql:openproject.sql:1000: ERROR: relation "custom_fields_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1017: ERROR: relation "custom_fields_projects" already exists
psql:openproject.sql:1027: ERROR: relation "custom_fields_types" already exists
psql:openproject.sql:1042: ERROR: relation "custom_options" already exists
psql:openproject.sql:1055: ERROR: relation "custom_options_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1078: ERROR: relation "custom_styles" already exists
psql:openproject.sql:1091: ERROR: relation "custom_styles_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1111: ERROR: relation "custom_values" already exists
psql:openproject.sql:1124: ERROR: relation "custom_values_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1143: ERROR: relation "customizable_journals" already exists
psql:openproject.sql:1156: ERROR: relation "customizable_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1179: ERROR: relation "delayed_job_statuses" already exists
psql:openproject.sql:1191: ERROR: relation "delayed_job_statuses_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1219: ERROR: relation "delayed_jobs" already exists
psql:openproject.sql:1232: ERROR: relation "delayed_jobs_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1252: ERROR: relation "design_colors" already exists
psql:openproject.sql:1265: ERROR: relation "design_colors_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1286: ERROR: relation "document_journals" already exists
psql:openproject.sql:1299: ERROR: relation "document_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1321: ERROR: relation "documents" already exists
psql:openproject.sql:1334: ERROR: relation "documents_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1351: ERROR: relation "done_statuses_for_project" already exists
psql:openproject.sql:1362: ERROR: relation "enabled_modules" already exists
psql:openproject.sql:1375: ERROR: relation "enabled_modules_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1394: ERROR: relation "enterprise_tokens" already exists
psql:openproject.sql:1407: ERROR: relation "enterprise_tokens_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1433: ERROR: relation "enumerations" already exists
psql:openproject.sql:1446: ERROR: relation "enumerations_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1469: ERROR: relation "export_card_configurations" already exists
psql:openproject.sql:1482: ERROR: relation "export_card_configurations_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1505: ERROR: relation "forums" already exists
psql:openproject.sql:1518: ERROR: relation "forums_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1541: ERROR: relation "grid_widgets" already exists
psql:openproject.sql:1553: ERROR: relation "grid_widgets_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1578: ERROR: relation "grids" already exists
psql:openproject.sql:1590: ERROR: relation "grids_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1607: ERROR: relation "group_users" already exists
psql:openproject.sql:1622: ERROR: relation "ifc_models" already exists
psql:openproject.sql:1634: ERROR: relation "ifc_models_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1653: ERROR: relation "journal_versions" already exists
psql:openproject.sql:1665: ERROR: relation "journal_versions_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1688: ERROR: relation "journals" already exists
psql:openproject.sql:1701: ERROR: relation "journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1722: ERROR: relation "labor_budget_items" already exists
psql:openproject.sql:1735: ERROR: relation "labor_budget_items_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1755: ERROR: relation "ldap_groups_memberships" already exists
psql:openproject.sql:1768: ERROR: relation "ldap_groups_memberships_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1790: ERROR: relation "ldap_groups_synchronized_filters" already exists
psql:openproject.sql:1802: ERROR: relation "ldap_groups_synchronized_filters_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1825: ERROR: relation "ldap_groups_synchronized_groups" already exists
psql:openproject.sql:1838: ERROR: relation "ldap_groups_synchronized_groups_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1859: ERROR: relation "material_budget_items" already exists
psql:openproject.sql:1872: ERROR: relation "material_budget_items_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1893: ERROR: relation "meeting_content_journals" already exists
psql:openproject.sql:1906: ERROR: relation "meeting_content_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1930: ERROR: relation "meeting_contents" already exists
psql:openproject.sql:1943: ERROR: relation "meeting_contents_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:1966: ERROR: relation "meeting_journals" already exists
psql:openproject.sql:1979: ERROR: relation "meeting_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2003: ERROR: relation "meeting_participants" already exists
psql:openproject.sql:2016: ERROR: relation "meeting_participants_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2040: ERROR: relation "meetings" already exists
psql:openproject.sql:2053: ERROR: relation "meetings_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2072: ERROR: relation "member_roles" already exists
psql:openproject.sql:2085: ERROR: relation "member_roles_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2105: ERROR: relation "members" already exists
psql:openproject.sql:2118: ERROR: relation "members_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2140: ERROR: relation "menu_items" already exists
psql:openproject.sql:2153: ERROR: relation "menu_items_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2179: ERROR: relation "message_journals" already exists
psql:openproject.sql:2192: ERROR: relation "message_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2220: ERROR: relation "messages" already exists
psql:openproject.sql:2233: ERROR: relation "messages_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2257: ERROR: relation "news" already exists
psql:openproject.sql:2270: ERROR: relation "news_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2293: ERROR: relation "news_journals" already exists
psql:openproject.sql:2306: ERROR: relation "news_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2332: ERROR: relation "oauth_access_grants" already exists
psql:openproject.sql:2344: ERROR: relation "oauth_access_grants_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2369: ERROR: relation "oauth_access_tokens" already exists
psql:openproject.sql:2381: ERROR: relation "oauth_access_tokens_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2408: ERROR: relation "oauth_applications" already exists
psql:openproject.sql:2420: ERROR: relation "oauth_applications_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2439: ERROR: relation "ordered_work_packages" already exists
psql:openproject.sql:2451: ERROR: relation "ordered_work_packages_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2471: ERROR: relation "plaintext_tokens" already exists
psql:openproject.sql:2484: ERROR: relation "plaintext_tokens_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2504: ERROR: relation "principal_roles" already exists
psql:openproject.sql:2517: ERROR: relation "principal_roles_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2538: ERROR: relation "project_associations" already exists
psql:openproject.sql:2551: ERROR: relation "project_associations_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2572: ERROR: relation "project_statuses" already exists
psql:openproject.sql:2584: ERROR: relation "project_statuses_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2610: ERROR: relation "projects" already exists
psql:openproject.sql:2623: ERROR: relation "projects_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2640: ERROR: relation "projects_types" already exists
psql:openproject.sql:2668: ERROR: relation "queries" already exists
psql:openproject.sql:2681: ERROR: relation "queries_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2703: ERROR: relation "rates" already exists
psql:openproject.sql:2716: ERROR: relation "rates_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2736: ERROR: relation "recaptcha_entries" already exists
psql:openproject.sql:2749: ERROR: relation "recaptcha_entries_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2777: ERROR: relation "relations" already exists
psql:openproject.sql:2790: ERROR: relation "relations_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2817: ERROR: relation "repositories" already exists
psql:openproject.sql:2830: ERROR: relation "repositories_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2850: ERROR: relation "role_permissions" already exists
psql:openproject.sql:2863: ERROR: relation "role_permissions_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2884: ERROR: relation "roles" already exists
psql:openproject.sql:2897: ERROR: relation "roles_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2913: ERROR: relation "schema_migrations" already exists
psql:openproject.sql:2927: ERROR: relation "sessions" already exists
psql:openproject.sql:2940: ERROR: relation "sessions_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2959: ERROR: relation "settings" already exists
psql:openproject.sql:2972: ERROR: relation "settings_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:2997: ERROR: relation "statuses" already exists
psql:openproject.sql:3010: ERROR: relation "statuses_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3041: ERROR: relation "time_entries" already exists
psql:openproject.sql:3054: ERROR: relation "time_entries_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3073: ERROR: relation "time_entry_activities_projects" already exists
psql:openproject.sql:3085: ERROR: relation "time_entry_activities_projects_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3115: ERROR: relation "time_entry_journals" already exists
psql:openproject.sql:3128: ERROR: relation "time_entry_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3149: ERROR: relation "tokens" already exists
psql:openproject.sql:3162: ERROR: relation "tokens_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3189: ERROR: relation "two_factor_authentication_devices" already exists
psql:openproject.sql:3202: ERROR: relation "two_factor_authentication_devices_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3229: ERROR: relation "types" already exists
psql:openproject.sql:3242: ERROR: relation "types_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3264: ERROR: relation "user_passwords" already exists
psql:openproject.sql:3277: ERROR: relation "user_passwords_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3297: ERROR: relation "user_preferences" already exists
psql:openproject.sql:3310: ERROR: relation "user_preferences_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3345: ERROR: relation "users" already exists
psql:openproject.sql:3358: ERROR: relation "users_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3379: ERROR: relation "version_settings" already exists
psql:openproject.sql:3392: ERROR: relation "version_settings_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3418: ERROR: relation "versions" already exists
psql:openproject.sql:3431: ERROR: relation "versions_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3450: ERROR: relation "watchers" already exists
psql:openproject.sql:3463: ERROR: relation "watchers_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3481: ERROR: relation "webhooks_events" already exists
psql:openproject.sql:3494: ERROR: relation "webhooks_events_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3520: ERROR: relation "webhooks_logs" already exists
psql:openproject.sql:3533: ERROR: relation "webhooks_logs_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3551: ERROR: relation "webhooks_projects" already exists
psql:openproject.sql:3564: ERROR: relation "webhooks_projects_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3588: ERROR: relation "webhooks_webhooks" already exists
psql:openproject.sql:3601: ERROR: relation "webhooks_webhooks_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3621: ERROR: relation "wiki_content_journals" already exists
psql:openproject.sql:3634: ERROR: relation "wiki_content_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3655: ERROR: relation "wiki_contents" already exists
psql:openproject.sql:3668: ERROR: relation "wiki_contents_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3691: ERROR: relation "wiki_pages" already exists
psql:openproject.sql:3704: ERROR: relation "wiki_pages_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3724: ERROR: relation "wiki_redirects" already exists
psql:openproject.sql:3737: ERROR: relation "wiki_redirects_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3758: ERROR: relation "wikis" already exists
psql:openproject.sql:3771: ERROR: relation "wikis_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3790: ERROR: relation "work_package_exports" already exists
psql:openproject.sql:3802: ERROR: relation "work_package_exports_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3839: ERROR: relation "work_package_journals" already exists
psql:openproject.sql:3852: ERROR: relation "work_package_journals_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3891: ERROR: relation "work_packages" already exists
psql:openproject.sql:3904: ERROR: relation "work_packages_id_seq" already exists
ALTER SEQUENCE
psql:openproject.sql:3926: ERROR: relation "workflows" already exists
psql:openproject.sql:3939: ERROR: relation "workflows_id_seq" already exists
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COPY 0
psql:openproject.sql:4705: ERROR: duplicate key value violates unique constraint "ar_internal_metadata_pkey"
DETAIL: Key (key)=(environment) already exists.
CONTEXT: COPY ar_internal_metadata, line 1
psql:openproject.sql:4727: ERROR: duplicate key value violates unique constraint "attachable_journals_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY attachable_journals, line 1
psql:openproject.sql:4744: ERROR: duplicate key value violates unique constraint "attachment_journals_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY attachment_journals, line 1
psql:openproject.sql:4761: ERROR: duplicate key value violates unique constraint "attachments_pkey"
DETAIL: Key (id)=(6) already exists.
CONTEXT: COPY attachments, line 1
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
psql:openproject.sql:4811: ERROR: duplicate key value violates unique constraint "categories_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY categories, line 1
COPY 0
COPY 0
COPY 0
COPY 0
psql:openproject.sql:4995: ERROR: duplicate key value violates unique constraint "colors_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY colors, line 1
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
psql:openproject.sql:5160: ERROR: duplicate key value violates unique constraint "delayed_jobs_pkey"
DETAIL: Key (id)=(2) already exists.
CONTEXT: COPY delayed_jobs, line 1
COPY 0
COPY 0
COPY 0
COPY 0
psql:openproject.sql:5229: ERROR: duplicate key value violates unique constraint "enabled_modules_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY enabled_modules, line 1
COPY 0
psql:openproject.sql:5258: ERROR: duplicate key value violates unique constraint "enumerations_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY enumerations, line 1
COPY 0
COPY 0
psql:openproject.sql:5312: ERROR: duplicate key value violates unique constraint "grid_widgets_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY grid_widgets, line 1
psql:openproject.sql:5326: ERROR: duplicate key value violates unique constraint "grids_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY grids, line 1
COPY 0
COPY 0
psql:openproject.sql:5415: ERROR: duplicate key value violates unique constraint "journal_versions_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY journal_versions, line 1
psql:openproject.sql:5514: ERROR: duplicate key value violates unique constraint "journals_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY journals, line 1
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
psql:openproject.sql:5604: ERROR: duplicate key value violates unique constraint "member_roles_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY member_roles, line 1
psql:openproject.sql:5614: ERROR: duplicate key value violates unique constraint "members_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY members, line 1
psql:openproject.sql:5634: ERROR: duplicate key value violates unique constraint "menu_items_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY menu_items, line 1
COPY 0
COPY 0
psql:openproject.sql:5660: ERROR: duplicate key value violates unique constraint "news_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY news, line 1
psql:openproject.sql:5670: ERROR: duplicate key value violates unique constraint "news_journals_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY news_journals, line 1
COPY 0
COPY 0
COPY 0
psql:openproject.sql:5715: ERROR: duplicate key value violates unique constraint "ordered_work_packages_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY ordered_work_packages, line 1
COPY 0
COPY 0
COPY 0
psql:openproject.sql:5751: ERROR: duplicate key value violates unique constraint "project_statuses_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY project_statuses, line 1
psql:openproject.sql:5763: ERROR: duplicate key value violates unique constraint "projects_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY projects, line 1
psql:openproject.sql:5796: ERROR: duplicate key value violates unique constraint "projects_types_unique"
DETAIL: Key (project_id, type_id)=(1, 1) already exists.
CONTEXT: COPY projects_types, line 1
psql:openproject.sql:5828: ERROR: duplicate key value violates unique constraint "queries_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY queries, line 1
COPY 0
COPY 0
psql:openproject.sql:5951: ERROR: duplicate key value violates unique constraint "relations_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY relations, line 1
COPY 0
psql:openproject.sql:6171: ERROR: duplicate key value violates unique constraint "role_permissions_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY role_permissions, line 1
psql:openproject.sql:6185: ERROR: duplicate key value violates unique constraint "roles_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY roles, line 1
psql:openproject.sql:6301: ERROR: duplicate key value violates unique constraint "schema_migrations_pkey"
DETAIL: Key (version)=(10000000000000) already exists.
CONTEXT: COPY schema_migrations, line 1
COPY 0
psql:openproject.sql:6441: ERROR: duplicate key value violates unique constraint "settings_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY settings, line 1
psql:openproject.sql:6463: ERROR: duplicate key value violates unique constraint "statuses_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY statuses, line 1
COPY 0
COPY 0
COPY 0
psql:openproject.sql:6496: ERROR: duplicate key value violates unique constraint "tokens_pkey"
DETAIL: Key (id)=(2) already exists.
CONTEXT: COPY tokens, line 1
COPY 0
psql:openproject.sql:6519: ERROR: duplicate key value violates unique constraint "types_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY types, line 1
psql:openproject.sql:6528: ERROR: duplicate key value violates unique constraint "user_passwords_pkey"
DETAIL: Key (id)=(2) already exists.
CONTEXT: COPY user_passwords, line 1
psql:openproject.sql:6537: ERROR: duplicate key value violates unique constraint "user_preferences_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY user_preferences, line 1
psql:openproject.sql:6548: ERROR: duplicate key value violates unique constraint "users_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY users, line 1
psql:openproject.sql:6560: ERROR: duplicate key value violates unique constraint "version_settings_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY version_settings, line 1
psql:openproject.sql:6572: ERROR: duplicate key value violates unique constraint "versions_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY versions, line 1
psql:openproject.sql:6582: ERROR: duplicate key value violates unique constraint "watchers_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY watchers, line 1
COPY 0
COPY 0
COPY 0
COPY 0
psql:openproject.sql:6627: ERROR: duplicate key value violates unique constraint "wiki_content_journals_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY wiki_content_journals, line 1
psql:openproject.sql:6640: ERROR: duplicate key value violates unique constraint "wiki_contents_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY wiki_contents, line 1
psql:openproject.sql:6653: ERROR: duplicate key value violates unique constraint "wiki_pages_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY wiki_pages, line 1
COPY 0
psql:openproject.sql:6673: ERROR: duplicate key value violates unique constraint "wikis_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY wikis, line 1
COPY 0
psql:openproject.sql:6764: ERROR: duplicate key value violates unique constraint "work_package_journals_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY work_package_journals, line 1
psql:openproject.sql:6821: ERROR: duplicate key value violates unique constraint "work_packages_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY work_packages, line 1
psql:openproject.sql:8001: ERROR: duplicate key value violates unique constraint "workflows_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY workflows, line 1
setval
(1 row)
psql:openproject.sql:8751: ERROR: multiple primary keys for table "announcements" are not allowed
psql:openproject.sql:8759: ERROR: multiple primary keys for table "ar_internal_metadata" are not allowed
psql:openproject.sql:8767: ERROR: multiple primary keys for table "attachable_journals" are not allowed
psql:openproject.sql:8775: ERROR: multiple primary keys for table "attachment_journals" are not allowed
psql:openproject.sql:8783: ERROR: multiple primary keys for table "attachments" are not allowed
psql:openproject.sql:8791: ERROR: multiple primary keys for table "attribute_help_texts" are not allowed
psql:openproject.sql:8799: ERROR: multiple primary keys for table "auth_sources" are not allowed
psql:openproject.sql:8807: ERROR: multiple primary keys for table "bcf_comments" are not allowed
psql:openproject.sql:8815: ERROR: multiple primary keys for table "bcf_issues" are not allowed
psql:openproject.sql:8823: ERROR: multiple primary keys for table "bcf_viewpoints" are not allowed
psql:openproject.sql:8831: ERROR: multiple primary keys for table "categories" are not allowed
psql:openproject.sql:8839: ERROR: multiple primary keys for table "changes" are not allowed
psql:openproject.sql:8847: ERROR: multiple primary keys for table "changeset_journals" are not allowed
psql:openproject.sql:8855: ERROR: multiple primary keys for table "changesets" are not allowed
psql:openproject.sql:8863: ERROR: multiple primary keys for table "colors" are not allowed
psql:openproject.sql:8871: ERROR: multiple primary keys for table "comments" are not allowed
psql:openproject.sql:8879: ERROR: multiple primary keys for table "cost_entries" are not allowed
psql:openproject.sql:8887: ERROR: multiple primary keys for table "cost_object_journals" are not allowed
psql:openproject.sql:8895: ERROR: multiple primary keys for table "cost_objects" are not allowed
psql:openproject.sql:8903: ERROR: multiple primary keys for table "cost_queries" are not allowed
psql:openproject.sql:8911: ERROR: multiple primary keys for table "cost_types" are not allowed
psql:openproject.sql:8919: ERROR: multiple primary keys for table "custom_actions" are not allowed
psql:openproject.sql:8927: ERROR: multiple primary keys for table "custom_actions_projects" are not allowed
psql:openproject.sql:8935: ERROR: multiple primary keys for table "custom_actions_roles" are not allowed
psql:openproject.sql:8943: ERROR: multiple primary keys for table "custom_actions_statuses" are not allowed
psql:openproject.sql:8951: ERROR: multiple primary keys for table "custom_actions_types" are not allowed
psql:openproject.sql:8959: ERROR: multiple primary keys for table "custom_fields" are not allowed
psql:openproject.sql:8967: ERROR: multiple primary keys for table "custom_options" are not allowed
psql:openproject.sql:8975: ERROR: multiple primary keys for table "custom_styles" are not allowed
psql:openproject.sql:8983: ERROR: multiple primary keys for table "custom_values" are not allowed
psql:openproject.sql:8991: ERROR: multiple primary keys for table "customizable_journals" are not allowed
psql:openproject.sql:8999: ERROR: multiple primary keys for table "delayed_job_statuses" are not allowed
psql:openproject.sql:9007: ERROR: multiple primary keys for table "delayed_jobs" are not allowed
psql:openproject.sql:9015: ERROR: multiple primary keys for table "design_colors" are not allowed
psql:openproject.sql:9023: ERROR: multiple primary keys for table "document_journals" are not allowed
psql:openproject.sql:9031: ERROR: multiple primary keys for table "documents" are not allowed
psql:openproject.sql:9039: ERROR: multiple primary keys for table "enabled_modules" are not allowed
psql:openproject.sql:9047: ERROR: multiple primary keys for table "enterprise_tokens" are not allowed
psql:openproject.sql:9055: ERROR: multiple primary keys for table "enumerations" are not allowed
psql:openproject.sql:9063: ERROR: multiple primary keys for table "export_card_configurations" are not allowed
psql:openproject.sql:9071: ERROR: multiple primary keys for table "forums" are not allowed
psql:openproject.sql:9079: ERROR: multiple primary keys for table "grid_widgets" are not allowed
psql:openproject.sql:9087: ERROR: multiple primary keys for table "grids" are not allowed
psql:openproject.sql:9095: ERROR: multiple primary keys for table "ifc_models" are not allowed
psql:openproject.sql:9103: ERROR: multiple primary keys for table "journal_versions" are not allowed
psql:openproject.sql:9111: ERROR: multiple primary keys for table "journals" are not allowed
psql:openproject.sql:9119: ERROR: multiple primary keys for table "labor_budget_items" are not allowed
psql:openproject.sql:9127: ERROR: multiple primary keys for table "ldap_groups_memberships" are not allowed
psql:openproject.sql:9135: ERROR: multiple primary keys for table "ldap_groups_synchronized_filters" are not allowed
psql:openproject.sql:9143: ERROR: multiple primary keys for table "ldap_groups_synchronized_groups" are not allowed
psql:openproject.sql:9151: ERROR: multiple primary keys for table "material_budget_items" are not allowed
psql:openproject.sql:9159: ERROR: multiple primary keys for table "meeting_content_journals" are not allowed
psql:openproject.sql:9167: ERROR: multiple primary keys for table "meeting_contents" are not allowed
psql:openproject.sql:9175: ERROR: multiple primary keys for table "meeting_journals" are not allowed
psql:openproject.sql:9183: ERROR: multiple primary keys for table "meeting_participants" are not allowed
psql:openproject.sql:9191: ERROR: multiple primary keys for table "meetings" are not allowed
psql:openproject.sql:9199: ERROR: multiple primary keys for table "member_roles" are not allowed
psql:openproject.sql:9207: ERROR: multiple primary keys for table "members" are not allowed
psql:openproject.sql:9215: ERROR: multiple primary keys for table "menu_items" are not allowed
psql:openproject.sql:9223: ERROR: multiple primary keys for table "message_journals" are not allowed
psql:openproject.sql:9231: ERROR: multiple primary keys for table "messages" are not allowed
psql:openproject.sql:9239: ERROR: multiple primary keys for table "news_journals" are not allowed
psql:openproject.sql:9247: ERROR: multiple primary keys for table "news" are not allowed
psql:openproject.sql:9255: ERROR: multiple primary keys for table "oauth_access_grants" are not allowed
psql:openproject.sql:9263: ERROR: multiple primary keys for table "oauth_access_tokens" are not allowed
psql:openproject.sql:9271: ERROR: multiple primary keys for table "oauth_applications" are not allowed
psql:openproject.sql:9279: ERROR: multiple primary keys for table "ordered_work_packages" are not allowed
psql:openproject.sql:9287: ERROR: multiple primary keys for table "plaintext_tokens" are not allowed
psql:openproject.sql:9295: ERROR: multiple primary keys for table "principal_roles" are not allowed
psql:openproject.sql:9303: ERROR: multiple primary keys for table "project_associations" are not allowed
psql:openproject.sql:9311: ERROR: multiple primary keys for table "project_statuses" are not allowed
psql:openproject.sql:9319: ERROR: multiple primary keys for table "projects" are not allowed
psql:openproject.sql:9327: ERROR: multiple primary keys for table "queries" are not allowed
psql:openproject.sql:9335: ERROR: multiple primary keys for table "rates" are not allowed
psql:openproject.sql:9343: ERROR: multiple primary keys for table "recaptcha_entries" are not allowed
psql:openproject.sql:9351: ERROR: multiple primary keys for table "relations" are not allowed
psql:openproject.sql:9359: ERROR: multiple primary keys for table "repositories" are not allowed
psql:openproject.sql:9367: ERROR: multiple primary keys for table "role_permissions" are not allowed
psql:openproject.sql:9375: ERROR: multiple primary keys for table "roles" are not allowed
psql:openproject.sql:9383: ERROR: multiple primary keys for table "schema_migrations" are not allowed
psql:openproject.sql:9391: ERROR: multiple primary keys for table "sessions" are not allowed
psql:openproject.sql:9399: ERROR: multiple primary keys for table "settings" are not allowed
psql:openproject.sql:9407: ERROR: multiple primary keys for table "statuses" are not allowed
psql:openproject.sql:9415: ERROR: multiple primary keys for table "time_entries" are not allowed
psql:openproject.sql:9423: ERROR: multiple primary keys for table "time_entry_activities_projects" are not allowed
psql:openproject.sql:9431: ERROR: multiple primary keys for table "time_entry_journals" are not allowed
psql:openproject.sql:9439: ERROR: multiple primary keys for table "tokens" are not allowed
psql:openproject.sql:9447: ERROR: multiple primary keys for table "two_factor_authentication_devices" are not allowed
psql:openproject.sql:9455: ERROR: multiple primary keys for table "types" are not allowed
psql:openproject.sql:9463: ERROR: multiple primary keys for table "user_passwords" are not allowed
psql:openproject.sql:9471: ERROR: multiple primary keys for table "user_preferences" are not allowed
psql:openproject.sql:9479: ERROR: multiple primary keys for table "users" are not allowed
psql:openproject.sql:9487: ERROR: multiple primary keys for table "version_settings" are not allowed
psql:openproject.sql:9495: ERROR: multiple primary keys for table "versions" are not allowed
psql:openproject.sql:9503: ERROR: multiple primary keys for table "watchers" are not allowed
psql:openproject.sql:9511: ERROR: multiple primary keys for table "webhooks_events" are not allowed
psql:openproject.sql:9519: ERROR: multiple primary keys for table "webhooks_logs" are not allowed
psql:openproject.sql:9527: ERROR: multiple primary keys for table "webhooks_projects" are not allowed
psql:openproject.sql:9535: ERROR: multiple primary keys for table "webhooks_webhooks" are not allowed
psql:openproject.sql:9543: ERROR: multiple primary keys for table "wiki_content_journals" are not allowed
psql:openproject.sql:9551: ERROR: multiple primary keys for table "wiki_contents" are not allowed
psql:openproject.sql:9559: ERROR: multiple primary keys for table "wiki_pages" are not allowed
psql:openproject.sql:9567: ERROR: multiple primary keys for table "wiki_redirects" are not allowed
psql:openproject.sql:9575: ERROR: multiple primary keys for table "wikis" are not allowed
psql:openproject.sql:9583: ERROR: multiple primary keys for table "work_package_exports" are not allowed
psql:openproject.sql:9591: ERROR: multiple primary keys for table "work_package_journals" are not allowed
psql:openproject.sql:9599: ERROR: multiple primary keys for table "work_packages" are not allowed
psql:openproject.sql:9607: ERROR: multiple primary keys for table "workflows" are not allowed
psql:openproject.sql:9614: ERROR: relation "changesets_changeset_id" already exists
psql:openproject.sql:9621: ERROR: relation "changesets_repos_rev" already exists
psql:openproject.sql:9628: ERROR: relation "changesets_repos_scmid" already exists
psql:openproject.sql:9635: ERROR: relation "changesets_work_packages_ids" already exists
psql:openproject.sql:9642: ERROR: relation "custom_fields_types_unique" already exists
psql:openproject.sql:9649: ERROR: relation "custom_values_customized" already exists
psql:openproject.sql:9656: ERROR: relation "delayed_jobs_priority" already exists
psql:openproject.sql:9663: ERROR: relation "documents_project_id" already exists
psql:openproject.sql:9670: ERROR: relation "enabled_modules_project_id" already exists
psql:openproject.sql:9677: ERROR: relation "forums_project_id" already exists
psql:openproject.sql:9684: ERROR: relation "group_user_ids" already exists
psql:openproject.sql:9691: ERROR: relation "index_announcements_on_show_until_and_active" already exists
psql:openproject.sql:9698: ERROR: relation "index_attachable_journals_on_attachment_id" already exists
psql:openproject.sql:9705: ERROR: relation "index_attachable_journals_on_journal_id" already exists
psql:openproject.sql:9712: ERROR: relation "index_attachment_journals_on_journal_id" already exists
psql:openproject.sql:9719: ERROR: relation "index_attachments_on_author_id" already exists
psql:openproject.sql:9726: ERROR: relation "index_attachments_on_container_id_and_container_type" already exists
psql:openproject.sql:9733: ERROR: relation "index_attachments_on_created_at" already exists
psql:openproject.sql:9740: ERROR: relation "index_attachments_on_file_tsv" already exists
psql:openproject.sql:9747: ERROR: relation "index_attachments_on_fulltext_tsv" already exists
psql:openproject.sql:9754: ERROR: relation "index_auth_sources_on_id_and_type" already exists
psql:openproject.sql:9761: ERROR: relation "index_bcf_comments_on_issue_id" already exists
psql:openproject.sql:9768: ERROR: relation "index_bcf_comments_on_journal_id" already exists
psql:openproject.sql:9775: ERROR: relation "index_bcf_comments_on_uuid" already exists
psql:openproject.sql:9782: ERROR: relation "index_bcf_comments_on_uuid_and_issue_id" already exists
psql:openproject.sql:9789: ERROR: relation "index_bcf_comments_on_viewpoint_id" already exists
psql:openproject.sql:9796: ERROR: relation "index_bcf_issues_on_uuid" already exists
psql:openproject.sql:9803: ERROR: relation "index_bcf_issues_on_work_package_id" already exists
psql:openproject.sql:9810: ERROR: relation "index_bcf_viewpoints_on_issue_id" already exists
psql:openproject.sql:9817: ERROR: relation "index_bcf_viewpoints_on_uuid" already exists
psql:openproject.sql:9824: ERROR: relation "index_bcf_viewpoints_on_uuid_and_issue_id" already exists
psql:openproject.sql:9831: ERROR: relation "index_categories_on_assigned_to_id" already exists
psql:openproject.sql:9838: ERROR: relation "index_changeset_journals_on_journal_id" already exists
psql:openproject.sql:9845: ERROR: relation "index_changesets_on_committed_on" already exists
psql:openproject.sql:9852: ERROR: relation "index_changesets_on_repository_id" already exists
psql:openproject.sql:9859: ERROR: relation "index_changesets_on_repository_id_and_committed_on" already exists
psql:openproject.sql:9866: ERROR: relation "index_changesets_on_user_id" already exists
psql:openproject.sql:9873: ERROR: relation "index_comments_on_author_id" already exists
psql:openproject.sql:9880: ERROR: relation "index_comments_on_commented_id_and_commented_type" already exists
psql:openproject.sql:9887: ERROR: relation "index_cost_objects_on_project_id_and_updated_on" already exists
psql:openproject.sql:9894: ERROR: relation "index_custom_actions_projects_on_custom_action_id" already exists
psql:openproject.sql:9901: ERROR: relation "index_custom_actions_projects_on_project_id" already exists
psql:openproject.sql:9908: ERROR: relation "index_custom_actions_roles_on_custom_action_id" already exists
psql:openproject.sql:9915: ERROR: relation "index_custom_actions_roles_on_role_id" already exists
psql:openproject.sql:9922: ERROR: relation "index_custom_actions_statuses_on_custom_action_id" already exists
psql:openproject.sql:9929: ERROR: relation "index_custom_actions_statuses_on_status_id" already exists
psql:openproject.sql:9936: ERROR: relation "index_custom_actions_types_on_custom_action_id" already exists
psql:openproject.sql:9943: ERROR: relation "index_custom_actions_types_on_type_id" already exists
psql:openproject.sql:9950: ERROR: relation "index_custom_fields_on_id_and_type" already exists
psql:openproject.sql:9957: ERROR: relation "index_custom_fields_projects_on_custom_field_id_and_project_id" already exists
psql:openproject.sql:9964: ERROR: relation "index_custom_values_on_custom_field_id" already exists
psql:openproject.sql:9971: ERROR: relation "index_customizable_journals_on_custom_field_id" already exists
psql:openproject.sql:9978: ERROR: relation "index_customizable_journals_on_journal_id" already exists
psql:openproject.sql:9985: ERROR: relation "index_delayed_job_statuses_on_job_id" already exists
psql:openproject.sql:9992: ERROR: relation "index_delayed_job_statuses_on_reference_type_and_reference_id" already exists
psql:openproject.sql:9999: ERROR: relation "index_design_colors_on_variable" already exists
psql:openproject.sql:10006: ERROR: relation "index_documents_on_category_id" already exists
psql:openproject.sql:10013: ERROR: relation "index_documents_on_created_at" already exists
psql:openproject.sql:10020: ERROR: relation "index_enabled_modules_on_name" already exists
psql:openproject.sql:10027: ERROR: relation "index_enumerations_on_color_id" already exists
psql:openproject.sql:10034: ERROR: relation "index_enumerations_on_id_and_type" already exists
psql:openproject.sql:10041: ERROR: relation "index_enumerations_on_project_id" already exists
psql:openproject.sql:10048: ERROR: relation "index_forums_on_last_message_id" already exists
psql:openproject.sql:10055: ERROR: relation "index_grid_widgets_on_grid_id" already exists
psql:openproject.sql:10062: ERROR: relation "index_grids_on_project_id" already exists
psql:openproject.sql:10069: ERROR: relation "index_grids_on_user_id" already exists
psql:openproject.sql:10076: ERROR: relation "index_ifc_models_on_is_default" already exists
psql:openproject.sql:10083: ERROR: relation "index_ifc_models_on_project_id" already exists
psql:openproject.sql:10090: ERROR: relation "index_ifc_models_on_uploader_id" already exists
psql:openproject.sql:10097: ERROR: relation "index_journals_on_activity_type" already exists
psql:openproject.sql:10104: ERROR: relation "index_journals_on_created_at" already exists
psql:openproject.sql:10111: ERROR: relation "index_journals_on_journable_id" already exists
psql:openproject.sql:10118: ERROR: relation "index_journals_on_journable_type" already exists
psql:openproject.sql:10125: ERROR: relation "index_journals_on_journable_type_and_journable_id_and_version" already exists
psql:openproject.sql:10132: ERROR: relation "index_journals_on_user_id" already exists
psql:openproject.sql:10139: ERROR: relation "index_ldap_groups_memberships_on_group_id" already exists
psql:openproject.sql:10146: ERROR: relation "index_ldap_groups_memberships_on_user_id" already exists
psql:openproject.sql:10153: ERROR: relation "index_ldap_groups_synchronized_filters_on_auth_source_id" already exists
psql:openproject.sql:10160: ERROR: relation "index_ldap_groups_synchronized_groups_on_auth_source_id" already exists
psql:openproject.sql:10167: ERROR: relation "index_ldap_groups_synchronized_groups_on_filter_id" already exists
psql:openproject.sql:10174: ERROR: relation "index_ldap_groups_synchronized_groups_on_group_id" already exists
psql:openproject.sql:10181: ERROR: relation "index_meetings_on_project_id_and_updated_at" already exists
psql:openproject.sql:10188: ERROR: relation "index_member_roles_on_inherited_from" already exists
psql:openproject.sql:10195: ERROR: relation "index_member_roles_on_member_id" already exists
psql:openproject.sql:10202: ERROR: relation "index_member_roles_on_role_id" already exists
psql:openproject.sql:10209: ERROR: relation "index_members_on_project_id" already exists
psql:openproject.sql:10216: ERROR: relation "index_members_on_user_id" already exists
psql:openproject.sql:10223: ERROR: relation "index_members_on_user_id_and_project_id" already exists
psql:openproject.sql:10230: ERROR: relation "index_menu_items_on_navigatable_id_and_title" already exists
psql:openproject.sql:10237: ERROR: relation "index_menu_items_on_parent_id" already exists
psql:openproject.sql:10244: ERROR: relation "index_message_journals_on_journal_id" already exists
psql:openproject.sql:10251: ERROR: relation "index_messages_on_author_id" already exists
psql:openproject.sql:10258: ERROR: relation "index_messages_on_created_on" already exists
psql:openproject.sql:10265: ERROR: relation "index_messages_on_forum_id_and_updated_on" already exists
psql:openproject.sql:10272: ERROR: relation "index_messages_on_last_reply_id" already exists
psql:openproject.sql:10279: ERROR: relation "index_news_journals_on_journal_id" already exists
psql:openproject.sql:10286: ERROR: relation "index_news_on_author_id" already exists
psql:openproject.sql:10293: ERROR: relation "index_news_on_created_at" already exists
psql:openproject.sql:10300: ERROR: relation "index_news_on_project_id_and_created_at" already exists
psql:openproject.sql:10307: ERROR: relation "index_oauth_access_grants_on_application_id" already exists
psql:openproject.sql:10314: ERROR: relation "index_oauth_access_grants_on_resource_owner_id" already exists
psql:openproject.sql:10321: ERROR: relation "index_oauth_access_grants_on_token" already exists
psql:openproject.sql:10328: ERROR: relation "index_oauth_access_tokens_on_application_id" already exists
psql:openproject.sql:10335: ERROR: relation "index_oauth_access_tokens_on_refresh_token" already exists
psql:openproject.sql:10342: ERROR: relation "index_oauth_access_tokens_on_resource_owner_id" already exists
psql:openproject.sql:10349: ERROR: relation "index_oauth_access_tokens_on_token" already exists
psql:openproject.sql:10356: ERROR: relation "index_oauth_applications_on_owner_id_and_owner_type" already exists
psql:openproject.sql:10363: ERROR: relation "index_oauth_applications_on_uid" already exists
psql:openproject.sql:10370: ERROR: relation "index_ordered_work_packages_on_position" already exists
psql:openproject.sql:10377: ERROR: relation "index_ordered_work_packages_on_query_id" already exists
psql:openproject.sql:10384: ERROR: relation "index_ordered_work_packages_on_work_package_id" already exists
psql:openproject.sql:10391: ERROR: relation "index_plaintext_tokens_on_user_id" already exists
psql:openproject.sql:10398: ERROR: relation "index_principal_roles_on_principal_id" already exists
psql:openproject.sql:10405: ERROR: relation "index_principal_roles_on_role_id" already exists
psql:openproject.sql:10412: ERROR: relation "index_project_associations_on_project_a_id" already exists
psql:openproject.sql:10419: ERROR: relation "index_project_associations_on_project_b_id" already exists
psql:openproject.sql:10426: ERROR: relation "index_project_statuses_on_project_id" already exists
psql:openproject.sql:10433: ERROR: relation "index_projects_on_identifier" already exists
psql:openproject.sql:10440: ERROR: relation "index_projects_on_lft" already exists
psql:openproject.sql:10447: ERROR: relation "index_projects_on_rgt" already exists
psql:openproject.sql:10454: ERROR: relation "index_queries_on_project_id" already exists
psql:openproject.sql:10461: ERROR: relation "index_queries_on_updated_at" already exists
psql:openproject.sql:10468: ERROR: relation "index_queries_on_user_id" already exists
psql:openproject.sql:10475: ERROR: relation "index_recaptcha_entries_on_user_id" already exists
psql:openproject.sql:10482: ERROR: relation "index_relations_direct_non_hierarchy" already exists
psql:openproject.sql:10489: ERROR: relation "index_relations_hierarchy_follows_scheduling" already exists
psql:openproject.sql:10496: ERROR: relation "index_relations_on_count" already exists
psql:openproject.sql:10503: ERROR: relation "index_relations_on_from_id" already exists
psql:openproject.sql:10510: ERROR: relation "index_relations_on_to_id" already exists
psql:openproject.sql:10517: ERROR: relation "index_relations_on_type_columns" already exists
psql:openproject.sql:10524: ERROR: relation "index_relations_only_hierarchy" already exists
psql:openproject.sql:10531: ERROR: relation "index_relations_to_from_only_follows" already exists
psql:openproject.sql:10538: ERROR: relation "index_repositories_on_project_id" already exists
psql:openproject.sql:10545: ERROR: relation "index_role_permissions_on_role_id" already exists
psql:openproject.sql:10552: ERROR: relation "index_sessions_on_session_id" already exists
psql:openproject.sql:10559: ERROR: relation "index_sessions_on_updated_at" already exists
psql:openproject.sql:10566: ERROR: relation "index_settings_on_name" already exists
psql:openproject.sql:10573: ERROR: relation "index_statuses_on_color_id" already exists
psql:openproject.sql:10580: ERROR: relation "index_statuses_on_is_closed" already exists
psql:openproject.sql:10587: ERROR: relation "index_statuses_on_is_default" already exists
psql:openproject.sql:10594: ERROR: relation "index_statuses_on_position" already exists
psql:openproject.sql:10601: ERROR: relation "index_teap_on_project_id_and_activity_id" already exists
psql:openproject.sql:10608: ERROR: relation "index_time_entries_on_activity_id" already exists
psql:openproject.sql:10615: ERROR: relation "index_time_entries_on_created_on" already exists
psql:openproject.sql:10622: ERROR: relation "index_time_entries_on_project_id_and_updated_on" already exists
psql:openproject.sql:10629: ERROR: relation "index_time_entries_on_user_id" already exists
psql:openproject.sql:10636: ERROR: relation "index_time_entry_activities_projects_on_active" already exists
psql:openproject.sql:10643: ERROR: relation "index_time_entry_activities_projects_on_activity_id" already exists
psql:openproject.sql:10650: ERROR: relation "index_time_entry_activities_projects_on_project_id" already exists
psql:openproject.sql:10657: ERROR: relation "index_time_entry_journals_on_journal_id" already exists
psql:openproject.sql:10664: ERROR: relation "index_tokens_on_user_id" already exists
psql:openproject.sql:10671: ERROR: relation "index_two_factor_authentication_devices_on_user_id" already exists
psql:openproject.sql:10678: ERROR: relation "index_types_on_color_id" already exists
psql:openproject.sql:10685: ERROR: relation "index_user_passwords_on_user_id" already exists
psql:openproject.sql:10692: ERROR: relation "index_user_preferences_on_user_id" already exists
psql:openproject.sql:10699: ERROR: relation "index_users_on_auth_source_id" already exists
psql:openproject.sql:10706: ERROR: relation "index_users_on_id_and_type" already exists
psql:openproject.sql:10713: ERROR: relation "index_users_on_type" already exists
psql:openproject.sql:10720: ERROR: relation "index_users_on_type_and_login" already exists
psql:openproject.sql:10727: ERROR: relation "index_users_on_type_and_status" already exists
psql:openproject.sql:10734: ERROR: relation "index_version_settings_on_project_id_and_version_id" already exists
psql:openproject.sql:10741: ERROR: relation "index_versions_on_sharing" already exists
psql:openproject.sql:10748: ERROR: relation "index_watchers_on_user_id" already exists
psql:openproject.sql:10755: ERROR: relation "index_watchers_on_watchable_id_and_watchable_type" already exists
psql:openproject.sql:10762: ERROR: relation "index_webhooks_events_on_webhooks_webhook_id" already exists
psql:openproject.sql:10769: ERROR: relation "index_webhooks_logs_on_webhooks_webhook_id" already exists
psql:openproject.sql:10776: ERROR: relation "index_webhooks_projects_on_project_id" already exists
psql:openproject.sql:10783: ERROR: relation "index_webhooks_projects_on_webhooks_webhook_id" already exists
psql:openproject.sql:10790: ERROR: relation "index_wiki_content_journals_on_journal_id" already exists
psql:openproject.sql:10797: ERROR: relation "index_wiki_contents_on_author_id" already exists
psql:openproject.sql:10804: ERROR: relation "index_wiki_contents_on_page_id_and_updated_on" already exists
psql:openproject.sql:10811: ERROR: relation "index_wiki_pages_on_parent_id" already exists
psql:openproject.sql:10818: ERROR: relation "index_wiki_pages_on_wiki_id" already exists
psql:openproject.sql:10825: ERROR: relation "index_wiki_redirects_on_wiki_id" already exists
psql:openproject.sql:10832: ERROR: relation "index_work_package_exports_on_user_id" already exists
psql:openproject.sql:10839: ERROR: relation "index_work_package_journals_on_journal_id" already exists
psql:openproject.sql:10846: ERROR: relation "index_work_packages_on_assigned_to_id" already exists
psql:openproject.sql:10853: ERROR: relation "index_work_packages_on_author_id" already exists
psql:openproject.sql:10860: ERROR: relation "index_work_packages_on_category_id" already exists
psql:openproject.sql:10867: ERROR: relation "index_work_packages_on_created_at" already exists
psql:openproject.sql:10874: ERROR: relation "index_work_packages_on_project_id" already exists
psql:openproject.sql:10881: ERROR: relation "index_work_packages_on_project_id_and_updated_at" already exists
psql:openproject.sql:10888: ERROR: relation "index_work_packages_on_responsible_id" already exists
psql:openproject.sql:10895: ERROR: relation "index_work_packages_on_status_id" already exists
psql:openproject.sql:10902: ERROR: relation "index_work_packages_on_type_id" already exists
psql:openproject.sql:10909: ERROR: relation "index_work_packages_on_updated_at" already exists
psql:openproject.sql:10916: ERROR: relation "index_work_packages_on_version_id" already exists
psql:openproject.sql:10923: ERROR: relation "index_workflows_on_new_status_id" already exists
psql:openproject.sql:10930: ERROR: relation "index_workflows_on_old_status_id" already exists
psql:openproject.sql:10937: ERROR: relation "index_workflows_on_role_id" already exists
psql:openproject.sql:10944: ERROR: relation "issue_categories_project_id" already exists
psql:openproject.sql:10951: ERROR: relation "messages_board_id" already exists
psql:openproject.sql:10958: ERROR: relation "messages_parent_id" already exists
psql:openproject.sql:10965: ERROR: relation "news_project_id" already exists
psql:openproject.sql:10972: ERROR: relation "projects_types_project_id" already exists
psql:openproject.sql:10979: ERROR: relation "projects_types_unique" already exists
psql:openproject.sql:10986: ERROR: relation "time_entries_issue_id" already exists
psql:openproject.sql:10993: ERROR: relation "time_entries_project_id" already exists
psql:openproject.sql:11000: ERROR: relation "unique_inherited_role" already exists
psql:openproject.sql:11007: ERROR: relation "unique_journal_version" already exists
psql:openproject.sql:11014: ERROR: relation "versions_project_id" already exists
psql:openproject.sql:11021: ERROR: relation "watchers_user_id_type" already exists
psql:openproject.sql:11028: ERROR: relation "wiki_contents_page_id" already exists
psql:openproject.sql:11035: ERROR: relation "wiki_pages_wiki_id_slug" already exists
psql:openproject.sql:11042: ERROR: relation "wiki_pages_wiki_id_title" already exists
psql:openproject.sql:11049: ERROR: relation "wiki_redirects_wiki_id_title" already exists
psql:openproject.sql:11056: ERROR: relation "wikis_project_id" already exists
psql:openproject.sql:11063: ERROR: relation "wkfs_role_type_old_status" already exists
psql:openproject.sql:11070: ERROR: relation "work_package_journal_on_burndown_attributes" already exists
psql:openproject.sql:11078: ERROR: constraint "fk_rails_0b09e132e7" for relation "two_factor_authentication_devices" already exists
psql:openproject.sql:11086: ERROR: constraint "fk_rails_3cf2a2e96d" for relation "project_statuses" already exists
psql:openproject.sql:11094: ERROR: constraint "fk_rails_3d1f3b58d2" for relation "oauth_applications" already exists
psql:openproject.sql:11102: ERROR: constraint "fk_rails_44dac1537e" for relation "ldap_groups_synchronized_groups" already exists
psql:openproject.sql:11110: ERROR: constraint "fk_rails_4e35bc3056" for relation "bcf_issues" already exists
psql:openproject.sql:11118: ERROR: constraint "fk_rails_4f53d4601c" for relation "ifc_models" already exists
psql:openproject.sql:11126: ERROR: constraint "fk_rails_551257cdac" for relation "webhooks_logs" already exists
psql:openproject.sql:11134: ERROR: constraint "fk_rails_556ef6e73e" for relation "bcf_comments" already exists
psql:openproject.sql:11142: ERROR: constraint "fk_rails_5b669d4f34" for relation "time_entry_activities_projects" already exists
psql:openproject.sql:11150: ERROR: constraint "fk_rails_732cb83ab7" for relation "oauth_access_tokens" already exists
psql:openproject.sql:11158: ERROR: constraint "fk_rails_7ac870008c" for relation "bcf_comments" already exists
psql:openproject.sql:11166: ERROR: constraint "fk_rails_890a90efa9" for relation "recaptcha_entries" already exists
psql:openproject.sql:11174: ERROR: constraint "fk_rails_a166925c91" for relation "webhooks_events" already exists
psql:openproject.sql:11182: ERROR: constraint "fk_rails_b4b53e07b8" for relation "oauth_access_grants" already exists
psql:openproject.sql:11190: ERROR: constraint "fk_rails_bc6c409022" for relation "time_entry_activities_projects" already exists
psql:openproject.sql:11198: ERROR: constraint "fk_rails_cc886e315a" for relation "oauth_applications" already exists
psql:openproject.sql:11206: ERROR: constraint "fk_rails_d7ea5de5b8" for relation "webhooks_projects" already exists
psql:openproject.sql:11214: ERROR: constraint "fk_rails_e978b5e3d7" for relation "webhooks_projects" already exists
psql:openproject.sql:11222: ERROR: constraint "fk_rails_e99c4d5dfe" for relation "ordered_work_packages" already exists
psql:openproject.sql:11230: ERROR: constraint "fk_rails_fa5c88e5be" for relation "bcf_viewpoints" already exists
psql:openproject.sql:11238: ERROR: constraint "fk_rails_fe038e4e03" for relation "ordered_work_packages" already exists
postgres=# \q
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ docker exec -it openproject_db_1 openproject.sql
the input device is not a TTY. If you are using mintty, try prefixing the command with 'winpty'
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ winpty docker exec -it openproject_db_1 openproject.sql
OCI runtime exec failed: exec failed: container_linux.go:349: starting container process caused "exec: \"openproject.sql\": executable file not found in $PATH": unknown
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ winpty docker exec -it openproject_db_1 rm openproject.sql
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)
$ docker-compose start web worker
Starting web ... done
Starting worker ... done
kuma.x@FBPC048 MINGW64 ~/openproject (stable/10)