BUG #14997: Get segmentation fault on select sum(bigint_field)
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #14997: Get segmentation fault on select sum(bigint_field) |
| Дата | |
| Msg-id | 20180103121632.10221.98596@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #14997: Get segmentation fault on select sum(bigint_field)
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #14997: Get segmentation fault on select sum(bigint_field) (David Rowley <david.rowley@2ndquadrant.com>) |
| Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления:
Следующее
От: Tom LaneДата:
Сообщение: Re: BUG #14997: Get segmentation fault on select sum(bigint_field)