BUG #17159: PostgreSQL13.3:TPCH-Few queries Failed-no connection to the server Vuser

The following bug has been logged on the website:

Bug reference: 17159
Logged by: arjun shetty
Email address: arjunshetty955(at)gmail(dot)com
PostgreSQL version: 13.3
Operating system: RHEL8.4
Description:

Tried to capture TPCH-results with HammerDB4.2 benchmark environment.

Postgres.conf:
-----------------
shared_buffers = 4GB
work_mem = 128MB
vacuum_cost_limit = 1000
max_wal_size = 24GB
checkpoint_timeout = 30min
checkpoint_completion_target = 0.9

# logging
log_temp_files = 1024

HammerDb_Schema:
-------------------------

dbset db pg
dbset bm TPROC-H
diset connection pg_host localhost
diset connection pg_port 5432
diset tpch pg_scale_fact 100
diset tpch pg_num_tpch_threads 64
print dict
buildschema

Hammerdb_testrun:
------------------------

dbset db pg

dbset bm tpc-h

diset connection pg_host localhost

diset connection pg_port 5432

# set the virtual users
vuset vu 60
vuset showoutput 1
vuset logtotemp 1
vuset unique 1
print vuconf
loadscript
vucreate
vurun
waittocomplete

Quires Failed:
++++++++++++++++++++++++++++++++++
Vuser 7:Query Failed : select sum(l_extendedprice) / 7.0 as avg_yearly from
lineitem, part where p_partkey = l_partkey and p_brand = 'Brand#44' and
p_container = 'SM CASE' and l_quantity < ( select 0.2 * avg(l_quantity) from
lineitem where l_partkey = p_partkey) : no connection to the server
Vuser 11:Query Failed : select sum(l_extendedprice * l_discount) as revenue
from lineitem where l_shipdate >= date '1996-01-01' and l_shipdate < date
'1996-01-01' + interval '1 year' and l_discount between 0.02 - 0.01 and 0.02
+ 0.01 and l_quantity < 25 : no connection to the server
Vuser 7:query 17 completed in 0.002 seconds
Vuser 11:query 6 completed in 0.002 seconds

Vuser 11:Query Failed : select supp_nation, cust_nation, l_year, sum(volume)
as revenue from ( select n1.n_name as supp_nation, n2.n_name as cust_nation,
extract(year from l_shipdate) as l_year, l_extendedprice * (1 - l_discount)
as volume from supplier, lineitem, orders, customer, nation n1, nation n2
where s_suppkey = l_suppkey and o_orderkey = l_orderkey and c_custkey =
o_custkey and s_nationkey = n1.n_nationkey and c_nationkey = n2.n_nationkey
and ( (n1.n_name = 'SAUDI ARABIA' and n2.n_name = 'VIETNAM') or (n1.n_name =
'VIETNAM' and n2.n_name = 'SAUDI ARABIA')) and l_shipdate between date
'1995-01-01' and date '1996-12-31') shipping group by supp_nation,
cust_nation, l_year order by supp_nation, cust_nation, l_year : no
connection to the server
Vuser 11:query 7 completed in 0.002 seconds
Vuser 11:Completed 1 query set(s) in 1988 seconds
Vuser 11:Geometric mean of query times returning rows (2) is 832.38630
Vuser 14:Query Failed : select s_acctbal, s_name, n_name, p_partkey, p_mfgr,
s_address, s_phone, s_comment from part, supplier, partsupp, nation, region
where p_partkey = ps_partkey and s_suppkey = ps_suppkey and p_size = 18 and
p_type like '%NICKEL' and s_nationkey = n_nationkey and n_regionkey =
r_regionkey and r_name = 'AMERICA' and ps_supplycost = ( select
min(ps_supplycost) from partsupp, supplier, nation, region where p_partkey =
ps_partkey and s_suppkey = ps_suppkey and s_nationkey = n_nationkey and
n_regionkey = r_regionkey and r_name = 'AMERICA') order by s_acctbal desc,
n_name, s_name, p_partkey : server closed the connection unexpectedly This
probably means the server terminated abnormally before or while processing
the request.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

postgres.log
++++++++++++

EDT [767490] LOG: listening on IPv4 address "0.0.0.0", port 5432
EDT [767490] LOG: listening on IPv6 address "::", port 5432
EDT [767490] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
EDT [767492] LOG: database system was shut down at 2021-08-25 06:08:57
EDT
EDT [767490] LOG: database system is ready to accept connections
EDT [767490] LOG: background worker "parallel worker" (PID 767794) was
terminated by signal 9: Killed
EDT [767490] DETAIL: Failed process was running: select nation, o_year,
sum(amount) as sum_profit from ( select n_name as nation, extract(year from
o_orderdate) as o_year, l_extendedprice * (1 - l_discount) - ps_supplycost *
l_quantity as amount from part, supplier, lineitem, partsupp, orders, nation
where s_suppkey = l_suppkey and ps_suppkey = l_suppkey and ps_partkey =
l_partkey and p_partkey = l_partkey and o_orderkey = l_orderkey and
s_nationkey = n_nationkey and p_name like '%burlywood%') profit group by
nation, o_year order by nation, o_year desc
EDT [767490] LOG: terminating any other active server processes
EDT [767490] LOG: all server processes terminated; reinitializing
EDT [767859] LOG: database system was interrupted; last known up at
2021-08-25 06:08:57 EDT
EDT [767859] LOG: database system was not properly shut down; automatic
recovery in progress