• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1858
  • Last Modified:

Warning: Fatal error 7987

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
customscoop
Asked:
customscoop
  • 4
  • 3
1 Solution
 
imran_fastCommented:
<< 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
 
imran_fastCommented:
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
 
customscoopAuthor Commented:
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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
imran_fastCommented:
did u run this
DBCC CHECKDB ('allscoopdb', REPAIR_FAST)
GO
0
 
customscoopAuthor Commented:
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
 
imran_fastCommented:
<< 2 consistency errors in table 'KeywordMatches' (object ID 693577509).>>
Try dbcc dbreindex(KeywordMatches') with All_indexes
0
 
customscoopAuthor Commented:
Thanks!  The DBCC CHECKDB ('allscoopdb', REPAIR_FAST) fixed all my problems!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now