[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-bugs] Error bootstrap v21 v22
From: |
slappinjohn |
Subject: |
[Gnumed-bugs] Error bootstrap v21 v22 |
Date: |
Sun, 15 Apr 2018 10:06:04 +0200 |
User-agent: |
Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.7.0 |
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
- [Gnumed-bugs] Error bootstrap v21 v22,
slappinjohn <=