SQL Server Performance

Database Consistency errors

Discussion in 'SQL Server Clustering' started by Zsolt, Nov 5, 2003.

  1. Zsolt New Member

    Hi,

    I have an active-active SQL cluster server. The 1st node contains only one (user) database.
    The second node has a replicated database of this one (transactional replication).
    Yesterday I found a consistency errors in the database on the 1st node. I fixed it db with dbcc checkdb...
    Then I created a new snapshot snd configured again the transactional repl. (The second node is the distributor.)

    I have a 3rd database on the2nd node that gets data from the replicated db. (triggers and stored procedures are responsibel for this on the 2nd node)

    I found some error messages in the application log that the every databases contains errors on the second node (including distribution database)

    when I use the dbcc checkdb it founds no errors in the database. It is very strange for me. Do you have any suggestion why happend this or what is the solution?

    Thanks

    Zsolt
  2. satya Moderator

    What are those 'some error messages' found in application log, post them to assess?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. Zsolt New Member

    The msg is the following<br /><br />Error: 8908, Severity: 22, State: 6<br />Table error: Database ID 9, object ID 1333631844, index ID 0. Chain linkage mismatch. (1:707634)-&gt;next = (1:24354), but (1:24354)-&gt<img src='/community/emoticons/emotion-4.gif' alt=';p' />rev = (1:24353). <br /><br />if I run the dbcc dbcheck on the appropriate db it dosen't found any error.<br /><br />Zsolt
  4. satya Moderator

    What is the level of service pack on SQL & OS?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. Zsolt New Member

    W2K SP4 and SQL2K Sp3



    Zsolt
  6. satya Moderator

    To ensure that the database is free of corruption, run a DBCC CHECKDB statement, preferably in single user mode, against the database. If DBCC CHECKDB returns no error, you can be certain that the database is free of corruption.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  7. Zsolt New Member

    do xou know what is the cause of this problem?<br />currently my replicated database is corrupted again. If I run the dbcc checkdb with repair_rebuild solves the problem.<br /><br />Several hours later the problem occures again<br /><br />I got the following message:<br /><br /><br />Error: 8908, Severity: 22, State: 6<br />Table error: Database ID 9, object ID 1333631844, index ID 0. Chain linkage mismatch. (1:24544)-&gt;next = (1:618432), but (1:618432)-&gt<img src='/community/emoticons/emotion-4.gif' alt=';p' />rev = (1:765054). <br /><br /><br />Zsolt
  8. satya Moderator

    You must check from event viewer and see any h/w issues or any drive issues that might triggering this consistency error.

    Its better to run DBCC checks and backup the database and restore on replicated end.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page