Thread: postgreslog-semctl(7438339, 4, SETVAL, 0) failed:

postgreslog-semctl(7438339, 4, SETVAL, 0) failed:

From
"surabhi.ahuja"
Date:
I am using postges, 8.0.0
on that system , it seems that there are two databases, i am not sure if the same postmaster is used to connect to both the databases,
 
 
i am seeing these logs in postgreslog
 
<2006-04-19 01:13:25 IST%>LOG:  connection received: host=[local] port=
<2006-04-19 01:13:25 IST%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-19 01:13:25 IST%startup>FATAL:  semctl(7438339, 4, SETVAL, 0) failed: Invalid argument
<2006-04-19 01:13:25 IST%>LOG:  connection received: host=[local] port=
<2006-04-19 01:13:25 IST%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-19 01:13:25 IST%startup>FATAL:  semctl(7438339, 4, SETVAL, 0) failed: Invalid argument
<2006-04-19 01:13:25 IST%>LOG:  connection received: host=[local] port=
<2006-04-19 01:13:25 IST%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-19 01:13:25 IST%startup>FATAL:  semctl(7438339, 4, SETVAL, 0) failed: Invalid argument
 
 
what do they mean?
 
thanks,
regards
Surabhi

Re: postgreslog-semctl(7438339, 4, SETVAL, 0) failed:

From
Tom Lane
Date:
"surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in> writes:
> <2006-04-19 01:13:25 IST%startup>FATAL:  semctl(7438339, 4, SETVAL, 0)
> failed: Invalid argument

Kinda looks like something deleted your semaphores --- does "ipcs -s"
show anything?

Stopping and restarting the postmaster should fix it, if so, but you'll
want to find out who ipcrm'd the semaphores and rap their knuckles.

            regards, tom lane