viewing paste Unknown #21400 | Text

Posted on the
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
$ gdb /usr/local/pgsql96d-unique_joins/bin/postgres /raid/dbt3/pgdata/core.48628
GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-64.el7
Copyright (C) 2013 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /usr/local/pgsql96d-unique_joins/bin/postgres...done.
[New LWP 48628]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `postgres: mark dbt3 [local] SELECT                                            '.
Program terminated with signal 11, Segmentation fault.
#0  ExecScanHashBucket (hjstate=hjstate@entry=0x25d8f68, econtext=econtext@entry=0x25d9078) at nodeHash.c:1086
1086                    if (hashTuple->hashvalue == hashvalue)
Missing separate debuginfos, use: debuginfo-install glibc-2.17-78.el7.x86_64
(gdb) bt
#0  ExecScanHashBucket (hjstate=hjstate@entry=0x25d8f68, econtext=econtext@entry=0x25d9078) at nodeHash.c:1086
#1  0x00000000005bcf3a in ExecHashJoin (node=node@entry=0x25d8f68) at nodeHashjoin.c:277
#2  0x00000000005ab548 in ExecProcNode (node=node@entry=0x25d8f68) at execProcnode.c:477
#3  0x00000000005c468e in ExecNestLoop (node=node@entry=0x25d8bf8) at nodeNestloop.c:123
#4  0x00000000005ab568 in ExecProcNode (node=node@entry=0x25d8bf8) at execProcnode.c:469
#5  0x00000000005c468e in ExecNestLoop (node=node@entry=0x25d8988) at nodeNestloop.c:123
#6  0x00000000005ab568 in ExecProcNode (node=0x25d8988) at execProcnode.c:469
#7  0x00000000005b66a1 in fetch_input_tuple (aggstate=aggstate@entry=0x25d8110) at nodeAgg.c:547
#8  0x00000000005b7be8 in agg_fill_hash_table (aggstate=0x25d8110) at nodeAgg.c:1912
#9  ExecAgg (node=node@entry=0x25d8110) at nodeAgg.c:1553
#10 0x00000000005ab5c8 in ExecProcNode (node=node@entry=0x25d8110) at execProcnode.c:496
#11 0x00000000005c6f11 in ExecSort (node=node@entry=0x25d7ea0) at nodeSort.c:103
#12 0x00000000005ab528 in ExecProcNode (node=node@entry=0x25d7ea0) at execProcnode.c:488
#13 0x00000000005bfcc4 in ExecLimit (node=node@entry=0x25d7ba0) at nodeLimit.c:91
#14 0x00000000005ab3d8 in ExecProcNode (node=node@entry=0x25d7ba0) at execProcnode.c:520
#15 0x00000000005a86a2 in ExecutePlan (dest=0x7f88dce9dcc8, direction=<optimized out>, numberTuples=0,
    sendTuples=1 '\001', operation=CMD_SELECT, planstate=0x25d7ba0, estate=0x25d7a00) at execMain.c:1549
#16 standard_ExecutorRun (queryDesc=0x25e3800, direction=<optimized out>, count=0) at execMain.c:337
#17 0x00000000006a3ebf in PortalRunSelect (portal=portal@entry=0x2514fd0, forward=forward@entry=1 '\001', count=0,
    count@entry=9223372036854775807, dest=dest@entry=0x7f88dce9dcc8) at pquery.c:946
#18 0x00000000006a5336 in PortalRun (portal=portal@entry=0x2514fd0, count=count@entry=9223372036854775807,
    isTopLevel=isTopLevel@entry=1 '\001', dest=dest@entry=0x7f88dce9dcc8, altdest=altdest@entry=0x7f88dce9dcc8,
    completionTag=completionTag@entry=0x7fff06964400 "") at pquery.c:790
#19 0x00000000006a2fa0 in exec_simple_query (
    query_string=0x2569b40 "select\n\ts_name,\n\tcount(*) as numwait\nfrom\n\tsupplier,\n\tlineitem l1,\n\torders,\n\tnation\nwhere\n\ts_suppkey = l1.l_suppkey\n\tand o_orderkey = l1.l_orderkey\n\tand o_orderstatus = 'F'\n\tand l1.l_receiptdate > l1."...) at postgres.c:1104
#20 PostgresMain (argc=<optimized out>, argv=argv@entry=0x24fb8a8, dbname=0x24fb7d8 "dbt3", username=<optimized out>)
    at postgres.c:4025
#21 0x000000000046508a in BackendRun (port=0x251bc80) at postmaster.c:4230
#22 BackendStartup (port=0x251bc80) at postmaster.c:3906
#23 ServerLoop () at postmaster.c:1665
#24 0x000000000064edf6 in PostmasterMain (argc=argc@entry=23, argv=argv@entry=0x24fa6a0) at postmaster.c:1274
#25 0x0000000000465b2c in main (argc=23, argv=0x24fa6a0) at main.c:223
 
Viewed 656 times, submitted by unknown.