Re: Segmentation fault with core dump

>
> Might be worth comparing sha1sum's of the postgres executable between
> this server and one that's not having the problem, just to eliminate
> the corrupted-binary theory.
>
>
>

The return is the same for the two servers,

$ sha1sum /usr/pgsql-9.6/bin/postmaster
56bcb4d644a8b00f07e9bd42f9a3f02be7ff2523 /usr/pgsql-9.6/bin/postmaster

Today I left to generate more core-dump, follow the return,

(gdb) bt
#0 tbm_comparator (left=left(at)entry=0x1d5ca08, right=right(at)entry=0x3acdb70)
at tidbitmap.c:1031
#1 0x0000000000801268 in med3 (a=0x1d5ca08 "\350>\337\001", b=0x3acdb70
<Address 0x3acdb70 out of bounds>, c=0x583ecd8 <Address 0x583ecd8 out of
bounds>, cmp=0x603ca0 <tbm_comparator>) at qsort.c:107
#2 0x0000000000801621 in pg_qsort (a=0x1d5ca08, n=<optimized out>,
n(at)entry=10477,
es=es(at)entry=8, cmp=cmp(at)entry=0x603ca0 <tbm_comparator>) at qsort.c:157
#3 0x0000000000604a7b in tbm_begin_iterate (tbm=tbm(at)entry=0x1dd8a00) at
tidbitmap.c:635
#4 0x00000000005d3a89 in BitmapHeapNext (node=node(at)entry=0x1dc2ef0) at
nodeBitmapHeapscan.c:110
#5 0x00000000005caf1a in ExecScanFetch (recheckMtd=0x5d35b0
<BitmapHeapRecheck>, accessMtd=0x5d35f0 <BitmapHeapNext>, node=0x1dc2ef0)
at execScan.c:95
#6 ExecScan (node=node(at)entry=0x1dc2ef0, accessMtd=accessMtd(at)entry=0x5d35f0
<BitmapHeapNext>, recheckMtd=recheckMtd(at)entry=0x5d35b0 <BitmapHeapRecheck>)
at execScan.c:180
#7 0x00000000005d3cff in ExecBitmapHeapScan (node=node(at)entry=0x1dc2ef0) at
nodeBitmapHeapscan.c:440
#8 0x00000000005c3fb8 in ExecProcNode (node=node(at)entry=0x1dc2ef0) at
execProcnode.c:437
#9 0x00000000005de877 in ExecNestLoop (node=node(at)entry=0x1dc0148) at
nodeNestloop.c:174
#10 0x00000000005c3f28 in ExecProcNode (node=node(at)entry=0x1dc0148) at
execProcnode.c:476
#11 0x00000000005de7d7 in ExecNestLoop (node=node(at)entry=0x1dbfdd8) at
nodeNestloop.c:123
#12 0x00000000005c3f28 in ExecProcNode (node=node(at)entry=0x1dbfdd8) at
execProcnode.c:476
#13 0x00000000005d624d in MultiExecHash (node=node(at)entry=0x1dbf9b8) at
nodeHash.c:104
#14 0x00000000005c40c0 in MultiExecProcNode (node=node(at)entry=0x1dbf9b8) at
execProcnode.c:577
#15 0x00000000005d6cb9 in ExecHashJoin (node=node(at)entry=0x1dbe688) at
nodeHashjoin.c:178
#16 0x00000000005c3f08 in ExecProcNode (node=node(at)entry=0x1dbe688) at
execProcnode.c:484
#17 0x00000000005de7d7 in ExecNestLoop (node=node(at)entry=0x1dbc6e0) at
nodeNestloop.c:123
#18 0x00000000005c3f28 in ExecProcNode (node=node(at)entry=0x1dbc6e0) at
execProcnode.c:476
#19 0x00000000005de7d7 in ExecNestLoop (node=node(at)entry=0x1dbc520) at
nodeNestloop.c:123
#20 0x00000000005c3f28 in ExecProcNode (node=0x1dbc520) at
execProcnode.c:476
#21 0x00000000005cf619 in fetch_input_tuple (aggstate=aggstate(at)entry=0x1dbbc48)
at nodeAgg.c:598
#22 0x00000000005d10ff in agg_retrieve_direct (aggstate=0x1dbbc48) at
nodeAgg.c:2067
#23 ExecAgg (node=node(at)entry=0x1dbbc48) at nodeAgg.c:1892
#24 0x00000000005c3ec8 in ExecProcNode (node=node(at)entry=0x1dbbc48) at
execProcnode.c:503
#25 0x00000000005c03a7 in ExecutePlan (dest=0x1b607c8, direction=<optimized
out>, numberTuples=0, sendTuples=1 '\001', operation=CMD_SELECT,
use_parallel_mode=<optimized out>, planstate=0x1dbbc48, estate=0x1dbba58)
at execMain.c:1566
#26 standard_ExecutorRun (queryDesc=0x1c98de0, direction=<optimized out>,
count=0) at execMain.c:338
#27 0x00007f016577e0a5 in pgss_ExecutorRun (queryDesc=0x1c98de0,
direction=ForwardScanDirection, count=0) at pg_stat_statements.c:877
#28 0x00000000006d3a97 in PortalRunSelect (portal=portal(at)entry=0x1ad9278,
forward=forward(at)entry=1 '\001', count=0, count(at)entry=9223372036854775807,
dest=dest(at)entry=0x1b607c8) at pquery.c:948
#29 0x00000000006d4eab in PortalRun (portal=0x1ad9278,
count=9223372036854775807, isTopLevel=<optimized out>, dest=0x1b607c8,
altdest=0x1b607c8, completionTag=0x7ffdfe32a700 "") at pquery.c:789
#30 0x00000000006d2371 in PostgresMain (argc=<optimized out>,
argv=<optimized out>, dbname=<optimized out>, username=<optimized out>) at
postgres.c:1969
#31 0x000000000046f8d4 in BackendRun (port=0x1add6d0) at postmaster.c:4294
#32 BackendStartup (port=0x1add6d0) at postmaster.c:3968
#33 ServerLoop () at postmaster.c:1719
#34 0x0000000000675b69 in PostmasterMain (argc=argc(at)entry=3,
argv=argv(at)entry=0x1ab1210)
at postmaster.c:1327
#35 0x000000000047053e in main (argc=3, argv=0x1ab1210) at main.c:228

Regards,
Glauco