FIX: Infrequent Access Violation During LOAD TRANSACTIONID: Q170436
|
You may infrequently experience a handled access violation (AV) during a
LOAD TRANSACTION. If you are running a debug version of SQL Server 6.5
(needed to ensure an accurate stack trace), you can determine that this AV
occurs in the ldxact() function.
If you use a LOAD DATABASE statement to reload the database and then use
LOAD TRANSACTION to reapply the same transaction, the problem usually does
not occur again.
The following is the stack trace from a 6.50.252 debug server:
ldxact() + 0x178C
s_execute() + 0x18FC
sequencer() + 0x035C
language_exec() + 0x06D6
To work around this problem, reload the database then reapply the same transaction files with LOAD TRANRANSACTION.
Microsoft has confirmed this to be a problem in SQL Server version 6.5.
This problem was corrected in the latest Microsoft SQL Server 6.5 U.S.
Service Pack. For information on obtaining the service pack, query on
the following word in the Microsoft Knowledge Base (without the spaces):
S E R V P A C K
Keywords : kbusage SSrvGen SSrvGPF SSrvTran_SQL kbbug6.50 kbfix6.50.sp4
Version : 6.5
Platform : WINDOWS
Issue type : kbbug
Last Reviewed: April 19, 1999