FIX: Heavy TEXT/IMAGE Inserts May Lead to Error 611

ID: Q195530

The information in this article applies to:
BUG #: 17860 (SQLBUG_65)

SYMPTOMS

Large numbers of users performing inserts into the same table with a TEXT or IMAGE column, within a transaction, can raise an error 611 as follows:

Error: 611 Severity: 21 State: 1 Attempt made to end transaction that is idle or in the middle of an update.


WORKAROUND

To work around this problem, perform the following steps:

  1. Remove the transaction or alter the transaction scope.


  2. Insert a NULL into the TEXT or IMAGE column within the transaction.


  3. Update to data to the proper text value outside the actual BEGIN TRANSACTION and COMMIT TRANSACTION statements.


Avoid using this method on non-logged text operations. Each time a non-logged text operation is completed, the SQL Server must make sure all dirty pages associated with the table are flushed to complete the operation. If many spids have dirtied pages, this can be a significant flush. In many cases, it may be better to increase the log size and avoid the immediate checkpoint of all pages associated with the specified table.


STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.


MORE INFORMATION

Error 611 is a specific connection level only error. It does not affect the SQL Server data integrity.

Additional query words: prodsqlsp sp5err message msg 


Keywords          : kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: May 4, 1999