Re: could not reattach to shared memory

From: "Sabin Coanda" <s(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: could not reattach to shared memory
Date: 2011-10-13 14:35:48
Message-ID: j76t06$17en$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-10-13 14:43:04 Re: Transfer 8.3 to 8.4 - FUNCTION gtsq_in(cstring) does not exist
Previous Message Sabin Coanda 2011-10-13 14:33:06 could not reattach to shared memory