I have an intermittent problem with PostgreSQL 7.3.2 on Solaris 8. The backend process crashes once in a while, with this in the database log:
... ... 2004-07-05 22:43:54 LOG: database system is ready IpcSemaphoreInitialize: semctl(id=65615, 14, SETVAL, 0) failed: Invalid argument 2004-07-06 09:19:03 LOG: server process (pid 23755) exited with exit code 1 2004-07-06 09:19:03 LOG: terminating any other active server processes 2004-07-06 09:19:03 WARNING: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. 2004-07-06 09:19:03 WARNING: Message from PostgreSQL backend: ... ... This problem may randomly pop up on any one of the few Pg servers running on this host. I'm not sure whether this could be a kernel problem... Do I need to look at the kernel configuration, installed patches, etc? Any idea on why this could happen would be appreciated. Mike. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend