[Info-ingres] Weird error on FK constraint

[Martin Bowes]

It's some form of timing issue in the RDF cache.

Here's what I've done as a workaround, which seems to allow the constraint to succeed.
set trace point rd010;
\shell sleep 5

Friday Kludgeday.

Marty

From: Martin Bowes <martin.bowes at ndph.ox.ac.uk>
Sent: 18 February 2022 14:16
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Weird error on FK constraint

And in the errlog we see:
DBING2_NDPH_OX_AC_::[35689             , 34706     ,  0000000000000000:00007f5bb3118840, rdfgetinfo.c:7957     ]: Fri Feb 18 14:13:37 2022 E_RD0136_CONCURRENT_PROC consistency check
    - invalid concurrent access to procedure object
DBING2_NDPH_OX_AC_::[35689             , 34706     ,  0000000000000000:00007f5bb3118840, rdfgetinfo.c:7957     ]: Fri Feb 18 14:13:37 2022 E_RD0136_CONCURRENT_PROC consistency check
    - invalid concurrent access to procedure object
DBING2_NDPH_OX_AC_::[35689             , 34706     ,  0000000000000000:00007f5bb3118840, psferror.c:823        ]: Fri Feb 18 14:13:37 2022 E_PS0D15_RDF_GETINFO RDF error occurred when getting information on an object.
DBING2_NDPH_OX_AC_::[35689             , 34706     ,  0000000000000000:00007f5bb3118840, psferror.c:352        ]: Fri Feb 18 14:13:37 2022 E_PS0007_INT_OTHER_FAC_ERR   PSF detected an internal error when calling other facility.
DBING2_NDPH_OX_AC_::[35689             , 34706     ,  0000000000000000:00007f5bb3118840, scsqncr.c:4207        ]: Fri Feb 18 14:13:37 2022 E_SC0215_PSF_ERROR   Error returned by PSF.


From: Martin Bowes <martin.bowes at ndph.ox.ac.uk<mailto:martin.bowes at ndph.ox.ac.uk>>
Sent: 18 February 2022 13:57
To: info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: [Info-ingres] Weird error on FK constraint

This ones got me stumped...

alter table base_c_note add constraint fk_c_note_operator_cid
FOREIGN KEY (operator_cid) REFERENCES "lust".c_operator(operator_cid)
WITH INDEX = c_note_operator_cid;
commit;
Executing . . .

E_RD0136 consistency check
    - invalid concurrent access to procedure object
    (Fri Feb 18 13:53:39 2022)

E_SC0206 An internal error prevents further processing of this query.
    Associated error messages which provide more detailed information about
    the problem can be found in the error log, II_LOG:errlog.log
    (Fri Feb 18 13:53:39 2022)

Any ideas?

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20220218/96ca7e74/attachment-0001.html>