Обсуждение: BUG #14997: Get segmentation fault on select sum(bigint_field)

Поиск
Список
Период
Сортировка

BUG #14997: Get segmentation fault on select sum(bigint_field)

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      14997
Logged by:          Sergey Levchenko
Email address:      sector119@gmail.com
PostgreSQL version: 10.1
Operating system:   Debian 4.13.13-1 x86_64
Description:

I get :

2018-01-03 14:08:18 EET LOG:  server process (PID 17415) was terminated by
signal 11: Segmentation fault                          
2018-01-03 14:08:18 EET DETAIL:  Failed process was running: select sum(sum)
from ternopil.offices_documents where commit_date between '2017-06-01' and
'2017-12-31'; 

epsdev=# select sum(sum) from ternopil.offices_documents where commit_date
between '2017-06-01' and '2017-12-31';
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!> 

But it works on small amount of data
epsdev=# select sum(sum) from ternopil.offices_documents where commit_date
between '2017-12-01' and '2017-12-31';
    sum    
-----------
 390815317
(1 row)


And it also works on the same big amount of data if I convert field to
::int
epsdev=# select sum(sum::int) from ternopil.offices_documents where
commit_date between '2017-06-01' and '2017-12-31';
     sum     
-------------
 44362344738
(1 row)




Here is backtrace:

Continuing.

Program received signal SIGUSR1, User defined signal 1.
0x000055bec266e550 in memcpy (__len=48, __src=0x7f159c37b174,
__dest=0x7f159c37b1a4) at /usr/include/x86_64-linux-gnu/bits/string3.h:53
warning: Source file is more recent than executable.
53      return __builtin___memcpy_chk (__dest, __src, __len, __bos0
(__dest));
Continuing.

Program received signal SIGUSR1, User defined signal 1.
0x000055bec266e550 in memcpy (__len=48, __src=0x7f159c37b174,
__dest=0x7f159c37b1a4) at /usr/include/x86_64-linux-gnu/bits/string3.h:53
53      return __builtin___memcpy_chk (__dest, __src, __len, __bos0
(__dest));
Continuing.

Program received signal SIGSEGV, Segmentation fault.
int8_avg_combine (fcinfo=0x55bec3fdbc28) at
./build/../src/backend/utils/adt/numeric.c:4285
4285    ./build/../src/backend/utils/adt/numeric.c: No such file or
directory.
Continuing.

Program terminated with signal SIGSEGV, Segmentation fault.
The program no longer exists.
The program is not being run.
quit
Breakpoint 1 at 0x55bec286c380: file
./build/../src/backend/utils/error/elog.c, line 414.
Continuing.

Program received signal SIGUSR1, User defined signal 1.
0x000055bec266e263 in pagetable_insert (found=<synthetic pointer>,
key=50333, tb=0x55bec3fdfae8) at
./build/../src/include/lib/simplehash.h:517
517    ./build/../src/include/lib/simplehash.h: No such file or directory.
Continuing.

Program received signal SIGUSR1, User defined signal 1.
0x000055bec266e263 in pagetable_insert (found=<synthetic pointer>,
key=50333, tb=0x55bec3fdfae8) at
./build/../src/include/lib/simplehash.h:517
517    in ./build/../src/include/lib/simplehash.h
Continuing.

Program received signal SIGSEGV, Segmentation fault.
int8_avg_combine (fcinfo=0x55bec3fd90f8) at
./build/../src/backend/utils/adt/numeric.c:4285
4285    ./build/../src/backend/utils/adt/numeric.c: No such file or
directory.
Continuing.

Program terminated with signal SIGSEGV, Segmentation fault.
The program no longer exists.
The program is not being run.
No stack.
quit
Breakpoint 1 at 0x55bec286c380: file
./build/../src/backend/utils/error/elog.c, line 414.
Continuing.

Program received signal SIGUSR1, User defined signal 1.
pagetable_insert (found=<synthetic pointer>, key=50334, tb=0x55bec3fe2618)
at ./build/../src/include/lib/simplehash.h:540
540    ./build/../src/include/lib/simplehash.h: No such file or directory.
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
quit
Not confirmed.
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
#0  pagetable_insert (found=<synthetic pointer>, key=50334,
tb=0x55bec3fe2618) at ./build/../src/include/lib/simplehash.h:540
#1  tbm_get_pageentry (tbm=tbm@entry=0x55bec3fe24a8,
pageno=pageno@entry=50334) at
./build/../src/backend/nodes/tidbitmap.c:1252
#2  0x000055bec266e9f0 in tbm_add_tuples (tbm=tbm@entry=0x55bec3fe24a8,
tids=<optimized out>, ntids=ntids@entry=1, recheck=recheck@entry=0 '\000')
at ./build/../src/backend/nodes/tidbitmap.c:432
#3  0x000055bec24ea2a0 in btgetbitmap (scan=0x55bec3fd66f0,
tbm=0x55bec3fe24a8) at ./build/../src/backend/access/nbtree/nbtree.c:459
#4  0x000055bec24e4722 in index_getbitmap (scan=scan@entry=0x55bec3fd66f0,
bitmap=bitmap@entry=0x55bec3fe24a8) at
./build/../src/backend/access/index/indexam.c:726
#5  0x000055bec2634db6 in MultiExecBitmapIndexScan (node=0x55bec3fd6440) at
./build/../src/backend/executor/nodeBitmapIndexscan.c:104
#6  0x000055bec26277ee in MultiExecProcNode (node=<optimized out>) at
./build/../src/backend/executor/execProcnode.c:490
#7  0x000055bec263426b in BitmapHeapNext (node=node@entry=0x55bec3fd4778) at
./build/../src/backend/executor/nodeBitmapHeapscan.c:144
#8  0x000055bec26288b7 in ExecScanFetch (recheckMtd=0x55bec2633a50
<BitmapHeapRecheck>, accessMtd=0x55bec2633ae0 <BitmapHeapNext>,
node=0x55bec3fd4778) at ./build/../src/backend/executor/execScan.c:97
#9  ExecScan (node=0x55bec3fd4778, accessMtd=0x55bec2633ae0
<BitmapHeapNext>, recheckMtd=0x55bec2633a50 <BitmapHeapRecheck>) at
./build/../src/backend/executor/execScan.c:164
#10 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd4778) at
./build/../src/include/executor/executor.h:250
#11 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:695
#12 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2336
#13 ExecAgg (pstate=0x55bec3fd4130) at
./build/../src/backend/executor/nodeAgg.c:2147
#14 0x000055bec2636154 in ExecProcNode (node=0x55bec3fd4130) at
./build/../src/include/executor/executor.h:250
#15 gather_getnext (gatherstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:281
#16 ExecGather (pstate=0x55bec3fd3e10) at
./build/../src/backend/executor/nodeGather.c:215
#17 0x000055bec262e9ec in ExecProcNode (node=0x55bec3fd3e10) at
./build/../src/include/executor/executor.h:250
#18 fetch_input_tuple (aggstate=aggstate@entry=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:695
#19 0x000055bec2630ca8 in agg_retrieve_direct (aggstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2336
#20 ExecAgg (pstate=0x55bec3fd3768) at
./build/../src/backend/executor/nodeAgg.c:2147
#21 0x000055bec2622a15 in ExecProcNode (node=0x55bec3fd3768) at
./build/../src/include/executor/executor.h:250
#22 ExecutePlan (execute_once=<optimized out>, dest=0x55bec3fcd388,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x55bec3fd3768, estate=0x55bec3fd3528) at
./build/../src/backend/executor/execMain.c:1722
#23 standard_ExecutorRun (queryDesc=0x55bec3fc8c28, direction=<optimized
out>, count=0, execute_once=<optimized out>) at
./build/../src/backend/executor/execMain.c:363
#24 0x000055bec2759e06 in PortalRunSelect
(portal=portal@entry=0x55bec3fb8aa8, forward=forward@entry=1 '\001',
count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bec3fcd388) at
./build/../src/backend/tcop/pquery.c:932
#25 0x000055bec275b3f0 in PortalRun (portal=portal@entry=0x55bec3fb8aa8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
run_once=run_once@entry=1 '\001', dest=dest@entry=0x55bec3fcd388,
altdest=altdest@entry=0x55bec3fcd388, completionTag=0x7fff53123880 "") at
./build/../src/backend/tcop/pquery.c:773
#26 0x000055bec2756f30 in exec_simple_query (query_string=0x55bec3f7b018
"select sum(sum) from ternopil.offices_documents where commit_date between
'2017-06-01' and '2017-12-31';") at
./build/../src/backend/tcop/postgres.c:1099
#27 0x000055bec2758f01 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x55bec3f256a0, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4088
#28 0x000055bec2499e2e in BackendRun (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4357
#29 BackendStartup (port=0x55bec3f20380) at
./build/../src/backend/postmaster/postmaster.c:4029
#30 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753
#31 0x000055bec26e8fef in PostmasterMain (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/postmaster/postmaster.c:1361
#32 0x000055bec249b944 in main (argc=5, argv=0x55bec3ef6d90) at
./build/../src/backend/main/main.c:228
Continuing.

