#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 set = {__val = {4194304, 140736805622640, 2, 6, 6666556, 94745029079040, 4611686018427388799, 139894076431014, 0, 281470681751456, 0, 0, 0, 0, 0, 0}} pid = tid = ret = #1 0x00007f3ba0830535 in __GI_abort () at abort.c:79 save_stage = 1 act = {__sigaction_handler = {sa_handler = 0x0, sa_sigaction = 0x0}, sa_mask = {__val = { 0, 0, 0, 0, 0, 139894074187765, 2, 7075777569425871984, 7003713384980111928, 94745029079040, 7003719963994515424, 0, 9449567279706640128, 140736805622880, 0, 140736805623744}}, sa_flags = -1949470720, sa_restorer = 0x0} sigs = {__val = {32, 0 }} #2 0x0000562b8c3818a0 in ExceptionalCondition ( conditionName=0x562b8c527e38 "!bms_overlap(baserel->relids, required_outer)", errorType=0x562b8c527a26 "FailedAssertion", fileName=0x562b8c527abf "relnode.c", lineNumber=1313) at assert.c:69 No locals. #3 0x0000562b8c0ef355 in get_baserel_parampathinfo (root=0x562b8d3ebd00, baserel=0x562b8d3e8ec0, required_outer=0x562b8d40e350) at relnode.c:1313 ppi = 0x562b8d3e8ec0 joinrelids = 0x562b8d40f468 pclauses = 0x562b8d40e490 rows = 6.9533220764192298e-310 lc = 0x562b8d40f4c0 #4 0x0000562b8c0debbd in create_append_path (root=0x562b8d3ebd00, rel=0x562b8d3e8ec0, subpaths=0x562b8d40f468, partial_subpaths=0x0, pathkeys=0x0, required_outer=0x562b8d40e350, parallel_workers=0, parallel_aware=false, rows=-1) at pathnode.c:1270 pathnode = 0x562b8d40f4c0 l = 0x0 #5 0x0000562b8c06ff7c in add_paths_to_append_rel (root=0x562b8d3ebd00, rel=0x562b8d3e8ec0, live_childrels=0x562b8d40f060) at allpaths.c:1610 required_outer = 0x562b8d40e350 lcr = 0x0 l__state = {l = 0x562b8d40f1c0, i = 0} subpaths = 0x562b8d40f468 subpaths_valid = true partial_subpaths = 0x562b8d40f110 pa_partial_subpaths = 0x562b8d40f168 pa_nonpartial_subpaths = 0x0 partial_subpaths_valid = true pa_subpaths_valid = true all_child_pathkeys = 0x0 all_child_outers = 0x562b8d40f1c0 l = 0x562b8d40f1d8 partial_rows = 500 #6 0x0000562b8c06f47b in set_append_rel_pathlist (root=0x562b8d3ebd00, rel=0x562b8d3e8ec0, rti=4, rte=0x562b8d3e7df0) at allpaths.c:1269 parentRTindex = 4 live_childrels = 0x562b8d40f060 l = 0x0 #7 0x0000562b8c06e33a in set_rel_pathlist (root=0x562b8d3ebd00, rel=0x562b8d3e8ec0, rti=4, rte=0x562b8d3e7df0) at allpaths.c:481 __func__ = "set_rel_pathlist" #8 0x0000562b8c06e023 in set_base_rel_pathlists (root=0x562b8d3ebd00) at allpaths.c:353 rel = 0x562b8d3e8ec0 rti = 4 #9 0x0000562b8c06dd72 in make_one_rel (root=0x562b8d3ebd00, joinlist=0x562b8d40c8a8) at allpaths.c:223 rel = 0x8d3ebd00 rti = 6 total_pages = 20 #10 0x0000562b8c0aab06 in query_planner (root=0x562b8d3ebd00, qp_callback=0x562b8c0b07c1 , qp_extra=0x7fffd74e5cc0) at planmain.c:276 parse = 0x562b8d3e72f0 joinlist = 0x562b8d40c8a8 final_rel = 0x562b8d3ed520 __func__ = "query_planner" #11 0x0000562b8c0ad2bf in grouping_planner (root=0x562b8d3ebd00, tuple_fraction=0) at planner.c:1447 sort_input_targets = 0x562b8d3edec8 sort_input_target_parallel_safe = false grouping_target = 0x562b8d3ebc70 scanjoin_target = 0x562b8d3edc40 activeWindows = 0x0 qp_extra = {activeWindows = 0x0, groupClause = 0x0} sort_input_targets_contain_srfs = 0x0 have_grouping = false wflists = 0x0 gset_data = 0x0 sort_input_target = 0x562b8d3edc98 grouping_targets = 0x562b8c017eee grouping_target_parallel_safe = false scanjoin_targets = 0x562b8d315790 scanjoin_target_parallel_safe = false grouping_targets_contain_srfs = 0x7fffd74e5d00 scanjoin_targets_contain_srfs = 0x0 scanjoin_target_same_exprs = false parse = 0x562b8d3e72f0 offset_est = 0 count_est = 0 limit_tuples = -1 have_postponed_srfs = false final_target = 0x7fffd74e5e50 final_targets = 0x562b8d3ebd00 final_targets_contain_srfs = 0x0 final_target_parallel_safe = false current_rel = 0x7fffd74e5e50 final_rel = 0x7fffd74e5d90 extra = {limit_needed = 32, limit_tuples = 4.681026602567763e-310, count_est = 0, offset_est = 0} lc = 0x0 __func__ = "grouping_planner" #12 0x0000562b8c0ac966 in subquery_planner (glob=0x562b8d3e91f0, parse=0x562b8d3e72f0, parent_root=0x0, hasRecursion=false, tuple_fraction=0) at planner.c:1025 root = 0x562b8d3ebd00 newWithCheckOptions = 0x0 newHaving = 0x0 hasOuterJoins = true hasResultRTEs = false final_rel = 0x93f900003457 l = 0x0 #13 0x0000562b8c0ab153 in standard_planner (parse=0x562b8d3e72f0, query_string=0x562b8d3158b0 "select \n 1 as c0\nfrom \n\t(select null::integer as c9, \n\t ref_0.a as c24\n\t from fkpart3_pk5 as ref_0\n \t) as subq_0\n \tright join public.inet_tbl as sample_0 on (cast(null as cidr) ="..., cursorOptions=2048, boundParams=0x0) at planner.c:406 result = 0x562b8c3bf3ba glob = 0x562b8d3e91f0 tuple_fraction = 0 root = 0x562b8c038659 final_rel = 0x7fffd74e6070 best_path = 0x562b8d3ebca8 top_plan = 0x7fffd74e6100 lp = 0x562b8d3e8880 lr = 0x562b8c038170 #14 0x0000562b8c0aaf08 in planner (parse=0x562b8d3e72f0, query_string=0x562b8d3158b0 "select \n 1 as c0\nfrom \n\t(select null::integer as c9, \n\t ref_0.a as c24\n\t from fkpart3_pk5 as ref_0\n \t) as subq_0\n \tright join public.inet_tbl as sample_0 on (cast(null as cidr) ="..., cursorOptions=2048, boundParams=0x0) at planner.c:277 result = 0x562b8d3e72f0 #15 0x0000562b8c1e5528 in pg_plan_query (querytree=0x562b8d3e72f0, query_string=0x562b8d3158b0 "select \n 1 as c0\nfrom \n\t(select null::integer as c9, \n\t ref_0.a as c24\n\t from fkpart3_pk5 as ref_0\n \t) as subq_0\n \tright join public.inet_tbl as sample_0 on (cast(null as cidr) ="..., cursorOptions=2048, boundParams=0x0) at postgres.c:847 plan = 0xe88c1e5459 #16 0x0000562b8c1e5672 in pg_plan_queries (querytrees=0x562b8d3ebca8, query_string=0x562b8d3158b0 "select \n 1 as c0\nfrom \n\t(select null::integer as c9, \n\t ref_0.a as c24\n\t from fkpart3_pk5 as ref_0\n \t) as subq_0\n \tright join public.inet_tbl as sample_0 on (cast(null as cidr) ="..., cursorOptions=2048, boundParams=0x0) at postgres.c:939 query = 0x562b8d3e72f0 stmt = 0x562b8d317548 query_list__state = {l = 0x562b8d3ebca8, i = 0} stmt_list = 0x0 query_list = 0x562b8d3ebcc0 #17 0x0000562b8c1e59e4 in exec_simple_query ( query_string=0x562b8d3158b0 "select \n 1 as c0\nfrom \n\t(select null::integer as c9, \n\t ref_0.a as c24\n\t from fkpart3_pk5 as ref_0\n \t) as subq_0\n \tright join public.inet_tbl as sample_0 on (cast(null as cidr) ="...) at postgres.c:1133 snapshot_set = true per_parsetree_context = 0x0 plantree_list = 0x562b8bcd7000 <_start> parsetree = 0x562b8d317548 commandTag = CMDTAG_SELECT qc = {commandTag = 3612238320, nprocessed = 94745036175053} querytree_list = 0x562b8d3ebca8 portal = 0x0 receiver = 0x562b8c39a5c7 format = 0 parsetree_item__state = {l = 0x562b8d317580, i = 0} dest = DestRemote oldcontext = 0x562b8d3d6f40 parsetree_list = 0x562b8d317580 parsetree_item = 0x562b8d317598 save_log_statement_stats = false was_logged = false use_implicit_block = false msec_str = "\260X1\215+V\000\000\352\000\000\000\006\000\000\000\000bN\327\377\177\000\000PD\001\214\352\000\000" __func__ = "exec_simple_query" #18 0x0000562b8c1ea328 in PostgresMain (argc=1, argv=0x7fffd74e6440, dbname=0x562b8d342420 "postgres", username=0x562b8d3423f8 "jcasanov") at postgres.c:4486 query_string = 0x562b8d3158b0 "select \n 1 as c0\nfrom \n\t(select null::integer as c9, \n\t ref_0.a as c24\n\t from fkpart3_pk5 as ref_0\n \t) as subq_0\n \tright join public.inet_tbl as sample_0 on (cast(null as cidr) ="... firstchar = 81 input_message = { data = 0x562b8d3158b0 "select \n 1 as c0\nfrom \n\t(select null::integer as c9, \n\t ref_0.a as c24\n\t from fkpart3_pk5 as ref_0\n \t) as subq_0\n \tright join public.inet_tbl as sample_0 on (cast(null as cidr) ="..., len = 235, maxlen = 1024, cursor = 235} local_sigjmp_buf = {{__jmpbuf = {0, 4442582095491262338, 94745029079040, 140736805627872, 0, 0, 4442582095537399682, 7930713879476856706}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1099511627520, 0, 0, 4294901760, 18446462598732840960, 0}}}} send_ready_for_query = false idle_in_transaction_timeout_enabled = false idle_session_timeout_enabled = false __func__ = "PostgresMain" #19 0x0000562b8c11fc30 in BackendRun (port=0x562b8d33bd10) at postmaster.c:4521 av = {0x562b8c52f6ff "postgres", 0x0} ac = 1 #20 0x0000562b8c11f55f in BackendStartup (port=0x562b8d33bd10) at postmaster.c:4243 bn = 0x562b8d33ba60 pid = 0 __func__ = "BackendStartup" #21 0x0000562b8c11b8b0 in ServerLoop () at postmaster.c:1765 port = 0x562b8d33bd10 i = 2 rmask = {fds_bits = {128, 0 }} selres = 1 now = 1631745784 readmask = {fds_bits = {224, 0 }} nSockets = 8 last_lockfile_recheck_time = 1631745754 last_touch_time = 1631745446 __func__ = "ServerLoop" #22 0x0000562b8c11b0ff in PostmasterMain (argc=3, argv=0x562b8d30eec0) at postmaster.c:1437 opt = -1 status = 0 userDoption = 0x562b8d3327d0 "data" listen_addr_saved = true i = 64 output_config_variable = 0x0 __func__ = "PostmasterMain" #23 0x0000562b8c0176be in main (argc=3, argv=0x562b8d30eec0) at main.c:199 do_check_root = true