Adrian Maier <adrian.maier@xxxxxxxxxxxxxxx> writes: > I am running PostgreSQL 8.3.5 on a linux machine (Ubuntu 10.04). > Sometimes it happens that connecting to the database fails with error : > FATAL: semctl(360458, 3, SETVAL, 0) failed: Invalid argument (PGError) > If i restart postgres the problem gets "fixed". It doesn't matter how do i > connect to the database : i saw this happening from psql, from jdbc, and > from ruby. The most likely theory is that something deleted Postgres' semaphores out from under it. You could check this by noting the output of "ipcs -s" while the database is running normally, and then comparing to the output after it starts to fail. If that does seem to be what's happening, look around for root-executed scripts doing "ipcrm" calls. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
