Re: [XP SP2/SP3] FATAL: could not reattach to shared memory

Łukasz Czerpak wrote:
> Hi,
>
> We have problems with PostgreSQL on Windows.
>
> PostgreSQL: 8.3.1
> System: Windows XP (SP3)
> FS: NTFS
> Hardware: IBM x3650, 1x Xeon Quad, 2GB RAM
>
>
> The database is accessed from multiple windows apps. One of them has a
> connection pool, the others use single connection per app.
> Somethimes when I start PgAdmin and then our app, the second one freeze
> (not a PgAdmin bug, the same issue is with other apps).
> The log contains:
>
> FATAL: could not reattach to shared memory (key=1808, addr=01CC0000): 487
> FATAL: could not reattach to shared memory (key=1808, addr=01CC0000): 487
> 2008-06-24 06:36:11 CEST WARNING: worker took too long to start; cancelled
>
> Errors appears on Windows XP SP2 too.
>
> On Windows 2000 we have never noticed memory errors like above - on very
> similar configuration (but with win2k) the PostgreSQL works perfectly.
>
> Anybody have any idea about this?

487 is "Invalid address".

Do you have any antivirus or similar software on the machine? If so, try
uninstalling it and trying again (just disabling it is usually not enough).

Have you changed any configuration parameters around the memory size
such as shared_buffers?

//Magnus