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

Kopperton

Member
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)"
 
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
 
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

 
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.
 
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
 
Back
Top