BUG #14997: Get segmentation fault on select sum(bigint_field) - Mailing list pgsql-bugs
From | PG Bug reporting form |
---|---|
Subject | BUG #14997: Get segmentation fault on select sum(bigint_field) |
Date | |
Msg-id | 20180103121632.10221.98596@wrigleys.postgresql.org Whole thread Raw |
Responses |
Re: BUG #14997: Get segmentation fault on select sum(bigint_field)
Re: BUG #14997: Get segmentation fault on select sum(bigint_field) |
List | 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 by date: