Re: [Gnumed-bugs] Fixup Server failed

[slappinjohn]

Perfect,

that's why I love GNUmed. Easy solution - and I've learned something.

SET default_transaction_read_only to off;
BEGIN;
ALTER TABLE gm.access_log DROP CONSTRAINT access_log_pkey CASCADE;
DROP INDEX if exists gm.access_log_pkey CASCADE;
SELECT * FROM gm.access_log WHERE pk = 67314;
DELETE FROM gm.access_log WHERE pk_audit = 593072;
REINDEX TABLE gm.access_log;

that's what solved it!

I had to drop the other line, otherwise I somehow got the same error
again. now gm_fixup_server ran without problems.

Thanks


Am 04.09.19 um 22:54 schrieb Karsten Hilbert:
> On Wed, Sep 04, 2019 at 12:22:43PM +0200, address@hidden wrote:
>
>>  pk_audit | row_version |         modified_when         | modified_by | 
>> pk   |                  user_action                 
>> ----------+-------------+-------------------------------+-------------+-------+-----------------------------------------------
>>    593072 |           0 | 2019-07-23 06:08:28.608499+00 | maan        |
>> 67314 | EMR access: pulling chart for identity [9670]
>>    593079 |           0 | 2019-07-23 06:26:59.141724+00 | maan        |
>> 67314 | EMR access: pulling chart for identity [9672]
>> (2 rows)
> One might simply delete one of the rows:
>
>
> SET default_transaction_read_only to off;
> BEGIN;
> SELECT * FROM gm.access_log WHERE pk = 67314;
> DELETE FROM gm.access_log WHERE pk_audit = 593079;
> REINDEX TABLE gm.access_log;
> ROLLBACK;
>
> Karsten
> --
> GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B