[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-bugs] Error bootstrap v21 v22
From: |
slappinjohn |
Subject: |
Re: [Gnumed-bugs] Error bootstrap v21 v22 |
Date: |
Sun, 15 Apr 2018 10:45:50 +0200 |
User-agent: |
Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.7.0 |
Testing in psql leads to
select fk_stay from blobs.lnk_doc2hospital_stay where fk_document =
blobs.doc_med.pk
gnumed_v21-# ;
ERROR: missing FROM-clause entry for table "doc_med"
and
gnumed_v21=# update blobs.doc_med set
gnumed_v21-# fk_hospital_stay = (
gnumed_v21(# select fk_stay from blobs.lnk_doc2hospital_stay where
gnumed_v21(# fk_document = blobs.doc_med.pk
gnumed_v21(# )
gnumed_v21-# ;
ERROR: column "fk_hospital_stay" of relation "doc_med" does not exist
Am 15.04.2018 um 10:06 schrieb slappinjohn:
> Hi Karsten,
>
> I tried to update my working DB (now over4gb) to v22 and got the
> following error:
>
>
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #144):
> update blobs.doc_med set
> fk_hospital_stay = (
> select fk_stay from blobs.lnk_doc2hospital_stay where
> fk_document = blobs.doc_med.pk
> )
> Traceback (most recent call last):
> File "/var/lib/gnumed/Gnumed/pycommon/gmPsql.py", line 137, in run
> curs.execute(curr_cmd)
> File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 144,
> in execute
> return super(DictCursor, self).execute(query, vars)
> InternalError: UPDATE into blobs.doc_med: Sanity check failed.
> fk_encounter=2907 -> patient=761. fk_episode=1539 -> patient=768.
> KONTEXT: PL/pgSQL function clin.trf_sanity_check_enc_epi_ins_upd() line
> 22 at RAISE
>
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #148):
> ../sql/v21-v22/dynamic/v22-blobs-doc_med-dynamic.sql:35: UPDATE into
> blobs.doc_med: Sanity check failed. fk_encounter=2907 -> patient=761.
> fk_episode=1539 -> patient=768.KONTEXT: PL/pgSQL function
> clin.trf_sanity_check_enc_epi_ins_upd() line 22 at RAISE
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #156): PG
> diags context: PL/pgSQL function clin.trf_sanity_check_enc_epi_ins_upd()
> line 22 at RAISE
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #156): PG
> diags message_primary: UPDATE into blobs.doc_med: Sanity check failed.
> fk_encounter=2907 -> patient=761. fk_episode=1539 -> patient=768.
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #156): PG
> diags severity: ERROR
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #156): PG
> diags source_file: pl_exec.c
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #156): PG
> diags source_function: exec_stmt_raise
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #156): PG
> diags source_line: 3165
> 2018-04-14 17:51:43 ERROR gm.bootstrapper [139682022967040
> MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #156): PG
> diags sqlstate: P0001
>
>
>
> Thanks Marc
>
>