Re: [HACKERS] database errors

2004-05-14 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Fri, 2004-05-14 at 02:00, Tom Lane wrote: >> Okay, you have a page with an LSN of A971020 which is past end of XLOG >> (550). You may have created this problem for yourself by doing >> pg_resetxlog with poorly chosen parameters. > Is there a way t

Re: [HACKERS] database errors

2004-05-14 Thread Michael Brusser
> -Original Message- > From: [EMAIL PROTECTED] > > > > pg_dump: ERROR: XLogFlush: request 0/A971020 is not satisfied --- > > > flushed only to 0/550 ... lost synchronization with > server, resetting > > > connection > > > > Okay, you have a page with an LSN of A971020 which is past e

Re: [HACKERS] database errors

2004-05-14 Thread Simon Riggs
On Fri, 2004-05-14 at 02:00, Tom Lane wrote: > Michael Brusser <[EMAIL PROTECTED]> writes: > > It looks that "No such file or directory" followed by the abort signal > > resulted from manually removing logs. pg_resetxlog took care of this, > > but other problems persisted. > > > pg_dump: ERROR: X

Re: [HACKERS] database errors

2004-05-13 Thread Tom Lane
Michael Brusser <[EMAIL PROTECTED]> writes: > It looks that "No such file or directory" followed by the abort signal > resulted from manually removing logs. pg_resetxlog took care of this, > but other problems persisted. > pg_dump: ERROR: XLogFlush: request 0/A971020 is not satisfied --- > flus

Re: [HACKERS] database errors

2004-05-13 Thread Michael Brusser
It looks that "No such file or directory" followed by the abort signal resulted from manually removing logs. pg_resetxlog took care of this, but other problems persisted. I got a copy of the database and installed it on the local partition. It does seem badly corrupted, these are some hard errors.

Re: [HACKERS] database errors

2004-05-13 Thread Tom Lane
Michael Brusser <[EMAIL PROTECTED]> writes: > I wonder if message > "open of /mnt_c1t2d0s0/... (log file 0, segment 1) failed: No such file or > directory" > may indicate some kind of NFS problem. Running a database over NFS is widely considered a horrid idea --- the NFS protocol is simply too pro

[HACKERS] database errors

2004-05-13 Thread Michael Brusser
Our customer has problems with Pg 7.3.2 on Solaris. There are numerous errors in the app. server log and in the database log, including these: LOG: open of /mnt_c1t2d0s0//postgresql/pg_xlog/0001 (log file 0, segment 1) failed: No such file or directory LOG: invalid primary checkpoint