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

The following bug has been logged on the website:

Bug reference:      17159
Logged by:          arjun shetty
Email address:      arjunshetty955@gmail.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