Problem while starting the DB

[ramyapriyacsit]

Hi All,

I am unable to start the DB as below error comes.
Please advice to recover the error.
$DLC/bin/_mprosrv cfacprtfuq
11:48:40 BROKER : Semaphore limit exceeded (1131)
11:48:40 BROKER : Removed shared memory with segment_id: 13041787
11:48:40 BROKER : ** This process terminated with exit code 2. (8619)

 

[Casper]

OS? Progress version? Other databases running at that server? What Startup parameters used?

Anyhow you are reaching some kind of OS limit regarding semphores.

Casper

 

[ramyapriyacsit]

Capser,

OS - Linux
Progress version - 91e
Other databases running at that server - Yes remaining are working fine
Startup parameters used for the reported db is below:

-cpinternal GB2312
-cpstream GB2312
-cprcodein GB2312
-L 184800
-c 350
-Ma 3
-Mn 1
-spin 50
-semsets 1
-n 12
~

Pls advice me if any to be changed.

Thanks and regards
Ramya

 

[Casper]

What flavour of Linux?

Are you using dataserver? I believe -c is a dataserver parameter.
-semsets 1 is the default value in 9.1E.
You can ommit -spin as well.

For testing purposes you could increase the values for SEMNI and SEMMNS.

Regards,

Casper.

 

[ramyapriyacsit]

Where i can specify the parameters SEMNI and SEMMNS ?
in the same parameter file ?
how much can i set the values to ?

Please advise.

Thanks for your quick replies.

 

[ramyapriyacsit]

The flavour am using Linux SuSE FUSE Version 2.0.0-RC2-SL0/SLES-9.

 

[TomBascom]

$ man sysctl

or

$ cat /proc/sys/kernel/sem


-spin 50 is probably not a very good value. -spin 5000 is probably much more appropriate. -semsets 1 is superfluous. -c is too (unless you're seeing an error that says otherwise). Also -- why specify -Ma & -Mn if you aren't specifying -S? Are you starting a secondary broker somewhere?