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

Started by surabhi.ahujaalmost 20 years ago2 messagesgeneral

surabhi.ahuja@iiitb.ac.in

almost 20 years ago

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

Tom Lane

tgl@sss.pgh.pa.us

almost 20 years ago

In reply to: surabhi.ahuja (#1)

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

"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