In mixed tpchsf1000, q05 gave OOM

In mixed tpchSF1000 where 2 biggest tables, lineitem and orders had duckdb storage engine , I hit error and when execcuted q05 seperately ,
I found OOM.

root@hz-duckdb-bench /test-data/tpchsf1000 # mariadb -vvv -e "use tpch;source /tmp/tpch_mq/q05.sql;"
--------------
SELECT
n_name,
SUM(l_extendedprice * (1 - l_discount)) AS revenue
FROM customer, orders, lineitem, supplier, nation, region
WHERE c_custkey = o_custkey
AND l_orderkey = o_orderkey
AND l_suppkey = s_suppkey
AND c_nationkey = s_nationkey
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
AND r_name = 'ASIA'
AND o_orderdate >= DATE '1994-01-01'
AND o_orderdate < DATE '1994-01-01' + INTERVAL 1 YEAR
GROUP BY n_name
ORDER BY revenue DESC
--------------

ERROR 1296 (HY000) at line 2 in file: '/tmp/tpch_mq/q05.sql': Got error 122 'Out of Memory Error: failed to offload data block of size 256.0 KiB (2.2 TiB/2.2 TiB used).
This limit was set by the 'max_temp_directory_size' setting.
By default, this setting utilizes the available' from DuckDB

Attaching shell scripts and sql files