xact.c 38.4 KB
Newer Older
1 2
/*-------------------------------------------------------------------------
 *
3
 * xact.c
4
 *	  top level transaction system support routines
5 6 7 8 9
 *
 * Copyright (c) 1994, Regents of the University of California
 *
 *
 * IDENTIFICATION
10
 *	  $Header: /cvsroot/pgsql/src/backend/access/transam/xact.c,v 1.49 1999/09/04 19:55:48 momjian Exp $
11
 *
12
 * NOTES
13
 *		Transaction aborts can now occur two ways:
14
 *
15 16
 *		1)	system dies from some internal cause  (Assert, etc..)
 *		2)	user types abort
17
 *
18 19 20
 *		These two cases used to be treated identically, but now
 *		we need to distinguish them.  Why?	consider the following
 *		two situatuons:
21
 *
22 23 24 25 26 27
 *				case 1							case 2
 *				------							------
 *		1) user types BEGIN				1) user types BEGIN
 *		2) user does something			2) user does something
 *		3) user does not like what		3) system aborts for some reason
 *		   she shes and types ABORT
28
 *
29 30 31 32 33
 *		In case 1, we want to abort the transaction and return to the
 *		default state.	In case 2, there may be more commands coming
 *		our way which are part of the same transaction block and we have
 *		to ignore these commands until we see an END transaction.
 *		(or an ABORT! --djm)
34
 *
35 36 37 38 39
 *		Internal aborts are now handled by AbortTransactionBlock(), just as
 *		they always have been, and user aborts are now handled by
 *		UserAbortTransactionBlock().  Both of them rely on AbortTransaction()
 *		to do all the real work.  The only difference is what state we
 *		enter after AbortTransaction() does it's work:
40
 *
41 42
 *		* AbortTransactionBlock() leaves us in TBLOCK_ABORT and
 *		* UserAbortTransactionBlock() leaves us in TBLOCK_ENDABORT
43
 *
44 45 46 47 48 49 50 51
 *	 NOTES
 *		This file is an attempt at a redesign of the upper layer
 *		of the V1 transaction system which was too poorly thought
 *		out to describe.  This new system hopes to be both simpler
 *		in design, simpler to extend and needs to contain added
 *		functionality to solve problems beyond the scope of the V1
 *		system.  (In particuler, communication of transaction
 *		information between parallel backends has to be supported)
52
 *
53
 *		The essential aspects of the transaction system are:
54
 *
55 56 57 58 59
 *				o  transaction id generation
 *				o  transaction log updating
 *				o  memory cleanup
 *				o  cache invalidation
 *				o  lock cleanup
60
 *
61 62 63 64 65
 *		Hence, the functional division of the transaction code is
 *		based on what of the above things need to be done during
 *		a start/commit/abort transaction.  For instance, the
 *		routine AtCommit_Memory() takes care of all the memory
 *		cleanup stuff done at commit time.
66
 *
67
 *		The code is layered as follows:
68
 *
69 70 71 72
 *				StartTransaction
 *				CommitTransaction
 *				AbortTransaction
 *				UserAbortTransaction
73
 *
74 75 76
 *		are provided to do the lower level work like recording
 *		the transaction status in the log and doing memory cleanup.
 *		above these routines are another set of functions:
77
 *
78 79 80
 *				StartTransactionCommand
 *				CommitTransactionCommand
 *				AbortCurrentTransaction
81
 *
82 83 84 85 86 87 88 89 90
 *		These are the routines used in the postgres main processing
 *		loop.  They are sensitive to the current transaction block state
 *		and make calls to the lower level routines appropriately.
 *
 *		Support for transaction blocks is provided via the functions:
 *
 *				StartTransactionBlock
 *				CommitTransactionBlock
 *				AbortTransactionBlock
91
 *
92 93 94 95
 *		These are invoked only in responce to a user "BEGIN", "END",
 *		or "ABORT" command.  The tricky part about these functions
 *		is that they are called within the postgres main loop, in between
 *		the StartTransactionCommand() and CommitTransactionCommand().
96
 *
97
 *		For example, consider the following sequence of user commands:
98
 *
99 100 101 102
 *		1)		begin
 *		2)		retrieve (foo.all)
 *		3)		append foo (bar = baz)
 *		4)		end
103
 *
104 105
 *		in the main processing loop, this results in the following
 *		transaction sequence:
106
 *
107 108 109 110
 *			/	StartTransactionCommand();
 *		1) /	ProcessUtility();				<< begin
 *		   \		StartTransactionBlock();
 *			\	CommitTransactionCommand();
111
 *
112 113 114
 *			/	StartTransactionCommand();
 *		2) <	ProcessQuery();					<< retrieve (foo.all)
 *			\	CommitTransactionCommand();
115
 *
116 117 118
 *			/	StartTransactionCommand();
 *		3) <	ProcessQuery();					<< append foo (bar = baz)
 *			\	CommitTransactionCommand();
119
 *
120 121 122 123
 *			/	StartTransactionCommand();
 *		4) /	ProcessUtility();				<< end
 *		   \		CommitTransactionBlock();
 *			\	CommitTransactionCommand();
124
 *
125 126 127 128 129 130
 *		The point of this example is to demonstrate the need for
 *		StartTransactionCommand() and CommitTransactionCommand() to
 *		be state smart -- they should do nothing in between the calls
 *		to StartTransactionBlock() and EndTransactionBlock() and
 *		outside these calls they need to do normal start/commit
 *		processing.
131
 *
132 133 134 135
 *		Furthermore, suppose the "retrieve (foo.all)" caused an abort
 *		condition.	We would then want to abort the transaction and
 *		ignore all subsequent commands up to the "end".
 *		-cim 3/23/90
136 137 138
 *
 *-------------------------------------------------------------------------
 */
M
-Wall'd  
Marc G. Fournier 已提交
139

140 141 142 143 144
/*
 * Large object clean up added in CommitTransaction() to prevent buffer leaks.
 * [PA, 7/17/98]
 * [PA] is Pascal André <andre@via.ecp.fr>
 */
145
#include "postgres.h"
M
-Wall'd  
Marc G. Fournier 已提交
146

147
#include "access/nbtree.h"
148 149 150
#include "catalog/heap.h"
#include "commands/async.h"
#include "commands/sequence.h"
151
#include "commands/vacuum.h"
152
#include "libpq/be-fsstubs.h"
B
Bruce Momjian 已提交
153
#include "storage/proc.h"
154
#include "utils/temprel.h"
B
Bruce Momjian 已提交
155 156 157
#include "utils/inval.h"
#include "utils/portal.h"
#include "utils/relcache.h"
158

159 160
extern bool	SharedBufferChanged;

161 162 163 164 165 166 167 168 169 170 171 172 173 174
static void AbortTransaction(void);
static void AtAbort_Cache(void);
static void AtAbort_Locks(void);
static void AtAbort_Memory(void);
static void AtCommit_Cache(void);
static void AtCommit_Locks(void);
static void AtCommit_Memory(void);
static void AtStart_Cache(void);
static void AtStart_Locks(void);
static void AtStart_Memory(void);
static void CommitTransaction(void);
static void RecordTransactionAbort(void);
static void RecordTransactionCommit(void);
static void StartTransaction(void);
175

176
/* ----------------
177
 *		global variables holding the current transaction state.
178
 *
179 180 181 182
 *		Note: when we are running several slave processes, the
 *			  current transaction state data is copied into shared memory
 *			  and the CurrentTransactionState pointer changed to
 *			  point to the shared copy.  All this occurrs in slaves.c
183 184 185
 * ----------------
 */
TransactionStateData CurrentTransactionStateData = {
186 187 188 189 190 191
	0,							/* transaction id */
	FirstCommandId,				/* command id */
	0x0,						/* start time */
	TRANS_DEFAULT,				/* transaction state */
	TBLOCK_DEFAULT				/* transaction block state */
};
192

193
TransactionState CurrentTransactionState = &CurrentTransactionStateData;
194

B
Bruce Momjian 已提交
195 196
int			DefaultXactIsoLevel = XACT_READ_COMMITTED;
int			XactIsoLevel;
V
Vadim B. Mikheev 已提交
197

198
/* ----------------
199
 *		info returned when the system is disabled
200 201 202 203
 *
 * Apparently a lot of this code is inherited from other prototype systems.
 * For DisabledStartTime, use a symbolic value to make the relationships clearer.
 * The old value of 1073741823 corresponds to a date in y2004, which is coming closer
204 205 206
 *	every day. It appears that if we return a value guaranteed larger than
 *	any real time associated with a transaction then comparisons in other
 *	modules will still be correct. Let's use BIG_ABSTIME for this. tgl 2/14/97
207
 *
208 209 210 211
 *		Note:  I have no idea what the significance of the
 *			   1073741823 in DisabledStartTime.. I just carried
 *			   this over when converting things from the old
 *			   V1 transaction system.  -cim 3/18/90
212 213
 * ----------------
 */
214
TransactionId DisabledTransactionId = (TransactionId) -1;
215

216
CommandId	DisabledCommandId = (CommandId) -1;
217

218
AbsoluteTime DisabledStartTime = (AbsoluteTime) BIG_ABSTIME;	/* 1073741823; */
219

220
/* ----------------
221
 *		overflow flag
222 223
 * ----------------
 */
224
bool		CommandIdCounterOverflowFlag;
225

226
/* ----------------
227 228 229
 *		catalog creation transaction bootstrapping flag.
 *		This should be eliminated and added to the transaction
 *		state stuff.  -cim 3/19/90
230 231
 * ----------------
 */
232
bool		AMI_OVERRIDE = false;
233

234
/* ----------------------------------------------------------------
235
 *					 transaction state accessors
236 237
 * ----------------------------------------------------------------
 */
238

239
/* --------------------------------
240 241
 *		TranactionFlushEnabled()
 *		SetTranactionFlushEnabled()
242
 *
243 244 245 246 247 248
 *		These are used to test and set the "TransactionFlushState"
 *		varable.  If this variable is true (the default), then
 *		the system will flush all dirty buffers to disk at the end
 *		of each transaction.   If false then we are assuming the
 *		buffer pool resides in stable main memory, in which case we
 *		only do writes as necessary.
249 250
 * --------------------------------
 */
251
static int	TransactionFlushState = 1;
252 253

int
254
TransactionFlushEnabled(void)
255 256
{
	return TransactionFlushState;
257 258
}

259
#ifdef NOT_USED
260 261
void
SetTransactionFlushEnabled(bool state)
262 263
{
	TransactionFlushState = (state == true);
264
}
265

266 267

/* --------------------------------
268
 *		IsTransactionState
269
 *
270 271
 *		This returns true if we are currently running a query
 *		within an executing transaction.
272 273 274
 * --------------------------------
 */
bool
275
IsTransactionState(void)
276
{
277 278 279 280
	TransactionState s = CurrentTransactionState;

	switch (s->state)
	{
281 282 283 284 285 286 287 288 289 290 291 292
		case TRANS_DEFAULT:
			return false;
		case TRANS_START:
			return true;
		case TRANS_INPROGRESS:
			return true;
		case TRANS_COMMIT:
			return true;
		case TRANS_ABORT:
			return true;
		case TRANS_DISABLED:
			return false;
293 294 295 296 297
	}

	/*
	 * Shouldn't get here, but lint is not happy with this...
	 */
298
	return false;
299
}
B
Bruce Momjian 已提交
300

301
#endif
302 303

/* --------------------------------
304
 *		IsAbortedTransactionBlockState
305
 *
306 307
 *		This returns true if we are currently running a query
 *		within an aborted transaction block.
308 309 310 311 312
 * --------------------------------
 */
bool
IsAbortedTransactionBlockState()
{
313 314 315 316 317 318
	TransactionState s = CurrentTransactionState;

	if (s->blockState == TBLOCK_ABORT)
		return true;

	return false;
319 320 321
}

/* --------------------------------
322
 *		OverrideTransactionSystem
323
 *
324 325 326 327
 *		This is used to temporarily disable the transaction
 *		processing system in order to do initialization of
 *		the transaction system data structures and relations
 *		themselves.
328 329
 * --------------------------------
 */
330
int			SavedTransactionState;
331 332 333 334

void
OverrideTransactionSystem(bool flag)
{
335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351
	TransactionState s = CurrentTransactionState;

	if (flag == true)
	{
		if (s->state == TRANS_DISABLED)
			return;

		SavedTransactionState = s->state;
		s->state = TRANS_DISABLED;
	}
	else
	{
		if (s->state != TRANS_DISABLED)
			return;

		s->state = SavedTransactionState;
	}
352 353 354
}

/* --------------------------------
355
 *		GetCurrentTransactionId
356
 *
357 358
 *		This returns the id of the current transaction, or
 *		the id of the "disabled" transaction.
359 360 361 362 363
 * --------------------------------
 */
TransactionId
GetCurrentTransactionId()
{
364 365 366 367 368 369 370 371 372 373 374 375 376 377 378
	TransactionState s = CurrentTransactionState;

	/* ----------------
	 *	if the transaction system is disabled, we return
	 *	the special "disabled" transaction id.
	 * ----------------
	 */
	if (s->state == TRANS_DISABLED)
		return (TransactionId) DisabledTransactionId;

	/* ----------------
	 *	otherwise return the current transaction id.
	 * ----------------
	 */
	return (TransactionId) s->transactionIdData;
379 380 381 382
}


/* --------------------------------
383
 *		GetCurrentCommandId
384 385 386 387 388
 * --------------------------------
 */
CommandId
GetCurrentCommandId()
{
389 390 391 392 393 394 395 396 397 398 399
	TransactionState s = CurrentTransactionState;

	/* ----------------
	 *	if the transaction system is disabled, we return
	 *	the special "disabled" command id.
	 * ----------------
	 */
	if (s->state == TRANS_DISABLED)
		return (CommandId) DisabledCommandId;

	return s->commandId;
400 401
}

402 403 404
CommandId
GetScanCommandId()
{
405 406 407 408 409 410 411 412 413 414 415
	TransactionState s = CurrentTransactionState;

	/* ----------------
	 *	if the transaction system is disabled, we return
	 *	the special "disabled" command id.
	 * ----------------
	 */
	if (s->state == TRANS_DISABLED)
		return (CommandId) DisabledCommandId;

	return s->scanCommandId;
416 417
}

418 419

/* --------------------------------
420
 *		GetCurrentTransactionStartTime
421 422 423 424 425
 * --------------------------------
 */
AbsoluteTime
GetCurrentTransactionStartTime()
{
426 427 428 429 430 431 432 433 434 435 436
	TransactionState s = CurrentTransactionState;

	/* ----------------
	 *	if the transaction system is disabled, we return
	 *	the special "disabled" starting time.
	 * ----------------
	 */
	if (s->state == TRANS_DISABLED)
		return (AbsoluteTime) DisabledStartTime;

	return s->startTime;
437 438 439 440
}


/* --------------------------------
441
 *		TransactionIdIsCurrentTransactionId
442 443 444 445 446
 * --------------------------------
 */
bool
TransactionIdIsCurrentTransactionId(TransactionId xid)
{
447 448 449 450 451 452 453
	TransactionState s = CurrentTransactionState;

	if (AMI_OVERRIDE)
		return false;

	return (bool)
		TransactionIdEquals(xid, s->transactionIdData);
454 455 456 457
}


/* --------------------------------
458
 *		CommandIdIsCurrentCommandId
459 460 461 462 463
 * --------------------------------
 */
bool
CommandIdIsCurrentCommandId(CommandId cid)
{
464 465 466 467 468
	TransactionState s = CurrentTransactionState;

	if (AMI_OVERRIDE)
		return false;

469
	return (cid == s->commandId) ? true : false;
470 471
}

472 473 474
bool
CommandIdGEScanCommandId(CommandId cid)
{
475 476 477 478 479
	TransactionState s = CurrentTransactionState;

	if (AMI_OVERRIDE)
		return false;

480
	return (cid >= s->scanCommandId) ? true : false;
481 482
}

483 484

/* --------------------------------
485
 *		ClearCommandIdCounterOverflowFlag
486 487
 * --------------------------------
 */
488
#ifdef NOT_USED
489 490 491
void
ClearCommandIdCounterOverflowFlag()
{
492
	CommandIdCounterOverflowFlag = false;
493
}
494

495
#endif
496 497

/* --------------------------------
498
 *		CommandCounterIncrement
499 500 501 502 503
 * --------------------------------
 */
void
CommandCounterIncrement()
{
504 505 506 507
	CurrentTransactionStateData.commandId += 1;
	if (CurrentTransactionStateData.commandId == FirstCommandId)
	{
		CommandIdCounterOverflowFlag = true;
508
		elog(ERROR, "You may only have 2^32-1 commands per transaction");
509 510
	}

511
	CurrentTransactionStateData.scanCommandId = CurrentTransactionStateData.commandId;
512 513 514 515

	/* make cache changes visible to me */
	AtCommit_Cache();
	AtStart_Cache();
V
Vadim B. Mikheev 已提交
516

517 518
}

519 520
void
SetScanCommandId(CommandId savedId)
521 522
{

523 524
	CurrentTransactionStateData.scanCommandId = savedId;

525 526
}

527
/* ----------------------------------------------------------------
528
 *						initialization stuff
529 530 531 532 533
 * ----------------------------------------------------------------
 */
void
InitializeTransactionSystem()
{
534
	InitializeTransactionLog();
535 536 537
}

/* ----------------------------------------------------------------
538
 *						StartTransaction stuff
539 540 541 542
 * ----------------------------------------------------------------
 */

/* --------------------------------
543
 *		AtStart_Cache
544 545
 * --------------------------------
 */
546
static void
547
AtStart_Cache()
548
{
549
	DiscardInvalid();
550 551 552
}

/* --------------------------------
553
 *		AtStart_Locks
554 555
 * --------------------------------
 */
556
static void
557
AtStart_Locks()
558
{
559 560 561 562 563 564 565

	/*
	 * at present, it is unknown to me what belongs here -cim 3/18/90
	 *
	 * There isn't anything to do at the start of a xact for locks. -mer
	 * 5/24/92
	 */
566 567 568
}

/* --------------------------------
569
 *		AtStart_Memory
570 571
 * --------------------------------
 */
572
static void
573
AtStart_Memory()
574
{
575 576
	Portal		portal;
	MemoryContext portalContext;
577 578 579 580 581 582 583 584 585 586 587 588 589 590

	/* ----------------
	 *	get the blank portal and its memory context
	 * ----------------
	 */
	portal = GetPortalByName(NULL);
	portalContext = (MemoryContext) PortalGetHeapMemory(portal);

	/* ----------------
	 *	tell system to allocate in the blank portal context
	 * ----------------
	 */
	MemoryContextSwitchTo(portalContext);
	StartPortalAllocMode(DefaultAllocMode, 0);
591 592 593 594
}


/* ----------------------------------------------------------------
595
 *						CommitTransaction stuff
596 597 598 599
 * ----------------------------------------------------------------
 */

/* --------------------------------
600
 *		RecordTransactionCommit
601
 *
602 603 604 605 606
 *		Note: the two calls to BufferManagerFlush() exist to ensure
 *			  that data pages are written before log pages.  These
 *			  explicit calls should be replaced by a more efficient
 *			  ordered page write scheme in the buffer manager
 *			  -cim 3/18/90
607 608
 * --------------------------------
 */
609
static void
610
RecordTransactionCommit()
611
{
612 613
	TransactionId xid;
	int			leak;
614 615 616 617 618 619 620

	/* ----------------
	 *	get the current transaction id
	 * ----------------
	 */
	xid = GetCurrentTransactionId();

621
	/* 
622 623 624 625 626 627
	 *	flush the buffer manager pages.  Note: if we have stable
	 *	main memory, dirty shared buffers are not flushed
	 *	plai 8/7/90
	 */
	leak = BufferPoolCheckLeak();

628 629 630
	/*
	 * If no one shared buffer was changed by this transaction then
	 * we don't flush shared buffers and don't record commit status.
631
	 */
632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649
	if (SharedBufferChanged)
	{
		FlushBufferPool(!TransactionFlushEnabled());
		if (leak)
			ResetBufferPool();

		/*
		 *	have the transaction access methods record the status
		 *	of this transaction id in the pg_log relation.
		 */
		TransactionIdCommit(xid);

		/*
		 *	Now write the log info to the disk too.
		 */
		leak = BufferPoolCheckLeak();
		FlushBufferPool(!TransactionFlushEnabled());
	}
650 651 652

	if (leak)
		ResetBufferPool();
653 654 655 656
}


/* --------------------------------
657
 *		AtCommit_Cache
658 659
 * --------------------------------
 */
660
static void
661 662
AtCommit_Cache()
{
663 664 665 666 667 668 669 670
	/* ----------------
	 * Make catalog changes visible to me for the next command.
	 * Other backends will not process my invalidation messages until
	 * after I commit and free my locks--though they will do
	 * unnecessary work if I abort.
	 * ----------------
	 */
	RegisterInvalid(true);
671 672 673
}

/* --------------------------------
674
 *		AtCommit_Locks
675 676
 * --------------------------------
 */
677
static void
678
AtCommit_Locks()
679
{
680 681 682 683 684 685 686
	/* ----------------
	 *	XXX What if ProcReleaseLocks fails?  (race condition?)
	 *
	 *	Then you're up a creek! -mer 5/24/92
	 * ----------------
	 */
	ProcReleaseLocks();
687 688 689
}

/* --------------------------------
690
 *		AtCommit_Memory
691 692
 * --------------------------------
 */
693
static void
694
AtCommit_Memory()
695
{
696 697 698
	Portal		portal;
	MemoryContext portalContext;

699
	/* ----------------
700
	 *	Release memory in the blank portal.
B
Bruce Momjian 已提交
701 702 703
	 *	Since EndPortalAllocMode implicitly works on the current context,
	 *	first make real sure that the blank portal is the selected context.
	 *	(This is probably not necessary, but seems like a good idea...)
704 705 706 707 708 709 710 711 712
	 * ----------------
	 */
	portal = GetPortalByName(NULL);
	portalContext = (MemoryContext) PortalGetHeapMemory(portal);
	MemoryContextSwitchTo(portalContext);
	EndPortalAllocMode();

	/* ----------------
	 *	Now that we're "out" of a transaction, have the
713 714 715 716 717
	 *	system allocate things in the top memory context instead
	 *	of the blank portal memory context.
	 * ----------------
	 */
	MemoryContextSwitchTo(TopMemoryContext);
718 719 720
}

/* ----------------------------------------------------------------
721
 *						AbortTransaction stuff
722 723 724 725
 * ----------------------------------------------------------------
 */

/* --------------------------------
726
 *		RecordTransactionAbort
727 728
 * --------------------------------
 */
729
static void
730
RecordTransactionAbort()
731
{
732
	TransactionId xid;
733 734 735 736 737 738 739

	/* ----------------
	 *	get the current transaction id
	 * ----------------
	 */
	xid = GetCurrentTransactionId();

740 741 742 743
	/* 
	 * Have the transaction access methods record the status of
	 * this transaction id in the pg_log relation. We skip it
	 * if no one shared buffer was changed by this transaction.
744
	 */
745 746
	if (SharedBufferChanged)
		TransactionIdAbort(xid);
747 748

	ResetBufferPool();
749 750 751
}

/* --------------------------------
752
 *		AtAbort_Cache
753 754
 * --------------------------------
 */
755
static void
756
AtAbort_Cache()
757
{
758
	RegisterInvalid(false);
759
	RelationCacheAbort();
760 761 762
}

/* --------------------------------
763
 *		AtAbort_Locks
764 765
 * --------------------------------
 */
766
static void
767
AtAbort_Locks()
768
{
769 770 771 772 773 774 775
	/* ----------------
	 *	XXX What if ProcReleaseLocks() fails?  (race condition?)
	 *
	 *	Then you're up a creek without a paddle! -mer
	 * ----------------
	 */
	ProcReleaseLocks();
776 777 778 779
}


/* --------------------------------
780
 *		AtAbort_Memory
781 782
 * --------------------------------
 */
783
static void
784
AtAbort_Memory()
785
{
786 787 788 789 790
	Portal		portal;
	MemoryContext portalContext;

	/* ----------------
	 *	Release memory in the blank portal.
B
Bruce Momjian 已提交
791 792 793
	 *	Since EndPortalAllocMode implicitly works on the current context,
	 *	first make real sure that the blank portal is the selected context.
	 *	(This is ESSENTIAL in case we aborted from someplace where it wasn't.)
794 795 796 797 798 799 800
	 * ----------------
	 */
	portal = GetPortalByName(NULL);
	portalContext = (MemoryContext) PortalGetHeapMemory(portal);
	MemoryContextSwitchTo(portalContext);
	EndPortalAllocMode();

801
	/* ----------------
802 803 804
	 *	Now that we're "out" of a transaction, have the
	 *	system allocate things in the top memory context instead
	 *	of the blank portal memory context.
805 806 807
	 * ----------------
	 */
	MemoryContextSwitchTo(TopMemoryContext);
808 809 810
}

/* ----------------------------------------------------------------
811
 *						interface routines
812 813 814 815
 * ----------------------------------------------------------------
 */

/* --------------------------------
816
 *		StartTransaction
817 818 819
 *
 * --------------------------------
 */
820
static void
821 822
StartTransaction()
{
823 824
	TransactionState s = CurrentTransactionState;

V
Vadim B. Mikheev 已提交
825
	FreeXactSnapshot();
826
	XactIsoLevel = DefaultXactIsoLevel;
V
Vadim B. Mikheev 已提交
827

828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852
	/* ----------------
	 *	Check the current transaction state.  If the transaction system
	 *	is switched off, or if we're already in a transaction, do nothing.
	 *	We're already in a transaction when the monitor sends a null
	 *	command to the backend to flush the comm channel.  This is a
	 *	hacky fix to a communications problem, and we keep having to
	 *	deal with it here.	We should fix the comm channel code.  mao 080891
	 * ----------------
	 */
	if (s->state == TRANS_DISABLED || s->state == TRANS_INPROGRESS)
		return;

	/* ----------------
	 *	set the current transaction state information
	 *	appropriately during start processing
	 * ----------------
	 */
	s->state = TRANS_START;

	/* ----------------
	 *	generate a new transaction id
	 * ----------------
	 */
	GetNewTransactionId(&(s->transactionIdData));

V
Vadim B. Mikheev 已提交
853 854
	XactLockTableInsert(s->transactionIdData);

855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876
	/* ----------------
	 *	initialize current transaction state fields
	 * ----------------
	 */
	s->commandId = FirstCommandId;
	s->scanCommandId = FirstCommandId;
	s->startTime = GetCurrentAbsoluteTime();

	/* ----------------
	 *	initialize the various transaction subsystems
	 * ----------------
	 */
	AtStart_Cache();
	AtStart_Locks();
	AtStart_Memory();

	/* --------------
	   initialize temporary relations list
	   the tempRelList is a list of temporary relations that
	   are created in the course of the transactions
	   they need to be destroyed properly at the end of the transactions
	 */
877
	InitNoNameRelList();
878 879 880 881 882 883 884 885

	/* ----------------
	 *	done with start processing, set current transaction
	 *	state to "in progress"
	 * ----------------
	 */
	s->state = TRANS_INPROGRESS;

886 887 888 889 890 891 892 893 894
}

/* ---------------
 * Tell me if we are currently in progress
 * ---------------
 */
bool
CurrentXactInProgress()
{
895
	return CurrentTransactionState->state == TRANS_INPROGRESS;
896 897 898
}

/* --------------------------------
899
 *		CommitTransaction
900 901 902
 *
 * --------------------------------
 */
903
static void
904 905
CommitTransaction()
{
906
	TransactionState s = CurrentTransactionState;
907 908

	/* ----------------
909
	 *	check the current transaction state
910 911
	 * ----------------
	 */
912 913 914 915 916 917
	if (s->state == TRANS_DISABLED)
		return;

	if (s->state != TRANS_INPROGRESS)
		elog(NOTICE, "CommitTransaction and not in in-progress state ");

918
	/* ----------------
919 920
	 *	set the current transaction state information
	 *	appropriately during the abort processing
921 922
	 * ----------------
	 */
923 924
	s->state = TRANS_COMMIT;

925
	/* ----------------
926
	 *	do commit processing
927 928
	 * ----------------
	 */
929

930
	/* handle commit for large objects [ PA, 7/17/98 ] */
931
	lo_commit(true);
932

933 934 935
	/* NOTIFY commit must also come before lower-level cleanup */
	AtCommit_Notify();

936
	CloseSequences();
937
	DestroyNoNameRels();
938 939
	AtEOXact_portals();
	RecordTransactionCommit();
940 941 942 943

	/*
	 * Let others know about no transaction in progress by me.
	 * Note that this must be done _before_ releasing locks we hold 
944
	 * and SpinAcquire(ShmemIndexLock) is required: UPDATE with xid 0 is 
945 946
	 * blocked by xid 1' UPDATE, xid 1 is doing commit while xid 2 
	 * gets snapshot - if xid 2' GetSnapshotData sees xid 1 as running
947 948
	 * then it must see xid 0 as running as well or it will see two
	 * tuple versions - one deleted by xid 1 and one inserted by xid 0.
949 950 951 952 953 954 955 956 957
	 */
	if (MyProc != (PROC *) NULL)
	{
		SpinAcquire(ShmemIndexLock);
		MyProc->xid = InvalidTransactionId;
		MyProc->xmin = InvalidTransactionId;
		SpinRelease(ShmemIndexLock);
	}

958
	RelationPurgeLocalRelation(true);
959
	AtEOXact_nbtree();
960 961 962
	AtCommit_Cache();
	AtCommit_Locks();
	AtCommit_Memory();
963
	AtEOXact_Files();
964

965
	/* ----------------
966 967
	 *	done with commit processing, set current transaction
	 *	state back to default
968 969
	 * ----------------
	 */
970
	s->state = TRANS_DEFAULT;
971
	SharedBufferChanged = false;	/* safest place to do it */
972

973
}
974

975
/* --------------------------------
976 977
 *		AbortTransaction
 *
978 979
 * --------------------------------
 */
980 981
static void
AbortTransaction()
982
{
983 984 985 986 987
	TransactionState s = CurrentTransactionState;

	/*
	 * Let others to know about no transaction in progress - vadim
	 * 11/26/96
988
	 */
989
	if (MyProc != (PROC *) NULL)
990
	{
991
		MyProc->xid = InvalidTransactionId;
992 993
		MyProc->xmin = InvalidTransactionId;
	}
994

995
	/* ----------------
996
	 *	check the current transaction state
997 998
	 * ----------------
	 */
999 1000 1001 1002 1003 1004
	if (s->state == TRANS_DISABLED)
		return;

	if (s->state != TRANS_INPROGRESS)
		elog(NOTICE, "AbortTransaction and not in in-progress state ");

1005
	/* ----------------
1006 1007
	 *	set the current transaction state information
	 *	appropriately during the abort processing
1008 1009
	 * ----------------
	 */
1010 1011
	s->state = TRANS_ABORT;

1012
	/* ----------------
1013
	 *	do abort processing
1014 1015
	 * ----------------
	 */
1016
	lo_commit(false);			/* 'false' means it's abort */
V
Vadim B. Mikheev 已提交
1017
	UnlockBuffers();
1018
	AtAbort_Notify();
1019 1020
	CloseSequences();
	AtEOXact_portals();
1021 1022
	if (VacuumRunning)
		vc_abort();
1023 1024
	RecordTransactionAbort();
	RelationPurgeLocalRelation(false);
1025
	DestroyNoNameRels();
1026
	invalidate_temp_relations();
1027
	AtEOXact_nbtree();
1028 1029 1030
	AtAbort_Cache();
	AtAbort_Locks();
	AtAbort_Memory();
1031
	AtEOXact_Files();
1032

1033
	/* ----------------
1034 1035
	 *	done with abort processing, set current transaction
	 *	state back to default
1036 1037
	 * ----------------
	 */
1038
	s->state = TRANS_DEFAULT;
1039
	SharedBufferChanged = false;	/* safest place to do it */
1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052
}

/* --------------------------------
 *		StartTransactionCommand
 * --------------------------------
 */
void
StartTransactionCommand()
{
	TransactionState s = CurrentTransactionState;

	switch (s->blockState)
	{
1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084
			/* ----------------
			 *		if we aren't in a transaction block, we
			 *		just do our usual start transaction.
			 * ----------------
			 */
		case TBLOCK_DEFAULT:
			StartTransaction();
			break;

			/* ----------------
			 *		We should never experience this -- if we do it
			 *		means the BEGIN state was not changed in the previous
			 *		CommitTransactionCommand().  If we get it, we print
			 *		a warning and change to the in-progress state.
			 * ----------------
			 */
		case TBLOCK_BEGIN:
			elog(NOTICE, "StartTransactionCommand: unexpected TBLOCK_BEGIN");
			s->blockState = TBLOCK_INPROGRESS;
			break;

			/* ----------------
			 *		This is the case when are somewhere in a transaction
			 *		block and about to start a new command.  For now we
			 *		do nothing but someday we may do command-local resource
			 *		initialization.
			 * ----------------
			 */
		case TBLOCK_INPROGRESS:
			break;

			/* ----------------
B
Bruce Momjian 已提交
1085
			 *		As with BEGIN, we should never experience this
1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119
			 *		if we do it means the END state was not changed in the
			 *		previous CommitTransactionCommand().  If we get it, we
			 *		print a warning, commit the transaction, start a new
			 *		transaction and change to the default state.
			 * ----------------
			 */
		case TBLOCK_END:
			elog(NOTICE, "StartTransactionCommand: unexpected TBLOCK_END");
			s->blockState = TBLOCK_DEFAULT;
			CommitTransaction();
			StartTransaction();
			break;

			/* ----------------
			 *		Here we are in the middle of a transaction block but
			 *		one of the commands caused an abort so we do nothing
			 *		but remain in the abort state.	Eventually we will get
			 *		to the "END TRANSACTION" which will set things straight.
			 * ----------------
			 */
		case TBLOCK_ABORT:
			break;

			/* ----------------
			 *		This means we somehow aborted and the last call to
			 *		CommitTransactionCommand() didn't clear the state so
			 *		we remain in the ENDABORT state and mabey next time
			 *		we get to CommitTransactionCommand() the state will
			 *		get reset to default.
			 * ----------------
			 */
		case TBLOCK_ENDABORT:
			elog(NOTICE, "StartTransactionCommand: unexpected TBLOCK_ENDABORT");
			break;
1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133
	}
}

/* --------------------------------
 *		CommitTransactionCommand
 * --------------------------------
 */
void
CommitTransactionCommand()
{
	TransactionState s = CurrentTransactionState;

	switch (s->blockState)
	{
1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166
			/* ----------------
			 *		if we aren't in a transaction block, we
			 *		just do our usual transaction commit
			 * ----------------
			 */
		case TBLOCK_DEFAULT:
			CommitTransaction();
			break;

			/* ----------------
			 *		This is the case right after we get a "BEGIN TRANSACTION"
			 *		command, but the user hasn't done anything else yet, so
			 *		we change to the "transaction block in progress" state
			 *		and return.
			 * ----------------
			 */
		case TBLOCK_BEGIN:
			s->blockState = TBLOCK_INPROGRESS;
			break;

			/* ----------------
			 *		This is the case when we have finished executing a command
			 *		someplace within a transaction block.  We increment the
			 *		command counter and return.  Someday we may free resources
			 *		local to the command.
			 *
			 *		That someday is today, at least for memory allocated by
			 *		command in the BlankPortal' HeapMemory context.
			 *				- vadim 03/25/97
			 * ----------------
			 */
		case TBLOCK_INPROGRESS:
			CommandCounterIncrement();
1167
#ifdef TBL_FREE_CMD_MEMORY
1168 1169
			EndPortalAllocMode();
			StartPortalAllocMode(DefaultAllocMode, 0);
1170
#endif
1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202
			break;

			/* ----------------
			 *		This is the case when we just got the "END TRANSACTION"
			 *		statement, so we go back to the default state and
			 *		commit the transaction.
			 * ----------------
			 */
		case TBLOCK_END:
			s->blockState = TBLOCK_DEFAULT;
			CommitTransaction();
			break;

			/* ----------------
			 *		Here we are in the middle of a transaction block but
			 *		one of the commands caused an abort so we do nothing
			 *		but remain in the abort state.	Eventually we will get
			 *		to the "END TRANSACTION" which will set things straight.
			 * ----------------
			 */
		case TBLOCK_ABORT:
			break;

			/* ----------------
			 *		Here we were in an aborted transaction block which
			 *		just processed the "END TRANSACTION" command from the
			 *		user, so now we return the to default state.
			 * ----------------
			 */
		case TBLOCK_ENDABORT:
			s->blockState = TBLOCK_DEFAULT;
			break;
1203
	}
1204 1205 1206
}

/* --------------------------------
1207
 *		AbortCurrentTransaction
1208 1209 1210 1211 1212
 * --------------------------------
 */
void
AbortCurrentTransaction()
{
1213 1214 1215 1216
	TransactionState s = CurrentTransactionState;

	switch (s->blockState)
	{
1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281
			/* ----------------
			 *		if we aren't in a transaction block, we
			 *		just do our usual abort transaction.
			 * ----------------
			 */
		case TBLOCK_DEFAULT:
			AbortTransaction();
			break;

			/* ----------------
			 *		If we are in the TBLOCK_BEGIN it means something
			 *		screwed up right after reading "BEGIN TRANSACTION"
			 *		so we enter the abort state.  Eventually an "END
			 *		TRANSACTION" will fix things.
			 * ----------------
			 */
		case TBLOCK_BEGIN:
			s->blockState = TBLOCK_ABORT;
			AbortTransaction();
			break;

			/* ----------------
			 *		This is the case when are somewhere in a transaction
			 *		block which aborted so we abort the transaction and
			 *		set the ABORT state.  Eventually an "END TRANSACTION"
			 *		will fix things and restore us to a normal state.
			 * ----------------
			 */
		case TBLOCK_INPROGRESS:
			s->blockState = TBLOCK_ABORT;
			AbortTransaction();
			break;

			/* ----------------
			 *		Here, the system was fouled up just after the
			 *		user wanted to end the transaction block so we
			 *		abort the transaction and put us back into the
			 *		default state.
			 * ----------------
			 */
		case TBLOCK_END:
			s->blockState = TBLOCK_DEFAULT;
			AbortTransaction();
			break;

			/* ----------------
			 *		Here, we are already in an aborted transaction
			 *		state and are waiting for an "END TRANSACTION" to
			 *		come along and lo and behold, we abort again!
			 *		So we just remain in the abort state.
			 * ----------------
			 */
		case TBLOCK_ABORT:
			break;

			/* ----------------
			 *		Here we were in an aborted transaction block which
			 *		just processed the "END TRANSACTION" command but somehow
			 *		aborted again.. since we must have done the abort
			 *		processing, we return to the default state.
			 * ----------------
			 */
		case TBLOCK_ENDABORT:
			s->blockState = TBLOCK_DEFAULT;
			break;
1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297
	}
}

/* ----------------------------------------------------------------
 *					   transaction block support
 * ----------------------------------------------------------------
 */
/* --------------------------------
 *		BeginTransactionBlock
 * --------------------------------
 */
void
BeginTransactionBlock(void)
{
	TransactionState s = CurrentTransactionState;

1298
	/* ----------------
1299
	 *	check the current transaction state
1300 1301
	 * ----------------
	 */
1302 1303 1304 1305 1306 1307
	if (s->state == TRANS_DISABLED)
		return;

	if (s->blockState != TBLOCK_DEFAULT)
		elog(NOTICE, "BeginTransactionBlock and not in default state ");

1308
	/* ----------------
1309 1310
	 *	set the current transaction block state information
	 *	appropriately during begin processing
1311 1312
	 * ----------------
	 */
1313 1314
	s->blockState = TBLOCK_BEGIN;

1315
	/* ----------------
1316
	 *	do begin processing
1317 1318
	 * ----------------
	 */
1319

1320
	/* ----------------
1321
	 *	done with begin processing, set block state to inprogress
1322 1323
	 * ----------------
	 */
1324
	s->blockState = TBLOCK_INPROGRESS;
1325 1326 1327
}

/* --------------------------------
1328
 *		EndTransactionBlock
1329 1330 1331
 * --------------------------------
 */
void
1332
EndTransactionBlock(void)
1333
{
1334 1335
	TransactionState s = CurrentTransactionState;

1336
	/* ----------------
1337
	 *	check the current transaction state
1338 1339
	 * ----------------
	 */
1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371
	if (s->state == TRANS_DISABLED)
		return;

	if (s->blockState == TBLOCK_INPROGRESS)
	{
		/* ----------------
		 *	here we are in a transaction block which should commit
		 *	when we get to the upcoming CommitTransactionCommand()
		 *	so we set the state to "END".  CommitTransactionCommand()
		 *	will recognize this and commit the transaction and return
		 *	us to the default state
		 * ----------------
		 */
		s->blockState = TBLOCK_END;
		return;
	}

	if (s->blockState == TBLOCK_ABORT)
	{
		/* ----------------
		 *	here, we are in a transaction block which aborted
		 *	and since the AbortTransaction() was already done,
		 *	we do whatever is needed and change to the special
		 *	"END ABORT" state.	The upcoming CommitTransactionCommand()
		 *	will recognise this and then put us back in the default
		 *	state.
		 * ----------------
		 */
		s->blockState = TBLOCK_ENDABORT;
		return;
	}

1372
	/* ----------------
1373 1374 1375 1376
	 *	We should not get here, but if we do, we go to the ENDABORT
	 *	state after printing a warning.  The upcoming call to
	 *	CommitTransactionCommand() will then put us back into the
	 *	default state.
1377 1378
	 * ----------------
	 */
1379
	elog(NOTICE, "EndTransactionBlock and not inprogress/abort state ");
1380 1381 1382 1383
	s->blockState = TBLOCK_ENDABORT;
}

/* --------------------------------
1384
 *		AbortTransactionBlock
1385 1386
 * --------------------------------
 */
1387 1388
#ifdef NOT_USED
static void
1389
AbortTransactionBlock(void)
1390
{
1391 1392
	TransactionState s = CurrentTransactionState;

1393
	/* ----------------
1394
	 *	check the current transaction state
1395 1396
	 * ----------------
	 */
1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419
	if (s->state == TRANS_DISABLED)
		return;

	if (s->blockState == TBLOCK_INPROGRESS)
	{
		/* ----------------
		 *	here we were inside a transaction block something
		 *	screwed up inside the system so we enter the abort state,
		 *	do the abort processing and then return.
		 *	We remain in the abort state until we see the upcoming
		 *	END TRANSACTION command.
		 * ----------------
		 */
		s->blockState = TBLOCK_ABORT;

		/* ----------------
		 *	do abort processing and return
		 * ----------------
		 */
		AbortTransaction();
		return;
	}

1420
	/* ----------------
1421 1422 1423 1424 1425
	 *	this case should not be possible, because it would mean
	 *	the user entered an "abort" from outside a transaction block.
	 *	So we print an error message, abort the transaction and
	 *	enter the "ENDABORT" state so we will end up in the default
	 *	state after the upcoming CommitTransactionCommand().
1426 1427
	 * ----------------
	 */
1428
	elog(NOTICE, "AbortTransactionBlock and not in in-progress state");
1429
	AbortTransaction();
1430
	s->blockState = TBLOCK_ENDABORT;
1431
}
1432

1433
#endif
1434 1435

/* --------------------------------
1436
 *		UserAbortTransactionBlock
1437 1438 1439 1440 1441
 * --------------------------------
 */
void
UserAbortTransactionBlock()
{
1442 1443
	TransactionState s = CurrentTransactionState;

1444
	/* ----------------
1445
	 *	check the current transaction state
1446 1447
	 * ----------------
	 */
1448 1449 1450 1451 1452 1453 1454
	if (s->state == TRANS_DISABLED)
		return;

	/*
	 * if the transaction has already been automatically aborted with an
	 * error, and the user subsequently types 'abort', allow it.  (the
	 * behavior is the same as if they had typed 'end'.)
1455
	 */
1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488
	if (s->blockState == TBLOCK_ABORT)
	{
		s->blockState = TBLOCK_ENDABORT;
		return;
	}

	if (s->blockState == TBLOCK_INPROGRESS)
	{
		/* ----------------
		 *	here we were inside a transaction block and we
		 *	got an abort command from the user, so we move to
		 *	the abort state, do the abort processing and
		 *	then change to the ENDABORT state so we will end up
		 *	in the default state after the upcoming
		 *	CommitTransactionCommand().
		 * ----------------
		 */
		s->blockState = TBLOCK_ABORT;

		/* ----------------
		 *	do abort processing
		 * ----------------
		 */
		AbortTransaction();

		/* ----------------
		 *	change to the end abort state and return
		 * ----------------
		 */
		s->blockState = TBLOCK_ENDABORT;
		return;
	}

1489
	/* ----------------
1490 1491 1492 1493 1494
	 *	this case should not be possible, because it would mean
	 *	the user entered an "abort" from outside a transaction block.
	 *	So we print an error message, abort the transaction and
	 *	enter the "ENDABORT" state so we will end up in the default
	 *	state after the upcoming CommitTransactionCommand().
1495 1496
	 * ----------------
	 */
1497 1498
	elog(NOTICE, "UserAbortTransactionBlock and not in in-progress state");
	AbortTransaction();
1499 1500 1501
	s->blockState = TBLOCK_ENDABORT;
}

1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519
/* --------------------------------
 *		AbortOutOfAnyTransaction
 *
 * This routine is provided for error recovery purposes.  It aborts any
 * active transaction or transaction block, leaving the system in a known
 * idle state.
 * --------------------------------
 */
void
AbortOutOfAnyTransaction()
{
	TransactionState s = CurrentTransactionState;

	/*
	 * Get out of any low-level transaction
	 */
	if (s->state != TRANS_DEFAULT)
		AbortTransaction();
B
Bruce Momjian 已提交
1520

1521 1522 1523 1524 1525 1526
	/*
	 * Now reset the high-level state
	 */
	s->blockState = TBLOCK_DEFAULT;
}

1527 1528 1529
bool
IsTransactionBlock()
{
1530 1531 1532 1533
	TransactionState s = CurrentTransactionState;

	if (s->blockState == TBLOCK_INPROGRESS
		|| s->blockState == TBLOCK_ENDABORT)
1534
		return true;
1535

1536
	return false;
1537
}