A daily report crashed repeatedly this morning running pg11.4.
I compiled 11.5 and reproduced it there, too, so I'm including backtrace with
-O0.
I'm trying to dig further into it, but it seems to be crashing under load, but
not when I try to narrow down to a single report, which seem to run to
completion when run individually.
postmaster[6750]: segfault at 7f4a527545bc ip 00000000004834ae sp
00007ffd547e2760 error 4 in postgres[400000+6e6000]
postmaster[29786]: segfault at 7f49a968d000 ip 00007f49b24abb0f sp
00007ffd547e2268 error 4 in libc-2.12.so (deleted)[7f49b2422000+18b000]
Core was generated by `postgres: telsasoft ts 192.168.122.11(35454) SELECT
'.
Program terminated with signal 11, Segmentation fault.
#0 0x00000000004877df in slot_deform_tuple (slot=0xe204638, natts=3) at
heaptuple.c:1465
#1 0x0000000000487f5b in slot_getsomeattrs (slot=0xe204638, attnum=3) at
heaptuple.c:1673
#2 0x00000000006d5aae in ExecInterpExpr (state=0xe257948, econtext=0xe204578,
isnull=0x7ffff5f38077) at execExprInterp.c:443
#3 0x00000000006ed221 in ExecEvalExprSwitchContext (state=0xe257948,
econtext=0xe204578, isNull=0x7ffff5f38077) at
../../../src/include/executor/executor.h:313
#4 0x00000000006ed30e in ExecQual (state=0xe257948, econtext=0xe204578) at
../../../src/include/executor/executor.h:382
#5 0x00000000006ed5f4 in ExecScan (node=0x252edc8, accessMtd=0x71c54c
<SeqNext>, recheckMtd=0x71c623 <SeqRecheck>) at execScan.c:190
#6 0x000000000071c670 in ExecSeqScan (pstate=0x252edc8) at nodeSeqscan.c:129
#7 0x00000000006eb855 in ExecProcNodeInstr (node=0x252edc8) at
execProcnode.c:461
#8 0x00000000006f6555 in ExecProcNode (node=0x252edc8) at
../../../src/include/executor/executor.h:247
#9 0x00000000006f6a05 in ExecAppend (pstate=0xe20e7b0) at nodeAppend.c:294
#10 0x00000000006eb855 in ExecProcNodeInstr (node=0xe20e7b0) at
execProcnode.c:461
#11 0x0000000000708a96 in ExecProcNode (node=0xe20e7b0) at
../../../src/include/executor/executor.h:247
#12 0x0000000000709b0d in ExecHashJoinOuterGetTuple (outerNode=0xe20e7b0,
hjstate=0xe20e4d8, hashvalue=0x7ffff5f3827c) at nodeHashjoin.c:821
#13 0x0000000000708f8d in ExecHashJoinImpl (pstate=0xe20e4d8, parallel=false)
at nodeHashjoin.c:355
#14 0x00000000007094ca in ExecHashJoin (pstate=0xe20e4d8) at nodeHashjoin.c:565
#15 0x00000000006eb855 in ExecProcNodeInstr (node=0xe20e4d8) at
execProcnode.c:461
#16 0x000000000071d9da in ExecProcNode (node=0xe20e4d8) at
../../../src/include/executor/executor.h:247
#17 0x000000000071db26 in ExecSort (pstate=0xe20e3c0) at nodeSort.c:107
#18 0x00000000006eb855 in ExecProcNodeInstr (node=0xe20e3c0) at
execProcnode.c:461
#19 0x00000000006eb826 in ExecProcNodeFirst (node=0xe20e3c0) at
execProcnode.c:445
#20 0x00000000006f74c5 in ExecProcNode (node=0xe20e3c0) at
../../../src/include/executor/executor.h:247
#21 0x00000000006f79bb in fetch_input_tuple (aggstate=0xe20df70) at
nodeAgg.c:406
#22 0x00000000006f9d11 in agg_retrieve_direct (aggstate=0xe20df70) at
nodeAgg.c:1755
#23 0x00000000006f98fa in ExecAgg (pstate=0xe20df70) at nodeAgg.c:1570
#24 0x00000000006eb855 in ExecProcNodeInstr (node=0xe20df70) at
execProcnode.c:461
#25 0x00000000006eb826 in ExecProcNodeFirst (node=0xe20df70) at
execProcnode.c:445
#26 0x0000000000708a96 in ExecProcNode (node=0xe20df70) at
../../../src/include/executor/executor.h:247
#27 0x0000000000709b0d in ExecHashJoinOuterGetTuple (outerNode=0xe20df70,
hjstate=0x2778580, hashvalue=0x7ffff5f3865c) at nodeHashjoin.c:821
#28 0x0000000000708f8d in ExecHashJoinImpl (pstate=0x2778580, parallel=false)
at nodeHashjoin.c:355
#29 0x00000000007094ca in ExecHashJoin (pstate=0x2778580) at nodeHashjoin.c:565
#30 0x00000000006eb855 in ExecProcNodeInstr (node=0x2778580) at
execProcnode.c:461
#31 0x00000000006eb826 in ExecProcNodeFirst (node=0x2778580) at
execProcnode.c:445
#32 0x0000000000702a9b in ExecProcNode (node=0x2778580) at
../../../src/include/executor/executor.h:247
#33 0x0000000000702d12 in MultiExecPrivateHash (node=0x27783a8) at
nodeHash.c:164
#34 0x0000000000702c8c in MultiExecHash (node=0x27783a8) at nodeHash.c:114
#35 0x00000000006eb8f7 in MultiExecProcNode (node=0x27783a8) at
execProcnode.c:501
#36 0x0000000000708e2a in ExecHashJoinImpl (pstate=0x2777210, parallel=false)
at nodeHashjoin.c:290
#37 0x00000000007094ca in ExecHashJoin (pstate=0x2777210) at nodeHashjoin.c:565
#38 0x00000000006eb855 in ExecProcNodeInstr (node=0x2777210) at
execProcnode.c:461
#39 0x00000000006eb826 in ExecProcNodeFirst (node=0x2777210) at
execProcnode.c:445
#40 0x000000000071d9da in ExecProcNode (node=0x2777210) at
../../../src/include/executor/executor.h:247
#41 0x000000000071db26 in ExecSort (pstate=0x2776ce0) at nodeSort.c:107
#42 0x00000000006eb855 in ExecProcNodeInstr (node=0x2776ce0) at
execProcnode.c:461
#43 0x00000000006eb826 in ExecProcNodeFirst (node=0x2776ce0) at
execProcnode.c:445
#44 0x00000000006f74c5 in ExecProcNode (node=0x2776ce0) at
../../../src/include/executor/executor.h:247
#45 0x00000000006f79bb in fetch_input_tuple (aggstate=0x2776ec8) at
nodeAgg.c:406
#46 0x00000000006f9d11 in agg_retrieve_direct (aggstate=0x2776ec8) at
nodeAgg.c:1755
#47 0x00000000006f98fa in ExecAgg (pstate=0x2776ec8) at nodeAgg.c:1570
#48 0x00000000006eb855 in ExecProcNodeInstr (node=0x2776ec8) at
execProcnode.c:461
#49 0x00000000006eb826 in ExecProcNodeFirst (node=0x2776ec8) at
execProcnode.c:445
#50 0x00000000006e0129 in ExecProcNode (node=0x2776ec8) at
../../../src/include/executor/executor.h:247
#51 0x00000000006e2abd in ExecutePlan (estate=0x27769d8, planstate=0x2776ec8,
use_parallel_mode=false, operation=CMD_SELECT, sendTuples=true, numberTuples=0,
direction=ForwardScanDirection, dest=0xa66bef0, execute_once=true) at
execMain.c:1723
#52 0x00000000006e0710 in standard_ExecutorRun (queryDesc=0xdeb5f38,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:364
#53 0x00007fd37e757633 in pgss_ExecutorRun (queryDesc=0xdeb5f38,
direction=ForwardScanDirection, count=0, execute_once=true) at
pg_stat_statements.c:892
#54 0x00007fd37e2d86ef in explain_ExecutorRun (queryDesc=0xdeb5f38,
direction=ForwardScanDirection, count=0, execute_once=true) at
auto_explain.c:281
#55 0x00000000006e0511 in ExecutorRun (queryDesc=0xdeb5f38,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:305
#56 0x00000000008cfebe in PortalRunSelect (portal=0x21d4bf8, forward=true,
count=0, dest=0xa66bef0) at pquery.c:932
#57 0x00000000008cfb4c in PortalRun (portal=0x21d4bf8,
count=9223372036854775807, isTopLevel=true, run_once=true, dest=0xa66bef0,
altdest=0xa66bef0, completionTag=0x7ffff5f39100 "") at pquery.c:773
#58 0x00000000008c9b22 in exec_simple_query (query_string=0xe2fbd80 "--BEGIN
SQL\nSELECT site_office AS site_gran,\n\tsite_location||'.'||sect_num AS
bs,\n\tgsm_site_name_to_sect_name(site_name, sect_num, sect_name) AS
sitename,\n\tperiod AS start_time,\n\t(maybe_div(sum(rrc_su"...)
at postgres.c:1145
#59 0x00000000008cddf3 in PostgresMain (argc=1, argv=0x218fef8,
dbname=0x215da48 "ts", username=0x218fed0 "telsasoft") at postgres.c:4182
#60 0x000000000082a098 in BackendRun (port=0x21867d0) at postmaster.c:4358
#61 0x0000000000829806 in BackendStartup (port=0x21867d0) at postmaster.c:4030
#62 0x0000000000825cab in ServerLoop () at postmaster.c:1707
#63 0x00000000008255dd in PostmasterMain (argc=3, argv=0x215b9a0) at
postmaster.c:1380
#64 0x000000000074ba30 in main (argc=3, argv=0x215b9a0) at main.c:228
(gdb)
#0 0x00000000004877df in slot_deform_tuple (slot=0xe204638, natts=3) at
heaptuple.c:1465
thisatt = 0x5265db0
tuple = 0xe838d40
tupleDesc = 0x5265d20
values = 0xe204698
isnull = 0xe2057e8
tup = 0x7fd3eb1b8058
hasnulls = false
attnum = 1
tp = 0x7fd3eb1b80bd <Address 0x7fd3eb1b80bd out of bounds>
off = 583369983
bp = 0x7fd3eb1b806f <Address 0x7fd3eb1b806f out of bounds>
slow = true
#1 0x0000000000487f5b in slot_getsomeattrs (slot=0xe204638, attnum=3) at
heaptuple.c:1673
tuple = 0xe838d40
attno = 3
__func__ = "slot_getsomeattrs"
#2 0x00000000006d5aae in ExecInterpExpr (state=0xe257948, econtext=0xe204578,
isnull=0x7ffff5f38077) at execExprInterp.c:443
op = 0xe257530
resultslot = 0x0
innerslot = 0x0
outerslot = 0x0
scanslot = 0xe204638
dispatch_table = {0x6d5a0d, 0x6d5a32, 0x6d5a61, 0x6d5a93, 0x6d5ac5,
0x6d5b74, 0x6d5c23, 0x6d5cd2, 0x6d5da3, 0x6d5e74, 0x6d5f45, 0x6d5f7c, 0x6d6056,
0x6d6130, 0x6d620a, 0x6d627e, 0x6d6347, 0x6d638f, 0x6d640e, 0x6d64ec, 0x6d6523,
0x6d655a, 0x6d6568, 0x6d65e9, 0x6d6657, 0x6d6665,
0x6d66e6, 0x6d6754, 0x6d6790, 0x6d6821, 0x6d6856, 0x6d68b4, 0x6d6915,
0x6d6986, 0x6d69ca, 0x6d6a14, 0x6d6a4b, 0x6d6a82, 0x6d6acb, 0x6d6b3b, 0x6d6bab,
0x6d6bf4, 0x6d6c2b, 0x6d6c62, 0x6d6ca1, 0x6d6dc3, 0x6d6e2e, 0x6d704c, 0x6d7161,
0x6d726f, 0x6d7376, 0x6d73a6, 0x6d73d6, 0x6d7406,
0x6d7436, 0x6d746d, 0x6d749d, 0x6d7625, 0x6d7724, 0x6d7754, 0x6d778b,
0x6d77c2, 0x6d77f9, 0x6d7862, 0x6d7892, 0x6d78c2, 0x6d6d32, 0x6d7959, 0x6d7989,
0x6d78f2, 0x6d7929, 0x6d79b9, 0x6d79e9, 0x6d7a98, 0x6d7ac8, 0x6d7b77, 0x6d7bae,
0x6d7be5, 0x6d7c40, 0x6d7cf5, 0x6d7d9a, 0x6d7ead,
0x6d7f52, 0x6d80b4, 0x6d8261, 0x6d8298, 0x6d82cf}
#3 0x00000000006ed221 in ExecEvalExprSwitchContext (state=0xe257948,
econtext=0xe204578, isNull=0x7ffff5f38077) at
../../../src/include/executor/executor.h:313
retDatum = 140737319764160
oldContext = 0x27768c0
#4 0x00000000006ed30e in ExecQual (state=0xe257948, econtext=0xe204578) at
../../../src/include/executor/executor.h:382
ret = 3018996923
isnull = false
#5 0x00000000006ed5f4 in ExecScan (node=0x252edc8, accessMtd=0x71c54c
<SeqNext>, recheckMtd=0x71c623 <SeqRecheck>) at execScan.c:190
slot = 0xe204638
econtext = 0xe204578
qual = 0xe257948
projInfo = 0xe257498
#6 0x000000000071c670 in ExecSeqScan (pstate=0x252edc8) at nodeSeqscan.c:129
---Type <return> to continue, or q <return> to quit---
node = 0x252edc8
#7 0x00000000006eb855 in ExecProcNodeInstr (node=0x252edc8) at
execProcnode.c:461
result = 0x702ace
#8 0x00000000006f6555 in ExecProcNode (node=0x252edc8) at
../../../src/include/executor/executor.h:247
No locals.
#9 0x00000000006f6a05 in ExecAppend (pstate=0xe20e7b0) at nodeAppend.c:294
subnode = 0x252edc8
result = 0xe258508
node = 0xe20e7b0
#10 0x00000000006eb855 in ExecProcNodeInstr (node=0xe20e7b0) at
execProcnode.c:461
result = 0x20e257058
#11 0x0000000000708a96 in ExecProcNode (node=0xe20e7b0) at
../../../src/include/executor/executor.h:247
No locals.
#12 0x0000000000709b0d in ExecHashJoinOuterGetTuple (outerNode=0xe20e7b0,
hjstate=0xe20e4d8, hashvalue=0x7ffff5f3827c) at nodeHashjoin.c:821
hashtable = 0xe8387c8
curbatch = 0
slot = 0x0
#13 0x0000000000708f8d in ExecHashJoinImpl (pstate=0xe20e4d8, parallel=false)
at nodeHashjoin.c:355
node = 0xe20e4d8
outerNode = 0xe20e7b0
hashNode = 0xe258720
joinqual = 0x0
otherqual = 0x0
econtext = 0xe20e6f0
hashtable = 0xe8387c8
outerTupleSlot = 0xe257058
hashvalue = 3018996923
batchno = 0
parallel_state = 0x0
__func__ = "ExecHashJoinImpl"
#14 0x00000000007094ca in ExecHashJoin (pstate=0xe20e4d8) at nodeHashjoin.c:565
No locals.
#15 0x00000000006eb855 in ExecProcNodeInstr (node=0xe20e4d8) at
execProcnode.c:461
result = 0x20c4
#16 0x000000000071d9da in ExecProcNode (node=0xe20e4d8) at
../../../src/include/executor/executor.h:247
No locals.
#17 0x000000000071db26 in ExecSort (pstate=0xe20e3c0) at nodeSort.c:107
plannode = 0xa6309c0
outerNode = 0xe20e4d8
---Type <return> to continue, or q <return> to quit---
tupDesc = 0xe2598a0
node = 0xe20e3c0
estate = 0x27769d8
dir = ForwardScanDirection
tuplesortstate = 0x2766998
slot = 0xe25b8b8
#18 0x00000000006eb855 in ExecProcNodeInstr (node=0xe20e3c0) at
execProcnode.c:461
result = 0x4785d0
#19 0x00000000006eb826 in ExecProcNodeFirst (node=0xe20e3c0) at
execProcnode.c:445
No locals.
#20 0x00000000006f74c5 in ExecProcNode (node=0xe20e3c0) at
../../../src/include/executor/executor.h:247
No locals.
#21 0x00000000006f79bb in fetch_input_tuple (aggstate=0xe20df70) at
nodeAgg.c:406
slot = 0xe20e240
#22 0x00000000006f9d11 in agg_retrieve_direct (aggstate=0xe20df70) at
nodeAgg.c:1755
node = 0xa6315d0
econtext = 0xe20e300
tmpcontext = 0xe20e1a8
peragg = 0x252e198
pergroups = 0xe7cdd40
outerslot = 0x7ffff5f38520
firstSlot = 0xe263e70
result = 0x0
hasGroupingSets = false
numGroupingSets = 1
currentSet = 222632768
nextSetSize = 0
numReset = 1
i = 1
#23 0x00000000006f98fa in ExecAgg (pstate=0xe20df70) at nodeAgg.c:1570
node = 0xe20df70
result = 0x0
#24 0x00000000006eb855 in ExecProcNodeInstr (node=0xe20df70) at
execProcnode.c:461
result = 0x4785d0
#25 0x00000000006eb826 in ExecProcNodeFirst (node=0xe20df70) at
execProcnode.c:445
No locals.
#26 0x0000000000708a96 in ExecProcNode (node=0xe20df70) at
../../../src/include/executor/executor.h:247
No locals.
#27 0x0000000000709b0d in ExecHashJoinOuterGetTuple (outerNode=0xe20df70,
hjstate=0x2778580, hashvalue=0x7ffff5f3865c) at nodeHashjoin.c:821
#28 0x0000000000708f8d in ExecHashJoinImpl (pstate=0x2778580, parallel=false)
at nodeHashjoin.c:355
node = 0x2778580
outerNode = 0xe20df70
hashNode = 0xe7e2560
joinqual = 0x0
otherqual = 0x0
econtext = 0x2778798
hashtable = 0xe837df0
outerTupleSlot = 0x4040
hashvalue = 0
batchno = 10926240
parallel_state = 0x0
__func__ = "ExecHashJoinImpl"
#29 0x00000000007094ca in ExecHashJoin (pstate=0x2778580) at nodeHashjoin.c:565
No locals.
#30 0x00000000006eb855 in ExecProcNodeInstr (node=0x2778580) at
execProcnode.c:461
result = 0x4785d0
#31 0x00000000006eb826 in ExecProcNodeFirst (node=0x2778580) at
execProcnode.c:445
No locals.
#32 0x0000000000702a9b in ExecProcNode (node=0x2778580) at
../../../src/include/executor/executor.h:247
No locals.
#33 0x0000000000702d12 in MultiExecPrivateHash (node=0x27783a8) at
nodeHash.c:164
outerNode = 0x2778580
hashkeys = 0xe7ebf78
hashtable = 0xe837cd8
slot = 0x80000000001
econtext = 0x27784c0
hashvalue = 0
#34 0x0000000000702c8c in MultiExecHash (node=0x27783a8) at nodeHash.c:114
No locals.
#35 0x00000000006eb8f7 in MultiExecProcNode (node=0x27783a8) at
execProcnode.c:501
result = 0x4
__func__ = "MultiExecProcNode"
#36 0x0000000000708e2a in ExecHashJoinImpl (pstate=0x2777210, parallel=false)
at nodeHashjoin.c:290
node = 0x2777210
outerNode = 0x27774e8
---Type <return> to continue, or q <return> to quit---
hashNode = 0x27783a8
joinqual = 0x0
otherqual = 0x0
econtext = 0x2777428
hashtable = 0xe837cd8
outerTupleSlot = 0x7ffff5f388ac
hashvalue = 0
batchno = 0
parallel_state = 0x0
__func__ = "ExecHashJoinImpl"
#37 0x00000000007094ca in ExecHashJoin (pstate=0x2777210) at nodeHashjoin.c:565
No locals.
#38 0x00000000006eb855 in ExecProcNodeInstr (node=0x2777210) at
execProcnode.c:461
result = 0x4785d0
#39 0x00000000006eb826 in ExecProcNodeFirst (node=0x2777210) at
execProcnode.c:445
No locals.
#40 0x000000000071d9da in ExecProcNode (node=0x2777210) at
../../../src/include/executor/executor.h:247
No locals.
#41 0x000000000071db26 in ExecSort (pstate=0x2776ce0) at nodeSort.c:107
plannode = 0xa632c18
outerNode = 0x2777210
tupDesc = 0xe7e6980
node = 0x2776ce0
estate = 0x27769d8
dir = ForwardScanDirection
tuplesortstate = 0x24feec8
slot = 0x219bfa0
#42 0x00000000006eb855 in ExecProcNodeInstr (node=0x2776ce0) at
execProcnode.c:461
result = 0x4785d0
#43 0x00000000006eb826 in ExecProcNodeFirst (node=0x2776ce0) at
execProcnode.c:445
No locals.
#44 0x00000000006f74c5 in ExecProcNode (node=0x2776ce0) at
../../../src/include/executor/executor.h:247
No locals.
#45 0x00000000006f79bb in fetch_input_tuple (aggstate=0x2776ec8) at
nodeAgg.c:406
slot = 0x2776df8
#46 0x00000000006f9d11 in agg_retrieve_direct (aggstate=0x2776ec8) at
nodeAgg.c:1755
node = 0xa633eb0
econtext = 0x2777150
tmpcontext = 0x2776bf0
---Type <return> to continue, or q <return> to quit---
peragg = 0xe824520
pergroups = 0xe832e88
outerslot = 0x7ffff5f38b40
firstSlot = 0xe81f6b8
result = 0x7ffff5f38b10
hasGroupingSets = false
numGroupingSets = 1
currentSet = 243398904
nextSetSize = 0
numReset = 1
i = 1
#47 0x00000000006f98fa in ExecAgg (pstate=0x2776ec8) at nodeAgg.c:1570
node = 0x2776ec8
result = 0x0
#48 0x00000000006eb855 in ExecProcNodeInstr (node=0x2776ec8) at
execProcnode.c:461
result = 0x4785d0
#49 0x00000000006eb826 in ExecProcNodeFirst (node=0x2776ec8) at
execProcnode.c:445
No locals.
#50 0x00000000006e0129 in ExecProcNode (node=0x2776ec8) at
../../../src/include/executor/executor.h:247
No locals.
#51 0x00000000006e2abd in ExecutePlan (estate=0x27769d8, planstate=0x2776ec8,
use_parallel_mode=false, operation=CMD_SELECT, sendTuples=true, numberTuples=0,
direction=ForwardScanDirection, dest=0xa66bef0, execute_once=true) at
execMain.c:1723
slot = 0x150
current_tuple_count = 0
#52 0x00000000006e0710 in standard_ExecutorRun (queryDesc=0xdeb5f38,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:364
estate = 0x27769d8
operation = CMD_SELECT
dest = 0xa66bef0
sendTuples = true
oldcontext = 0xdeb5e20
__func__ = "standard_ExecutorRun"
#53 0x00007fd37e757633 in pgss_ExecutorRun (queryDesc=0xdeb5f38,
direction=ForwardScanDirection, count=0, execute_once=true) at
pg_stat_statements.c:892
save_exception_stack = 0x7ffff5f38dd0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {233529144, 9176610699338068304,
4687312, 140737319770032, 0, 0, 9176610699377914192, 9151536278965596496},
__mask_was_saved = 0, __saved_mask = {__val = {4294967302, 243497128,
4295032832, 140737319767408, 7255973, 140737319767408, 68726688595,
41380312, 174276272, 174278840, 41381576, 0, 41381576, 16,
174278840, 140737319767696}}}}
#54 0x00007fd37e2d86ef in explain_ExecutorRun (queryDesc=0xdeb5f38,
direction=ForwardScanDirection, count=0, execute_once=true) at
auto_explain.c:281
save_exception_stack = 0x7ffff5f38fa0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {233529144, 9176610699451314512,
4687312, 140737319770032, 0, 0, 9176610699340165456, 9151535941362266448},
__mask_was_saved = 0, __saved_mask = {__val = {10926707, 24, 41371824,
41371824, 238009728, 41372168, 8600905475, 35241888, 336, 243497664,
---Type <return> to continue, or q <return> to quit---
41380032, 243498000, 233528864, 336, 174505712,
140737319767760}}}}
#55 0x00000000006e0511 in ExecutorRun (queryDesc=0xdeb5f38,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:305
No locals.
#56 0x00000000008cfebe in PortalRunSelect (portal=0x21d4bf8, forward=true,
count=0, dest=0xa66bef0) at pquery.c:932
queryDesc = 0xdeb5f38
direction = ForwardScanDirection
nprocessed = 233528864
__func__ = "PortalRunSelect"
#57 0x00000000008cfb4c in PortalRun (portal=0x21d4bf8,
count=9223372036854775807, isTopLevel=true, run_once=true, dest=0xa66bef0,
altdest=0xa66bef0, completionTag=0x7ffff5f39100 "") at pquery.c:773
save_exception_stack = 0x7ffff5f39240
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {174505712, 9176610698715214160,
4687312, 140737319770032, 0, 0, 9176610699432440144, -9176589804060397232},
__mask_was_saved = 0, __saved_mask = {__val = {233529080, 2405784, 21306251184,
128, 13, 616, 174505656, 140737319768192, 10970883, 480, 112,
174505712, 34999312, 174505824, 233528864, 112}}}}
result = false
nprocessed = 4687312
saveTopTransactionResourceOwner = 0x2197a20
saveTopTransactionContext = 0x27748b0
saveActivePortal = 0x0
saveResourceOwner = 0x2197a20
savePortalContext = 0x0
saveMemoryContext = 0x27748b0
__func__ = "PortalRun"
#58 0x00000000008c9b22 in exec_simple_query (query_string=0xe2fbd80 "--BEGIN
SQL\nSELECT site_office AS site_gran,\n\tsite_location||'.'||sect_num AS
bs,\n\tgsm_site_name_to_sect_name(site_name, sect_num, sect_name) AS
sitename,\n\tperiod AS start_time,\n\t(maybe_div(sum(rrc_su"...)
at postgres.c:1145
parsetree = 0xd4f1c38
portal = 0x21d4bf8
snapshot_set = true
commandTag = 0xc5ed4d "SELECT"
completionTag =
"\000\000\000\000\002\000\000\000\n\000\000\000\000\000\000\000P\221\363\365\377\177\000\000\017s\245\000\000\000\000\000\036\020\000\000\000\000\000\000\000\f\026\002\030\020\000\000\200\275/\016\000\000\000\000(\r\026\002\006\000\000"
querytree_list = 0xe230d58
plantree_list = 0xa66beb8
receiver = 0xa66bef0
format = 0
dest = DestRemote
oldcontext = 0x27748b0
parsetree_list = 0xd4f1c98
parsetree_item = 0xd4f1c70
save_log_statement_stats = false
was_logged = false
---Type <return> to continue, or q <return> to quit---
use_implicit_block = false
msec_str =
"\220\221\363\365\377\177\000\000&C\245\000\000\000\000\000\006\000\000\000\030\020\000\000\200\275/\016\000\000\000"
__func__ = "exec_simple_query"
#59 0x00000000008cddf3 in PostgresMain (argc=1, argv=0x218fef8,
dbname=0x215da48 "ts", username=0x218fed0 "telsasoft") at postgres.c:4182
query_string = 0xe2fbd80 "--BEGIN SQL\nSELECT site_office AS
site_gran,\n\tsite_location||'.'||sect_num AS
bs,\n\tgsm_site_name_to_sect_name(site_name, sect_num, sect_name) AS
sitename,\n\tperiod AS start_time,\n\t(maybe_div(sum(rrc_su"...
firstchar = 81
input_message = {data = 0xe2fbd80 "--BEGIN SQL\nSELECT site_office AS
site_gran,\n\tsite_location||'.'||sect_num AS
bs,\n\tgsm_site_name_to_sect_name(site_name, sect_num, sect_name) AS
sitename,\n\tperiod AS start_time,\n\t(maybe_div(sum(rrc_su"..., len = 4121,
maxlen = 8192,
cursor = 4121}
local_sigjmp_buf = {{__jmpbuf = {35192568, 9176610698734088528,
4687312, 140737319770032, 0, 0, 9176610698788614480, -9176589805133483696},
__mask_was_saved = 1, __saved_mask = {__val = {0, 0, 4494597, 0, 0, 0,
10923965, 1024, 35138464, 140737319768848, 10928134, 35138464, 34999312,
34999312, 35138440, 8}}}}
send_ready_for_query = false
disable_idle_in_transaction_timeout = false
__func__ = "PostgresMain"
#60 0x000000000082a098 in BackendRun (port=0x21867d0) at postmaster.c:4358
av = 0x218fef8
maxac = 2
ac = 1
secs = 618513625
usecs = 637903
i = 1
__func__ = "BackendRun"
#61 0x0000000000829806 in BackendStartup (port=0x21867d0) at postmaster.c:4030
bn = 0x2185ef0
pid = 0
__func__ = "BackendStartup"
#62 0x0000000000825cab in ServerLoop () at postmaster.c:1707
port = 0x21867d0
i = 0
rmask = {fds_bits = {8, 0 <repeats 15 times>}}
selres = 1
now = 1565198425
readmask = {fds_bits = {56, 0 <repeats 15 times>}}
nSockets = 6
last_lockfile_recheck_time = 1565198368
last_touch_time = 1565197325
__func__ = "ServerLoop"
#63 0x00000000008255dd in PostmasterMain (argc=3, argv=0x215b9a0) at
postmaster.c:1380
opt = -1
status = 0
---Type <return> to continue, or q <return> to quit---
userDoption = 0x217d500 "/var/lib/pgsql/11/data"
listen_addr_saved = true
i = 64
output_config_variable = 0x0
__func__ = "PostmasterMain"
#64 0x000000000074ba30 in main (argc=3, argv=0x215b9a0) at main.c:228
do_check_root = true
