Re: [Gnumed-bugs] Error bootstrap v21 v22

[slappinjohn]

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
>
>