[BUGS] BUG #14574: unable to execute SQL query. crashes. word has fallen :(

The following bug has been logged on the website:

Bug reference:      14574
Logged by:          Andrey Lelikov
Email address:      postgres1@lelik.org
PostgreSQL version: 9.2.14
Operating system:   debian
Description:

Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x0000000000676a68 in make_subqueryscan (qptlist=0x33f0620, qpqual=0x0,
scanrelid=1, subplan=0x0) at createplan.c:3259
3259        plan->total_cost += cpu_tuple_cost * subplan->plan_rows;
(gdb) bt
#0  0x0000000000676a68 in make_subqueryscan (qptlist=0x33f0620, qpqual=0x0,
scanrelid=1, subplan=0x0) at createplan.c:3259
#1  0x00000000006727f8 in create_append_plan (root=0x32d2fd8,
best_path=0x33efcc0) at createplan.c:688
#2  0x0000000000671fdc in create_plan_recurse (root=0x32d2fd8,
best_path=0x33efcc0) at createplan.c:245
#3  0x0000000000671f11 in create_plan (root=0x32d2fd8, best_path=0x33efcc0)
at createplan.c:199
#4  0x000000000067e6c2 in grouping_planner (root=0x32d2fd8,
tuple_fraction=0) at planner.c:1337
#5  0x000000000067d2c7 in subquery_planner (glob=0x27150b0, parse=0x32b1618,
parent_root=0x31439b0, hasRecursion=0 '\000', tuple_fraction=0,
subroot=0x7ffd91ecab00) at planner.c:533
#6  0x0000000000659842 in set_subquery_pathlist (root=0x31439b0,
rel=0x32acd98, rti=1, rte=0x327fad0) at allpaths.c:1222
#7  0x000000000065837c in set_rel_size (root=0x31439b0, rel=0x32acd98,
rti=1, rte=0x327fad0) at allpaths.c:263
#8  0x00000000006581fc in set_base_rel_sizes (root=0x31439b0) at
allpaths.c:179
#9  0x0000000000658167 in make_one_rel (root=0x31439b0, joinlist=0x32ad288)
at allpaths.c:137
#10 0x000000000067c3ae in query_planner (root=0x31439b0, tlist=0x32a9548,
tuple_fraction=0, limit_tuples=-1, qp_callback=0x67fcc3
<standard_qp_callback>, qp_extra=0x7ffd91ecadb0,
cheapest_path=0x7ffd91ecada8, sorted_path=0x7ffd91ecada0, 
    num_groups=0x7ffd91ecade0) at planmain.c:251
#11 0x000000000067e3c9 in grouping_planner (root=0x31439b0,
tuple_fraction=0) at planner.c:1243
#12 0x000000000067d2c7 in subquery_planner (glob=0x27150b0, parse=0x327f970,
parent_root=0x2c3f2b0, hasRecursion=0 '\000', tuple_fraction=0,
subroot=0x7ffd91ecb020) at planner.c:533
#13 0x0000000000659842 in set_subquery_pathlist (root=0x2c3f2b0,
rel=0x2ec0a78, rti=4, rte=0x2e96610) at allpaths.c:1222
#14 0x000000000065837c in set_rel_size (root=0x2c3f2b0, rel=0x2ec0a78,
rti=4, rte=0x2e96610) at allpaths.c:263
#15 0x0000000000658a22 in set_append_rel_size (root=0x2c3f2b0,
rel=0x2ec0788, rti=2, rte=0x2715250) at allpaths.c:592
#16 0x0000000000658300 in set_rel_size (root=0x2c3f2b0, rel=0x2ec0788,
rti=2, rte=0x2715250) at allpaths.c:239
#17 0x00000000006581fc in set_base_rel_sizes (root=0x2c3f2b0) at
allpaths.c:179
#18 0x0000000000658167 in make_one_rel (root=0x2c3f2b0, joinlist=0x2ec0ca0)
at allpaths.c:137
#19 0x000000000067c3ae in query_planner (root=0x2c3f2b0, tlist=0x2ec04f8,
tuple_fraction=0, limit_tuples=-1, qp_callback=0x67fcc3
<standard_qp_callback>, qp_extra=0x7ffd91ecb3d0,
cheapest_path=0x7ffd91ecb3c8, sorted_path=0x7ffd91ecb3c0, 
    num_groups=0x7ffd91ecb400) at planmain.c:251
#20 0x000000000067e3c9 in grouping_planner (root=0x2c3f2b0,
tuple_fraction=0) at planner.c:1243
#21 0x000000000067d2c7 in subquery_planner (glob=0x27150b0, parse=0x2714f70,
parent_root=0x0, hasRecursion=0 '\000', tuple_fraction=0,
subroot=0x7ffd91ecb638) at planner.c:533
#22 0x000000000067c9ee in standard_planner (parse=0x2714f70,
cursorOptions=0, boundParams=0x0) at planner.c:204
#23 0x000000000067c85f in planner (parse=0x2714f70, cursorOptions=0,
boundParams=0x0) at planner.c:133
#24 0x000000000070459b in pg_plan_query (querytree=0x2714f70,
cursorOptions=0, boundParams=0x0) at postgres.c:778
#25 0x000000000070464e in pg_plan_queries (querytrees=0x2c3f280,
cursorOptions=0, boundParams=0x0) at postgres.c:837
#26 0x00000000007048ee in exec_simple_query (
    query_string=0x2794000 "INSERT INTO tt45 (_Q_000_F_000RRef,
_Q_000_F_001_TYPE, _Q_000_F_001_RTRef, _Q_000_F_001_RRRef,
_Q_000_F_002_TYPE, _Q_000_F_002_RTRef, _Q_000_F_002_RRRef,
_Q_000_F_003_TYPE, _Q_000_F_003_RTRef, _Q_000_"...)
    at postgres.c:1002
#27 0x0000000000708a42 in PostgresMain (argc=1, argv=0x1d6bef0,
dbname=0x1d6bed0 "smile_acc2", username=0x1d6beb0 "postgres") at
postgres.c:4032
#28 0x00000000006b3f2b in BackendRun (port=0x1d93d50) at postmaster.c:3738
#29 0x00000000006b35f0 in BackendStartup (port=0x1d93d50) at
postmaster.c:3411
#30 0x00000000006b0652 in ServerLoop () at postmaster.c:1453
#31 0x00000000006aff71 in PostmasterMain (argc=5, argv=0x1d6b270) at
postmaster.c:1183
#32 0x000000000062034d in main (argc=5, argv=0x1d6b270) at main.c:230



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs