On Fri, Oct 14, 2011 at 1:30 AM, Sabin Coanda <s.coanda@xxxxxxxxxxxxxx> 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@xxxxxxxxx] > Sent: Thursday, October 13, 2011 7:59 PM > To: Sabin Coanda > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: could not reattach to shared memory > > On Thu, Oct 13, 2011 at 9:35 AM, Sabin Coanda <s.coanda@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
