Re: crash while decoding INSERT ON CONFLICT

Поиск

Список

Период

Сортировка

От	Euler Taveira
Тема	Re: crash while decoding INSERT ON CONFLICT
Дата	22 мая 2018 г. 02:31:16
Msg-id	CAHE3wghuM++xkWHvLPrjtODW7FW1Mc2+-d3YV3YN3EFsP=syhA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: crash while decoding INSERT ON CONFLICT (Peter Geoghegan <pg@bowt.ie>)
Ответы	Re: crash while decoding INSERT ON CONFLICT (Peter Geoghegan <pg@bowt.ie>)
Список	pgsql-bugs

Дерево обсуждения

2018-05-21 17:15 GMT-03:00 Peter Geoghegan <pg@bowt.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

В списке pgsql-bugs по дате отправления:

Предыдущее

От: Peter Geoghegan
Дата: 22 мая 2018 г., 02:15:15
Сообщение: Re: crash while decoding INSERT ON CONFLICT

Следующее

От: Peter Geoghegan
Дата: 22 мая 2018 г., 07:37:00
Сообщение: Re: crash while decoding INSERT ON CONFLICT

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: crash while decoding INSERT ON CONFLICT

Предыдущее

Следующее