# MonetDB 5 server v11.54.0 # This is an unreleased version # Serving database 'mTests_sql_benchmarks_tpch', using 8 threads # Compiled for ppc64-pc-linux-gnu/64bit # Found 255.358 GiB available main-memory of which we use 208.117 GiB # Virtual memory usage limited to 32.000 GiB # Copyright (c) 2024, 2025 MonetDB Foundation, all rights reserved # Visit https://www.monetdb.org/ for further information # MonetDB/SQL module loaded # Listening for connection requests on mapi:monetdb://power8:41659/ # Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-50119/.s.monetdb.41659 #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot') #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: start transaction #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: create table region ( r_regionkey integer not null, #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: create table nation ( n_nationkey integer not null, #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: create table part ( p_partkey integer not null, #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: create table supplier ( s_suppkey integer not null, #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: create table partsupp ( ps_partkey integer not null, #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: create table customer ( c_custkey integer not null, #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: create table orders ( o_orderkey integer not null, #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: create table lineitem ( l_orderkey integer not null, #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: commit #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from customer #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from nation #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from orders #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from partsupp #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from part #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from region #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from supplier #2025-04-04 23:31:25: client0017: SQLrun: INFO: Executing: select * from lineitem #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: start transaction #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: copy 5 records into region from '../SF-0.01/region.tbl' on client using delimiters '|', E'|\n' #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: copy 25 records into nation from '../SF-0.01/nation.tbl' on client using delimiters '|', E'|\n' #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: copy 100 records into supplier from '../SF-0.01/supplier.tbl' on client using delimiters '|', E'|\n' #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: copy 1500 records into customer from '../SF-0.01/customer.tbl' on client using delimiters '|', E'|\n' #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: copy 2000 records into part from '../SF-0.01/part.tbl' on client using delimiters '|', E'|\n' #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: copy 8000 records into partsupp from '../SF-0.01/partsupp.tbl' on client using delimiters '|', E'|\n' #2025-04-04 23:31:25: client0018: SQLrun: INFO: Executing: copy 15000 records into orders from '../SF-0.01/orders.tbl' on client using delimiters '|', E'|\n' #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: copy 70000 records into lineitem from '../SF-0.01/lineitem.tbl' on client using delimiters '|', E'|\n' #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: commit #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: select count(*) from customer #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: select count(*) from nation #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: select count(*) from orders #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: select count(*) from partsupp #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: select count(*) from part #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: select count(*) from region #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: select count(*) from supplier #2025-04-04 23:31:26: client0018: SQLrun: INFO: Executing: select count(*) from lineitem #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: create procedure sys.dict_compress( sname string, tname string, cname string, ordered_values bool) external name dict.compress #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: create procedure sys.for_compress( sname string, tname string, cname string) external name "for".compress #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'region', 'r_regionkey', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'nation', 'n_nationkey', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'nation', 'n_regionkey', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'supplier', 's_nationkey', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'customer', 'c_nationkey', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'customer', 'c_mktsegment', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'part', 'p_mfgr', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'part', 'p_brand', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'part', 'p_type', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'part', 'p_size', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'part', 'p_container', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'part', 'p_retailprice', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'partsupp', 'ps_availqty', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'orders', 'o_orderstatus', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'orders', 'o_orderdate', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'orders', 'o_orderpriority', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'orders', 'o_clerk', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'orders', 'o_shippriority', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_linenumber', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_quantity', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_discount', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call for_compress('sys', 'lineitem', 'l_tax') #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_returnflag', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_linestatus', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_shipdate', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_commitdate', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_shipinstruct', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_receiptdate', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: call dict_compress('sys', 'lineitem', 'l_shipmode', true) #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from region order by r_regionkey limit 9 #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from nation order by n_nationkey limit 9 #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from supplier order by s_suppkey limit 9 #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from customer order by c_custkey limit 9 #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from part order by p_partkey limit 9 #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from partsupp order by ps_partkey, ps_suppkey limit 9 #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from orders order by o_orderkey limit 9 #2025-04-04 23:31:26: client0041: SQLrun: INFO: Executing: select * from lineitem order by l_orderkey, l_linenumber limit 9 #2025-04-04 23:31:26: client0042: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0042: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0042: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0043: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0043: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0043: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0044: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0044: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0044: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0045: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0045: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0045: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0046: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0046: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0046: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0047: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0047: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0047: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0048: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0048: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0048: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0049: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0049: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0049: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0050: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0050: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0050: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0051: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0051: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0051: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0052: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0052: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0052: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0053: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0053: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0053: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0054: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0054: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0054: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0055: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0055: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0055: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0055: SQLrun: INFO: Executing: create view revenue0 (supplier_no, total_revenue) as #2025-04-04 23:31:26: client0056: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0056: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0056: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0056: SQLrun: INFO: Executing: drop view revenue0 #2025-04-04 23:31:26: client0057: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0057: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0057: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0058: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0058: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0058: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0059: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0059: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0059: SQLrun: INFO: Executing: select #2025-04-04 23:31:26: client0060: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:26: client0060: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:26: client0060: SQLrun: INFO: Executing: select #2025-04-04 23:31:33: client0061: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:33: client0061: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:33: client0061: SQLrun: INFO: Executing: select #2025-04-04 23:31:33: client0062: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:33: client0062: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:33: client0062: SQLrun: INFO: Executing: select #2025-04-04 23:31:33: client0063: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:33: client0063: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:33: client0063: SQLrun: INFO: Executing: select #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: call sys.setsessiontimeout(60) #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint' #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select o_totalprice, count(*) from sys.orders group by o_totalprice having count(*) >1 order by o_totalprice limit 10 #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select max(o_totalprice) from sys.orders #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select min(o_totalprice) from sys.orders #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select count(*) from sys.orders where o_totalprice between 38451.0 and 38452.0 #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select count(*) from sys.orders where o_totalprice = 38451.38 #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select count(*) from sys.orders where o_totalprice >= 555285.16 #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select count(*) from sys.orders where o_totalprice < 858.0 #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select count(*) from sys.partsupp as i, sys.supplier as s, sys.part as p #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select count(*) from sys.partsupp as i, sys.supplier as s, sys.part as p #2025-04-04 23:31:33: client0064: SQLrun: INFO: Executing: select count(*) from sys.partsupp as i, sys.supplier as s, sys.part as p #SIGUSR1 info start #Virtual memory allocated: 16934672, of which 11298576 with malloc #gdk_vm_maxsize: 34359738368, gdk_mem_maxsize: 223463815249 #gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296 #Virtual size: 1734737920, anonymous RSS: 68026368, shared RSS: 26673152 (together: 94699520) #BATs: #fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc #fix, dirty, transient, loaded, hot: 115 bats, 30104 virtual, 30104 malloc #fix, clean, persistent, loaded, hot: 5 bats, 9216 virtual, 9216 malloc #no fix, dirty, persistent, loaded, hot: 102 bats, 768 virtual, 768 malloc #no fix, dirty, transient, loaded, hot: 49 bats, 0 virtual, 0 malloc #no fix, clean, persistent, loaded, hot: 240 bats, 10681315 virtual, 5045219 malloc #no fix, clean, persistent, not loaded, cold: 9 bats, 0 virtual, 0 malloc #no fix, clean, transient, loaded, hot: 8 bats, 231499 virtual, 231499 malloc #870 bats total, 529 in use, 105 free bats in common shared list #Threads: #client0064, tid 64, Thread 0x7fff6f64f180, 0 free bats, waiting for nothing, working on exiting #heartbeat, tid 14, Thread 0x7fff6f85f180, 0 free bats, waiting for nothing, working on sleeping #listenThread, tid 13, Thread 0x7fff6fa6f180, 0 free bats, waiting for nothing, working on nothing #logmanager, tid 12, Thread 0x7fff6fc7f180, 31 free bats, waiting for nothing, working on sleeping #DFLOWworker0011, tid 11, Thread 0x7fff6fe8f180, 20 free bats, waiting for semaphore DFLOWsema0011, working on idle, waiting for new client #DFLOWworker0010, tid 10, Thread 0x7fff7009f180, 6 free bats, waiting for semaphore todo, working on waiting for work #DFLOWworker0009, tid 9, Thread 0x7fff702af180, 17 free bats, waiting for semaphore todo, working on waiting for work #DFLOWworker0008, tid 8, Thread 0x7fff704bf180, 23 free bats, waiting for semaphore todo, working on waiting for work #DFLOWworker0007, tid 7, Thread 0x7fff706cf180, 10 free bats, waiting for semaphore DFLOWsema0007, working on idle, waiting for new client #DFLOWworker0006, tid 6, Thread 0x7fff708df180, 44 free bats, waiting for semaphore todo, working on waiting for work #DFLOWworker0005, tid 5, Thread 0x7fff70aef180, 24 free bats, waiting for semaphore todo, working on waiting for work #DFLOWworker0004, tid 4, Thread 0x7fff70cff180, 11 free bats, waiting for semaphore todo, working on waiting for work #DFLOWworker0003, tid 3, Thread 0x7fff70f0f180, 50 free bats, waiting for semaphore todo, working on waiting for work #BBPmanager, tid 2, Thread 0x7fff763df180, 0 free bats, waiting for nothing, working on sleeping #main-thread, tid 1, Thread 0x7fff84918aa0, 0 free bats, waiting for nothing, working on nothing #Clients: #0 active clients, 0 finishing clients, 0 blocked clients; max: 64 #WAL: #SQL store oldest pending 342 #logger sql: #current log file 33, last handled log file 32 #current transaction id 30, saved transaction id 29 #number of flushers: 0 #number of catalog entries 351, of which 0 deleted #pending range 33: drops 0, last_ts 267, flushed_ts 267, refcount 1, file size 226 (current) #SIGUSR1 info end # mserver5 exiting