On Thu, Jul 19, 2007 at 03:13:27PM -0700, Ben wrote: > What corner case reduces 2pc from "guaranteed" to "very high probability"? > Is the worry if somebody leaves transactions in a prepared state for > weeks, only to find that deadlock issues has arrisen at final commit time?
That's not the worry, no. But something _else_ could happen. For instance, recently it turned out that there was a way, using 2PC, to lock everybody out of the database. The only remedy to that at the moment is to blow away all the PREPAREd transactions, which could mean you lose something that was already committed to. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly