[Gnumed-bugs] Error bootstrap v21 v22

[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