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 or flat)
Thread:
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;
cancelled

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
again.

 

Any ideas what is going wrong?

 

Thanks,

 

Juan C.

Responses

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-2014 The PostgreSQL Global Development Group