---------- cores/core.32064
Core was generated by `postgres: parallel worker for PID 31747         '.
Program terminated with signal SIGABRT, Aborted.
#0  __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at pthread_kill.c:44
44	      return INTERNAL_SYSCALL_ERROR_P (ret) ? INTERNAL_SYSCALL_ERRNO (ret) : 0;
#0  __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at pthread_kill.c:44
#1  0x00007e40aecf4cb3 in __pthread_kill_internal (signo=6, threadid=<optimized out>) at pthread_kill.c:78
#2  0x00007e40aeca49c6 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
#3  0x00007e40aec8e7f4 in __GI_abort () at abort.c:79
#4  0x0000000000c9eb36 in errfinish (filename=0xe6aea8 "s_lock.c", lineno=84, funcname=0xe6aeb1 "s_lock_stuck") at elog.c:677
#5  0x0000000000a85cb0 in s_lock_stuck (file=0xe68c8c "lwlock.c", line=907, func=0xe690a1 "LWLockWaitListLock") at s_lock.c:83
#6  0x0000000000a85a8d in perform_spin_delay (status=0x7ffd8758b8e8) at s_lock.c:134
#7  0x0000000000a771c3 in LWLockWaitListLock (lock=0x7e40a597c060) at lwlock.c:911
#8  0x0000000000a76e93 in LWLockConflictsWithVar (lock=0x7e40a597c060, valptr=0x7e40a597c048, oldval=1, newval=0x7e40a597c048, result=0x7ffd8758b983) at lwlock.c:1580
#9  0x0000000000a76ce9 in LWLockWaitForVar (lock=0x7e40a597c060, valptr=0x7e40a597c048, oldval=1, newval=0x7e40a597c048) at lwlock.c:1638
#10 0x000000000080aa55 in SemiJoinFilterFinishScan (semiJoinFilters=0x2e349b0, tableId=1253696, parallel_area=0x2e17388) at nodeMergejoin.c:2035
#11 0x00000000007cec8b in ExecScan (node=0x2e21ea8, accessMtd=0x818d90 <SeqNext>, recheckMtd=0x818e50 <SeqRecheck>) at execScan.c:216
#12 0x000000000081837b in ExecSeqScan (pstate=0x2e21ea8) at nodeSeqscan.c:121
#13 0x000000000081ae32 in ExecProcNode (node=0x2e21ea8) at ../../../src/include/executor/executor.h:259
#14 0x000000000081a6c4 in ExecSort (pstate=0x2e22420) at nodeSort.c:135
#15 0x00000000007ca405 in ExecProcNodeFirst (node=0x2e22420) at execProcnode.c:464
#16 0x000000000080ae92 in ExecProcNode (node=0x2e22420) at ../../../src/include/executor/executor.h:259
#17 0x0000000000808cff in ExecMergeJoin (pstate=0x2e21768) at nodeMergejoin.c:663
#18 0x00000000007ca405 in ExecProcNodeFirst (node=0x2e21768) at execProcnode.c:464
#19 0x00000000007e20b2 in ExecProcNode (node=0x2e21768) at ../../../src/include/executor/executor.h:259
#20 0x00000000007e1d28 in fetch_input_tuple (aggstate=0x2e21978) at nodeAgg.c:562
---------- cores/core.33882
Core was generated by `postgres: user test [local] SELECT              '.
Program terminated with signal SIGABRT, Aborted.
#0  __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at pthread_kill.c:44
44	      return INTERNAL_SYSCALL_ERROR_P (ret) ? INTERNAL_SYSCALL_ERRNO (ret) : 0;
#0  __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at pthread_kill.c:44
#1  0x00007e40aecf4cb3 in __pthread_kill_internal (signo=6, threadid=<optimized out>) at pthread_kill.c:78
#2  0x00007e40aeca49c6 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
#3  0x00007e40aec8e7f4 in __GI_abort () at abort.c:79
#4  0x0000000000c9d56b in ExceptionalCondition (conditionName=0xe43724 "inner_overlapping_ratio >= 0 && inner_overlapping_ratio <= 1", errorType=0xd33069 "FailedAssertion", fileName=0xe42bdb "costsize.c", lineNumber=7442) at assert.c:69
#5  0x00000000008ed767 in evaluate_semijoin_filtering_rate (join_path=0x2fe79f0, equijoin_list=0x2fea6c0, root=0x2fe6b68, workspace=0x7ffd87588a78, best_clause=0x7ffd875888cc, rows_filtered=0x7ffd875888c8) at costsize.c:7442
#6  0x00000000008eca19 in final_cost_mergejoin (root=0x2fe6b68, path=0x2fe79f0, workspace=0x7ffd87588a78, extra=0x7ffd87588ce8) at costsize.c:3908
#7  0x000000000096655d in create_mergejoin_path (root=0x2fe6b68, joinrel=0x2fe8730, jointype=JOIN_INNER, workspace=0x7ffd87588a78, extra=0x7ffd87588ce8, outer_path=0x2fe7ef0, inner_path=0x2fe8fa8, restrict_clauses=0x2fe9508, pathkeys=0x0, required_outer=0x0, mergeclauses=0x2fe97a0, outersortkeys=0x2fe9700, innersortkeys=0x2fe97f0) at pathnode.c:2558
#8  0x0000000000903d88 in try_mergejoin_path (root=0x2fe6b68, joinrel=0x2fe8730, outer_path=0x2fe7ef0, inner_path=0x2fe8fa8, pathkeys=0x0, mergeclauses=0x2fe97a0, outersortkeys=0x2fe9700, innersortkeys=0x2fe97f0, jointype=JOIN_INNER, extra=0x7ffd87588ce8, is_partial=false) at joinpath.c:887
#9  0x0000000000902815 in sort_inner_and_outer (root=0x2fe6b68, joinrel=0x2fe8730, outerrel=0x2fe7550, innerrel=0x2fe7c40, jointype=JOIN_INNER, extra=0x7ffd87588ce8) at joinpath.c:1300
#10 0x0000000000901f72 in add_paths_to_joinrel (root=0x2fe6b68, joinrel=0x2fe8730, outerrel=0x2fe7550, innerrel=0x2fe7c40, jointype=JOIN_INNER, sjinfo=0x7ffd87588dd8, restrictlist=0x2fe9508) at joinpath.c:280
#11 0x00000000009073a3 in populate_joinrel_with_paths (root=0x2fe6b68, rel1=0x2fe7550, rel2=0x2fe7c40, joinrel=0x2fe8730, sjinfo=0x7ffd87588dd8, restrictlist=0x2fe9508) at joinrels.c:807
#12 0x00000000009069b2 in make_join_rel (root=0x2fe6b68, rel1=0x2fe7550, rel2=0x2fe7c40) at joinrels.c:760
#13 0x00000000009062f4 in make_rels_by_clause_joins (root=0x2fe6b68, old_rel=0x2fe7550, other_rels_list=0x2fe9088, other_rels=0x2fe90a8) at joinrels.c:312
#14 0x0000000000905a43 in join_search_one_level (root=0x2fe6b68, level=2) at joinrels.c:123
#15 0x00000000008df2ab in standard_join_search (root=0x2fe6b68, levels_needed=2, initial_rels=0x2fe9088) at allpaths.c:3414
#16 0x00000000008dce98 in make_rel_from_joinlist (root=0x2fe6b68, joinlist=0x2fe8600) at allpaths.c:3345
#17 0x00000000008dc938 in make_one_rel (root=0x2fe6b68, joinlist=0x2fe8600) at allpaths.c:231
#18 0x0000000000927632 in query_planner (root=0x2fe6b68, qp_callback=0x92e170 <standard_qp_callback>, qp_extra=0x7ffd87589368) at planmain.c:278
#19 0x000000000092aa51 in grouping_planner (root=0x2fe6b68, tuple_fraction=0) at planner.c:1469
#20 0x0000000000929507 in subquery_planner (glob=0x2ff0a60, parse=0x2fe8dd8, parent_root=0x0, hasRecursion=false, tuple_fraction=0) at planner.c:1046