I have a client that is getting DB crashes weekly and we cannot see that any processes are being exclusively killed. What we do see is that an appserver process that is connected to shared memory dies with either holding shared memory lock or does a core dump and has this in the bmrehash: Error occurred in area 205, block number: 1678890, extent: D:\Int\DB\dbname_205.d1.
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (10561) Writing block 1678890 to log file. Please save and send the log file to Progress Software Corp. for investigation.
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) SYSTEM DEBUG: Database buffer block
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) pbktbl = 0x20444440
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) pbktbl->qself = 0x000c000000434441
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) XBKBUF(pbktbl->qself) = 0x0018d59c20444441
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) pbktbl->bt_qbuf = 000c000006f84850
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) XBKBUF(pbktbl->bt_qbuf) = 0x26F94850
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) qusrctl: 0x000b00000019a0c0
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) use count: 1, governing latch: 24, lru: 0, state: 4
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) changed: 0, chkpt: 0, writing: 0, fixed: 0
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) aged: 0, onlru: 0, cleaning: 0, apwq: 0
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) bt_qlrunxt: 0x0c000000ca63c041, bt_qlruprv: 0x0c000000cae880c0
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) bt_qapwnxt: 0x0000000000000000, bt_qapwprv: 0x0000000000000000
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) bt_qfstuser: 0x0000000000000000, bt_qcuruser: 0x0000000000000000
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) pbkbuf = 0x26F94850
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) Block dbkey = 107449024 Offset = 6876737536
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) File: D:\Int\DB\dbname_205.d1
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) 0000: c043 3603 0000 0c00 6045 4300 0000 0c00
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) 0010: 5048 f806 0000 0c00 f956 0000 0100 0000
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) 0020: 0100 0000 1800 e903 5869 0000 1800 0000
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) 0030: 5538 0000 0000 0000 c08a 6706 0000 0000
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) 0040: cd00 0000 ffff ffff 70e2 ff0f 0000 0d00
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) 0050: 00b0 e299 0100 0000 0000 0000 0000 0000
[2013/05/24@11:24:20.773-0400] P-17840 T-33556 I APPSR1001: (-----) 0060: 0000 0000 0000 0000 41c0 63ca 0000 000c................................
Does anyone have any ideas or have seen this , the client is on 10.2B0712
The best option is to call TechSupport and send the ecore dump file and db log file to be inspected.
Besides that a possible cause is a bad coded transaction scoper within some procedure on appServer side