Program received signal SIGUSR1, User defined signal 1.
pagetable_insert (found=<synthetic pointer>, key=50334, tb=0x55bec3fe2618)
at ./build/../src/include/lib/simplehash.h:540
540    in ./build/../src/include/lib/simplehash.h
Continuing.

Program received signal SIGSEGV, Segmentation fault.
int8_avg_combine (fcinfo=0x55bec3fdbc28) at
./build/../src/backend/utils/adt/numeric.c:4285
4285    ./build/../src/backend/utils/adt/numeric.c: No such file or
directory.
Continuing.

Program terminated with signal SIGSEGV, Segmentation fault.
The program no longer exists.
quit

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
Tom Lane
Дата:
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> I get :

> Program received signal SIGSEGV, Segmentation fault.
> int8_avg_combine (fcinfo=0x55bec3fdbc28) at
> ./build/../src/backend/utils/adt/numeric.c:4285

Judging by the location of the failure, what you're running into is
the int128 alignment problem fixed here:
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=619a8c47da7279c186bb57cc16b26ad011366b73

That will be in next month's update releases.  In the mean time,
you could avoid the problem by disabling parallel queries.
Or build from REL_10_STABLE branch tip if you'd like to test
the fix.

            regards, tom lane

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
David Rowley
Дата:
Sergey,

On 4 January 2018 at 01:16, PG Bug reporting form
<noreply@postgresql.org> wrote:
> Program received signal SIGSEGV, Segmentation fault.
> int8_avg_combine (fcinfo=0x55bec3fdbc28) at
> ./build/../src/backend/utils/adt/numeric.c:4285

Thanks for reporting this.

Can I ask, did you build from source?

I can recreate this using:

create table i8 (a bigint);
insert into i8 select generate_Series(1,10000000);
select sum(a) from i8;

But I only get the crash when building with gcc 7.2. I've not tried
other gcc versions, but It works just fine with clang 4.0

The crash occurs at:

state1->sumX = state2->sumX;

sumX is an int128 type, and both state1 and state2 are non-NULL. It's
quite late here, but at first look, this appears to be a gcc bug.

Can you confirm your compiler version?

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
David Rowley
Дата:
On 4 January 2018 at 04:08, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> =?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
>> I get :
>
>> Program received signal SIGSEGV, Segmentation fault.
>> int8_avg_combine (fcinfo=0x55bec3fdbc28) at
>> ./build/../src/backend/utils/adt/numeric.c:4285
>
> Judging by the location of the failure, what you're running into is
> the int128 alignment problem fixed here:
> https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=619a8c47da7279c186bb57cc16b26ad011366b73

Oh right, I missed that one. That makes more sense than my diagnosis. Thanks.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
Tom Lane
Дата:
David Rowley <david.rowley@2ndquadrant.com> writes:
> I can recreate this using:

Can you reproduce on HEAD/v10 branch tip, or just 10.1 as released?
Cuz it sure looks like the alignment issue we already fixed...

            regards, tom lane

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
David Rowley
Дата:
On 4 January 2018 at 04:15, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Can you reproduce on HEAD/v10 branch tip, or just 10.1 as released?
> Cuz it sure looks like the alignment issue we already fixed...

a8910506757c58016616b9b0c4c6c78dcb835e3b crashes.
619a8c47da7279c186bb57cc16b26ad011366b73 is fine.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
sector119
Дата:
How can I disable parallel queries?

