Обсуждение: could not reattach to shared memory

Hi all,

A user on the mapserver news group is getting this error.  I have not
run on windows so dont know what it means.  Any hints would be appreciated.


FATAL: could not reattach to shared memory (Key=224, addr=025F0000): 487

The OS is windows vista
PostGIS version - 1.3.6
Postgresql - 8.3


Postgresql.conf settings:


listen_addresses = '*'          # what IP address(es) to listen on;
port = 5432                             # (change requires restart)
max_connections = 100                   # (change requires restart)

# - Memory -

shared_buffers = 32MB                   # min 128kB or max_connections*16kB
                                         # (change requires restart)

max_fsm_pages = 204800                  # min max_fsm_relations*16, 6
bytes each
                                         # (change requires restart)

# - Where to Log -

log_destination = 'stderr'
logging_collector = on

log_line_prefix = '%%t '                        # special values:

datestyle = 'iso, mdy'
lc_messages = 'English, United States'
                                         # strings
lc_monetary = 'English, United States'
lc_numeric = 'English, United States'
lc_time = 'English, United States'

# default configuration for text search
default_text_search_config = 'pg_catalog.simple'

On Tue, Sep 29, 2009 at 7:41 AM, Andy Colson <andy@squeakycode.net> wrote:
> Hi all,
>
> A user on the mapserver news group is getting this error.  I have not run on
> windows so dont know what it means.  Any hints would be appreciated.

I believe the latest releases of postgresql have fixed this bug.  Here
is a write up about it:
http://blog.hagander.net/archives/149-Help-us-test-a-patch-for-the-Win32-shared-memory-issue.html


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

On Tue, 2009-09-29 at 09:41 -0500, Andy Colson wrote:
> FATAL: could not reattach to shared memory (Key=224, addr=025F0000):
> 487
>
> The OS is windows vista
> PostGIS version - 1.3.6
> Postgresql - 8.3

IIRC, this was fixed in 8.3.8. An update should be the first step.

Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

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