Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    60

    Unanswered: WARNING: EC 259683c0, 0 waited 32100 sec. on latch 807133b0. Not a BUF latch.

    During a bulk insert I am receiving this error message in the sql log. It appears to have caused the server to reboot the other night..

    I am running SQL 2000 8.00.760 (Service Pack 3)

    2004-04-07 12:57:52.82 spid8 WARNING: EC 259683c0, 0 waited 32100 sec. on latch 807133b0. Not a BUF latch.
    2004-04-07 12:57:52.82 spid8 Waiting for type 0x4, current count 0xa, current owning EC 0x70899570.


    Any ideas???

    Thanks

    Scott

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Run DBCC CHECKDB and see if it comes back clean. Generally errors posted in errorlog regarding BCP are related to format mismatch (bcp'ed out with -n and attempting to bcp in with -c, or using wrong format file).

  3. #3
    Join Date
    Oct 2003
    Posts
    60
    quick question, will dbcc checkdb block users from connecting to the database?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •