Re: Dynamic Server 2000 crash
Posted in 2000
"smooth1" <smooth1@iclway.co.uk> wrote in message
news:399c6620_3@news1.vip.uk.com...
>
> Check kernel parameters
> I am not sure you can have more than 10 shared memory segments
> under Linux. Increase SHMVIRtSIZE in your ONCONFIG file.
>
> Also check the kernel parameters for semaphores.
Caldera Linux documentation is crappy; I can't even find a list of the
kernel parameters and their ranges of values. I'm used to SCO Unix, which
has a central list of parameters; Caldera Linux uses a /proc
pseudo-directory.
At any rate, I looked in my onconfig file, and it says that SHMVIRTSIZE is
the initial size of shared memory. Did you mean that I should increase
SHMADD, the size of added memory segments? I looked at what you said about
10 shared memory segments under Linux and changed my onconfig parameters to
SHMVIRTSIZE 8000
SHMADD 32000
SHMTOTAL 320000
so that 10 added segments could no longer be greater than SHMTOTAL. (I also
have forced residency on.) When I re-tried the program, it failed this time
with an error message -208, Memory Allocation Failed During Query
Processing, instead of crashing the engine, so there's some progress. I
still have no clue why a program that does nothing but a retrieval and sort
of a big table followed by 100 insert statements should grab all available
memory during the insert statements.