Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Warning: Fatal error 7987

Posted on 2006-04-10
7
Medium Priority
?
1,814 Views
Last Modified: 2008-01-09
We are seeing this problem in our application:

Warning: Fatal error 7987 occurred at Apr 10 2006 9:18AM猠楡⹤䄠牰汩椠⁳敤楳湧瑡摥愠⁳慎楴湯. Note the error and time, and contact your system administrator.

And upon checking the SQL logs we are seeing everytime a specific simple query is run:
A possible database consistency problem has been detected on database 'allscoopdb'.  DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'allscoopdb'..

We had this problem once last week, and a reboot fixed it.  The error is coming up everytime we run a specific sql query against the allscoopdb database.  We have been running this query for over a year with no problems.

I've run the DBCC CHECKDB and it has returned no errors.  Do you think there could be some kind of hardware problem?  Or what else can I do to figure out what the problem is?  

We are running MSSQL 2k on a big box.  It's a quad box with 16 gigs of RAM with a SAN device.  We are using managed hosting at RackSpace.

Help!
0
Comment
Question by:customscoop
  • 4
  • 3
7 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 16417358
<< The error is coming up everytime we run a specific sql query against the allscoopdb database. >>
run this statemnt

DBCC CHECKCATALOG ('allscoopdb')
GO

DBCC CHECKDB ('allscoopdb', REPAIR_FAST)
GO




0
 
LVL 28

Expert Comment

by:imran_fast
ID: 16417374
This problem migth be because of bad sector in the disk so try running scan disk for windows at a drive containing log file and datafile for the allscoopdb database.
0
 

Author Comment

by:customscoop
ID: 16417515
Those look great.  Will running either:

DBCC CHECKCATALOG ('allscoopdb')
GO

DBCC CHECKDB ('allscoopdb', REPAIR_FAST)
GO

Require single user mode, making the database unavailable in anyway?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 28

Accepted Solution

by:
imran_fast earned 2000 total points
ID: 16417597
did u run this
DBCC CHECKDB ('allscoopdb', REPAIR_FAST)
GO
0
 

Author Comment

by:customscoop
ID: 16421163
Here is the error I've gotten from the DBCC CHECKDB:

There are 69159732 rows in 280572 pages for object 'KeywordMatches'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'KeywordMatches' (object ID 693577509).

When I run this:
select keywordid from keywordmatches WITH (INDEX (keywordmatches11))
forcing it to use that index, it blows up.  So I suspect this index is having problems.  It did take 6 hours to run so I'll give the REPAIR_FAST option a try overnight.  I'll update this in the morning.

0
 
LVL 28

Expert Comment

by:imran_fast
ID: 16423955
<< 2 consistency errors in table 'KeywordMatches' (object ID 693577509).>>
Try dbcc dbreindex(KeywordMatches') with All_indexes
0
 

Author Comment

by:customscoop
ID: 16426678
Thanks!  The DBCC CHECKDB ('allscoopdb', REPAIR_FAST) fixed all my problems!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question