postgres.git / summary / log / commit / refs

commit    73bf9b77fc28840a335002d8dc817e8706d9a2ce
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue May 29 03:57:20 2012 +0000
First released in: 9.2.0, 8.3.19, 8.4.12, 9.0.8, 9.1.4

    Teach AbortOutOfAnyTransaction to clean up partially-started transactions.
    
    AbortOutOfAnyTransaction failed to do anything if the state it saw on
    entry corresponded to failing partway through StartTransaction.  I fixed
    AbortCurrentTransaction to cope with that case way back in commit
    60b2444cc3ba037630c9b940c3c9ef01b954b87b, but evidently overlooked that
    AbortOutOfAnyTransaction should do likewise.
    
    Back-patch to all supported branches.  It's not clear that this omission
    has any more-than-cosmetic consequences, but it's also not clear that it
    doesn't, so back-patching seems the least risky choice.


 src/backend/access/transam/xact.c | 19 ++++++++++++++++++-
 1 file changed, 18 insertions(+), 1 deletion(-)

diff --git a/src/backend/access/transam/xact.c b/src/backend/access/transam/xact.c
index d1cebeb86db..511e17c2e45 100644
--- a/src/backend/access/transam/xact.c
+++ b/src/backend/access/transam/xact.c
@@ -3748,7 +3748,24 @@ AbortOutOfAnyTransaction(void)
 		switch (s->blockState)
 		{
 			case TBLOCK_DEFAULT:
-				/* Not in a transaction, do nothing */
+				if (s->state == TRANS_DEFAULT)
+				{
+					/* Not in a transaction, do nothing */
+				}
+				else
+				{
+					/*
+					 * We can get here after an error during transaction start
+					 * (state will be TRANS_START).  Need to clean up the
+					 * incompletely started transaction.  First, adjust the
+					 * low-level state to suppress warning message from
+					 * AbortTransaction.
+					 */
+					if (s->state == TRANS_START)
+						s->state = TRANS_INPROGRESS;
+					AbortTransaction();
+					CleanupTransaction();
+				}
 				break;
 			case TBLOCK_STARTED:
 			case TBLOCK_BEGIN:


[parent: 785b8d6ab312]