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

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(at)bowt(dot)ie>:
> On Fri, Apr 6, 2018 at 12:42 AM, Vitaly V. Voronov <wizard_1024(at)tut(dot)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