> 3 янв. 2018 г., в 17:08, Tom Lane <tgl@sss.pgh.pa.us> написал(а):
>
> =?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
>> I get :
>
>> Program received signal SIGSEGV, Segmentation fault.
>> int8_avg_combine (fcinfo=0x55bec3fdbc28) at
>> ./build/../src/backend/utils/adt/numeric.c:4285
>
> Judging by the location of the failure, what you're running into is
> the int128 alignment problem fixed here:
> https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=619a8c47da7279c186bb57cc16b26ad011366b73
>
> That will be in next month's update releases.  In the mean time,
> you could avoid the problem by disabling parallel queries.
> Or build from REL_10_STABLE branch tip if you'd like to test
> the fix.
>
>             regards, tom lane

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
Tom Lane
Дата:
sector119 <sector119@gmail.com> writes:
> How can I disable parallel queries?

set max_parallel_workers to zero

            regards, tom lane

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
sector119
Дата:
Setting max_parallel_workers to 0  doesn’t help..

eps=# select sum(sum) from ternopil.offices_documents where commit_date BETWEEN '2017-01-01' AND '2017-12-31’;
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

              name               | setting
---------------------------------+---------
 max_parallel_workers            | 0
 max_parallel_workers_per_gather | 2

postgresql.log:

2018-01-03 21:50:05 EET LOG:  server process (PID 26702) was terminated by signal 11: Segmentation fault
2018-01-03 21:50:05 EET DETAIL:  Failed process was running: select sum(sum) from ternopil.offices_documents where
commit_dateBETWEEN '2017-01-01' AND '2017-12-31'; 
2018-01-03 21:50:05 EET LOG:  terminating any other active server processes
2018-01-03 21:50:05 EET WARNING:  terminating connection because of crash of another server process
2018-01-03 21:50:05 EET DETAIL:  The postmaster has commanded this server process to roll back the current transaction
andexit, because another server process exited abnormally and possibly corrupted shared memory. 
2018-01-03 21:50:05 EET HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2018-01-03 21:50:05 EET WARNING:  terminating connection because of crash of another server process
2018-01-03 21:50:05 EET DETAIL:  The postmaster has commanded this server process to roll back the current transaction
andexit, because another server process exited abnormally and possibly corrupted shared memory. 
2018-01-03 21:50:05 EET HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2018-01-03 21:50:05 EET FATAL:  the database system is in recovery mode
2018-01-03 21:50:05 EET LOG:  archiver process (PID 26675) exited with exit code 1
2018-01-03 21:50:05 EET LOG:  all server processes terminated; reinitializing
2018-01-03 21:50:05 EET LOG:  database system was interrupted; last known up at 2018-01-03 21:48:27 EET
2018-01-03 21:50:05 EET FATAL:  the database system is in recovery mode
2018-01-03 21:50:05 EET FATAL:  the database system is in recovery mode
2018-01-03 21:50:05 EET LOG:  database system was not properly shut down; automatic recovery in progress
2018-01-03 21:50:05 EET LOG:  redo starts at 6D/8E002220
2018-01-03 21:50:05 EET LOG:  invalid record length at 6D/8E004270: wanted 24, got 0
2018-01-03 21:50:05 EET LOG:  redo done at 6D/8E004238
2018-01-03 21:50:05 EET LOG:  database system is ready to accept connections



> 3 янв. 2018 г., в 21:29, Tom Lane <tgl@sss.pgh.pa.us> написал(а):
>
> sector119 <sector119@gmail.com> writes:
>> How can I disable parallel queries?
>
> set max_parallel_workers to zero
>
>             regards, tom lane

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
Jeff Janes
Дата:
> 3 янв. 2018 г., в 21:29, Tom Lane <tgl@sss.pgh.pa.us> написал(а):
>
> sector119 <sector119@gmail.com> writes:
>> How can I disable parallel queries?
>
> set max_parallel_workers to zero
>

On Wed, Jan 3, 2018 at 2:52 PM, sector119 <sector119@gmail.com> wrote:
Setting max_parallel_workers to 0  doesn’t help..

Try setting max_parallel_workers_per_gather to 0

Please don't top-post.

Cheers,

Jeff

Re: BUG #14997: Get segmentation fault on select sum(bigint_field)

От
sector119
Дата:
I rebuild debian packages from REL_10_STABLE and now it works without segfaults :)

Thank you.

Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.