<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">See:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><a href="http://docs.actian.com/ingres/11.0/index.html#page/DatabaseAdmin%2FHow_to_Load_an_Audit_Trail_as_a_Table.htm">http://docs.actian.com/ingres/11.0/index.html#page/DatabaseAdmin%2FHow_to_Load_an_Audit_Trail_as_a_Table.htm</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">The example is based on the columns in the example table. You’ll need to define the target table based on the audited table.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Alex<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org>
<b>On Behalf Of </b>Mark<br>
<b>Sent:</b> 17 May 2018 16:19<br>
<b>To:</b> info-ingres@lists.planetingres.org<br>
<b>Subject:</b> Re: [Info-ingres] Weird problem in Ingres 10<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">On Thu, 17 May 2018 15:03:18 +0000, Alex Hanshaw<br>
<<a href="mailto:Alex.Hanshaw@actian.com">Alex.Hanshaw@actian.com</a>> wrote:<br>
<br>
>One of my guys recently added the ability to dump audit data to a trl file with a timestamp rather than an Ingres date as the first column so that millisecond precision is included.<br>
>Part of the test plan he developed included abort and abort to savepoint and the records are included if you use the right flag on auditdb. E.g.<br>
>auditdb -table=b133019 -aborted_transactions -file=b133019.trl -timestamp b133019db<br>
>Omit the -timestamp option if you don't have a patch with that functionality. There's a section in the docs that lets you create a table to load the trl file and then you can see the audit records.<br>
<br>
I have run this command and get a binary file as output. How can I<br>
interpret this file?<br>
<br>
>Alex<br>
><br>
>From: Laframboise, André (BAC/LAC) <<a href="mailto:andre.laframboise@canada.ca">andre.laframboise@canada.ca</a>><br>
>Sent: 17 May 2018 15:37<br>
>To: Alex Hanshaw <<a href="mailto:Alex.Hanshaw@actian.com">Alex.Hanshaw@actian.com</a>>; Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk</a>>;
<a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a><br>
>Subject: RE: [Info-ingres] Weird problem in Ingres 10<br>
><br>
>Are you sure ? Even Log full aborts that rolls back thousands of rows ?<br>
><br>
>André Laframboise<br>
><br>
>Conseiller Principal Base de Données, Direction générale de l'Innovation et du Dirigeant principal de l'information<br>
>Bibliothèque et Archives Canada<<a href="http://www.bac-lac.gc.ca/fra/Pages/bac-web.aspx">http://www.bac-lac.gc.ca/fra/Pages/bac-web.aspx</a>> / Gouvernement du Canada<br>
><a href="mailto:andre.laframboise@canada.ca%3cmailto:andre.laframboise@canada.ca">andre.laframboise@canada.ca<mailto:andre.laframboise@canada.ca</a>> / Tél. : 613-298-1346<br>
><br>
>Senior Database Advisor, Innovation and Chief Information Officer Branch<br>
>Library and Archives Canada<<a href="http://www.bac-lac.gc.ca/eng/Pages/lac-web.aspx">http://www.bac-lac.gc.ca/eng/Pages/lac-web.aspx</a>> / Government of Canada<br>
><a href="mailto:andre.laframboise@canada.ca%3cmailto:andre.laframboise@canada.ca">andre.laframboise@canada.ca<mailto:andre.laframboise@canada.ca</a>> / Tel: 613-298-1346<br>
><br>
>[<a href="http://www.bac-lac.gc.ca/eng/events/PublishingImages/banner.jpg">http://www.bac-lac.gc.ca/eng/events/PublishingImages/banner.jpg</a>]<<a href="http://www.bac-lac.gc.ca/eng/events/Pages/events.aspx">http://www.bac-lac.gc.ca/eng/events/Pages/events.aspx</a>><br>
><br>
>From: <a href="mailto:info-ingres-bounces@lists.planetingres.org%3cmailto:info-ingres-bounces@lists.planetingres.org">
info-ingres-bounces@lists.planetingres.org<mailto:info-ingres-bounces@lists.planetingres.org</a>> <<a href="mailto:info-ingres-bounces@lists.planetingres.org%3cmailto:info-ingres-bounces@lists.planetingres.org">info-ingres-bounces@lists.planetingres.org<mailto:info-ingres-bounces@lists.planetingres.org</a>>>
On Behalf Of Alex Hanshaw<br>
>Sent: Thursday, May 17, 2018 10:32 AM<br>
>To: Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk%3cmailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk<mailto:martin.bowes@ndph.ox.ac.uk</a>>>;
<a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
><br>
>aborted statements should also appear in auditdb output.<br>
><br>
>From: <a href="mailto:info-ingres-bounces@lists.planetingres.org%3cmailto:info-ingres-bounces@lists.planetingres.org">
info-ingres-bounces@lists.planetingres.org<mailto:info-ingres-bounces@lists.planetingres.org</a>> <<a href="mailto:info-ingres-bounces@lists.planetingres.org%3cmailto:info-ingres-bounces@lists.planetingres.org">info-ingres-bounces@lists.planetingres.org<mailto:info-ingres-bounces@lists.planetingres.org</a>>>
On Behalf Of Martin Bowes<br>
>Sent: 17 May 2018 15:00<br>
>To: <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
><br>
>Please remove it. You may get a swathe of data but in this case more may shed some light on the issue.<br>
><br>
>Are there any other processes you know of which are monkeying with the data?<br>
><br>
>Is there a good reason why there is nojournaling on this table? Can we turn it on ... which will entail backing up the database as well.<br>
><br>
>Marty<br>
><br>
>-----Original Message-----<br>
>From: Mark [<a href="mailto:i@dontgetlotsofspamanymore.net">mailto:i@dontgetlotsofspamanymore.net</a>]<br>
>Sent: 17 May 2018 14:54<br>
>To: <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
><br>
>On Thu, 17 May 2018 13:43:35 +0000, Martin Bowes<br>
><<a href="mailto:martin.bowes@ndph.ox.ac.uk%3cmailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk<mailto:martin.bowes@ndph.ox.ac.uk</a>>> wrote:<br>
><br>
>>Hi Mark,<br>
>><br>
>>I note that you are turning off the sc930 trace with a SET TRACE POINT SC930 0 which is still presumably in your ESQLC script. Sadly I think that is masking what is happening here as on the first occasion we lost nearly two minutes of activity, then over
a minute on the second and over 4minutes on the third occasion. Could you<br>
please remove that from the script and try again.<br>
><br>
>I wanted to disable the tracing after the problematic statement had<br>
>finished. I can remove this if there may be useful data shown<br>
>otherwise.<br>
><br>
>>If this table is journaled could you please also check with auditdb for an insert of the message_id = ' 100055700000XDBW' record after 10:34:06<br>
><br>
>The table is not journalled.<br>
><br>
>>Marty<br>
>><br>
>>-----Original Message-----<br>
>>From: Martin Bowes [<a href="mailto:martin.bowes@ndph.ox.ac.uk">mailto:martin.bowes@ndph.ox.ac.uk</a>]<br>
>>Sent: 17 May 2018 14:31<br>
>>To: <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
>><br>
>>Whoops sorry, I'll take that back there are 4 queries.<br>
>><br>
>>The first and the fourth queries are seemingly identical and the fourth indicates a rowcount 1 on the update.<br>
>><br>
>>I'll have a closer look.<br>
>><br>
>>Marty<br>
>><br>
>>-----Original Message-----<br>
>>From: Martin Bowes [<a href="mailto:martin.bowes@ndph.ox.ac.uk">mailto:martin.bowes@ndph.ox.ac.uk</a>]<br>
>>Sent: 17 May 2018 14:25<br>
>>To: Mark; <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
>><br>
>>Hi Mark,<br>
>><br>
>>That trace shows three successive update attempts each with a different message_id. The first one updates no rows the others update a single row.<br>
>><br>
>>So can you do a:<br>
>>select count(*) from db_msg where message_id = ' 100055700000XDBW' and queue <> ' log_20150325' /* rowcount = 0 */<br>
>><br>
>>select count(*) from db_msg where message_id = ' 400055700000XDBW' and queue <> ' log_20150325' /* rowcount = 1 */<br>
>><br>
>>select count(*) from db_msg where message_id = ' 500055700000XDBW' and queue <> ' log_20150325' /* rowcount = 1 */<br>
>><br>
>>Marty<br>
>><br>
>>-----Original Message-----<br>
>>From: Mark [<a href="mailto:i@dontgetlotsofspamanymore.net">mailto:i@dontgetlotsofspamanymore.net</a>]<br>
>>Sent: 17 May 2018 14:17<br>
>>To: <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
>><br>
>>On Thu, 17 May 2018 13:03:16 +0000, Martin Bowes<br>
>><<a href="mailto:martin.bowes@ndph.ox.ac.uk%3cmailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk<mailto:martin.bowes@ndph.ox.ac.uk</a>>> wrote:<br>
>><br>
>>>Sorry, my bad that should have been a line starting: SESSION BEGINS<br>
>>><br>
>>>Can you send the update queries and parameters (if any) from the good and bad cases. Those won't show any private data, so it should be cool.<br>
>><br>
>>Cheers. I have emailed you the logs.<br>
>><br>
>>>Marty<br>
>>><br>
>>>-----Original Message-----<br>
>>>From: Mark [<a href="mailto:i@dontgetlotsofspamanymore.net">mailto:i@dontgetlotsofspamanymore.net</a>]<br>
>>>Sent: 17 May 2018 13:51<br>
>>>To: <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>>>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
>>><br>
>>>On Thu, 17 May 2018 12:35:38 +0000, Martin Bowes<br>
>>><<a href="mailto:martin.bowes@ndph.ox.ac.uk%3cmailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk<mailto:martin.bowes@ndph.ox.ac.uk</a>>> wrote:<br>
>>><br>
>>>>Going out on a limb here...<br>
>>>><br>
>>>>Are we sure the two sessions are working on the same table owned by the same user in the same database as each other?<br>
>>><br>
>>>I am only using a single session for this.<br>
>>><br>
>>>>In the sc930 trace file can you find the connection information immediately prior to the update code. You are looking for a line like:<br>
>>>>BEG 27/03/2018 13:26:07.598545, Database: iidbdb, User: ingres<br>
>>><br>
>>>There's nothing like this in the trace files.<br>
>>><br>
>>>>You could also check your database and see if there are any duplicates of the table with the query:<br>
>>>>Select table_owner from iitables where table_name='YOURTABLE';<br>
>>>><br>
>>>>Do that for each table involved in the update.<br>
>>><br>
>>>Only 1 row (& only 1 table in the update).<br>
>>><br>
>>>>Marty<br>
>>>><br>
>>>>-----Original Message-----<br>
>>>>From: Mark [<a href="mailto:i@dontgetlotsofspamanymore.net">mailto:i@dontgetlotsofspamanymore.net</a>]<br>
>>>>Sent: 17 May 2018 13:21<br>
>>>>To: <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>>>>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
>>>><br>
>>>>On Thu, 17 May 2018 12:06:48 +0000, Martin Bowes<br>
>>>><<a href="mailto:martin.bowes@ndph.ox.ac.uk%3cmailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk<mailto:martin.bowes@ndph.ox.ac.uk</a>>> wrote:<br>
>>>><br>
>>>>>No error code and with a rowcount of zero means the update is successful, but had no work to do.<br>
>>>>><br>
>>>>>I presume there is a where clause in the update and that it looks OK.<br>
>>>><br>
>>>>There is a where clause and it does match a record so there is "work<br>
>>>>to do".<br>
>>>><br>
>>>>>Can you compare the code which worked and the code which didn't work for discrepancies?<br>
>>>><br>
>>>>Yes. They are exactly the same! And it only fails the first time it<br>
>>>>is executed, all other times work fine.<br>
>>>><br>
>>>>>Marty<br>
>>>>><br>
>>>>>-----Original Message-----<br>
>>>>>From: Mark [<a href="mailto:i@dontgetlotsofspamanymore.net">mailto:i@dontgetlotsofspamanymore.net</a>]<br>
>>>>>Sent: 17 May 2018 12:57<br>
>>>>>To: <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>>>>>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
>>>>><br>
>>>>>On Thu, 17 May 2018 11:21:37 +0000, Martin Bowes<br>
>>>>><<a href="mailto:martin.bowes@ndph.ox.ac.uk%3cmailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk<mailto:martin.bowes@ndph.ox.ac.uk</a>>> wrote:<br>
>>>>><br>
>>>>>>Twice...<br>
>>>>>><br>
>>>>>>Once where it updates the data and once where it puts it back the way it was?<br>
>>>>><br>
>>>>>No. The data is the same for each.<br>
>>>>><br>
>>>>>>What do the Rowcount figures say on each statement?<br>
>>>>><br>
>>>>>0.<br>
>>>>><br>
>>>>>>Marty<br>
>>>>>><br>
>>>>>>-----Original Message-----<br>
>>>>>>From: Mark [<a href="mailto:i@dontgetlotsofspamanymore.net">mailto:i@dontgetlotsofspamanymore.net</a>]<br>
>>>>>>Sent: 17 May 2018 12:12<br>
>>>>>>To: <a href="mailto:info-ingres@lists.planetingres.org%3cmailto:info-ingres@lists.planetingres.org">
info-ingres@lists.planetingres.org<mailto:info-ingres@lists.planetingres.org</a>><br>
>>>>>>Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
>>>>>><br>
>>>>>>On Wed, 16 May 2018 12:40:48 -0400, Karl and Betty Schendel<br>
>>>>>><<a href="mailto:schendel@kbcomputer.com%3cmailto:schendel@kbcomputer.com">schendel@kbcomputer.com<mailto:schendel@kbcomputer.com</a>>> wrote:<br>
>>>>>><br>
>>>>>>>SC930 tracing is server wide and runs until you stop it with set notrace sc930.<br>
>>>>>>>So you can connect to any database, do the set trace record '/some/ingres-writable/dir'<br>
>>>>>>>and the set trace point sc930, go to the trace record directory you gave it and<br>
>>>>>>>ensure that there's at least something there (should be one or more sessNNNNN files),<br>
>>>>>>>and then you can run your esql program until the fault happens.<br>
>>>>>>><br>
>>>>>>>You don't actually need to put the sc930 into the esql program unless you want to<br>
>>>>>>>do it that way.<br>
>>>>>>><br>
>>>>>>>Once you capture what you need to capture, set notrace point sc930 turns it off.<br>
>>>>>>><br>
>>>>>>>You'll need the trace point privilege, simplest is to do it as the installation owner<br>
>>>>>>>(user ingres, traditionally).<br>
>>>>>><br>
>>>>>>Thanks again. We now have traces but they don't help me. The traces<br>
>>>>>>include the SQL statement and the data but, pretty much, nothing else.<br>
>>>>>><br>
>>>>>>The only notable thing I observed is that the data is traced twice for<br>
>>>>>>the failed transaction and only once for the successful ones.<br>
>>>>>><br>
>>>>>>There are no error messages.<br>
>>>>>><br>
>>>>>>>Karl<br>
>>>>>>><br>
>>>>>>>> On May 16, 2018, at 11:12 AM, Mark <<a href="mailto:i@dontgetlotsofspamanymore.net%3cmailto:i@dontgetlotsofspamanymore.net">i@dontgetlotsofspamanymore.net<mailto:i@dontgetlotsofspamanymore.net</a>>> wrote:<br>
>>>>>>>><br>
>>>>>>>> On Wed, 16 May 2018 12:11:08 +0000, Martin Bowes<br>
>>>>>>>> <<a href="mailto:martin.bowes@ndph.ox.ac.uk%3cmailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk<mailto:martin.bowes@ndph.ox.ac.uk</a>>> wrote:<br>
>>>>>>>><br>
>>>>>>>>> Just to expand on Karl's sc930...You may already know this...<br>
>>>>>>>>><br>
>>>>>>>>> To turn it on, make a recording directory...mkdir /full/path/to/directory'<br>
>>>>>>>>><br>
>>>>>>>>> And then...<br>
>>>>>>>>> sql iidbdb << SQL_END<br>
>>>>>>>>> set trace record '/full/path/to/directory';<br>
>>>>>>>>> set trace point sc930 1;<br>
>>>>>>>>> \p\g<br>
>>>>>>>>> \q<br>
>>>>>>>>> SQL_END<br>
>>>>>>>><br>
>>>>>>>> Do I need to run this on the server account? I have implemented it<br>
>>>>>>>> currently in the embedded SQL of my program.<br>
>>>>>>>><br>
>>>>>>>>> FYI. The digit after the sc930 indicates a tracing level, 1 should be sufficient.<br>
>>>>>>>>><br>
>>>>>>>>> Run the errant query.<br>
>>>>>>>>><br>
>>>>>>>>> And turn off the sc930.<br>
>>>>>>>>> sql iidbdb << SQL_END<br>
>>>>>>>>> set trace point sc930 0;<br>
>>>>>>>>> \p\g<br>
>>>>>>>>> \q<br>
>>>>>>>>> SQL_END<br>
>>>>>>>>><br>
>>>>>>>>> You can now access the recording directory and start scanning the files for any sign of life from your query.<br>
>>>>>>>>><br>
>>>>>>>>> Marty<br>
>>>>>>>>><br>
>>>>>>>>> -----Original Message-----<br>
>>>>>>>>> From: Karl and Betty Schendel [<a href="mailto:schendel@kbcomputer.com">mailto:schendel@kbcomputer.com</a>]<br>
>>>>>>>>> Sent: 16 May 2018 12:54<br>
>>>>>>>>> To: Ingres and related product discussion forum<br>
>>>>>>>>> Subject: Re: [Info-ingres] Weird problem in Ingres 10<br>
>>>>>>>>><br>
>>>>>>>>> On May 16, 2018, at 7:44 AM, Mark <<a href="mailto:i@dontgetlotsofspamanymore.net%3cmailto:i@dontgetlotsofspamanymore.net">i@dontgetlotsofspamanymore.net<mailto:i@dontgetlotsofspamanymore.net</a>>> wrote:<br>
>>>>>>>>>><br>
>>>>>>>>>> On Tue, 15 May 2018 12:27:09 -0400, Karl and Betty Schendel<br>
>>>>>>>>>> <<a href="mailto:schendel@kbcomputer.com%3cmailto:schendel@kbcomputer.com">schendel@kbcomputer.com<mailto:schendel@kbcomputer.com</a>>> wrote:<br>
>>>>>>>>>><br>
>>>>>>>>>>> It's certainly not something I have heard of or seen before. Do you have any rules<br>
>>>>>>>>>>> defined on the relevant tables? Try enabling LOG_TRACE if the problem is<br>
>>>>>>>>>>> sufficiently predictable, or do a logdump after the problem occurs if it's not;<br>
>>>>>>>>>>> the idea being to try to see whether you actually got any PUT (insert) or<br>
>>>>>>>>>>> REP (replace) log records that were then rolled back, or whether the insert / update<br>
>>>>>>>>>>> was never executed at all.<br>
>>>>>>>>>><br>
>>>>>>>>>> After enabling log_trace all I got was:<br>
>>>>>>>>>><br>
>>>>>>>>>> LOG: SAVEPOINT Size written/reserved: 0/ 0 Flags:<br>
>>>>>>>>>> -------------------------------------------------------------------<br>
>>>>>>>>><br>
>>>>>>>>> So the insert/update isn't ever being executed. Either it's failing with some sort of<br>
>>>>>>>>> silent error, which would seem odd, or it's not reaching the backend at all, or<br>
>>>>>>>>> it's being pre-empted by a before rule. I think the next step would be to enable<br>
>>>>>>>>> sc930 tracing and see if the backend is getting the insert-update, and what<br>
>>>>>>>>> end-of-query status it's recording. There should be KB articles on enabling<br>
>>>>>>>>> SC930 tracing.<br>
>>>>>>>>><br>
>>>>>>>>> Karl<br>
>>>>>>>>><br>
>>>>>>>>> _______________________________________________<br>
>>>>>>>>> Info-ingres mailing list<br>
>>>>>>>>> <a href="mailto:Info-ingres@lists.planetingres.org%3cmailto:Info-ingres@lists.planetingres.org">
Info-ingres@lists.planetingres.org<mailto:Info-ingres@lists.planetingres.org</a>><br>
>>>>>>>>> <a href="http://lists.planetingres.org/mailman/listinfo/info-ingres">
http://lists.planetingres.org/mailman/listinfo/info-ingres</a><<a href="http://lists.planetingres.org/mailman/listinfo/info-ingres">http://lists.planetingres.org/mailman/listinfo/info-ingres</a>><br>
>>>>>>>><br>
>>>>>>>> --<br>
>>>>>>>> <insert witty sig here><br>
>>>>>>>> _______________________________________________<br>
>>>>>>>> Info-ingres mailing list<br>
>>>>>>>> <a href="mailto:Info-ingres@lists.planetingres.org%3cmailto:Info-ingres@lists.planetingres.org">
Info-ingres@lists.planetingres.org<mailto:Info-ingres@lists.planetingres.org</a>><br>
>>>>>>>> <a href="http://lists.planetingres.org/mailman/listinfo/info-ingres">
http://lists.planetingres.org/mailman/listinfo/info-ingres</a><<a href="http://lists.planetingres.org/mailman/listinfo/info-ingres">http://lists.planetingres.org/mailman/listinfo/info-ingres</a>><br>
<br>
-- <br>
<insert witty sig here><br>
_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org">Info-ingres@lists.planetingres.org</a><br>
<a href="http://lists.planetingres.org/mailman/listinfo/info-ingres">http://lists.planetingres.org/mailman/listinfo/info-ingres</a><o:p></o:p></p>
</div>
</body>
</html>