Changeset: 64250b071839 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=64250b071839 Removed Files: sql/benchmarks/tpch/fileleak/Tests/All sql/benchmarks/tpch/fileleak/Tests/check0.reqtests sql/benchmarks/tpch/fileleak/Tests/check0.sql sql/benchmarks/tpch/fileleak/Tests/check0.stable.err sql/benchmarks/tpch/fileleak/Tests/check0.stable.out sql/benchmarks/tpch/fileleak/Tests/check1.reqtests sql/benchmarks/tpch/fileleak/Tests/check1.sql sql/benchmarks/tpch/fileleak/Tests/check1.stable.err sql/benchmarks/tpch/fileleak/Tests/check1.stable.out sql/benchmarks/tpch/fileleak/Tests/create.sql.src sql/benchmarks/tpch/fileleak/Tests/create.stable.err sql/benchmarks/tpch/fileleak/Tests/create.stable.out sql/benchmarks/tpch/fileleak/Tests/delete_all.SQL.py sql/benchmarks/tpch/fileleak/Tests/delete_all.stable.err sql/benchmarks/tpch/fileleak/Tests/delete_all.stable.out sql/benchmarks/tpch/fileleak/Tests/leaks.SQL.py sql/benchmarks/tpch/fileleak/Tests/leaks.stable.err sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out.Windows sql/benchmarks/tpch/fileleak/Tests/load.SQL.py sql/benchmarks/tpch/fileleak/Tests/load.reqtests sql/benchmarks/tpch/fileleak/Tests/load.stable.err sql/benchmarks/tpch/fileleak/Tests/load.stable.out sql/benchmarks/tpch/fileleak/Tests/test.py sql/benchmarks/tpch/fileleak/Tests/test.sql Branch: Jul2017 Log Message:
Removed tests: the results are too variable. We keep switching between 64k and 256k file sizes in the leaks test. diffs (truncated from 1014 to 300 lines): diff --git a/sql/benchmarks/tpch/fileleak/Tests/All b/sql/benchmarks/tpch/fileleak/Tests/All deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/All +++ /dev/null @@ -1,6 +0,0 @@ -create -check0 -load -check1 -HAVE_PYMONETDB?delete_all -HAVE_PYMONETDB?leaks diff --git a/sql/benchmarks/tpch/fileleak/Tests/check0.reqtests b/sql/benchmarks/tpch/fileleak/Tests/check0.reqtests deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/check0.reqtests +++ /dev/null @@ -1,1 +0,0 @@ -create diff --git a/sql/benchmarks/tpch/fileleak/Tests/check0.sql b/sql/benchmarks/tpch/fileleak/Tests/check0.sql deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/check0.sql +++ /dev/null @@ -1,8 +0,0 @@ -select * from customer; -select * from nation; -select * from orders; -select * from partsupp; -select * from part; -select * from region; -select * from supplier; -select * from lineitem; diff --git a/sql/benchmarks/tpch/fileleak/Tests/check0.stable.err b/sql/benchmarks/tpch/fileleak/Tests/check0.stable.err deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/check0.stable.err +++ /dev/null @@ -1,17 +0,0 @@ -stderr of test 'check0` in directory 'sql/benchmarks/tpch/fileleak` itself: - - -# 19:09:06 > -# 19:09:06 > Mtimeout -timeout 180 Mserver "--config=/var/tmp/_PREFIX_MONET_GNU_32_d__/etc/monet.conf" --debug=10 --set "monet_mod_path=/var/tmp/_PREFIX_MONET_GNU_32_d__/lib/MonetDB:/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB" --set "gdk_dbfarm=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/dbfarm" --set "sql_logdir=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/log" --set mapi_port=56086 --set sql_port=51688 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" "/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB/sqlserver.mil" ; echo ; echo Over.. -# 19:09:06 > - - -# 19:09:06 > -# 19:09:06 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=51688 --trace < check0.sql -# 19:09:06 > - - -# 19:09:06 > -# 19:09:06 > Done. -# 19:09:06 > - diff --git a/sql/benchmarks/tpch/fileleak/Tests/check0.stable.out b/sql/benchmarks/tpch/fileleak/Tests/check0.stable.out deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/check0.stable.out +++ /dev/null @@ -1,63 +0,0 @@ -stdout of test 'check0` in directory 'sql/benchmarks/tpch/fileleak` itself: - - -# 12:34:18 > -# 12:34:18 > Mtimeout -timeout 180 Mserver "--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin" --set "gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm" --set "sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log" --set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" --dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over.. -# 12:34:18 > - -# Monet Database Server V4.9.3 -# Copyright (c) 1993-2005, CWI. All rights reserved. -# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically linked. -# Visit http://monetdb.cwi.nl/ for further information. - - -Ready. - - -# 11:47:51 > -# 11:47:51 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35781 < check0.sql -# 11:47:51 > - -% sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer # table_name -% c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment # name -% int, varchar, varchar, int, char, decimal, char, varchar # type -% 1, 0, 0, 1, 15, 17, 10, 0 # length -#select * from nation; -% sys.nation, sys.nation, sys.nation, sys.nation # table_name -% n_nationkey, n_name, n_regionkey, n_comment # name -% int, char, int, varchar # type -% 1, 25, 1, 0 # length -#select * from orders; -% sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders # table_name -% o_orderkey, o_custkey, o_orderstatus, o_totalprice, o_orderdate, o_orderpriority, o_clerk, o_shippriority, o_comment # name -% int, int, char, decimal, date, char, char, int, varchar # type -% 1, 1, 1, 17, 10, 15, 15, 1, 0 # length -#select * from partsupp; -% sys.partsupp, sys.partsupp, sys.partsupp, sys.partsupp, sys.partsupp # table_name -% ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment # name -% int, int, int, decimal, varchar # type -% 1, 1, 1, 17, 0 # length -% sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part # table_name -% p_partkey, p_name, p_mfgr, p_brand, p_type, p_size, p_container, p_retailprice, p_comment # name -% int, varchar, char, char, varchar, int, char, decimal, varchar # type -% 1, 0, 25, 10, 0, 1, 10, 17, 0 # length -#select * from region; -% sys.region, sys.region, sys.region # table_name -% r_regionkey, r_name, r_comment # name -% int, char, varchar # type -% 1, 25, 0 # length -#select * from supplier; -% sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier # table_name -% s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment # name -% int, char, varchar, int, char, decimal, varchar # type -% 1, 25, 0, 1, 15, 17, 0 # length -#select * from lineitem; -% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem # table_name -% l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_commitdate, l_receiptdate, l_shipinstruct, l_shipmode, l_comment # name -% int, int, int, int, decimal, decimal, decimal, decimal, char, char, date, date, date, char, char, varchar # type -% 1, 1, 1, 1, 17, 17, 17, 17, 1, 1, 10, 10, 10, 25, 10, 0 # length - -# 11:47:51 > -# 11:47:51 > Done. -# 11:47:51 > - diff --git a/sql/benchmarks/tpch/fileleak/Tests/check1.reqtests b/sql/benchmarks/tpch/fileleak/Tests/check1.reqtests deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/check1.reqtests +++ /dev/null @@ -1,3 +0,0 @@ -create -check0 -load diff --git a/sql/benchmarks/tpch/fileleak/Tests/check1.sql b/sql/benchmarks/tpch/fileleak/Tests/check1.sql deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/check1.sql +++ /dev/null @@ -1,17 +0,0 @@ -select count(*) from customer; -select count(*) from nation; -select count(*) from orders; -select count(*) from partsupp; -select count(*) from part; -select count(*) from region; -select count(*) from supplier; -select count(*) from lineitem; - -select * from region limit 9; -select * from nation limit 9; -select * from supplier limit 9; -select * from customer limit 9; -select * from part limit 9; -select * from partsupp limit 9; -select * from orders limit 9; -select * from lineitem limit 9; diff --git a/sql/benchmarks/tpch/fileleak/Tests/check1.stable.err b/sql/benchmarks/tpch/fileleak/Tests/check1.stable.err deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/check1.stable.err +++ /dev/null @@ -1,17 +0,0 @@ -stderr of test 'check1` in directory 'sql/benchmarks/tpch/fileleak` itself: - - -# 19:09:29 > -# 19:09:29 > Mtimeout -timeout 180 Mserver "--config=/var/tmp/_PREFIX_MONET_GNU_32_d__/etc/monet.conf" --debug=10 --set "monet_mod_path=/var/tmp/_PREFIX_MONET_GNU_32_d__/lib/MonetDB:/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB" --set "gdk_dbfarm=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/dbfarm" --set "sql_logdir=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/log" --set mapi_port=56086 --set sql_port=51688 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" "/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB/sqlserver.mil" ; echo ; echo Over.. -# 19:09:29 > - - -# 19:09:29 > -# 19:09:29 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=51688 --trace < check1.sql -# 19:09:29 > - - -# 19:09:30 > -# 19:09:30 > Done. -# 19:09:30 > - diff --git a/sql/benchmarks/tpch/fileleak/Tests/check1.stable.out b/sql/benchmarks/tpch/fileleak/Tests/check1.stable.out deleted file mode 100644 --- a/sql/benchmarks/tpch/fileleak/Tests/check1.stable.out +++ /dev/null @@ -1,186 +0,0 @@ -stdout of test 'check1` in directory 'sql/benchmarks/tpch/fileleak` itself: - - -# 11:55:48 > -# 11:55:48 > mserver5 "--config=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=30364 --set xrpc_port=49769 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. -# 11:55:48 > - -# MonetDB server v5.6.1, based on kernel v1.24.1 -# Serving database 'mTests_src_benchmarks_tpch' -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Copyright (c) 1993-2008 CWI, all rights reserved -# Visit http://monetdb.cwi.nl/ for further information -# Listening for connection requests on mapi:monetdb://alviss.ins.cwi.nl:30364/ -# MonetDB/SQL module v2.24.1 loaded - -Ready. -#function user.main():void; -# clients.quit(); -#end main; - - -# 11:47:54 > -# 11:47:54 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35781 < check1.sql -# 11:47:54 > - -#select count(*) from customer; -% sys.L4 # table_name -% L3 # name -% bigint # type -% 4 # length -[ 1500 ] -#select count(*) from nation; -% sys.L4 # table_name -% L3 # name -% bigint # type -% 2 # length -[ 25 ] -#select count(*) from orders; -% sys.L4 # table_name -% L3 # name -% bigint # type -% 5 # length -[ 15000 ] -#select count(*) from partsupp; -% sys.L4 # table_name -% L3 # name -% bigint # type -% 4 # length -[ 8000 ] -#select count(*) from part; -% sys.L4 # table_name -% L3 # name -% bigint # type -% 4 # length -[ 2000 ] -#select count(*) from region; -% sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 5 ] -#select count(*) from supplier; -% sys.L4 # table_name -% L3 # name -% bigint # type -% 3 # length -[ 100 ] -#select count(*) from lineitem; -% sys.L4 # table_name -% L3 # name -% bigint # type -% 5 # length -[ 60175 ] -#select * from region limit 9; -% sys.region, sys.region, sys.region # table_name -% r_regionkey, r_name, r_comment # name -% int, char, varchar # type -% 1, 25, 115 # length -[ 0, "AFRICA", "lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to " ] -[ 1, "AMERICA", "hs use ironic, even requests. s" ] -[ 2, "ASIA", "ges. thinly even pinto beans ca" ] -[ 3, "EUROPE", "ly final courts cajole furiously final excuse" ] -[ 4, "MIDDLE EAST", "uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl" ] -#select * from nation limit 9; -% sys.nation, sys.nation, sys.nation, sys.nation # table_name -% n_nationkey, n_name, n_regionkey, n_comment # name -% int, char, int, varchar # type -% 1, 25, 1, 107 # length -[ 0, "ALGERIA", 0, " haggle. carefully final deposits detect slyly agai" ] -[ 1, "ARGENTINA", 1, "al foxes promise slyly according to the regular accounts. bold requests alon" ] -[ 2, "BRAZIL", 1, "y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special " ] -[ 3, "CANADA", 1, "eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold" ] -[ 4, "EGYPT", 4, "y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d" ] -[ 5, "ETHIOPIA", 0, "ven packages wake quickly. regu" ] -[ 6, "FRANCE", 3, "refully final requests. regular, ironi" ] -[ 7, "GERMANY", 3, "l platelets. regular accounts x-ray: unusual, regular acco" ] -[ 8, "INDIA", 2, "ss excuses cajole slyly across the packages. deposits print aroun" ] -#select * from supplier limit 9; -% sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier # table_name -% s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment # name -% int, char, varchar, int, char, decimal, varchar # type -% 1, 25, 35, 2, 15, 17, 99 # length -[ 1, "Supplier#000000001", " N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ", 17, "27-918-335-1736", 5755.94, "each slyly above the careful" ] -[ 2, "Supplier#000000002", "89eJ5ksX3ImxJQBvxObC,", 5, "15-679-861-2259", 4032.68, " slyly bold instructions. idle dependen" ] -[ 3, "Supplier#000000003", "q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3", 1, "11-383-516-1199", 4192.40, "blithely silent requests after the express dependencies are sl" ] -[ 4, "Supplier#000000004", "Bk7ah4CK8SYQTepEmvMkkgMwg", 15, "25-843-787-7479", 4641.08, "riously even requests above the exp" ] -[ 5, "Supplier#000000005", "Gcdm2rJRzl5qlTVzc", 11, "21-151-690-3663", -283.84, ". slyly regular pinto bea" ] -[ 6, "Supplier#000000006", "tQxuVm7s7CnK", 14, "24-696-997-4969", 1365.79, "final accounts. regular dolphins use against the furiously ironic decoys. " ] -[ 7, "Supplier#000000007", "s,4TicNGB4uO6PaSqNBUq", 23, "33-990-965-2201", 6820.35, "s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit" ] -[ 8, "Supplier#000000008", "9Sq4bBH2FQEmaFOocY45sRTxo6yuoG", 17, "27-498-742-3860", 7627.85, "al pinto beans. asymptotes haggl" ] -[ 9, "Supplier#000000009", "1KhUgZegwM3ua7dsYmekYBsK", 10, "20-403-398-8662", 5302.37, "s. unusual, even requests along the furiously regular pac" ] -#select * from customer limit 9; -% sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer # table_name -% c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment # name -% int, varchar, varchar, int, char, decimal, char, varchar # type -% 1, 18, 37, 2, 15, 17, 10, 113 # length -[ 1, "Customer#000000001", "IVhzIApeRb ot,c,E", 15, "25-989-741-2988", 711.56, "BUILDING", "to the even, regular platelets. regular, ironic epitaphs nag e" ] -[ 2, "Customer#000000002", "XSTf4,NCwDVaWNe6tEgvwfmRchLXak", 13, "23-768-687-3665", 121.65, "AUTOMOBILE", "l accounts. blithely ironic theodolites integrate boldly: caref" ] -[ 3, "Customer#000000003", "MG9kdTD2WBHm", 1, "11-719-748-3364", 7498.12, "AUTOMOBILE", " deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov" ] -[ 4, "Customer#000000004", "XxVSJsLAGtn", 4, "14-128-190-5944", 2866.83, "MACHINERY", " requests. final, regular ideas sleep final accou" ] -[ 5, "Customer#000000005", "KvpyuHCplrB84WgAiGV6sYpZq7Tj", 3, "13-750-942-6364", 794.47, "HOUSEHOLD", "n accounts will have to unwind. foxes cajole accor" ] -[ 6, "Customer#000000006", "sKZz0CsnMD7mp4Xd0YrBvx,LREYKUWAh yVn", 20, "30-114-968-4951", 7638.57, "AUTOMOBILE", "tions. even deposits boost according to the slyly bold packages. final accounts cajole requests. furious" ] -[ 7, "Customer#000000007", "TcGe5gaZNgVePxU5kRrvXBfkasDTea", 18, "28-190-982-9759", 9561.95, "AUTOMOBILE", "ainst the ironic, express theodolites. express, even pinto beans among the exp" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
