Failed assertion root->hasLateralRTEs on initsplan.c - Mailing list pgsql-hackers
From | Emre Hasegeli |
---|---|
Subject | Failed assertion root->hasLateralRTEs on initsplan.c |
Date | |
Msg-id | CAE2gYzx8NfaRWF10i42KKxNOZFSnkBKYWTfO3DuCLBOFhspwhg@mail.gmail.com Whole thread Raw |
Responses |
Re: Failed assertion root->hasLateralRTEs on initsplan.c
|
List | pgsql-hackers |
I get assertion failure on initsplan.c line 1325 while executing following query on HEAD (edc43458d797a5956f4bf39af18cf62abb0077db). It works fine without --enable-cassert. update subscriber set properties = hstore(a) from (select firstname, lastname from player where player.id = subscriber.id) as a; Backtrace: * thread #1: tid = 0x2e16ec, 0x00007fff85f0b866 libsystem_kernel.dylib`__pthread_kill + 10, queue = 'com.apple.main-thread, stop reason = signal SIGABRT frame #0: 0x00007fff85f0b866 libsystem_kernel.dylib`__pthread_kill+ 10 frame #1: 0x00007fff8450335c libsystem_pthread.dylib`pthread_kill + 92 frame#2: 0x00007fff82ffdbba libsystem_c.dylib`abort + 125 frame #3: 0x000000010e2b7510 postgres`ExceptionalCondition(conditionName=<unavailable>, errorType=<unavailable>, fileName=<unavailable>, lineNumber=<unavailable>) + 80 at assert.c:54 frame #4: 0x000000010e155ab6 postgres`distribute_qual_to_rels(root=<unavailable>, clause=0x00007fd5c382e208, is_deduced='\0', below_outer_join='\0', jointype=JOIN_INNER, qualscope=0x00007fd5c3835ee8, ojscope=<unavailable>, outerjoin_nonnullable=<unavailable>, deduced_nullable_relids=<unavailable>, postponed_qual_list=<unavailable>) + 1254 at initsplan.c:1325 frame #5: 0x000000010e154a66 postgres`deconstruct_recurse(root=0x00007fd5c382c248, jtnode=0x00007fd5c382cde0, below_outer_join='\0', qualscope=0x00007fff51c723f8, inner_join_rels=<unavailable>, postponed_qual_list=0x00007fff51c72400) + 870 at initsplan.c:781 frame #6: 0x000000010e1548ab postgres`deconstruct_recurse(root=0x00007fd5c382c248, jtnode=0x00007fd5c382bfd8, below_outer_join='\0', qualscope=0x00007fff51c72450, inner_join_rels=0x00007fff51c72448, postponed_qual_list=0x00007fff51c72440) + 427 at initsplan.c:732 frame #7: 0x000000010e1546a1 postgres`deconstruct_jointree(root=<unavailable>) + 81 at initsplan.c:655 frame #8: 0x000000010e156a1b postgres`query_planner(root=0x00007fd5c382c248, tlist=0x00007fd5c382e398, qp_callback=0x000000010e15a660, qp_extra=0x00007fff51c725f0) + 219 at planmain.c:145 frame #9: 0x000000010e1589d8 postgres`grouping_planner(root=0x00007fd5c382c248, tuple_fraction=<unavailable>) + 2888 at planner.c:1243 frame #10: 0x000000010e157adf postgres`subquery_planner(glob=0x00007fd5c4007e68, parse=0x00007fd5c4007a30, parent_root=<unavailable>, hasRecursion=<unavailable>, tuple_fraction=0, subroot=0x00007fff51c72900) + 3119 at planner.c:572 frame #11: 0x000000010e156cac postgres`standard_planner(parse=0x00007fd5c4007a30, cursorOptions=<unavailable>, boundParams=<unavailable>) + 236 at planner.c:210 frame #12: 0x000000010e1d6356 postgres`pg_plan_query(querytree=0x00007fd5c4007a30, cursorOptions=0, boundParams=0x0000000000000000) + 118 at postgres.c:759 frame #13: 0x000000010e1d979a postgres`PostgresMain [inlined] pg_plan_queries(cursorOptions=0, querytrees=<unavailable>, boundParams=<unavailable>) + 56 at postgres.c:818 frame #14: 0x000000010e1d9762 postgres`PostgresMain [inlined] exec_simple_query(query_string=0x00007fd5c4006038) + 21 at postgres.c:983 frame #15: 0x000000010e1d974d postgres`PostgresMain(argc=<unavailable>, argv=<unavailable>, dbname=0x00007fd5c301ac30, username=<unavailable>) + 8749 at postgres.c:4011 frame #16: 0x000000010e184c1f postgres`PostmasterMain [inlined] BackendRun + 7551 at postmaster.c:4085 frame #17: 0x000000010e184c00 postgres`PostmasterMain [inlined] BackendStartup at postmaster.c:3774 frame #18: 0x000000010e184c00 postgres`PostmasterMain [inlined] ServerLoop at postmaster.c:1585 frame #19: 0x000000010e184c00 postgres`PostmasterMain(argc=<unavailable>, argv=<unavailable>) + 7520 at postmaster.c:1240 frame #20: 0x000000010e11924f postgres`main(argc=1, argv=0x00007fd5c2c03ec0) + 783 at main.c:194 frame #21: 0x00007fff897165fd libdyld.dylib`start + 1 frame #22: 0x00007fff897165fdlibdyld.dylib`start + 1
pgsql-hackers by date: