November 17, 2008 at 10:20 am
I'm running SQL Server 2000(SP4) with pull transactional replication on 2 machines, publisher A & subscriber B.
Since morning I have been getting error 3624 whenever I try to read or write to the published database on machine A.
The error is
2008-11-17 13:33:57.30 spid1162 Stack Signature for the dump is 0xF814A3F1
2008-11-17 13:33:57.33 spid1162 SQL Server Assertion: File: , line=1004
Failed Assertion = 'filepos + cBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
2008-11-17 13:33:57.35 spid1162 Error: 3624, Severity: 20, State: 1.
This doesnt happen all the time, just 20% of the time when I run queries.The rest of the time the queries work fine. even a simple select statement throws up this error.
I'm attaching the error log and dump file.
Can anybody please help me troubleshoot this? Please
November 20, 2008 at 10:38 pm
With assertion failures and stack dumps, you should probably be calling CSS (customer support) as they are likely the only ones who will be able to help you.
Can you run a checkdb and see if it picks up an y errors. run it with No_infomsgs and all_errormsgs options.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 21, 2008 at 9:27 am
I restarted the server and didnt get the error for the whole day today, maybe there is some issue with sql 2000 and windows 2003 server hard disk I/O we dont know about
I ran checkdb it didnt show any errors
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply