[Health-dev] [bug #62002] update to version 4.0 fails in 'before.sql'

[Axel Braun]

URL:
  <https://savannah.gnu.org/bugs/?62002>

                 Summary: update to version 4.0 fails in 'before.sql'
                 Project: GNU Health
            Submitted by: coogor
            Submitted on: Mon 07 Feb 2022 03:08:28 PM UTC
                Category: Database
                Severity: 4 - Important
              Item Group: None
                  Status: None
                 Privacy: Public
             Assigned to: meanmicio
             Open/Closed: Open
                 Release: None
         Discussion Lock: Any
                  Module: Update

    _______________________________________________________

Details:

I tried to upgrade a 3.8 demo database:
postgres@localhost:/usr/share/doc/packages/gnuhealth/upgrade/4.0> psql
ghdemo40 < before.sql
UPDATE 1
UPDATE 1
DELETE 4051
ALTER TABLE
ALTER TABLE
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 1
ERROR:  relation "account_payment_sepa_message" does not exist
ERROR:  relation "project_work" does not exist
LINE 1: UPDATE project_work SET status = db_id FROM ir_model_data WH...
               ^
ERROR:  relation "project_work" does not exist
LINE 1: UPDATE project_work SET status = db_id FROM ir_model_data WH...
               ^
ERROR:  relation "sale_amendment_line" does not exist
UPDATE 20
UPDATE 2
UPDATE 0
ALTER TABLE


as a consequence, the following trytond-admin failed as well, see log
attached




    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Mon 07 Feb 2022 03:08:28 PM UTC  Name: log.txt  Size: 25KiB   By: coogor

<http://savannah.gnu.org/bugs/download.php?file_id=52819>

    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?62002>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/