This is a multi-part message in MIME format.
------=_NextPart_000_00C6_01CACFE7.14D35670
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi, I have a table which is constantly updated through out the day with =
no problems, I'm running Postgresql 8.3.8 in ubuntu karmic. However, =
within the last week for some reason overnight it is being emptied and I =
can't work out why. I've set log_min_duration_statement to 0 so that =
postgresql dumps out every query made to the db but it hasn't brought =
anything up. During the period between from when I know the table is ok =
to the next morning when it is empty I can see entries in the logs for =
the expected 200 or so deletions, but during this period approx 15k rows =
are removed. The odd thing is that there is nothing else in the logs =
that references the table (I've looked for the obvious deletion and =
trunctate statements).
The table is modified using JDBC prepared statements so I see 3 entries =
for each of the expected delete statements (parse, bind, execute) and =
the statement is as follows:
delete from product_list where retailer_id=3D? and product_id=3D?
Therefore I have a few questions:
- Is there any other statements that could be causing the rows to be =
removed that I've missed
- Is there anything that could be deleting them without generating a log =
entry for the statement?
- Is it possible that data corruption of either the index/table is =
making my delete statements removed more rows?
- Is it a possibly bug?
Thanks
John
--
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/
------=_NextPart_000_00C6_01CACFE7.14D35670
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16981" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi, I have a table which is constantly =
updated
through out the day with no problems, I'm running Postgresql =
8.3.8 in
ubuntu karmic. However, within the last week for some reason overnight =
it is
being emptied and I can't work out why. I've set =
log_min_duration_statement to 0
so that postgresql dumps out every query made to the db but it hasn't =
brought
anything up. During the period between from when I know the table is ok =
to the
next morning when it is empty I can see entries in the logs =
for the
expected 200 or so deletions, but during this period approx 15k rows are =
removed. The odd thing is that there is nothing else in the logs that =
references
the table (I've looked for the obvious deletion and trunctate
statements).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The table is modified using JDBC =
prepared
statements so I see 3 entries for each of the expected delete statements =
(parse,
bind, execute) and the statement is as follows:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>delete from product_list where =
retailer_id=3D? and
product_id=3D?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Therefore I have a few =
questions:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- Is there any other statements that =
could be
causing the rows to be removed that I've missed</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- Is there anything that could be =
deleting them
without generating a log entry for the statement?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- Is it possible that data corruption =
of either the
index/table is making my delete statements removed more =
rows?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- Is it a possibly bug?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>John</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>--</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Got needs? Get Goblin'! - <A
href=3D"http://www.pricegoblin.co.uk/">http://www.pricegobli n.co.uk/</A><=
BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_00C6_01CACFE7.14D35670--
