Projet

Général

Profil

Anomalie #13867

Nommage de la base par défaut : impossible de mettre à jour une base 19.04 en 20.03 sans effectuer de manipulations préalables

Ajouté par Henri QUENEAU il y a presque 4 ans. Mis à jour il y a presque 3 ans.

Statut:
Rejeté
Priorité:
1-Majeur
Assigné à:
Henri QUENEAU
Version cible:
Début:
06/05/2020
Echéance:
Version applicable MC:
Tags Courrier:

Description

en migrant la base 1904 en 2003, on obtient les erreurs ci-dessous. Pour la migration, la doc suivante a été utilisée:
https://docs.maarch.org/gitbook/html/MaarchCourrier/20.03/guat/guat_migration/home.html

postgres@henri-ThinkPad-T480s:/home/henri/Downloads$ psql -d testicdc2 < /var/www/html/maarch2003/migration/20.03/2003.sql
ERROR:  relation "parameters" does not exist
LINE 1: UPDATE parameters SET param_value_string = '20.03' WHERE id ...
               ^
ERROR:  relation "parameters" does not exist
LINE 1: UPDATE parameters SET description = 'Département par défaut ...
               ^
NOTICE:  view "res_view_letterbox" does not exist, skipping
DROP VIEW
NOTICE:  view "res_view_attachments" does not exist, skipping
DROP VIEW
NOTICE:  view "view_folders" does not exist, skipping
DROP VIEW
NOTICE:  view "res_view_business" does not exist, skipping
DROP VIEW
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "docservers" does not exist
LINE 2: DELETE FROM docservers where docserver_type_id = 'FULLTEXT';
                    ^
