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
22 matches
Mail list logo
