Re: SEMVMX problem with postgresql

[Patrick Welche <prlw1%cam.ac.uk@localhost>]

On Tue, Mar 10, 2009 at 10:37:13AM +1100, Sarton O'Brien wrote:
> Patrick Welche wrote:
>>  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.
>
> It wasn't unresolved, I just needed to recompile. The error message was  
> misleading.

[Grumble: Have to look for old postgres source, as pg_resetxlog obviously
refuses to change 8.3 to 8.4 for the benefit of seeing the old data.]

> No amount of tweaking would fix it. A change occurred recently (last  
> month or so), probably to libc, that has required a lot of packages to  
> be recompiled. On some systems I've been better off doing pkg_delete  
> '*-*' and starting from scratch.

Still wonder what it is, eg

        ret = semget(0x52e2c1,0x11,0x780);
        if (ret == -1)
                err(1, NULL);

works fine on both computers...


OK postgres recompiling it is...


Thanks!

Patrick