D
durgaprasad m
Guest
HI All, Yesterday we have faced issue database got crashed.During that time we found below errors in database log files. Previously when we faced issue we thought some network connection and also we got same info from knowledge base also. 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 whether if any block will be corrupted if any batch jobs or reports run. why i'm saying this issue happening during non-business hours. I would like to test the above errors. How we can re produce the same error.I want to test this error 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.. 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)
Continue reading...
Continue reading...
