Actions
Anomalie #13867
ferméNommage de la base par défaut : impossible de mettre à jour une base 19.04 en 20.03 sans effectuer de manipulations préalables
Début:
06/05/2020
Echéance:
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...
Fichiers
Actions
#2
Mis à jour par Henri QUENEAU il y a plus de 4 ans
en pièce jointe la base de données en 19.04
Actions
#3
Mis à jour par Henri QUENEAU il y a plus de 4 ans
La base est bien existante avec des données dedans
Actions
#4
Mis à jour par Alex ORLUC il y a plus de 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.
Actions
#5
Mis à jour par Alex ORLUC il y a plus de 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
Actions
#6
Mis à jour par Emmanuel DILLARD il y a plus de 4 ans
- Statut changé de A qualifier à Complément d'Informations
Actions
#7
Mis à jour par Henri QUENEAU il y a plus de 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).
Actions
#8
Mis à jour par Emmanuel DILLARD il y a plus de 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
Actions
#9
Mis à jour par Emmanuel DILLARD il y a plus de 4 ans
- Assigné à changé de EDI PO à Henri QUENEAU
Actions
#10
Mis à jour par Henri QUENEAU il y a plus de 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)
Actions
#11
Mis à jour par Emmanuel DILLARD il y a plus de 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
Actions
#12
Mis à jour par Emmanuel DILLARD il y a plus de 4 ans
- Priorité changé de 1-Majeur à 2-Sérieux
Actions
#13
Mis à jour par Henri QUENEAU il y a plus de 4 ans
- Priorité changé de 2-Sérieux à 0-Bloquant
Actions
#14
Mis à jour par Emmanuel DILLARD il y a plus de 4 ans
- Priorité changé de 0-Bloquant à 1-Majeur
Actions
#15
Mis à jour par Emmanuel DILLARD il y a environ 4 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
Actions
#16
Mis à jour par Emmanuel DILLARD il y a plus de 3 ans
- Statut changé de Rejeté PO à Rejeté
Actions
#17
Mis à jour par Emmanuel DILLARD il y a plus de 3 ans
- Projet changé de 298 à Backlog Courrier
- Version cible changé de 20.03 (Fin de vie) à 20.03 (Sécurité)
Actions