Skip site navigation (1) Skip section navigation (2)

WARNING: out of shared memory

From: "Juan C(dot) Aragon" <juan(at)keisercomputers(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: WARNING: out of shared memory
Date: 2009-07-16 21:41:13
Message-ID: C9A098E7894944A2A31C6D8A0F7BA68F@JUANPC (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

We are working on Windows Server 2003 Enterprise with PostgreSQL 8.4, when
we start populating a table with 130,000 records it start giving "WARNING:
out of shared memory"

on every record that was inserted. At the end it did not finish, it only
inserted 4,000 records and got the following message:


2009-07-16 16:54:05 EDT    WARNING:  worker took too long to start;

2009-07-16 16:54:05 EDT    WARNING:  out of shared memory

2009-07-16 16:54:05 EDT    FATAL:  out of shared memory


Also, we are not able to login to the database with PgAdmin, getting same
error "out of shared memory"

Once we stop and start the service, we were able to access the database


Any ideas what is going wrong?




Juan C.


pgsql-bugs by date

Next:From: Jaime CasanovaDate: 2009-07-16 21:44:56
Subject: Re: FATAL: could not reattach to shared memory (key=268, addr=01E30000): 487
Previous:From: Greg StarkDate: 2009-07-16 20:27:47
Subject: Re: BUG #4926: too few pathkeys for mergeclauses

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group