[Progress Communities] [Progress OpenEdge ABL] Forum Post: DB Crash: Out of free shared memory. Use -Mxs to increase

[Steven Peeters]

Hi, HPUX 11.31 / OE 11.6.3 We are performing some tests on large transactions on our SAII test-database. After deleting a large amount of records in 1 transaction (BI growth > 2GB) and then canceling the still running procedure (CTRL-C in editor with direct connection to DB) our database did a forced shut-down trying to undo the deletes: [2018/03/08@12:28:32.519+0100] P-23126 T-1 F ABL 22: (6495) Out of free shared memory. Use -Mxs to increase. [2018/03/08@12:28:32.527+0100] P-17493 T-1 I BIW 11: (453) Logout by root on batch. [2018/03/08@12:28:32.531+0100] P-23126 T-1 I ABL 22: (5028) SYSTEM ERROR: Releasing regular latch. latchId: 17 [2018/03/08@12:28:32.531+0100] P-23126 T-1 I ABL 22: (5029) SYSTEM ERROR: Releasing multiplexed latch. latchId: 2865857 [2018/03/08@12:28:32.531+0100] P-23126 T-1 I ABL 22: (-----) SYSTEM ERROR: dbenvout(a) released latch. [2018/03/08@12:28:32.531+0100] P-23126 T-1 F ABL 22: (5026) User 22 died holding 2 shared memory locks. [2018/03/08@12:28:32.552+0100] P-23126 T-1 I ABL 22: (439) ** Save file named core for analysis by Progress Software Corporation. [2018/03/08@12:28:32.563+0100] P-17496 T-1 I APW 12: (453) Logout by root on batch. [2018/03/08@12:28:32.564+0100] P-17502 T-1 I APW 14: (453) Logout by root on batch. [2018/03/08@12:28:32.565+0100] P-17508 T-1 I APW 16: (453) Logout by root on batch. [2018/03/08@12:28:32.566+0100] P-17505 T-1 I APW 15: (453) Logout by root on batch. [2018/03/08@12:28:32.577+0100] P-17489 T-1 I BROKER 0: (15192) The database will complete shutdown within approximately 60 seconds. [2018/03/08@12:28:32.586+0100] P-17489 T-1 I BROKER 0: (2249) Begin ABNORMAL shutdown code 2 [2018/03/08@12:28:42.685+0100] P-17489 T-1 I BROKER 0: (2527) Disconnecting dead user 22. [2018/03/08@12:29:35.206+0100] P-17489 T-1 I BROKER 0: (15194) Database activity did not finish before the shutdown timeout expired so the database is performing an immediate shutdown. [2018/03/08@12:30:03.355+0100] P-17489 T-1 I BROKER : (334) Multi-user session end. [2018/03/08@12:30:03.363+0100] P-17489 T-1 I BROKER : (16869) Removed shared memory with segment_id: 1114118 Database can be restarted with a (long) recovery. I'm guessing this is caused by error 6495? It's unclear to me how the -Mxs parameter should be set. Could this have been prevented with a higher -Mxs? (at the moment we don't set the parameter at all) Regards, Steven

Continue reading...