On Friday 20 June 2008 05:26, Robert Treat wrote:
> On Thursday 19 June 2008 14:06:38 Garry Saddington wrote:
> > > In any case, however, if PostgreSQL reported the transaction complete
> > > and the machine didn't experience any hardware problems (like sudden
> > > power or disk failure), I would
Robert Treat <[EMAIL PROTECTED]> writes:
> On Thursday 19 June 2008 14:06:38 Garry Saddington wrote:
>> The problem seems to have started last friday, when reports started to go
>> missing.
> Out of curiosity, what is your vacuum strategy?
If you're thinking "transaction ID wraparound", I believ
On Thursday 19 June 2008 14:06:38 Garry Saddington wrote:
> > In any case, however, if PostgreSQL reported the transaction complete and
> > the machine didn't experience any hardware problems (like sudden power or
> > disk failure), I would certainly not suspect PostgreSQL as the source of
> > the
Hi,
Garry Saddington wrote:
On Thursday 19 June 2008 16:55, Joshua D. Drake wrote:
On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote:
...
Yes I thought of this but once the report is sent to the DB a separate query
is run to get all of that teacher's reports and these are then displa
On Thu, 2008-06-19 at 20:29 +0100, Garry Saddington wrote:
> On Thursday 19 June 2008 19:03, Joshua D. Drake wrote:
> > On Thu, 2008-06-19 at 19:06 +0100, Garry Saddington wrote:
> > > On Thursday 19 June 2008 18:15, Alan Hodgson wrote:
> > > > On Thursday 19 June 2008, Garry Saddington
> <[EMAIL
On Thursday 19 June 2008 19:03, Joshua D. Drake wrote:
> On Thu, 2008-06-19 at 19:06 +0100, Garry Saddington wrote:
> > On Thursday 19 June 2008 18:15, Alan Hodgson wrote:
> > > On Thursday 19 June 2008, Garry Saddington <[EMAIL PROTECTED]>
>
> Although I appreciate that this is a funky problem, th
Adrian Klaver wrote:
Yes I thought of this but once the report is sent to the DB a
separate query is run to get all of that teacher's reports and
these are then displayed on a new page. They all appear here but
then disappear later. Zope has transaction machinery that rolls
everything back on an
Garry Saddington <[EMAIL PROTECTED]> writes:
> Oh, and the problem has been intermittant. Another
> thing that happened this morning is that Postgres had today as 18/06/2008
> when in fact it was 19/06/2008 and the OS reported this correctly.
Two theories about that one:
1. Postgres' timezone set
-- Original message --
From: Garry Saddington <[EMAIL PROTECTED]>
> On Thursday 19 June 2008 18:52, Adrian Klaver wrote:
> > -- Original message --
> > From: Garry Saddington <[EMAIL PROTECTED]>
> >
> > > On Thursday 19 June 2008 16:5
On Thu, 2008-06-19 at 19:12 +0100, Garry Saddington wrote:
> On Thursday 19 June 2008 18:52, Adrian Klaver wrote:
> > -- Original message --
> > From: Garry Saddington <[EMAIL PROTECTED]>
> > Seems like a transaction with no commit. Basically along as the session
On Thursday 19 June 2008 18:52, Adrian Klaver wrote:
> -- Original message --
> From: Garry Saddington <[EMAIL PROTECTED]>
>
> > On Thursday 19 June 2008 16:55, Joshua D. Drake wrote:
> > > On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote:
> > > > I have had
On Thu, 2008-06-19 at 19:06 +0100, Garry Saddington wrote:
> On Thursday 19 June 2008 18:15, Alan Hodgson wrote:
> > On Thursday 19 June 2008, Garry Saddington <[EMAIL PROTECTED]>
Although I appreciate that this is a funky problem, the problem doesn't
yet exist and we are operating in a diagnost
Garry Saddington wrote:
On Thursday 19 June 2008 18:15, Alan Hodgson wrote:
On Thursday 19 June 2008, Garry Saddington <[EMAIL PROTECTED]>
wrote:
I read in a
Postgres manual that the hard disk may report to the OS that a write has
occured when it actually has not, is this possible?
Yeah. But
On Thursday 19 June 2008 18:09, Scott Marlowe wrote:
> On Thu, Jun 19, 2008 at 9:55 AM, Garry Saddington
>
> <[EMAIL PROTECTED]> wrote:
> > I have had a serious loss of data and wondered if anyone could shed any
> > light on what may have happened.
> > My users have been writing reports on students
On Thursday 19 June 2008 18:15, Alan Hodgson wrote:
> On Thursday 19 June 2008, Garry Saddington <[EMAIL PROTECTED]>
>
> wrote:
> > I read in a
> > Postgres manual that the hard disk may report to the OS that a write has
> > occured when it actually has not, is this possible?
>
> Yeah. But unless t
-- Original message --
From: Garry Saddington <[EMAIL PROTECTED]>
> On Thursday 19 June 2008 16:55, Joshua D. Drake wrote:
> > On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote:
> > > I have had a serious loss of data and wondered if anyone could shed any
> >
On Thursday 19 June 2008 18:10, Bill Moran wrote:
> In response to Garry Saddington <[EMAIL PROTECTED]>:
> > On Thursday 19 June 2008 16:55, Joshua D. Drake wrote:
> > > On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote:
> > > > I have had a serious loss of data and wondered if anyone could
On Thursday 19 June 2008, Garry Saddington <[EMAIL PROTECTED]>
wrote:
> I read in a
> Postgres manual that the hard disk may report to the OS that a write has
> occured when it actually has not, is this possible?
Yeah. But unless the power suddenly turned off that wouldn't cause data
loss.
> Oh
In response to Garry Saddington <[EMAIL PROTECTED]>:
> On Thursday 19 June 2008 16:55, Joshua D. Drake wrote:
> > On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote:
> > > I have had a serious loss of data and wondered if anyone could shed any
> > > light on what may have happened.
> > > My
On Thu, Jun 19, 2008 at 9:55 AM, Garry Saddington
<[EMAIL PROTECTED]> wrote:
> I have had a serious loss of data and wondered if anyone could shed any light
> on what may have happened.
> My users have been writing reports on students. No error messages have been
> produced and when called back up
On Thursday 19 June 2008 16:55, Joshua D. Drake wrote:
> On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote:
> > I have had a serious loss of data and wondered if anyone could shed any
> > light on what may have happened.
> > My users have been writing reports on students. No error messages
On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote:
> I have had a serious loss of data and wondered if anyone could shed any light
> on what may have happened.
> My users have been writing reports on students. No error messages have been
> produced and when called back up the reports se
I have had a serious loss of data and wondered if anyone could shed any light
on what may have happened.
My users have been writing reports on students. No error messages have been
produced and when called back up the reports seem to be present at the time
of writing. However, next day they have
23 matches
Mail list logo
