BUG #2371: database crashes with semctl failed error

From: "Brock Peabody" <brock(dot)peabody(at)npcinternational(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2371: database crashes with semctl failed error
Date: 2006-04-03 14:05:00
Message-ID: 200604031405.k33E50h6057559@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2371
Logged by: Brock Peabody
Email address: brock(dot)peabody(at)npcinternational(dot)com
PostgreSQL version: 8.1
Operating system: Windows Server 2003
Description: database crashes with semctl failed error
Details:

The full text of the error message is:

FATAL: semctl(167894456, 4, SETVAL, 0) failed: A non-blocking socket
operation could not be completed immediately.

I have a program that inserts/updates/deletes a large number of records to a
large database (~100 GB). The program works, but after it runs for a few
hours it starts getting this error message. Once this happens the database
is unusable to all clients until it is restarted.

I found this documented bug:

http://archives.postgresql.org/pgsql-bugs/2006-02/msg00185.php

but I'm not sure if it is related to my problem or not.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jim Nasby 2006-04-03 16:22:34 Re: BUG #2364: DB Error: connect failed ... PHP/PostgreSql
Previous Message Richard Huxton 2006-04-03 13:17:56 Re: BUG #2365: can't install