Workload running stuck when USE_BAO = False

[LumingSun]

After I collected bao_run.txt and set USE_BAO = False to collect PG running behavior, I got stuck after running the 0 16query, and I compared with the bao_run, the next query is q1_8a463.sql. I tried several times and the process has no progress even after 9 hours. htop shows there are parallel PG worker running. It is very strange and I don't know why the run_queries.py is stuck.

[LumingSun]

BaoForPostgreSQL/run_queries.py

Line 34 in 28142c7

continue

Why use while True and continue here?

[ScottLiao920]

same here; run_quries.py stuck at q1_8a463sql, in my pg log it says ERROR: canceling statement due to statement timeout. Have you got any solution for this issue?

[LumingSun]

@ScottLiao920 I just deleted continue in

BaoForPostgreSQL/run_queries.py

Line 34 in 28142c7

continue

[ScottLiao920]

Based on my understanding, if you delete continue in

BaoForPostgreSQL/run_queries.py

Line 34 in 28142c7

continue

this query will be ignored after one failed attempt (in this case, timeout after 5 mins).
If you want to run q1_8a463.sql, you may change the timeout setting here at

BaoForPostgreSQL/run_queries.py

Line 27 in 28142c7

cur.execute("SET statement_timeout TO 300000")

to 0, which means no timeout for upcoming queries.