locked
Transactions/Client-Side Redirect issue RRS feed

  • Question

  • Hi there.

    With Client-Side Redirect, connections can be dinamically redirected in case of failover. But if a long transaction is running on the principal, when it fails the redirect doesn´t work with the current ado.net connection, connected to the database running that transaction.

    So if the principal fails, current running transaction will be lost right ?

     

    Thanks in advance.

    Thursday, March 23, 2006 6:03 PM

Answers

  • So, there are a couple of issues here.

    1. ANY transaction that is currently running and has not commited will have to be reapplied after a failover.  Long running transactions just have a bigger "window" in which a failure could happen.

    2. In the RTM version of 2005, the client's TCP timeout was longer than the connection timeout. So, the connection would be closed before the redirect could occur. We've changed this in SP1, which has a CTP ready for download.

    Thanks,

    Mark

    Friday, March 24, 2006 6:53 PM