From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Sabin Coanda <s(dot)coanda(at)deuromedia(dot)com> |
Cc: | Sabin Coanda <s(dot)coanda(at)deuromedia(dot)ro>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: could not reattach to shared memory |
Date: | 2011-10-14 19:27:22 |
Message-ID: | CAHyXU0x6G_0B6e3dPoUHA6TJW57q2zZLOpx67cPt+hE=pviULQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Oct 14, 2011 at 1:30 AM, Sabin Coanda <s(dot)coanda(at)deuromedia(dot)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(at)gmail(dot)com]
> Sent: Thursday, October 13, 2011 7:59 PM
> To: Sabin Coanda
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] could not reattach to shared memory
>
> On Thu, Oct 13, 2011 at 9:35 AM, Sabin Coanda <s(dot)coanda(at)deuromedia(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2011-10-14 19:29:56 | Re: pg 8.3 replication causing corruption |
Previous Message | Guillaume Lelarge | 2011-10-14 17:58:06 | Re: Postgres Account Inherit Question |