Memory Violation.. - Forum - OpenEdge RDBMS - Progress Community
 Forum

Memory Violation..

This question is not answered

Test1.txtError.txtDatabase errors_all.txt

HI All,

Yesterday we have faced issue database got crashed.During that time we found below errors found in database log files.

Previously when we faced issue we thought some network levl issues and also we got same info from knowledge base also then we restarted database.

23:31:34 SQLSRV2 6: SYSTEM ERROR: Memory violation. (49

23:31:34 SQLSRV2 8: SYSTEM ERROR: Memory violation. (49)

23:31:35 Usr    43: SYSTEM ERROR: rmlocate: Invalid RM block for area 6 , requested Dbkey 461129088 and located Dbkey 253. (10809)

23:31:35 Usr    43: ** Save file named core for analysis by Progress Software Corporation. (439)

23:31:35 Usr    43: Corrupt block detected when attempting to release a buffer. (4232)

23:31:35 Usr    43: bmReleaseBuffer: Error occurred in area 6, block number: 7205141, extent: /progdata/prd/crndb1/prdcrn.d1. (10560)

23:31:35 Usr    43: Writing block  7205141 to log file. Please save and send the log file to Progress Software Corp. for investigation. (10561)

23:31:35 Usr    43: SYSTEM DEBUG: Database buffer block

23:31:35 Usr    43: pbktbl = 0x30bf3f44

23:31:35 Usr    43: pbktbl->qself = 0x58bf3f44

23:31:35 Usr    43: XBKBUF(pbktbl->qself) = 0x30bf3f44

23:31:35 Usr    43: pbktbl->bt_qbuf = 0x786347bc

23:31:35 Usr    43: XBKBUF(pbktbl->bt_qbuf) = 0x706347bc

23:31:35 Usr    43: pbkbuf = 0x706347bc

23:31:35 Usr    43: Block dbkey = 0x1b7c4580   bt_offset = 0x0 

But this issue is happened second time..

I would like  to know if any block got corrupted during any batch jobs or reports run. why i'm saying this is issue happening during non-business hours only.
I would like to test the above errors.
How we can re produce the same errors.I want to test this errors in any test database.Any suggestion how we can reproduce or how we can resolve this issue.

23:31:34 SQLSRV2 6: SYSTEM ERROR: Memory violation. (49

23:31:34 SQLSRV2 8: SYSTEM ERROR: Memory violation. (49)

23:31:35 Usr    43: SYSTEM ERROR: rmlocate: Invalid RM block for area 6 , requested Dbkey 461129088 and located Dbkey 253. (10809)

23:31:35 Usr    43: ** Save file named core for analysis by Progress Software Corporation. (439)

23:31:35 Usr    43: Corrupt block detected when attempting to release a buffer. (4232)

23:31:35 Usr    43: bmReleaseBuffer: Error occurred in area 6, block number: 7205141, extent: /progdata/prd/crndb1/prdcrn.d1. (10560) 

And also during this incident in all our database log files i found below errors..
Any idea.

23:31:34 SQLSRV2 6: SYSTEM ERROR: Memory violation. (49)

23:31:34 SQLSRV2 8: SYSTEM ERROR: Memory violation. (49)

23:31:35 Usr    43: SYSTEM ERROR: rmlocate: Invalid RM block for area 6 , requested Dbkey 461129088 and located Dbkey 253. (10809)

23:31:35 Usr    43: ** Save file named core for analysis by Progress Software Corporation. (439)

23:31:35 Usr    43: Corrupt block detected when attempting to release a buffer. (4232)

23:31:35 Usr    43: bmReleaseBuffer: Error occurred in area 6, block number: 7205141, extent: /progdata/prd/crndb1/prdcrn.d1. (10560)

23:31:35 Usr    43: Writing block  7205141 to log file. Please save and send the log file to Progress Software Corp. for investigation. (10561)

23:31:35 Usr    43: SYSTEM DEBUG: Database buffer block

23:31:35 Usr    43: pbktbl = 0x30bf3f44

23:31:35 Usr    43: pbktbl->qself = 0x58bf3f44

23:31:35 Usr    43: XBKBUF(pbktbl->qself) = 0x30bf3f44

23:31:35 Usr    43: pbktbl->bt_qbuf = 0x786347bc

23:31:35 Usr    43: XBKBUF(pbktbl->bt_qbuf) = 0x706347bc

23:31:35 Usr    43: pbkbuf = 0x706347bc

23:31:35 Usr    43: Block dbkey = 0x1b7c4580   bt_offset = 0x0

 Please find attached errors log files details

Please help me!!..

23:49:07 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:49:12 SRV    13: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:49:35 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:49:42 SRV    13: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:49:49 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:49:57 SRV    24: Connection timed out on socket=92 for usernum 2, attempt disconnect. (1280)

23:50:05 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:50:20 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:50:35 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:50:36 SRV    28: Server's received count 1 does not equal client(1)'s send count 1414744096. (1055)

23:50:50 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:50:50 SRV    27: Server's received count 1 does not equal client(1)'s send count 1414744096. (1055)

23:51:06 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:51:20 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:51:36 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:51:41 SRV    24: Connection timed out on socket=92 for usernum 2, attempt disconnect. (1280)

23:51:50 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:52:07 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:52:18 SRV    24: Connection timed out on socket=92 for usernum 2, attempt disconnect. (1280)

23:52:21 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:52:37 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:52:51 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:52:53 SRV    24: Connection timed out on socket=92 for usernum 2, attempt disconnect. (1280)

23:53:07 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:53:21 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:53:37 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:53:38 SRV    24: Connection timed out on socket=92 for usernum 2, attempt disconnect. (1280)

23:53:49 SRV    16: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:53:51 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:54:07 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:54:09 SRV    24: Connection timed out on socket=92 for usernum 2, attempt disconnect. (1280)

23:54:21 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:54:38 SRV    28: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

23:54:51 SRV    24: Connection timed out on socket=92 for usernum 2, attempt disconnect. (1280)

23:54:52 SRV    27: Connection timed out on socket=91 for usernum 1, attempt disconnect. (1280)

Error in Database : prdreyb

===================================

23:37:59 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:37:59 SRV    24: Server's received count 1 does not equal client(1)'s send count 1414744096. (1055)

23:38:30 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:39:00 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:39:31 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:40:01 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:40:31 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:41:01 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:41:32 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:42:02 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:42:32 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:43:02 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:44:18 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:44:48 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:46:01 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:46:46 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:47:16 SRV    24: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:49:27 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:50:15 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:50:51 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:51:26 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:52:12 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:52:42 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:53:28 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:53:49 SRV    31: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:53:53 SRV    40: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:53:58 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:54:28 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

23:54:28 SRV    33: Server's received count 1 does not equal client(1)'s send count 1414744096. (1055)

23:54:58 SRV    33: Connection timed out on socket=31 for usernum 1, attempt disconnect. (1280)

Error in Database : prdslc

===================================

Error in Database : prdslcb

===================================

23:48:52 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:48:57 BROKER  1: Connection timed out on socket=60 for usernum 1, attempt disconnect. (1280)

23:49:18 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:49:27 BROKER  1: Connection timed out on socket=60 for usernum 1, attempt disconnect. (1280)

23:49:30 SRV    23: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:49:39 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:49:48 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:50:15 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:50:19 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:50:49 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:50:51 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:51:19 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:51:27 SRV    23: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:51:36 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:51:49 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:52:03 SRV    23: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:52:07 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:52:20 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:52:38 SRV    23: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:52:49 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:52:50 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:53:19 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:53:24 SRV    23: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:53:49 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:53:50 SRV    28: Server's received count 1 does not equal client(1)'s send count 1414744096. (1055)

23:53:54 SRV    23: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:54:05 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:54:08 SRV    11: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:54:20 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:54:35 SRV    27: Connection timed out on socket=62 for usernum 2, attempt disconnect. (1280)

23:54:36 SRV    23: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

23:54:50 SRV    28: Connection timed out on socket=61 for usernum 1, attempt disconnect. (1280)

All Replies
  • I have taken dbanalys report for test database which is created with backup which is taken after issue.

    Using below errors we can identify anything

    AREA "Schema Area" : 6  BLOCK ANALYSIS

    -------------------------------------------------

    [Warning] RM block found that should be in the RM free chain. (2802)

    dbkey=256534912, free space=8170, # of free directories=64, hold=0

    (3865)

    11599786 block(s) found in the area.

  • i taken dbanalys using backup which is taken after the issue.

    can i know what exactly the issue.

    AREA "Schema Area" : 6  BLOCK ANALYSIS

    -------------------------------------------------

    [Warning] RM block found that should be in the RM free chain. (2802)

    dbkey=256534912, free space=8170, # of free directories=64, hold=0

    (3865)

    11599786 block(s) found in the area.

  • You asked if you could identify anything with the data you had -

    000015059 - How to determine what table a given RECID resides in when using Progress Version 9 or later

  • Carey, we can't find a table based on a /wrong/ dbkey. Record's offset inside the block can be wrong as well (as in this case). Even an area number can be wrong. And finally even if you will use the correct dbkey but the header of the specified block contains a wrong dbkey then the FIND statement will crash.

  • > i taken dbanalys using backup which is taken after the issue.

    You need to rebuild the backup because the message in your attached Test1.txt file says that "this database has not been fully restored". Can you describe all your steps during backup and restore?