Re: crash while decoding INSERT ON CONFLICT

2018-05-21 17:15 GMT-03:00 Peter Geoghegan <pg(at)bowt(dot)ie>:
> Can I get this as a "bt full", in case any of the local variables turn
> out to be interesting?
>
(gdb) bt full
#0 ReorderBufferCommit (rb=0xde14c8, xid=<value optimized out>,
commit_lsn=6211559254952, end_lsn=<value optimized out>,
commit_time=<value optimized out>, origin_id=<value optimized out>,
origin_lsn=0) at reorderbuffer.c:1397
relation = 0x0
reloid = <value optimized out>
change = 0x0
specinsert = 0x0
save_exception_stack = 0x7fff367fd9e0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {6211559255000,
4463254845150949641, 0, 6211559255000, 144441221, 0,
-2494219915992272627, 2494057498805104909}, __mask_was_saved = 0,
__saved_mask = {
__val = {8522252, 13894872, 4096, 209054130552,
209054130464, 4, 0, 140734107735660, 140734107735679, 0, 64, 2608,
8526491, 2608, 8522252, 0}}}}
txn = 0xdf7fd8
snapshot_now = 0xd42718
command_id = 0
using_subtxn = 0 '\000'
iterstate = 0xde15d8
__func__ = "ReorderBufferCommit"
#1 0x00000000006bdd58 in DecodeCommit (ctx=0xdbe888, record=<value
optimized out>) at decode.c:611
origin_lsn = 0
commit_time = 580224365830168
origin_id = 0
i = <value optimized out>
#2 DecodeXactOp (ctx=0xdbe888, record=<value optimized out>) at decode.c:241
xlrec = <value optimized out>
parsed = {xact_time = 580224365830168, xinfo = 1, dbId =
355309, tsId = 1663, nsubxacts = 0, subxacts = 0x0, nrels = 0, xnodes
= 0x0, nmsgs = 0, msgs = 0x0, twophase_xid = 0,
origin_lsn = 0, origin_timestamp = 0}
xid = 144441221
builder = <value optimized out>
reorder = <value optimized out>
info = <value optimized out>
r = <value optimized out>
#3 LogicalDecodingProcessRecord (ctx=0xdbe888, record=<value
optimized out>) at decode.c:113
__func__ = "LogicalDecodingProcessRecord"
#4 0x00000000006d0754 in XLogSendLogical () at walsender.c:2781
record = <value optimized out>
errm = 0x0
__func__ = "XLogSendLogical"
#5 0x00000000006cf782 in WalSndLoop (send_data=0x6d0700
<XLogSendLogical>) at walsender.c:2149
now = <value optimized out>
__func__ = "WalSndLoop"
#6 0x00000000006d1463 in StartLogicalReplication (cmd_string=<value
optimized out>) at walsender.c:1102
buf = {data = 0x0, len = 3, maxlen = 1024, cursor = 87}
#7 exec_replication_command (cmd_string=<value optimized out>) at
walsender.c:1539
cmd = 0xd24928
parse_rc = <value optimized out>
cmd_node = 0xd24928
cmd_context = 0xd56f48
old_context = 0xd04828
__func__ = "exec_replication_command"
#8 0x00000000007182b9 in PostgresMain (argc=<value optimized out>,
argv=<value optimized out>, dbname=0xd368a8 "foo", username=<value
optimized out>) at postgres.c:4084
query_string = 0xdc37c8 "START_REPLICATION SLOT
\"sub_xxxxxx_xxxxxx_01_011\" LOGICAL 0/0 (proto_version '1',
publication_names '\"pub_xxxxxxxxxx_xxxxxx\"')"
firstchar = <value optimized out>
input_message = {data = 0xdc37c8 "START_REPLICATION SLOT
\"sub_xxxxxx_xxxxxx_01_011\" LOGICAL 0/0 (proto_version '1',
publication_names '\"pub_xxxxxxxxxx_xxxxxx\"')", len = 127,
maxlen = 1024, cursor = 127}
local_sigjmp_buf = {{__jmpbuf = {140734107736816,
2494058286424355085, 13791920, 1526910016, 0, 1526907023,
-2494219915887415027, 2494057610916884749}, __mask_was_saved = 1,
__saved_mask = {__val = {0, 0, 0, 0, 0, 0, 0,
209050462168, 140345725128704, 0, 4294967295, 0, 1, 13116160, 0, 0}}}}
send_ready_for_query = 0 '\000'
disable_idle_in_transaction_timeout = 0 '\000'
__func__ = "PostgresMain"
#9 0x00000000006ad27d in BackendRun (argc=<value optimized out>,
argv=<value optimized out>) at postmaster.c:4405
ac = 1
usecs = 102525
i = 1
av = 0xd47ff0
maxac = <value optimized out>
#10 BackendStartup (argc=<value optimized out>, argv=<value optimized
out>) at postmaster.c:4077
bn = <value optimized out>
pid = 0
#11 ServerLoop (argc=<value optimized out>, argv=<value optimized
out>) at postmaster.c:1755
rmask = {fds_bits = {8, 0 <repeats 15 times>}}
selres = <value optimized out>
now = <value optimized out>
readmask = {fds_bits = {56, 0 <repeats 15
times>}}zlib-1.2.3-29.el6.x86_64
>> (gdb) bt
>
> Can I get this as a "bt full", in case any of the local variables turn
> out to be interesting?
>
(gdb) bt full
#0 ReorderBufferCommit (rb=0xde14c8, xid=<value optimized out>,
commit_lsn=6211559254952, end_lsn=<value optimized out>,
commit_time=<value optimized out>, origin_id=<value optimized out>,
origin_lsn=0) at reorderbuffer.c:1397
relation = 0x0
reloid = <value optimized out>
change = 0x0
specinsert = 0x0
save_exception_stack = 0x7fff367fd9e0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {6211559255000,
4463254845150949641, 0, 6211559255000, 144441221, 0,
-2494219915992272627, 2494057498805104909}, __mask_was_saved = 0,
__saved_mask = {
__val = {8522252, 13894872, 4096, 209054130552,
209054130464, 4, 0, 140734107735660, 140734107735679, 0, 64, 2608,
8526491, 2608, 8522252, 0}}}}
txn = 0xdf7fd8
snapshot_now = 0xd42718
command_id = 0
using_subtxn = 0 '\000'
iterstate = 0xde15d8
__func__ = "ReorderBufferCommit"
#1 0x00000000006bdd58 in DecodeCommit (ctx=0xdbe888, record=<value
optimized out>) at decode.c:611
origin_lsn = 0
commit_time = 580224365830168
origin_id = 0
i = <value optimized out>
#2 DecodeXactOp (ctx=0xdbe888, record=<value optimized out>) at decode.c:241
xlrec = <value optimized out>
parsed = {xact_time = 580224365830168, xinfo = 1, dbId =
355309, tsId = 1663, nsubxacts = 0, subxacts = 0x0, nrels = 0, xnodes
= 0x0, nmsgs = 0, msgs = 0x0, twophase_xid = 0,
origin_lsn = 0, origin_timestamp = 0}
xid = 144441221
builder = <value optimized out>
reorder = <value optimized out>
info = <value optimized out>
r = <value optimized out>
#3 LogicalDecodingProcessRecord (ctx=0xdbe888, record=<value
optimized out>) at decode.c:113
__func__ = "LogicalDecodingProcessRecord"
#4 0x00000000006d0754 in XLogSendLogical () at walsender.c:2781
record = <value optimized out>
errm = 0x0
__func__ = "XLogSendLogical"
#5 0x00000000006cf782 in WalSndLoop (send_data=0x6d0700
<XLogSendLogical>) at walsender.c:2149
now = <value optimized out>
__func__ = "WalSndLoop"
#6 0x00000000006d1463 in StartLogicalReplication (cmd_string=<value
optimized out>) at walsender.c:1102
buf = {data = 0x0, len = 3, maxlen = 1024, cursor = 87}
#7 exec_replication_command (cmd_string=<value optimized out>) at
walsender.c:1539
cmd = 0xd24928
parse_rc = <value optimized out>
cmd_node = 0xd24928
cmd_context = 0xd56f48
old_context = 0xd04828
__func__ = "exec_replication_command"
#8 0x00000000007182b9 in PostgresMain (argc=<value optimized out>,
argv=<value optimized out>, dbname=0xd368a8 "foo", username=<value
optimized out>) at postgres.c:4084
query_string = 0xdc37c8 "START_REPLICATION SLOT
\"sub_xxxxxx_xxxxxx_01_011\" LOGICAL 0/0 (proto_version '1',
publication_names '\"pub_xxxxxxxxxx_xxxxxx\"')"
firstchar = <value optimized out>
input_message = {data = 0xdc37c8 "START_REPLICATION SLOT
\"sub_xxxxxx_xxxxxx_01_011\" LOGICAL 0/0 (proto_version '1',
publication_names '\"pub_xxxxxxxxxx_xxxxxx\"')", len = 127,
maxlen = 1024, cursor = 127}
local_sigjmp_buf = {{__jmpbuf = {140734107736816,
2494058286424355085, 13791920, 1526910016, 0, 1526907023,
-2494219915887415027, 2494057610916884749}, __mask_was_saved = 1,
__saved_mask = {__val = {0, 0, 0, 0, 0, 0, 0,
209050462168, 140345725128704, 0, 4294967295, 0, 1, 13116160, 0, 0}}}}
send_ready_for_query = 0 '\000'
disable_idle_in_transaction_timeout = 0 '\000'
__func__ = "PostgresMain"
#9 0x00000000006ad27d in BackendRun (argc=<value optimized out>,
argv=<value optimized out>) at postmaster.c:4405
ac = 1
usecs = 102525
i = 1
av = 0xd47ff0
maxac = <value optimized out>
#10 BackendStartup (argc=<value optimized out>, argv=<value optimized
out>) at postmaster.c:4077
bn = <value optimized out>
pid = 0
#11 ServerLoop (argc=<value optimized out>, argv=<value optimized
out>) at postmaster.c:1755
rmask = {fds_bits = {8, 0 <repeats 15 times>}}
selres = <value optimized out>
now = <value optimized out>
readmask = {fds_bits = {56, 0 <repeats 15 times>}}
nSockets = 6
last_lockfile_recheck_time = 1526910016
last_touch_time = 1526907023
#12 PostmasterMain (argc=<value optimized out>, argv=<value optimized
out>) at postmaster.c:1363
opt = <value optimized out>
status = <value optimized out>
userDoption = <value optimized out>
listen_addr_saved = <value optimized out>
i = <value optimized out>
output_config_variable = <value optimized out>
__func__ = "PostmasterMain"
#13 0x000000000062e5b0 in main (argc=3, argv=0xd04540) at main.c:228
No locals.

--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento