Re: pg11.1: dsa_area could not attach to segment - Mailing list pgsql-hackers

And here's the "dsa_allocate could not find %zu free pages" error with core.

@@ -726,5 +728,5 @@ dsa_allocate_extended(dsa_area *area, size_t size, int flags)
                 */
-               if (!FreePageManagerGet(segment_map->fpm, npages, &first_page))
-                       elog(FATAL,
-                                "dsa_allocate could not find %zu free pages", npages);
+               assert (FreePageManagerGet(segment_map->fpm, npages, &first_page));
+
+               // if (!FreePageManagerGet(segment_map->fpm, npages, &first_page)) elog(PANIC, "dsa_allocate could not
find%zu free pages", npages);
 
                LWLockRelease(DSA_AREA_LOCK(area));

< 2019-02-05 13:23:29.137 EST  >LOG:  background worker "parallel worker" (PID 7140) was terminated by signal 6:
Aborted
< 2019-02-05 13:23:29.137 EST  >DETAIL:  Failed process was running: explain analyze SELECT * FROM eric_enodeb_metrics
WHEREstart_time>='2017-10-01' AND (site_id<1900 OR site_id>2700)
 

#0  0x00000037b9c32495 in raise () from /lib64/libc.so.6
#1  0x00000037b9c33c75 in abort () from /lib64/libc.so.6
#2  0x00000037b9c2b60e in __assert_fail_base () from /lib64/libc.so.6
#3  0x00000037b9c2b6d0 in __assert_fail () from /lib64/libc.so.6
#4  0x00000000008c6f74 in dsa_allocate_extended (area=0x27c05e0, size=393220, flags=5) at dsa.c:729
#5  0x000000000068521f in pagetable_allocate (pagetable=<value optimized out>, size=<value optimized out>) at
tidbitmap.c:1511
#6  0x00000000006876d2 in pagetable_grow (tbm=0x7f84a8d86a58, pageno=1635) at
../../../src/include/lib/simplehash.h:383
#7  pagetable_insert (tbm=0x7f84a8d86a58, pageno=1635) at ../../../src/include/lib/simplehash.h:508
#8  tbm_get_pageentry (tbm=0x7f84a8d86a58, pageno=1635) at tidbitmap.c:1225
#9  0x0000000000687c50 in tbm_add_tuples (tbm=0x7f84a8d86a58, tids=<value optimized out>, ntids=1, recheck=false) at
tidbitmap.c:405
#10 0x00000000004e43df in btgetbitmap (scan=0x2829fa8, tbm=0x7f84a8d86a58) at nbtree.c:332
#11 0x00000000004d8a91 in index_getbitmap (scan=0x2829fa8, bitmap=<value optimized out>) at indexam.c:726
#12 0x0000000000647c98 in MultiExecBitmapIndexScan (node=0x2829720) at nodeBitmapIndexscan.c:104
#13 0x0000000000646078 in MultiExecBitmapOr (node=0x28046e8) at nodeBitmapOr.c:153
#14 0x0000000000646afd in BitmapHeapNext (node=0x2828db8) at nodeBitmapHeapscan.c:145
#15 0x000000000063a550 in ExecScanFetch (node=0x2828db8, accessMtd=0x6469e0 <BitmapHeapNext>, recheckMtd=0x646740
<BitmapHeapRecheck>)at execScan.c:95
 
#16 ExecScan (node=0x2828db8, accessMtd=0x6469e0 <BitmapHeapNext>, recheckMtd=0x646740 <BitmapHeapRecheck>) at
execScan.c:162
#17 0x0000000000638ce0 in ExecProcNodeInstr (node=0x2828db8) at execProcnode.c:461
#18 0x00000000006414fc in ExecProcNode (pstate=<value optimized out>) at ../../../src/include/executor/executor.h:237
#19 ExecAppend (pstate=<value optimized out>) at nodeAppend.c:294
#20 0x0000000000638ce0 in ExecProcNodeInstr (node=0x27cb0a0) at execProcnode.c:461
#21 0x00000000006349c7 in ExecProcNode (queryDesc=0x7f84a8de7520, direction=<value optimized out>, count=0,
execute_once=160)at ../../../src/include/executor/executor.h:237
 
#22 ExecutePlan (queryDesc=0x7f84a8de7520, direction=<value optimized out>, count=0, execute_once=160) at
execMain.c:1723
#23 standard_ExecutorRun (queryDesc=0x7f84a8de7520, direction=<value optimized out>, count=0, execute_once=160) at
execMain.c:364
#24 0x00007f84a97c8618 in pgss_ExecutorRun (queryDesc=0x7f84a8de7520, direction=ForwardScanDirection, count=0,
execute_once=true)at pg_stat_statements.c:892
 
#25 0x00007f84a91aa7dd in explain_ExecutorRun (queryDesc=0x7f84a8de7520, direction=ForwardScanDirection, count=0,
execute_once=true)at auto_explain.c:268
 
