[Info-ingres] Weird problem in Ingres 10

[Karl and Betty Schendel]

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.

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