ERROR:  relation "docservers" does not exist
LINE 1: INSERT INTO docservers (docserver_id, docserver_type_id, dev...
                    ^
ERROR:  relation "docservers" does not exist
LINE 1: INSERT INTO docservers (docserver_id, docserver_type_id, dev...
                    ^
ERROR:  relation "docserver_types" does not exist
LINE 1: UPDATE docserver_types SET fingerprint_mode = NULL WHERE doc...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET fulltext_result = 'SUCCESS' WHERE f...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET fulltext_result = 'ERROR' WHERE ful...
               ^
ERROR:  relation "res_attachments" does not exist
LINE 1: UPDATE res_attachments SET fulltext_result = 'SUCCESS' WHERE...
               ^
ERROR:  relation "res_attachments" does not exist
LINE 1: UPDATE res_attachments SET fulltext_result = 'ERROR' WHERE f...
               ^
ERROR:  relation "usergroups" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "groupbasket" does not exist
ERROR:  relation "groupbasket" does not exist
ERROR:  relation "groupbasket" does not exist
LINE 1: UPDATE groupbasket SET list_event = 'processDocument'
               ^
ERROR:  relation "groupbasket" does not exist
LINE 1: UPDATE groupbasket SET list_event = 'viewDoc'
               ^
ERROR:  relation "groupbasket" does not exist
LINE 1: UPDATE groupbasket SET list_event = 'signatureBookAction'
               ^
ERROR:  relation "groupbasket" does not exist
ERROR:  relation "groupbasket" does not exist
ERROR:  relation "groupbasket" does not exist
LINE 1: update groupbasket set list_event_data = '{"canUpdate":true,...
               ^
ERROR:  relation "groupbasket" does not exist
LINE 1: UPDATE groupbasket SET list_event_data = '{"defaultTab":"inf...
               ^
ERROR:  relation "actions_categories" does not exist
LINE 1: DELETE FROM actions_categories WHERE action_id in (SELECT id...
                    ^
ERROR:  relation "actions_groupbaskets" does not exist
LINE 1: DELETE FROM actions_groupbaskets WHERE id_action in (SELECT ...
                    ^
ERROR:  relation "groupbasket_redirect" does not exist
LINE 1: DELETE FROM groupbasket_redirect WHERE action_id in (SELECT ...
                    ^
ERROR:  relation "actions" does not exist
LINE 1: DELETE FROM actions WHERE component = 'viewDoc' OR action_pa...
                    ^
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'rejectVisaBackToPreviousActi...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'redirectInitiatorEntityActio...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'rejectVisaBackToPreviousActi...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'resetVisaAction' WHERE actio...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'interruptVisaAction' WHERE a...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'sendSignatureBookAction' WHE...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'continueVisaCircuitAction' W...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'closeMailWithAttachmentsOrNo...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'sendToOpinionCircuitAction' ...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'continueOpinionCircuitAction...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'giveOpinionParallelAction' W...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'sendToParallelOpinion' WHERE...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'validateParallelOpinionDiffu...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'createAcknowledgementReceipt...
               ^
ERROR:  relation "actions_groupbaskets" does not exist
LINE 1: DELETE FROM actions_groupbaskets WHERE id_action IN (SELECT ...
                    ^
ERROR:  relation "actions_categories" does not exist
LINE 1: DELETE FROM actions_categories WHERE action_id IN (SELECT id...
                    ^
ERROR:  relation "actions" does not exist
LINE 1: DELETE FROM actions WHERE action_page = 'put_in_copy';
                    ^
ERROR:  relation "folders" does not exist
CONTEXT:  SQL statement "ALTER TABLE folders RENAME TO folder_tmp"
PL/pgSQL function inline_code_block line 3 at SQL statement
NOTICE:  table "folders" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE folders
                     ^
NOTICE:  table "resources_folders" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE resources_folders
                     ^
NOTICE:  table "entities_folders" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE entities_folders
                     ^
NOTICE:  table "users_pinned_folders" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE users_pinned_folders
                     ^
NOTICE:  table "custom_fields" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE custom_fields
                     ^
NOTICE:  table "contacts_custom_fields_list" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE contacts_custom_fields_list
                     ^
NOTICE:  table "indexing_models" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE indexing_models
                     ^
NOTICE:  table "indexing_models_fields" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE indexing_models_fields
                     ^
ERROR:  relation "tags" does not exist
CONTEXT:  SQL statement "ALTER TABLE tags RENAME COLUMN tag_label TO label"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "tags" does not exist
LINE 1: SELECT setval('tags_id_seq', (SELECT MAX(id) from tags));
                                                          ^
NOTICE:  table "tags_entities" does not exist, skipping
DROP TABLE
ERROR:  relation "doctypes" does not exist
CONTEXT:  SQL statement "ALTER TABLE doctypes ADD COLUMN process_delay INTEGER"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "notes" does not exist
CONTEXT:  SQL statement "ALTER TABLE notes ADD COLUMN user_tmp_id integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
CONTEXT:  SQL statement "ALTER TABLE res_attachments RENAME COLUMN doc_date TO modification_date"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_attachments" does not exist
CONTEXT:  SQL statement "ALTER TABLE res_attachments ADD COLUMN modified_by integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "docservers" does not exist
LINE 2: UPDATE docservers SET coll_id = 'attachments_coll', is_reado...
               ^
ERROR:  relation "docservers" does not exist
LINE 1: UPDATE docservers SET coll_id = 'attachments_coll', is_reado...
               ^
ERROR:  relation "docservers" does not exist
LINE 1: UPDATE docservers SET coll_id = 'attachments_coll', is_reado...
               ^
ERROR:  relation "docservers" does not exist
LINE 1: UPDATE docservers SET coll_id = 'attachments_coll', is_reado...
               ^
ERROR:  relation "docservers" does not exist
LINE 1: UPDATE docservers SET docserver_type_id = 'DOC' WHERE coll_i...
               ^
ERROR:  relation "res_letterbox" does not exist
CONTEXT:  SQL statement "ALTER TABLE res_letterbox ADD COLUMN category_id character varying(32)"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET external_id = jsonb_set(external_id...
               ^
QUERY:  UPDATE res_letterbox SET external_id = jsonb_set(external_id, '{signatureBookId}', external_signatory_book_id::text::jsonb) WHERE external_signatory_book_id IS NOT NULL
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox set model_id = 2 WHERE category_id = 'o...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox set model_id = 3 WHERE category_id = 'i...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox set model_id = 4 WHERE category_id = 'g...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox set model_id = 1 WHERE model_id IS NULL...
               ^
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
CONTEXT:  SQL statement "ALTER TABLE res_letterbox ADD COLUMN typist_tmp integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "usergroup_content" does not exist
CONTEXT:  SQL statement "ALTER TABLE usergroup_content ADD COLUMN user_id_tmp integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "usergroup_content" does not exist
CONTEXT:  SQL statement "ALTER TABLE usergroup_content ADD COLUMN group_id_tmp integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
NOTICE:  table "contacts" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE contacts
                     ^
NOTICE:  table "contacts_parameters" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE contacts_parameters
                     ^
ERROR:  relation "acknowledgement_receipts" does not exist
ERROR:  relation "acknowledgement_receipts" does not exist
ERROR:  relation "contacts_groups_lists" does not exist
ERROR:  relation "contacts_groups_lists" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "adr_letterbox" does not exist
LINE 1: UPDATE adr_letterbox SET version = 1;
               ^
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET version = 1;
               ^
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "entities" does not exist
ERROR:  relation "entities" does not exist
ERROR:  relation "usergroup_content" does not exist
LINE 1: DELETE FROM usergroup_content WHERE group_id in (SELECT id F...
                    ^
QUERY:  DELETE FROM usergroup_content WHERE group_id in (SELECT id FROM usergroups WHERE enabled = 'N')
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "actions_categories" does not exist
LINE 1: DELETE FROM actions_categories WHERE action_id in (SELECT id...
                    ^
QUERY:  DELETE FROM actions_categories WHERE action_id in (SELECT id FROM actions WHERE enabled = 'N')
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "listinstance" does not exist
LINE 1: UPDATE listinstance SET item_mode = 'cc' WHERE item_mode = '...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'admin_fi...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'put_doc_...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'fileplan...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'update_c...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'join_res...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'join_res...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'close_ca...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'add_case...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id IN ('folder...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'add_tag_...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'tag_view...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'thesauru...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'add_thes...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET service_id = 'manage_tags_app...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET service_id = 'update_status_m...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'quicklau...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'put_in_v...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'print_de...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'print_do...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'view_att...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'index_at...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'display_...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'choose_e...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'manage_n...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'notes_re...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'graphics...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'show_rep...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'param_te...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'doctype_...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'search_c...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'use_date...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'delete_d...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET service_id = 'manage_numeric_...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'edit_rec...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'update_l...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'edit_rec...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET service_id = 'edit_resource' ...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'edit_att...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'modify_a...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'delete_a...
                    ^
ERROR:  relation "usergroups_services" does not exist
ERROR:  relation "usergroups_services" does not exist
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET parameters = (
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'view_per...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'admin_th...
                    ^
ERROR:  relation "history" does not exist
LINE 1: UPDATE history SET event_type = 'PRE' where event_type = 'RE...
               ^
ERROR:  relation "listmodels" does not exist
LINE 1: UPDATE listmodels SET title = object_id WHERE title IS NULL
               ^
QUERY:  UPDATE listmodels SET title = object_id WHERE title IS NULL
CONTEXT:  PL/pgSQL function inline_code_block line 6 at SQL statement
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets SET basket_clause = REGEXP_REPLACE(basket_cla...
               ^
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets SET basket_clause = REGEXP_REPLACE(basket_cla...
               ^
ERROR:  relation "templates" does not exist
LINE 1: UPDATE templates SET template_target = 'attachments' WHERE (...
               ^
ERROR:  relation "templates" does not exist
LINE 1: UPDATE templates SET template_target = 'notes' WHERE (templa...
               ^
ERROR:  relation "templates" does not exist
LINE 1: DELETE FROM templates WHERE template_target = '' OR template...
                    ^
NOTICE:  table "list_templates" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE list_templates
                     ^
NOTICE:  table "list_templates_items" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE list_templates_items
                     ^
ERROR:  relation "notif_email_stack" does not exist
ERROR:  relation "tags" does not exist
ERROR:  relation "priorities" does not exist
LINE 1: UPDATE priorities SET delays = 30 WHERE delays IS NULL;
               ^
ERROR:  relation "priorities" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "notif_email_stack" does not exist
ERROR:  relation "notif_email_stack" does not exist
ERROR:  relation "notif_email_stack" does not exist
ERROR:  relation "users" does not exist
LINE 1: UPDATE users SET status = 'SPD' WHERE enabled = 'N' and (sta...
               ^
QUERY:  UPDATE users SET status = 'SPD' WHERE enabled = 'N' and (status = 'OK' or status = 'ABS')
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
NOTICE:  view "fp_view_fileplan" does not exist, skipping
DROP VIEW
ERROR:  relation "res_attachments" does not exist
NOTICE:  table "foldertypes" does not exist, skipping
DROP TABLE
NOTICE:  table "foldertypes_doctypes" does not exist, skipping
DROP TABLE
NOTICE:  table "foldertypes_doctypes_level1" does not exist, skipping
DROP TABLE
NOTICE:  table "foldertypes_indexes" does not exist, skipping
DROP TABLE
ERROR:  relation "doctypes" does not exist
NOTICE:  table "mlb_doctype_ext" does not exist, skipping
DROP TABLE
ERROR:  relation "priorities" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "listinstance" does not exist
ERROR:  relation "listinstance" does not exist
ERROR:  relation "listinstance" does not exist
ERROR:  relation "listinstance" does not exist
ERROR:  relation "listinstance_history_details" does not exist
ERROR:  relation "usergroup_content" does not exist
ERROR:  relation "emails" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
NOTICE:  table "templates_doctype_ext" does not exist, skipping
DROP TABLE
NOTICE:  table "notif_rss_stack" does not exist, skipping
DROP TABLE
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET external_id = json_build_object('m2...
               ^
QUERY:  UPDATE res_letterbox SET external_id = json_build_object('m2m', reference_number), reference_number = null FROM mlb_coll_ext WHERE res_letterbox.res_id = mlb_coll_ext.res_id AND mlb_coll_ext.nature_id = 'message_exchange'
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "custom_fields" does not exist
ERROR:  relation "custom_fields" does not exist
LINE 1: INSERT INTO custom_fields (id, label, type, values) VALUES (...
                    ^
ERROR:  relation "custom_fields" does not exist
LINE 1: ...al('custom_fields_id_seq', (select max(id)+1 from custom_fie...
                                                             ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET custom_fields = json_build_object('...
               ^
QUERY:  UPDATE res_letterbox SET custom_fields = json_build_object('1', 'Courrier simple') FROM mlb_coll_ext WHERE res_letterbox.res_id = mlb_coll_ext.res_id AND mlb_coll_ext.nature_id = 'simple_mail'
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets set basket_clause = replace(basket_clause, 'n...
               ^
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets SET basket_clause = replace(basket_clause, 's...
               ^
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets SET basket_clause = replace(basket_clause, 'a...
               ^
ERROR:  relation "history" does not exist
LINE 1: UPDATE history SET user_id = (select user_id from users orde...
               ^
NOTICE:  table "users_followed_resources" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE users_followed_resources
                     ^
ERROR:  relation "shippings" does not exist
CONTEXT:  SQL statement "ALTER TABLE shippings DROP COLUMN IF EXISTS document_type"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "shippings" does not exist
ERROR:  relation "shippings" does not exist
ERROR:  relation "indexing_models" does not exist
ERROR:  relation "indexing_models" does not exist
LINE 1: INSERT INTO indexing_models (id, category, label, "default",...
                    ^
ERROR:  relation "indexing_models" does not exist
LINE 1: INSERT INTO indexing_models (id, category, label, "default",...
                    ^
ERROR:  relation "indexing_models" does not exist
LINE 1: INSERT INTO indexing_models (id, category, label, "default",...
                    ^
ERROR:  relation "indexing_models" does not exist
LINE 1: INSERT INTO indexing_models (id, category, label, "default",...
                    ^
ERROR:  relation "indexing_models" does not exist
LINE 1: ...('indexing_models_id_seq', (select max(id)+1 from indexing_m...
                                                             ^
ERROR:  relation "indexing_models_fields" does not exist
ERROR:  relation "indexing_models_fields" does not exist
LINE 2: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 2: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 2: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 2: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
icdc2.sql (275 ko) icdc2.sql Henri QUENEAU, 06/05/2020 12:24
Screenshot from 2020-05-06 12-28-05.png (79,5 ko) Screenshot from 2020-05-06 12-28-05.png Henri QUENEAU, 06/05/2020 12:28
5135

Historique

#2 Mis à jour par Henri QUENEAU il y a presque 4 ans

en pièce jointe la base de données en 19.04

#3 Mis à jour par Henri QUENEAU il y a presque 4 ans

5135

La base est bien existante avec des données dedans

#4 Mis à jour par Alex ORLUC il y a presque 4 ans

  • Assigné à changé de EDI PO à Henri QUENEAU

J'ai pas eu de soucis avec cette base avec pgadmin.

D'un premier coup d’œil je dirais que le problème pourrait venir du schéma qui n'est pas standard.

Ici 'maarch' est utilisé par rapport a public.

#5 Mis à jour par Alex ORLUC il y a presque 4 ans

Voici ce que tu peux faire :

psql -d testicdc2
SET search_path = maarch;
\i /var/www/html/maarch2003/migration/20.03/2003.sql

#6 Mis à jour par Emmanuel DILLARD il y a presque 4 ans

  • Statut changé de A qualifier à Complément d'Informations

#7 Mis à jour par Henri QUENEAU il y a presque 4 ans

  • Statut changé de Complément d'Informations à A traiter
  • Assigné à changé de Henri QUENEAU à EDI PO

Le problème ne vient pas de la base..
la base fonctionne très bien.
l'application fonctionne également très bien.

en effet, il y a un schéma nommé maarch à la demande du client.
le client souhaite utiliser un schéma pour les raisons ci-dessous:

  • Pour autoriser beaucoup d'utilisateurs d'utiliser une base de données sans se gêner les uns les autres.
  • Pour organiser des objets de bases de données en groupes logiques afin de faciliter leur gestion.
  • Les applications tierces peuvent être mises dans des schémas séparés pour qu'il n'y ait pas de collision avec les noms d'autres objets.

En étudiant ce problème, il est primordial que nous travaillons sur un schéma nommé 'maarch' ou autre chose que 'public'(est essentiellement utilisé comme bac à sable).

En revanche, il n'est pas possible de migrer la base en étant sur ce schéma. Afin de régler ce problème, il faudrait prefixer dans les scripts de migration le schéma correspondant (par défaut à maarch ou alors à public si on reste sur public).

#8 Mis à jour par Emmanuel DILLARD il y a presque 4 ans

  • Statut changé de A traiter à Complément d'Informations

Cela fonctionne-t-il avec les manipulations indiquées par Alex ?

psql -d testicdc2
SET search_path = maarch;
\i /var/www/html/maarch2003/migration/20.03/2003.sql

#9 Mis à jour par Emmanuel DILLARD il y a presque 4 ans

  • Assigné à changé de EDI PO à Henri QUENEAU

#10 Mis à jour par Henri QUENEAU il y a presque 4 ans

  • Statut changé de Complément d'Informations à A traiter
  • Assigné à changé de Henri QUENEAU à EDI PO

Oui la commande fonctionne.

Ce que j'ai dit dans mon précédent ticket est qu'il faut que la commande soit intégrée dans les scripts de migration!
Et que chaque install soit sur un schéma nommé maarch et non public pour les raisons listées précédemment.

cela permettra de montrer que maarch maitrise à minima l'architecture et environnement de postgresql. (tout comme on va commencer à travailler de plus en plus sous redhat et centos car ce sont des environnements professionnels)

#11 Mis à jour par Emmanuel DILLARD il y a presque 4 ans

  • Sujet changé de impossible de mettre à jour une base 19.04 en 20.03 à Nommage de la base par défaut : impossible de mettre à jour une base 19.04 en 20.03 sans effectuer de manipulations préalables
  • Statut changé de A traiter à Etude planifiée
  • Priorité changé de 0-Bloquant à 1-Majeur

#12 Mis à jour par Emmanuel DILLARD il y a presque 4 ans

  • Priorité changé de 1-Majeur à 2-Sérieux

#13 Mis à jour par Henri QUENEAU il y a plus de 3 ans

  • Priorité changé de 2-Sérieux à 0-Bloquant

#14 Mis à jour par Emmanuel DILLARD il y a plus de 3 ans

  • Priorité changé de 0-Bloquant à 1-Majeur

#15 Mis à jour par Emmanuel DILLARD il y a plus de 3 ans

  • Statut changé de Etude planifiée à Rejeté PO
  • Assigné à changé de EDI PO à Henri QUENEAU

Ce ne sera pas intégré dans le code. (pas détectable)

L'installation par défaut est prévue sur le schéma "Public", schéma par défaut de PostgreSQL.

https://docs.maarch.org/gitbook/html/MaarchCourrier/20.03/guat/guat_installation/debian.html

Voir ici : https://mkyong.com/database/postgresql-how-to-change-default-schema/

C'est de l'intégration. (chaque client peut avoir un schéma différent)

Adaptation à l'environnement client

Si le schéma n'est pas celui par défaut :

psql -d testicdc2
SET search_path = maarch;
\i /var/www/html/maarch2003/migration/20.03/2003.sql

#16 Mis à jour par Emmanuel DILLARD il y a presque 3 ans

  • Statut changé de Rejeté PO à Rejeté

#17 Mis à jour par Emmanuel DILLARD il y a presque 3 ans

  • Projet changé de Backlog à Backlog Courrier
  • Version cible changé de 20.03 (Fin de vie) à 20.03 (Sécurité)

Formats disponibles : Atom PDF