WSS 3.0 - Is the DB full?
After receiving the following event log message (see below) a DBCC was run on the DB listed however the Query return (see below) states that the ‘tempdb out of space or a system table is inconsistent.’ Event Log message: Application Log Event: 16 Dec 2010 02:12:29 AM Computer: [ESM-APP] Monitor: [Event Log Monitor] Description: * Event Time: 16 Dec 2010 02:06:34 AM * Source: MSSQL$MICROSOFT##SSEE * Event Log: Application * Type: Error Event * Event ID: 824 * SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x44a75f1c; actual: 0x2411382a). It occurred during a read of page (1:28776) in database ID 21 at offset 0x0000000e0d0000 in file 'C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\DATA\WSS_Content_118e5acc9f9d487cafcd24a9780049ba.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. * Event Time: 16 Dec 2010 02:06:34 AM * Source: Windows SharePoint Services 3 * Event Log: Application * Type: Error Event * Event ID: 6398 * The Execute method of job definition Microsoft.SharePoint.Administration.SPRecycleBinCleanupJobDefinition (ID 37583bce-2258-42a6-87f4-718952fe2337) threw an exception. More information is included below. Cannot complete this action. Please try again. Query return message: Msg 8967, Level 16, State 216, Line 1 An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services. DBCC results for 'WSS_Content_118e5acc9f9d487cafcd24a9780049ba'. Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors. CHECKDB found 0 allocation errors and 0 consistency errors in database 'WSS_Content_118e5acc9f9d487cafcd24a9780049ba'. File WSS_Content_118e5acc9f9d487cafcd24a9780049ba.mdf is 1.29GB. The server has plenty of disk space. C: has 7GB free and D: has 13GB free. What does this mean? Could it mean the SharePoint Services DB is limited in growth space and that the limit of DB space has been reached? How can one remove old data from this kind of database? If data needs to be removed what data is it in the SharePoint site? -DM Small Biz IT Manager
December 22nd, 2010 11:52am

Hi, The 824 error indicates that a logical consistency error was detected during a read. A logical consistency error is a clear indication of actual damage and frequently indicates data corruption caused by a faulty I/O subsystem component. If the problem is not hardware-related and a known clean backup is available, restore the database from the backup. For more information, please refer to: http://technet.microsoft.com/en-us/library/aa337274(SQL.90).aspx For Event ID 6398 error, it is likely to occur for the SharePoint Timer service, the issue has fixed by KB946517: http://support.microsoft.com/?id=946517 Hope the information can help. Xue-Mei Chang TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.com Xue-Mei Chang
Free Windows Admin Tool Kit Click here and download it now
December 24th, 2010 2:41am

You have DB corruption going on. Hopefully you have a backup before this corruption happend. This is your DB file with inconsistencies: \WSS_Content_118e5acc9f9d487cafcd24a9780049ba.mdf' Given that you are running a SharePoint Standalone installation with Windows Internal Database (SSEE), you need to open it with \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query in Management Studio to run DBCC CheckDB. Living the SharePoint dream...
December 25th, 2010 3:55am

You have DB corruption going on. Hopefully you have a backup before this corruption happend. This is your DB file with inconsistencies: \WSS_Content_118e5acc9f9d487cafcd24a9780049ba.mdf' Given that you are running a SharePoint Standalone installation with Windows Internal Database (SSEE), you need to open it with \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query in Management Studio to run DBCC CheckDB. Living the SharePoint dream...
Free Windows Admin Tool Kit Click here and download it now
December 25th, 2010 3:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics