>
> This is a fairly spectacular failure :-(.  As far as I can see from
the
> semctl and shmctl man pages, the only plausible reason for EINVAL is
> that something had deleted the semaphores and shared memory out from
> under Postgres.  I do not believe that Postgres itself could have done

> that --- it had to be some external agency.  Unless the kernel is
> broken, whatever requested those deletions had to be running as root
or
> as postgres in order to have the necessary permissions.  You sure you
> didn't have some loose-cannon script running around issuing ipcrm
> commands?
>
No, I'm not sure at all about a loose-cannon script running around
issuing ipcrm commands.
I have to ask the other staff members what scripts are running.
I already had a suspicion that something like an ipcrm command is
causing this,
but it was denied. Now, with your support they probably will believe me.

Thanks for the quick reply.

Regards, Christoph




Mon, 17 Feb 2003 16:36:57 +0100
Christoph Haller <ch@rodos.fzk.de>
Re: IpcSemaphoreKill: ...) failed: Invalid argument
Christoph Haller wrote:
> No, I'm not sure at all about a loose-cannon script running around
> issuing ipcrm commands.
> I have to ask the other staff members what scripts are running.
> I already had a suspicion that something like an ipcrm command is
> causing this,
> but it was denied. Now, with your support they probably will believe me.

If you want to track it down and the people on your staff don't
already know what's going on, you can move the ipcrm binary out of the
way (to, say, ipcrm.bin) and replace it with a shell script that looks
something like this:

    #!/bin/sh
    
    (echo "ipcrm called with the following arguments:"
    echo
    for i in "$@" do echo "$i" ; done
    echo
    echo "Current programs running:"
    echo
    ps -elf) >/tmp/ipcrm.out.$$
    
    exec "$0".bin "$@"


Then just look for /tmp/ipcrm.out.* files and examine their contents.
(I think I got the arguments to ps right.  It's been so long since
I've had to mess with a SysVr4 style system that I'm not sure
anymore.  If it's a BSD-style ps then the arguments should be -auxww).


-- 
Kevin Brown					      kevin@sysexperts.com

Mon, 17 Feb 2003 11:16:37 -0800
Kevin Brown <kevin@sysexperts.com>
Re: IpcSemaphoreKill: ...) failed: Invalid argument