Re: Segmentation fault with core dump - Mailing list pgsql-general
| From | Glauco Torres |
|---|---|
| Subject | Re: Segmentation fault with core dump |
| Date | |
| Msg-id | CAMd+QOTYezjvyCbg_V3uxqcOznpjFLxajhR2Qk9Ujm0VeR86ZQ@mail.gmail.com Whole thread Raw |
| In response to | Re: Segmentation fault with core dump (Tom Lane <tgl@sss.pgh.pa.us>) |
| Responses |
Re: Segmentation fault with core dump
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| List | pgsql-general |
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@entry=0x1d5ca08, right=right@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@entry=10477, es=es@entry=8, cmp=cmp@entry=0x603ca0 <tbm_comparator>) at qsort.c:157
#3 0x0000000000604a7b in tbm_begin_iterate (tbm=tbm@entry=0x1dd8a00) at tidbitmap.c:635
#4 0x00000000005d3a89 in BitmapHeapNext (node=node@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@entry=0x1dc2ef0, accessMtd=accessMtd@entry=0x5d35f0 <BitmapHeapNext>, recheckMtd=recheckMtd@entry=0x5d35b0 <BitmapHeapRecheck>) at execScan.c:180
#7 0x00000000005d3cff in ExecBitmapHeapScan (node=node@entry=0x1dc2ef0) at nodeBitmapHeapscan.c:440
#8 0x00000000005c3fb8 in ExecProcNode (node=node@entry=0x1dc2ef0) at execProcnode.c:437
#9 0x00000000005de877 in ExecNestLoop (node=node@entry=0x1dc0148) at nodeNestloop.c:174
#10 0x00000000005c3f28 in ExecProcNode (node=node@entry=0x1dc0148) at execProcnode.c:476
#11 0x00000000005de7d7 in ExecNestLoop (node=node@entry=0x1dbfdd8) at nodeNestloop.c:123
#12 0x00000000005c3f28 in ExecProcNode (node=node@entry=0x1dbfdd8) at execProcnode.c:476
#13 0x00000000005d624d in MultiExecHash (node=node@entry=0x1dbf9b8) at nodeHash.c:104
#14 0x00000000005c40c0 in MultiExecProcNode (node=node@entry=0x1dbf9b8) at execProcnode.c:577
#15 0x00000000005d6cb9 in ExecHashJoin (node=node@entry=0x1dbe688) at nodeHashjoin.c:178
#16 0x00000000005c3f08 in ExecProcNode (node=node@entry=0x1dbe688) at execProcnode.c:484
#17 0x00000000005de7d7 in ExecNestLoop (node=node@entry=0x1dbc6e0) at nodeNestloop.c:123
#18 0x00000000005c3f28 in ExecProcNode (node=node@entry=0x1dbc6e0) at execProcnode.c:476
#19 0x00000000005de7d7 in ExecNestLoop (node=node@entry=0x1dbc520) at nodeNestloop.c:123
#20 0x00000000005c3f28 in ExecProcNode (node=0x1dbc520) at execProcnode.c:476
#21 0x00000000005cf619 in fetch_input_tuple (aggstate=aggstate@entry=0x1dbbc48) at nodeAgg.c:598
#22 0x00000000005d10ff in agg_retrieve_direct (aggstate=0x1dbbc48) at nodeAgg.c:2067
#23 ExecAgg (node=node@entry=0x1dbbc48) at nodeAgg.c:1892
#24 0x00000000005c3ec8 in ExecProcNode (node=node@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@entry=0x1ad9278, forward=forward@entry=1 '\001', count=0, count@entry=9223372036854775807, dest=dest@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@entry=3, argv=argv@entry=0x1ab1210) at postmaster.c:1327
#35 0x000000000047053e in main (argc=3, argv=0x1ab1210) at main.c:228
#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@entry=10477, es=es@entry=8, cmp=cmp@entry=0x603ca0 <tbm_comparator>) at qsort.c:157
#3 0x0000000000604a7b in tbm_begin_iterate (tbm=tbm@entry=0x1dd8a00) at tidbitmap.c:635
#4 0x00000000005d3a89 in BitmapHeapNext (node=node@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@entry=0x1dc2ef0, accessMtd=accessMtd@entry=0x5d35f0 <BitmapHeapNext>, recheckMtd=recheckMtd@entry=0x5d35b0 <BitmapHeapRecheck>) at execScan.c:180
#7 0x00000000005d3cff in ExecBitmapHeapScan (node=node@entry=0x1dc2ef0) at nodeBitmapHeapscan.c:440
#8 0x00000000005c3fb8 in ExecProcNode (node=node@entry=0x1dc2ef0) at execProcnode.c:437
#9 0x00000000005de877 in ExecNestLoop (node=node@entry=0x1dc0148) at nodeNestloop.c:174
#10 0x00000000005c3f28 in ExecProcNode (node=node@entry=0x1dc0148) at execProcnode.c:476
#11 0x00000000005de7d7 in ExecNestLoop (node=node@entry=0x1dbfdd8) at nodeNestloop.c:123
#12 0x00000000005c3f28 in ExecProcNode (node=node@entry=0x1dbfdd8) at execProcnode.c:476
#13 0x00000000005d624d in MultiExecHash (node=node@entry=0x1dbf9b8) at nodeHash.c:104
#14 0x00000000005c40c0 in MultiExecProcNode (node=node@entry=0x1dbf9b8) at execProcnode.c:577
#15 0x00000000005d6cb9 in ExecHashJoin (node=node@entry=0x1dbe688) at nodeHashjoin.c:178
#16 0x00000000005c3f08 in ExecProcNode (node=node@entry=0x1dbe688) at execProcnode.c:484
#17 0x00000000005de7d7 in ExecNestLoop (node=node@entry=0x1dbc6e0) at nodeNestloop.c:123
#18 0x00000000005c3f28 in ExecProcNode (node=node@entry=0x1dbc6e0) at execProcnode.c:476
#19 0x00000000005de7d7 in ExecNestLoop (node=node@entry=0x1dbc520) at nodeNestloop.c:123
#20 0x00000000005c3f28 in ExecProcNode (node=0x1dbc520) at execProcnode.c:476
#21 0x00000000005cf619 in fetch_input_tuple (aggstate=aggstate@entry=0x1dbbc48) at nodeAgg.c:598
#22 0x00000000005d10ff in agg_retrieve_direct (aggstate=0x1dbbc48) at nodeAgg.c:2067
#23 ExecAgg (node=node@entry=0x1dbbc48) at nodeAgg.c:1892
#24 0x00000000005c3ec8 in ExecProcNode (node=node@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@entry=0x1ad9278, forward=forward@entry=1 '\001', count=0, count@entry=9223372036854775807, dest=dest@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@entry=3, argv=argv@entry=0x1ab1210) at postmaster.c:1327
#35 0x000000000047053e in main (argc=3, argv=0x1ab1210) at main.c:228
Regards,
Glauco
pgsql-general by date: