[Info-ingres] Weird problem in Ingres 10

Mark i at dontgetlotsofspamanymore.net
Wed May 16 11:44:15 UTC 2018


On Tue, 15 May 2018 12:27:09 -0400, Karl and Betty Schendel
<schendel at kbcomputer.com> wrote:

>It's certainly not something I have heard of or seen before.  Do you have any rules
>defined on the relevant tables?  Try enabling LOG_TRACE if the problem is
>sufficiently predictable, or do a logdump after the problem occurs if it's not;
>the idea being to try to see whether you actually got any PUT (insert) or
>REP (replace) log records that were then rolled back, or whether the insert / update
>was never executed at all.

After enabling log_trace all I got was:

    LOG: SAVEPOINT   Size written/reserved:      0/     0  Flags:
-------------------------------------------------------------------


>Karl
>
>> On May 15, 2018, at 11:41 AM, Mark <i at dontgetlotsofspamanymore.net> wrote:
>> 
>> We have C code using embedded SQL to access Ingres databases.  The
>> relevant code has been working for a long time.  Recently we have
>> experienced occasions where the first time an INSERT or UPDATE
>> statement is executed the data is not inserted or updated, but no
>> errors are reported.  Subsequent cases where the same code is excuted
>> work fine.  This problem has only occurred on Ingres 10 databases on
>> Linux and the same code with Ingres 9 works fine.
>> 
>> I know this is very little to go on but does anyone have any idea what
>> could be wrong???
>> 
>> -- 
>> <insert witty sig here>
>> _______________________________________________
>> Info-ingres mailing list
>> Info-ingres at lists.planetingres.org
>> http://lists.planetingres.org/mailman/listinfo/info-ingres

-- 
<insert witty sig here>



More information about the Info-ingres mailing list