could not reattach to shared memory

Sorry, for the unfinished text,

So, I run a long transaction with a lot of data, and after a while I got the
messages:

NOTICE: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the
configuration parameter "max_fsm_relations".
LOG: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the
configuration parameter "max_fsm_relations".
STATEMENT: VACUUM
FATAL: could not reattach to shared memory (key=324, addr=021A0000): 487

And the process stops.

Why ? What to do ?

TIA,
Sabin

On Thu, Oct 13, 2011 at 9:35 AM, Sabin Coanda <s.coanda@deuromedia.ro> wrote:

Sorry, for the unfinished text,

So, I run a long transaction with a lot of data, and after a while I got the
messages:

NOTICE: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the
configuration parameter "max_fsm_relations".
LOG: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the
configuration parameter "max_fsm_relations".
STATEMENT: VACUUM
FATAL: could not reattach to shared memory (key=324, addr=021A0000): 487

And the process stops.

Why ? What to do ?

need:
postgres version
o/s and o/s version
relevant memory settings in postgres, especially shared buffers
value of SHMMAX etc

merlin

On Fri, Oct 14, 2011 at 1:30 AM, Sabin Coanda <s.coanda@deuromedia.com> wrote:

Hi,

The requested info:
       - "PostgreSQL 8.3.5, compiled by Visual C++ build 1400"
       - Windows 7 Enterprise v6.1 build 7601:sp1
       - postgres.conf is attached

Thanks,
Sabin

-----Original Message-----
From: Merlin Moncure [mailto:mmoncure@gmail.com]
Sent: Thursday, October 13, 2011 7:59 PM
To: Sabin Coanda
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] could not reattach to shared memory

On Thu, Oct 13, 2011 at 9:35 AM, Sabin Coanda <s.coanda@deuromedia.ro> wrote:

Sorry, for the unfinished text,

So, I run a long transaction with a lot of data, and after a while I
got the
messages:

NOTICE: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the
configuration parameter "max_fsm_relations".
LOG: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the
configuration parameter "max_fsm_relations".
STATEMENT: VACUUM
FATAL: could not reattach to shared memory (key=324, addr=021A0000):
487

And the process stops.

Why ? What to do ?

Upgrade your database. See:
http://www.postgresql.org/docs/8.3/static/release-8-3-8.html

"Fix Windows shared-memory allocation code (Tsutomu Yamada, Magnus)

This bug led to the often-reported "could not reattach to shared
memory" error message."

merlin