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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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