#26 0x0000000000635071 in ParallelQueryMain (seg=0x268fba8, toc=0x7f84a93ed000) at execParallel.c:1402
#27 0x0000000000508f34 in ParallelWorkerMain (main_arg=<value optimized out>) at parallel.c:1409
#28 0x0000000000704760 in StartBackgroundWorker () at bgworker.c:834
#29 0x000000000070e11c in do_start_bgworker () at postmaster.c:5698
#30 maybe_start_bgworkers () at postmaster.c:5911
#31 0x0000000000710786 in sigusr1_handler (postgres_signal_arg=<value optimized out>) at postmaster.c:5091
#32 <signal handler called>
#33 0x00000037b9ce1603 in __select_nocancel () from /lib64/libc.so.6
#34 0x000000000071300e in ServerLoop (argc=<value optimized out>, argv=<value optimized out>) at postmaster.c:1670
#35 PostmasterMain (argc=<value optimized out>, argv=<value optimized out>) at postmaster.c:1379
#36 0x000000000067e8c0 in main (argc=3, argv=0x265f960) at main.c:228

#0  0x00000037b9c32495 in raise () from /lib64/libc.so.6
No symbol table info available.
#1  0x00000037b9c33c75 in abort () from /lib64/libc.so.6
No symbol table info available.
#2  0x00000037b9c2b60e in __assert_fail_base () from /lib64/libc.so.6
No symbol table info available.
#3  0x00000037b9c2b6d0 in __assert_fail () from /lib64/libc.so.6
No symbol table info available.
#4  0x00000000008c6f74 in dsa_allocate_extended (area=0x27c05e0, size=393220, flags=5) at dsa.c:729
        npages = 97
        first_page = <value optimized out>
        span_pointer = 1099511632488
        pool = 0x7f84a93eecf0
        size_class = <value optimized out>
        start_pointer = <value optimized out>
        segment_map = <value optimized out>
        result = 140207751879680
        __func__ = "dsa_allocate_extended"
        __PRETTY_FUNCTION__ = "dsa_allocate_extended"
#5  0x000000000068521f in pagetable_allocate (pagetable=<value optimized out>, size=<value optimized out>) at
tidbitmap.c:1511
        tbm = 0x7f84a8d86a58
        ptbase = <value optimized out>
#6  0x00000000006876d2 in pagetable_grow (tbm=0x7f84a8d86a58, pageno=1635) at
../../../src/include/lib/simplehash.h:383
        olddata = 0x7f84a8d23004
        i = <value optimized out>
        copyelem = <value optimized out>
        startelem = 0
        oldsize = <value optimized out>
        newdata = <value optimized out>
#7  pagetable_insert (tbm=0x7f84a8d86a58, pageno=1635) at ../../../src/include/lib/simplehash.h:508
        hash = 218584604
        startelem = <value optimized out>
        curelem = <value optimized out>
        data = <value optimized out>
        insertdist = 0
#8  tbm_get_pageentry (tbm=0x7f84a8d86a58, pageno=1635) at tidbitmap.c:1225
        page = <value optimized out>
        found = <value optimized out>
#9  0x0000000000687c50 in tbm_add_tuples (tbm=0x7f84a8d86a58, tids=<value optimized out>, ntids=1, recheck=false) at
tidbitmap.c:405
        blk = <value optimized out>
        off = 14
        wordnum = <value optimized out>
        bitnum = <value optimized out>
        currblk = <value optimized out>
        page = <value optimized out>
        i = <value optimized out>
        __func__ = "tbm_add_tuples"
#10 0x00000000004e43df in btgetbitmap (scan=0x2829fa8, tbm=0x7f84a8d86a58) at nbtree.c:332
        so = 0x2843c90
        ntids = 5842
        heapTid = <value optimized out>
#11 0x00000000004d8a91 in index_getbitmap (scan=0x2829fa8, bitmap=<value optimized out>) at indexam.c:726
        ntids = <value optimized out>
        __func__ = "index_getbitmap"
#12 0x0000000000647c98 in MultiExecBitmapIndexScan (node=0x2829720) at nodeBitmapIndexscan.c:104
        tbm = 0x7f84a8d86a58
        scandesc = 0x2829fa8
        nTuples = <value optimized out>
        doscan = <value optimized out>
#13 0x0000000000646078 in MultiExecBitmapOr (node=0x28046e8) at nodeBitmapOr.c:153
        subnode = 0x2829720
        subresult = <value optimized out>
        bitmapplans = <value optimized out>
        nplans = 2
        i = <value optimized out>
        result = 0x7f84a8d86a58
        __func__ = "MultiExecBitmapOr"
#14 0x0000000000646afd in BitmapHeapNext (node=0x2828db8) at nodeBitmapHeapscan.c:145
        econtext = 0x2828b08
        scan = 0x282d808
        tbm = <value optimized out>
        tbmiterator = 0x0
        shared_tbmiterator = 0x0
        tbmres = <value optimized out>
        targoffset = <value optimized out>
        slot = 0x282a888
        pstate = 0x7f84a93eda40
        dsa = 0x27c05e0
        __func__ = "BitmapHeapNext"

Justin