Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv20889/src/test/BugTracker/Tests
Modified Files:
All
Added Files:
crash_on_concurrent_use.SF-1411926.py
crash_on_concurrent_use.SF-1411926.sql
select_id_not_in_another_select.SF-1737777.stable.err
select_id_not_in_another_select.SF-1737777.stable.out
Log Message:
propagated changes of Wednesday Jun 20 2007 - Thursday Jun 21 2007
from the SQL_2-18 branch to the development trunk
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.60
retrieving revision 1.61
diff -u -d -r1.60 -r1.61
--- All 15 Jun 2007 14:32:44 -0000 1.60
+++ All 22 Jun 2007 07:09:13 -0000 1.61
@@ -75,3 +75,4 @@
update_fkey_with_value_not_in_the_pkey.SF-1734143
alter_table_add_fkey.SF-1737668
select_id_not_in_another_select.SF-1737777
+crash_on_concurrent_use.SF-1411926
--- NEW FILE: crash_on_concurrent_use.SF-1411926.sql ---
select count(*) from tables;
create table t1(i int);
insert into t1 values(1);
insert into t1 values(2);
select * from t1;
drop table t1;
--- NEW FILE: select_id_not_in_another_select.SF-1737777.stable.out ---
stdout of test 'select_id_not_in_another_select.SF-1737777` in directory
'src/test/BugTracker` itself:
# 09:42:27 >
# 09:42:27 > Mtimeout -timeout 180 mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/xquery_logs"
--set mapi_open=true --set mapi_port=32420 --set xrpc_port=48768 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --dbinit=' include
sql;' ; echo ; echo Over..
# 09:42:27 >
# MonetDB Server v5.0.0
# Copyright (c) 1993-2007 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# dbname:mTests_src_test_BugTracker
# Visit http://monetdb.cwi.nl/ for further information
Ready.
Over..
# 09:42:27 >
# 09:42:27 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=32420
# 09:42:27 >
# 09:42:28 >
# 09:42:28 > Done.
# 09:42:28 >
--- NEW FILE: select_id_not_in_another_select.SF-1737777.stable.err ---
stderr of test 'select_id_not_in_another_select.SF-1737777` in directory
'src/test/BugTracker` itself:
# 09:42:27 >
# 09:42:27 > Mtimeout -timeout 180 mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/xquery_logs"
--set mapi_open=true --set mapi_port=32420 --set xrpc_port=48768 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --dbinit=' include
sql;' ; echo ; echo Over..
# 09:42:27 >
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)
# 09:42:27 >
# 09:42:27 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=32420
# 09:42:27 >
MAPI = [EMAIL PROTECTED]:32420
QUERY = select objID1 from "Match" where objID1 not in (select objID1 from
ERROR = !SELECT: outer reference in the selection part is not supported
# 09:42:28 >
# 09:42:28 > Done.
# 09:42:28 >
--- NEW FILE: crash_on_concurrent_use.SF-1411926.py ---
import os, time, sys, subprocess, threading
def server_start(dbinit):
srvcmd = '%s --dbname "%s" --dbinit="%s"' %
(os.getenv('MSERVER'),os.getenv('TSTDB'),dbinit)
sys.stderr.write('#mserver: "%s"\n' % (srvcmd))
sys.stdout.flush()
sys.stderr.flush()
srv = os.popen(srvcmd, 'w')
time.sleep(5) # give server time to start
return srv
def server_stop(srv):
srv.close()
def clients(client, runs, clmd):
for i in range(runs):
sys.stdout.write('#start client %d run %d %d \t' % (client, i,
time.time()))
sys.stdout.flush()
sys.stderr.flush()
clt = os.popen(clcmd, 'w')
clt.close()
sys.stdout.write('#close client %d run %d %d \n' % (client, i,
time.time()))
class Client(threading.Thread):
def __init__(self, client):
threading.Thread.__init__ (self)
self.client= client
def run(self):
global clcmd
clcmd = str(os.getenv('SQL_CLIENT')) + "< %s" %
('%s/crash_on_concurrent_use.SF-1411926.sql' % os.getenv('RELSRCDIR'))
sys.stderr.write('#client%d: "%s"\n' % (self.client, clcmd))
clients(self.client, 20, clcmd)
def main():
srv = server_start('include sql;')
client_0 = Client(0)
client_1 = Client(1)
client_0.start()
client_1.start()
server_stop(srv)
main()
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
