Re: BUG #15144: *** glibc detected *** postgres: postgres smsconsole [local] SELECT: double free or corruption (!pre - Mailing list pgsql-bugs

Hello, Peter.

We have cat crash at our secondary server.
This full stack trace from crash dump:
(gdb) bt full
#0  0x0000003d22232495 in raise () from /lib64/libc.so.6
No symbol table info available.
#1  0x0000003d22233c75 in abort () from /lib64/libc.so.6
No symbol table info available.
#2  0x0000003d222703a7 in __libc_message () from /lib64/libc.so.6
No symbol table info available.
#3  0x0000003d22275dee in malloc_printerr () from /lib64/libc.so.6
No symbol table info available.
#4  0x0000003d22278c80 in _int_free () from /lib64/libc.so.6
No symbol table info available.
#5  0x0000000000808887 in tuplestore_end (state=0x1794898) at tuplestore.c:455
        i = <value optimized out>
#6  0x00000000005e94e5 in ExecEndFunctionScan (node=0x178e3d8) at nodeFunctionscan.c:550
        fs = 0x178e388
        i = <value optimized out>
#7  0x00000000005cbaae in ExecEndPlan (queryDesc=0x16c6a38) at execMain.c:1451
        resultRelInfo = <value optimized out>
        i = <value optimized out>
        l = <value optimized out>
#8  standard_ExecutorEnd (queryDesc=0x16c6a38) at execMain.c:468
        estate = 0x178e278
        oldcontext = 0x1677e48
#9  0x0000000000593d6e in PortalCleanup (portal=0x16c3138) at portalcmds.c:280
        save_exception_stack = 0x7fff07538610
        save_context_stack = 0x0
        local_sigjmp_buf = {{__jmpbuf = {23867704, 2475436528305129399, 24351312, 24686200, 2, 24686152,
-2475701272642631753,2475437018370099127},
 
            __mask_was_saved = 0, __saved_mask = {__val = {24686152, 15971042801079502775, 2475436856846141367, 0,
8280655,0, 24149016, 9856140, 2, 1,
 
                23867704, 140733316302126, 88, 23867704, 24351312, 9377246}}}}
        saveResourceOwner = 0x1678878
        queryDesc = 0x16c6a38
#10 0x00000000007fcaca in PortalDrop (portal=0x16c3138, isTopCommit=0 '\000') at portalmem.c:510
        __func__ = "PortalDrop"
#11 0x00000000006e0eb2 in exec_simple_query (query_string=0x1738468 "select count(*) from pg_buffercache where
isdirty")at postgres.c:1095
 
        parsetree = 0x1739140
        portal = 0x16c3138
        snapshot_set = <value optimized out>
        commandTag = <value optimized out>
        completionTag = "SELECT 1\000\000\000\000\000\000\000\000h\204s\001\000\000\000\000h\204s\001\000\000\000\000m
pg_buf\220!\002\"=\000\000\000\336\000\000\000\000\000\000\000\205\312~\000\000\000\000"
        querytree_list = <value optimized out>
        plantree_list = 0x178ae48
        receiver = 0x178ae78
        format = 0
        dest = DestRemote
        oldcontext = 0x1677e48
---Type <return> to continue, or q <return> to quit---
        parsetree_list = 0x1739270
        parsetree_item = 0x1739250
        save_log_statement_stats = 0 '\000'
        was_logged = 0 '\000'
        isTopLevel = 1 '\001'
        msec_str = "\220\205S\a\377\177\000\000\000\207S\a\377\177\000\000h\204s\001", '\000' <repeats 11 times>
        __func__ = "exec_simple_query"
#12 0x00000000006e256c in PostgresMain (argc=<value optimized out>, argv=<value optimized out>, dbname=0x16c8f08
"smsconsole",
    username=<value optimized out>) at postgres.c:4072
        query_string = 0x1738468 "select count(*) from pg_buffercache where isdirty"
        firstchar = 81
        input_message = {data = 0x1738468 "select count(*) from pg_buffercache where isdirty", len = 50, maxlen = 1024,
cursor= 50}
 
        local_sigjmp_buf = {{__jmpbuf = {140733316302560, 2475436528304998327, 1, 1523890764, -9187201950435737471, 0,
-2475701272437110857,
              2475436853937391543}, __mask_was_saved = 1, __saved_mask = {__val = {0, 0, 4294967295, 12667896, 1,
12667240,0, 9259542123273814145, 0, 0,
 
                1024, 23891912, 12732800, 1523890764, 8372124, 140733316302592}}}}
        send_ready_for_query = 0 '\000'
        disable_idle_in_transaction_timeout = 0 '\000'
        __func__ = "PostgresMain"
#13 0x00000000006823e5 in BackendRun (argc=<value optimized out>, argv=<value optimized out>) at postmaster.c:4342
        ac = 1
        usecs = 446360
        i = 1
        av = 0x16c8fc8
        maxac = <value optimized out>
#14 BackendStartup (argc=<value optimized out>, argv=<value optimized out>) at postmaster.c:4016
        bn = <value optimized out>
        pid = 0
#15 ServerLoop (argc=<value optimized out>, argv=<value optimized out>) at postmaster.c:1721
        rmask = {fds_bits = {32, 0 <repeats 15 times>}}
        selres = <value optimized out>
        now = <value optimized out>
        readmask = {fds_bits = {120, 0 <repeats 15 times>}}
        nSockets = 7
        last_lockfile_recheck_time = 1523890764
        last_touch_time = 1523887759
#16 PostmasterMain (argc=<value optimized out>, argv=<value optimized out>) at postmaster.c:1329
        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"
#17 0x0000000000609fe8 in main (argc=3, argv=0x1676990) at main.c:228
No locals.


10.04.2018, 22:56, "Peter Geoghegan" <pg@bowt.ie>:
> On Fri, Apr 6, 2018 at 12:42 AM, Vitaly V. Voronov <wizard_1024@tut.by> wrote:
>>  Sorry. I can't do this. Because, 1s - this is production and 2nd - it had been initialized as replica.
>>  We use 2 server, and this server (with error) now initialized as secondary.
>>  We use pgpool for switching servers.
>>  And i posted full log from Postgres logs.
>>  All other logs is clear.
>
> I won't be able to help you without this information.
>
> --
> Peter Geoghegan