D
durgaprasad m
Guest
Hi All, In our database went down due to memory violation error.I checked in promon > 1> Status: Shared Memory Segments It shows all memory utilized. Now database and application up and running but shared memory segments is full for all database. what action i need to take to resolve this issue. Status: Shared Memory Segments Seg Id Size Used Free 1 393265 134217728 134217724 4 2 393248 134217728 134217724 4 3 393264 134217728 134217716 12 4 393247 134217728 134217716 12 5 393228 134217728 120246044 13971684 6 393263 25251840 396 25251444 Enter , R, P, T, or X (? for help): 19:08:39 SQLSRV2 6: SYSTEM ERROR: Memory violation. (49) 19:08:47 SQLSRV2 3: SYSTEM ERROR: Memory violation. (49) 19:08:50 SQLSRV2 5: SYSTEM ERROR: Memory violation. (49) 19:08:57 SQLSRV2 4: SYSTEM ERROR: Memory violation. (49) 19:08:59 SRV 35: Corrupt block detected when attempting to release a buffer. (4232) 19:08:59 SRV 35: bmReleaseBuffer: Error occurred in area 6, block number: 7171557, extent: /progdata/prd/slcdb1/prdslc.d1. (10560) 19:08:59 SRV 35: Writing block 7171557 to log file. Please save and send the log file to Progress Software Corp. for investigation. (10561) 19:08:59 SRV 35: SYSTEM DEBUG: Database buffer block PROGRESS Version 9.1E as of Tue Oct 12 17:19:22 EDT 2004 PROGRESS SHARED MEMORY STATUS ID ShMemVer Seg# InUse Database 131072 - - - (not PROGRESS) 131073 - - - (not PROGRESS) We tried rebooting server option also but few seconds it is worked fine, again it showing shared memory segments full. OS: Aix 5.3 Progress version : 9.1e Application : Mfg/pro 8.3
Continue reading...
Continue reading...
