Changeset: 08a38dbbbd3f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=08a38dbbbd3f Modified Files: sql/test/BugTracker-2011/Tests/All sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.sql sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.err sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.out Branch: Aug2011 Log Message:
Added test for bug 2882. This test runs fine when running single threaded. It results in a timeout and totally bogus results when running multi-threaded. diffs (truncated from 445 to 300 lines): diff --git a/sql/test/BugTracker-2011/Tests/All b/sql/test/BugTracker-2011/Tests/All --- a/sql/test/BugTracker-2011/Tests/All +++ b/sql/test/BugTracker-2011/Tests/All @@ -35,3 +35,4 @@ multicolumn_constraints.Bug-2849 CASE_nested_functions.Bug-2852 FK_self_reference.Bug-2862 time_precision.Bug-2873 +delete-large-table.Bug-2882 diff --git a/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.sql b/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.sql @@ -0,0 +1,69 @@ +create table bigtable2882 (i int); +insert into bigtable2882 values (1); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; +insert into bigtable2882 (select * from bigtable2882); +select count(*) from bigtable2882; + +create table test2882(id bigint); +insert into test2882(id) SELECT ROW_NUMBER () OVER () FROM bigtable2882 limit 20000000; +select count(*) from test2882; +select * from test2882 where id = 1; +select * from test2882 where id = 20000000; +select * from test2882 where id in (1, 20000000); +delete from test2882 where id = 1; +delete from test2882 where id = 20000000; +select count(*) from test2882; +select * from test2882 where id = 1; +select * from test2882 where id = 20000000; +select * from test2882 where id in (1, 20000000); + +drop table bigtable2882; +drop table test2882; diff --git a/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.err b/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.err @@ -0,0 +1,37 @@ +stderr of test 'delete-large-table.Bug-2882` in directory 'test/BugTracker-2011` itself: + + +# 11:01:08 > +# 11:01:08 > mserver5 --debug=10 --set gdk_nr_threads=1 --set "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" --set mapi_open=true --set mapi_port=37694 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_test_BugTracker-2011" --set mal_listing=0 ; echo ; echo Over.. +# 11:01:08 > + +# builtin opt gdk_dbname = demo +# builtin opt gdk_dbfarm = /ufs/sjoerd/Monet-candidate/var/monetdb5/dbfarm +# builtin opt gdk_debug = 0 +# builtin opt gdk_alloc_map = no +# builtin opt gdk_vmtrim = yes +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 1 +# cmdline opt gdk_dbfarm = /ufs/sjoerd/Monet-candidate/var/MonetDB +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 37694 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbname = mTests_test_BugTracker-2011 +# cmdline opt mal_listing = 0 + +# 11:01:09 > +# 11:01:09 > mclient -lsql -ftest -i -e --host=ottar --port=37694 +# 11:01:09 > + + +# 11:01:24 > +# 11:01:24 > Done. +# 11:01:24 > + diff --git a/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.out b/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.out @@ -0,0 +1,316 @@ +stdout of test 'delete-large-table.Bug-2882` in directory 'test/BugTracker-2011` itself: + + +# 11:01:08 > +# 11:01:08 > mserver5 --debug=10 --set gdk_nr_threads=1 --set "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" --set mapi_open=true --set mapi_port=37694 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_test_BugTracker-2011" --set mal_listing=0 ; echo ; echo Over.. +# 11:01:08 > + +# MonetDB 5 server v11.5.2 +# This is an unreleased version +# Serving database 'mTests_test_BugTracker-2011', using 1 thread +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 7.749 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://ottar.ins.cwi.nl:37694/ +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. +# SQL catalog created, loading sql scripts once +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/10_math.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/11_times.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/12_url.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/13_date.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/14_inet.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/15_history.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/16_tracelog.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/17_compress.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/18_dictionary.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/19_cluster.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/20_vacuum.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/21_dependency_functions.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/22_clients.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/23_skyserver.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/24_zorder.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/25_debug.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/40_geom.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/80_udf.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/99_system.sql + +Over.. + +# 11:01:09 > +# 11:01:09 > mclient -lsql -ftest -i -e --host=ottar --port=37694 +# 11:01:09 > + +#create table bigtable2882 (i int); +#insert into bigtable2882 values (1); +[ 1 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L2 # name +% wrd # type +% 1 # length +[ 1 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 1 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L3 # name +% wrd # type +% 1 # length +[ 2 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 2 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L4 # name +% wrd # type +% 1 # length +[ 4 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 4 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L5 # name +% wrd # type +% 1 # length +[ 8 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 8 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L6 # name +% wrd # type +% 2 # length +[ 16 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 16 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L7 # name +% wrd # type +% 2 # length +[ 32 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 32 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L10 # name +% wrd # type +% 2 # length +[ 64 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 64 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L11 # name +% wrd # type +% 3 # length +[ 128 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 128 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L12 # name +% wrd # type +% 3 # length +[ 256 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 256 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L13 # name +% wrd # type +% 3 # length +[ 512 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 512 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L14 # name +% wrd # type +% 4 # length +[ 1024 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 1024 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L15 # name +% wrd # type +% 4 # length +[ 2048 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 2048 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L16 # name +% wrd # type +% 4 # length +[ 4096 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 4096 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L17 # name +% wrd # type +% 4 # length +[ 8192 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 8192 ] +#select count(*) from bigtable2882; +% sys.bigtable2882 # table_name +% L20 # name +% wrd # type +% 5 # length +[ 16384 ] +#insert into bigtable2882 (select * from bigtable2882); +[ 16384 ] +#select count(*) from bigtable2882; _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
