No subject


Fri May 2 19:13:14 EDT 2003


log cannot be truncated until the transaction is committed.  What says "DBCC
OPENTRAN tempdb" ?  

Two possibilities:

1.	a goof on your end, failing to commit a transaction.  
2.	a bug in FreeTDS, causing the transaction to be left open when it
shouldn't be.  

#2 could be libtdb or in odbc.  

If you can't find the source of the open transaction, you can kill all the
client connections ("kill <spid>").  That should do it.  Else reboot the
server.  

If there is no open transaction before running 0014, and 0014 is exhausting
your tempdb log, then we have to look for a FreeTDS bug, methinks.  I'll see
if I can reproduce it.  TDS 7.0 and current CVS?  

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.





More information about the FreeTDS mailing list