Assertion Errors

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  January 17, 2005 at 10:37 am

  #87441

  Hi All,

  I have started getting Assertion Errors in SQL.

  It appears when I process a cube (Most of the time)

  Other SQL statements, usually with a join or 6 do the same thing.

  Whaving a scratch around google, I noticed the most people who get these errors are using SATA drives. Either RAID or not.

  Surprise, I am using SATA in RAID 1.

  Is this a common thing with SATA? I can't go to the pwers that be and say I need a couple large SCSI drives because I _think_ it's the SATA's.

  Another very odd thing that happened thismorning was I copied the mdf and ldf files off my machine (About 70GB) and onto the server. attached them and SQL was happy.

  Select Count(*) from aview gave me the count I was expecting.

  Select * From aview returned no rows. most of the time.

  I thought I was going mad. F5 works, then it doesn't then it does then, you get the point.

  Backup and restore seemed better until the errors below started...

  HELP!!!!

  Thanks

  Cheers,

  Crispin

  17066 :

  SQL Server Assertion: File: <q:\SPHINX\NTDBMS\storeng\drs\include\record.inl>, line=1447

  Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.

   

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• Antares686

  SSC Guru

  Points: 125444

  More actions

  January 18, 2005 at 8:32 am

  #537851

  Take a look here

  http://support.microsoft.com/kb/841776