[Info-ingres] Weird problem in Ingres 10

[Martin Bowes]

Just to expand on Karl's sc930...You may already know this...

To turn it on, make a recording directory...mkdir /full/path/to/directory'

And then...
sql iidbdb << SQL_END
set trace record '/full/path/to/directory';
set trace point sc930 1;
\p\g
\q
SQL_END

FYI. The digit after the sc930 indicates a tracing level, 1 should be sufficient.

Run the errant query.

And turn off the sc930.
sql iidbdb << SQL_END
set trace point sc930 0;
\p\g
\q
SQL_END

You can now access the recording directory and start scanning the files for any sign of life from your query.

Marty

-----Original Message-----
From: Karl and Betty Schendel [mailto:schendel at kbcomputer.com] 
Sent: 16 May 2018 12:54
To: Ingres and related product discussion forum
Subject: Re: [Info-ingres] Weird problem in Ingres 10

On May 16, 2018, at 7:44 AM, Mark <i at dontgetlotsofspamanymore.net> wrote:
> 
> 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:
> -------------------------------------------------------------------

So the insert/update isn't ever being executed.  Either it's failing with some sort of
silent error, which would seem odd, or it's not reaching the backend at all, or
it's being pre-empted by a before rule.  I think the next step would be to enable
sc930 tracing and see if the backend is getting the insert-update, and what
end-of-query status it's recording.  There should be KB articles on enabling
SC930 tracing.

Karl

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres