| Joel Stevenson 2005-11-09, 8:24 pm |
| At 3:24 PM -0500 11/9/05, Tom Lane wrote:
>Joel Stevenson <joelstevenson@mac.com> writes:
>
>OK, now that that's straightened out, there are some more things to
>look at in the core file. Please try these gdb commands:
>
> p *MyProc
> p *SerializableSnapsho
t
> p *CurrentTransactionS
tate
>
> regards, tom lane
Ok, here are the results:
(gdb) p *MyProc
$1 = {links = {prev = 4294967295, next = 4294967295}, sem = {semId = 8880136,
semNum = 10}, waitStatus = 0, xid = 0, xmin = 0, pid = 20633,
databaseId = 16385, roleId = 16384, lwWaiting = 0 '\0', lwExclusive
= 1 '\001',
lwWaitLink = 0x0, waitLock = 0x0, waitProcLock = 0x0, waitLockMode = 0,
heldLocks = 0, procLocks = {prev = 34618656, next = 34618656}, subxids = {
overflowed = 0 '\0', nxids = 0, xids = {0 <repeats 64 times>}}}
(gdb) p *SerializableSnapsho
t
$2 = {xmin = 1068152, xmax = 1068155, xcnt = 2, xip = 0x9b142b8, curcid = 0}
(gdb) p *CurrentTransactionS
tate
$3 = {transactionId = 1068154, subTransactionId = 1, name = 0x0,
savepointLevel = 0,
state = TRANS_ABORT, blockState = TBLOCK_ABORT, nestingLevel = 1,
curTransactionContex
t = 0x9b06a9c, curTransactionOwner = 0x9ab0294,
childXids = 0x0, currentUser = 0, prevXactReadOnly = 0 '\0', parent = 0x0}
-Joel
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
|