Current-Users archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

SEMVMX problem with postgresql



I saw an unresolved posting about this on port-xen:

 FATAL:  semctl(65538, 16, SETVAL, 536) failed: Result too large or too small
HINT:  You possibly need to raise your kernel's SEMVMX value to be at least 
536.  Look into the PostgreSQL documentation for details.


but see it on i386. It happened when upgrading to a Feb 20 kernel, but I can't
remember how old the previous one was.

kern.ipc.sysvmsg = 1
kern.ipc.sysvsem = 1
kern.ipc.sysvshm = 1
kern.ipc.shmmax = 41943040
kern.ipc.shmmni = 128
kern.ipc.shmseg = 128
kern.ipc.shmmaxpgs = 10240
kern.ipc.shm_use_phys = 0
kern.ipc.msgmni = 40
kern.ipc.msgseg = 2048
kern.ipc.semmni = 10
kern.ipc.semmns = 60
kern.ipc.semmnu = 30
kern.posix.semmax = 128
/usr/include/sys/sem.h:#define SEMVMX   32767           /* semaphore maximum 
value */

I see this with postgresql 8.3.0, but not with 8.4devel. Any ideas on what
changed. There was talk of rlimit enforcement, but even if I unlimit in
the shell postmaster is started from, I see the same.

Cheers,

Patrick


Home | Main Index | Thread Index | Old Index