Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. Migration or backup of openproject data

Migration or backup of openproject data

Added by kuma x over 4 years ago

Hi All

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.

Kuma


Replies (6)

RE: Migration or backup of openproject data - Added by Max Mutzge over 4 years ago

Hello Kuma,

have you already found our documentation regarding this topic? https://docs.openproject.org/installation-and-operations/misc/migration 

I hope it helps.

RE: Migration or backup of openproject data - Added by kuma x over 4 years ago

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

RE: Migration or backup of openproject data - Added by Oliver Günther over 4 years ago

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

RE: Migration or backup of openproject data - Added by kuma x over 4 years ago

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

RE: Migration or backup of openproject data - Added by Max Mutzge over 4 years ago

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!

RE: Migration or backup of openproject data - Added by kuma x over 4 years ago

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)

  • (1 - 6/6)
Loading...