error in database, Can't attach shared memory with segment_id: 999

[Kopperton]

In middle of something database stops.
hereis the error, what I must do to fix this?

os UNIX, Progress 9.1D, SX.enterprise,1Gb ram
SYSTEM ERROR: Can't attach shared memory with segment_id: 999 for /db/nxt x There is no server for database //nxt. (1423)"

 

[Kirmik]

Check the system log on the unix server for clues as to why this is happening. You may need to tweak the Kernel settings accordingly

 

[Lee Curzon]

This was the earlier thread that suggested solutions to the problem. I presume it didn't help you much, but in case you lost a reference to it...

http://www.progresstalk.com/showthread.php?t=89328&highlight=1423

 

[Kopperton]

This happens when somebody runs a Brio query.

Error is ""Unable to commit the transaction in one database. (1417)"

in odbc,advanced
Default Isolation Level is "READ UNCOMMITTED"
Fetch Array: 50

 

[Casper]

What Unix are you on?
(Sco, AIX, HP-UX..) and what version?

Casper

 

[Kopperton]

Hello Casper,
OS is Unixware 7.1, 4gb ram

 

[Casper]

Do you have set up a secondary broker for sql servers?
Anyhting else in the log? (dead servers, transaction backup...) how many sql servers you have at max?

Dunno if I canhelp you out here, haven't had that problem....

Casper.

 

[Kopperton]

Casper this is what progress recomended, all brio queries run fine and I realized is only this big brio query that is causing this error. Do I need to tweak anything?

in file conmgr.properties i have

[configuration.nxt.defaultconfiguration]
maxservers=15

[servergroup.nxt.defaultconfiguration.defaultservergroup]
maxclientsperserver=55
minclientsperserver=15