Thread: BUG #14997: Get segmentation fault on select sum(bigint_field)
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
=?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
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
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
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
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
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
sector119 <sector119@gmail.com> writes:
> How can I disable parallel queries?
set max_parallel_workers to zero
regards, tom lane
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
> 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
>
> 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:
Cheers,
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
I rebuild debian packages from REL_10_STABLE and now it works without segfaults :) Thank you.