Kbase P92083: Procedure that updates schema terminates abnormally with Out of free shared memory. Use -Mxs to incr
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/09/2004 |
|
Status: Unverified
FACT(s) (Environment):
IBM AIX
SYMPTOM(s):
procedure that updates schema terminates abnormally
Out of free shared memory. Use -Mxs to increase. (6495)
SYSTEM ERROR: Releasing regular latch. latchId: 5 (5028)
User <id> died holding 1 shared memory locks. (5026)
** Save file named core for analysis by Progress Software Corporation. (439)
BROKER 0: Begin ABNORMAL shutdown code 2 (2249)
BROKER 0: Disconnecting dead user <id>. (2527)
BROKER : Removed shared memory with segment_id: <id>
BROKER : Multi-user session end. (334)
CAUSE:
The -mxs parameter was not set high enough to account for the schema modification.
Factored into shared memory is a linked list based partially on how many mandatory fields are defined within the database's schema.
The information in the schema of the database is read after memory is allocated.
FIX:
Increase the -mxs parameter when performing schema updates.