Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-16 Thread Andy
  I have removed the AV software and the problem doesn’t go away, it does seem to happen less frequently but is still there.  It is the same error -   “FATAL:  could not reattach to shared memory (key=5432001, addr=0196): Invalid argument”   The referenced key and address are alway

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-09 Thread Tom Lane
"Andy" <[EMAIL PROTECTED]> writes: > To try and reproduce the problem on another machine, I did a new install of > the same version of Postgres (8.1.3) and dump/restored the database onto > this new server. So far it has been running with the same load and activity > for almost 30 hours and the pr

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-09 Thread Andy
Hi,   Thank you for your replies.   I accept that the "Permission denied" problem does suggest that the DB error may be caused by the OS somehow.    There is no problem with the permissions/ownership of the files because the Postgres account created and owns and those files; this rul

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-09 Thread Simon Riggs
On Mon, 2006-05-08 at 08:31 -0400, Alvaro Herrera wrote: > > 2006-05-07 23:44:20 10.10.12.100(4018)PANIC: 42501: could not write to log > > file 0, segment 90 at offset 2998272, length 8192: Permission denied This is a pg_xlog error, so it looks like you have a whole-system issue, not just isolat

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-08 Thread Alvaro Herrera
Andy Male wrote: Hi Andy, This is your problem: > 2006-05-07 23:44:20 10.10.12.100(4018)PANIC: 42501: could not write to log > file 0, segment 90 at offset 2998272, length 8192: Permission denied > 2006-05-07 23:44:20 10.10.12.100(4018)CONTEXT: writing block 75 of relation > 1663/20632/100738

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-08 Thread Andy Male
n because of crash of another server process -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 07 May 2006 00:16 To: Andy Male Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #2419: could not reattach to shared memory I wish I had more to suggest to you. We

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-06 Thread Bruce Momjian
I wish I had more to suggest to you. We are working on a few problems with semaphore on Win2003 SP1, but nothing related to shared memory. --- Andy Male wrote: > > The following bug has been logged online: > > Bug referen

[BUGS] BUG #2419: could not reattach to shared memory

2006-05-05 Thread Andy Male
The following bug has been logged online: Bug reference: 2419 Logged by: Andy Male Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows 2003 Server (standard) SP1 Description:could not reattach to shared memory Details: FULL ERROR IN WI