D
durgaprasad m
Guest
Hi Tom, Today also we received same memory violation error in our database log and database went down. Again we restarted database its came up after that 2 mins mfg/pro application received "server or system ha no more resource" connect . After few mins issue resolved on it owns mfg/pro application we are able to connect. 06:26:49 SRV 7: vv_flush:I/O error 5 on fd 1 06:26:49 SRV 7: Previous message sent on behalf of user 1071. (5512) 06:26:49 SRV 7: HANGUP signal received. (562) 06:26:49 SRV 7: Previous message sent on behalf of user 1071. (5512) 06:26:49 SRV 7: Begin transaction backout. (2252) 06:26:49 SRV 7: Transaction backout completed. (2253) 06:26:49 SRV 7: Logout usernum 1071, userid y020txe, on p5lp5 122. (739) 06:26:50 SRV 7: HANGUP signal received. (562) 06:26:50 SRV 7: Previous message sent on behalf of user 1072. (5512) 06:26:50 SRV 7: Logout usernum 1072, userid y020txe, on p5lp5 51. (739) 06:27:28 SQLSRV2 5: SYSTEM ERROR: Memory violation. (49) 06:27:29 SRV 6: SYSTEM ERROR: Attempt to read block 0 which does not exist. (210) 06:27:29 SRV 6: ** Save file named core for analysis by Progress Software Corporation. (439) 06:27:29 SRV 6: Logout usernum 1085, userid y020txe, on p5lp5 42. (739) 06:27:29 SRV 6: Logout usernum 1081, userid fsobien, on mhlctxqad07a. (739) 06:27:29 SRV 6: Logout usernum 1083, userid y020axh, on p5lp5 1. (739) 06:27:29 SRV 6: Begin transaction backout. (2252) 06:27:29 SRV 6: Transaction backout completed. (2253) 06:27:29 SRV 6: Logout usernum 1080, userid rhughes, on mhlctxqad08a. (739) 06:27:29 SRV 6: Logout usernum 1082, userid y020dyv, on p5lp5 123. (739) 06:27:29 SRV 6: Stopped. (2520) 06:27:38 SRV 8: Corrupt block detected when attempting to release a buffer. (4232) 06:27:38 SRV 8: bmReleaseBuffer: Error occurred in area 6, block number: 7171557, extent: /progdata/prd/slcdb1/prdslc.d1. (10560) 06:27:38 SRV 8: Writing block 7171557 to log file. Please save and send the log file to Progress Software Corp. for investigation. (10561) 06:27:38 SRV 8: SYSTEM DEBUG: Database buffer block 06:27:38 SRV 8: pbktbl = 0x30a0401c 06:27:38 SRV 8: pbktbl->qself = 0x58a0401c 06:27:38 SRV 8: XBKBUF(pbktbl->qself) = 0x30a0401c 06:27:38 SRV 8: pbktbl->bt_qbuf = 0x72a30bb4 06:27:38 SRV 8: XBKBUF(pbktbl->bt_qbuf) = 0x62a30bb4 06:27:38 SRV 8: pbkbuf = 0x62a30bb4 06:27:38 SRV 8: Block dbkey = 0x1b5b7980 bt_offset = 0x0 06:27:38 SRV 8: File: /progdata/prd/slcdb6/prdslc.d55 06:27:38 SRV 8: 0000: 0000 0000 0000 08e4 58a0 40cc 72a3 0bb4 06:27:38 SRV 8: 0010: 0000 0001 0100 042d 0000 23fc 001b 0000 06:27:38 SRV 8: 0020: 1b5b 7980 0000 0006 67ff f3f8 0000 0000 06:27:38 SRV 8: 0030: 0000 0000 3dc3 8000 ffff ffff 0000 0000 06:27:38 SRV 8: 0040: 0000 0000 0000 0000 0000 0000 58a2 d62c 06:27:38 SRV 8: 0050: 5859 3c8c 0000 0000 0000 0000 0000 0000 06:27:38 SRV 8: 0060: 0000 0000 0000 0000 0001 0100 0000 0000 06:27:38 SRV 8: 0070: 006a 0000 0000 0000 0000 0000 0000 0000 06:27:38 SRV 8: 0080: 0000 0000 0000 0000 0000 0000 0000 0000 06:27:38 SRV 8: 0090: 0000 0000 0000 0000 0000 0000 0000 0000 06:27:38 SRV 8: 00a0: 58a0 401c 0000 0000 0000 0000 0000 0000 06:27:38 SRV 8: Block buffer dump follows, from address 0x62a30bb4: 06:27:38 SRV 8: 0000: 0401 ab6f 5e06 4953 532d 534f 0000 0102 .... 06:27:38 SRV 8: 1ff0: 487f 0000 0004 01a6 8ae5 0000 0000 00fd 06:27:38 SRV 8: End of buffer 06:27:38 SRV 8: SYSTEM ERROR: wrong dbkey in block. Found 67218287, should be 458979712 in area 6 (1124) 06:27:38 SRV 8: ** Save file named core for analysis by Progress Software Corporation. (439) 06:27:38 SRV 8: Stopped. (2520) 06:27:38 SRV 7: Stopped. (2520) 06:27:38 SRV 2: Stopped. (2520) 06:27:38 BIW 41: Stopped. (2520) 06:27:38 AIW 42: Stopped. (2520) 06:27:38 APW 36: Stopped. (2520) 06:27:38 APW 37: Stopped. (2520) 06:27:38 APW 39: Stopped. (2520) 06:27:38 APW 38: Stopped. (2520) 06:27:39 BROKER 0: Begin ABNORMAL shutdown code 2 (2249) 06:27:40 BROKER 0: Disconnecting dead server -1. (2525) 06:27:41 BROKER 0: Disconnecting dead server -1. (2525) 06:27:42 BROKER 0: Disconnecting dead server -1. (2525) 06:27:46 WDOG 40: Stopped. (2520) 06:27:47 BROKER : Removed shared memory with segment_id: 131105 06:27:47 BROKER : Removed shared memory with segment_id: 131083 06:27:47 BROKER : Removed shared memory with segment_id: 131121 06:27:47 BROKER : Removed shared memory with segment_id: 131120 06:27:47 BROKER : Removed shared memory with segment_id: 131079 06:27:47 BROKER : Removed shared memory with segment_id: 131081 06:27:47 BROKER : Multi-user session end. (334) Now we are able to see shared memory status for database which went down only. PROGRESS SHARED MEMORY STATUS ID ShMemVer Seg# InUse Database 393216 9136 3 - /progdata/prd/slcdb1/prdslc.db 393217 9136 4 - /progdata/prd/slcdb1/prdslc.db You have mail in /usr/spool/mail/pgresdba please provide your suggestion or thoughts on this issue.
Continue reading...
Continue reading...
