Re: [Gnumed-devel] Error bootstrapping server v11

[Karsten Hilbert]

On Tue, Sep 01, 2009 at 06:36:11PM +0200, Slappinjohn wrote:

> 2009-09-01 18:27:16  DEBUG     gm.cfg 
> (/home/marc/downloads/GNUmed-v11.0/Gnumed/pycommon/gmCfg2.py::get() #314): 
> option [bundle v11-test_data::schema] found in source [file]
> 2009-09-01 18:27:16  DEBUG     gm.cfg 
> (/home/marc/downloads/GNUmed-v11.0/Gnumed/pycommon/gmCfg2.py::get() #314): 
> option [bundle v11-test_data::schema base directory] found in source [file]
> 2009-09-01 18:27:16  DEBUG     gm.bootstrapper 
> (/home/marc/downloads/GNUmed-v11.0/Gnumed/pycommon/gmPsql.py::run() #226): 
> insert into clin.episode (
>       fk_health_issue,
>       description,
>       is_open,
>       fk_encounter
> ) values (
>       1,
>       'abdominal lap',
>       False,
>       (select pk from clin.encounter
>        where fk_patient = (
>               select pk_identity from dem.v_basic_person
>               where firstnames = 'James Tiberius' and lastnames = 'Kirk' and 
> date_trunc('day', dob) = '1931-3-21'
>        )
>        limit 1
>       )
> )
> 2009-09-01 18:27:16  ERROR     gm.bootstrapper 
> (/home/marc/downloads/GNUmed-v11.0/Gnumed/pycommon/gmPsql.py::run() #231): 
> ../sql/test-data/test_data-Kirk_hospital_stay-dynamic.sql:45: null value in 
> column "fk_encounter" violates not-null constraint
> 2009-09-01 18:27:16  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::_import_schema() #1193): failed to import 
> [../sql/test-data/test_data-Kirk_hospital_stay-dynamic.sql]

Seems you removed Capt. Kirk from the database.

- in update_db-v10_v11.conf remove the "v11-test_data" bundle
- in said file adjust the "episodes" upgrade plausibility check
  - namely, remove the "+1" after the count(1)
- rerun the upgrade from v10 to v11

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346