On 2007-03-26 13:00, Romulo Goncalves wrote:

Update of /cvsroot/monetdb/sql/src/test/Connections/Tests In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv4526/Tests

Modified Files: connections.py Added Files: connections.stable.err connections.stable.out Log Message: The connections test now is green. Thanks Stefan for the help...

Index: connections.py

RCS file: /cvsroot/monetdb/sql/src/test/Connections/Tests/connections.py,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- connections.py 23 Mar 2007 18:24:48 -0000 1.4 +++ connections.py 26 Mar 2007 11:00:13 -0000 1.5 @@ -42,12 +42,22 @@

def client_load_file(clt, port, file): f = open(file, 'r')

• sys_err = sys.stderr
• clt_err = open('%s/err.log' % os.getenv('RELSRCDIR'), 'w')
• sys.stderr = clt_err

Use os.path.join to join paths (as in os.path.join(os.getenv('RELSRCDIR'), 'err.log')).

 for line in f:

line = line.replace('port_num', str(port+1))

• line = line.replace('port_num_5', str(port+2))
• line = line.replace('port_num_6', str(port+3))

• line = line.replace('port_num5', str(port+2)) clt.write(line)

•    clt_err.close()
  

• clt_err = open('%s/err.log' % os.getenv('RELSRCDIR'), 'r')                       
  

• for line1 in clt_err:

• sys.stderr.write('%s\n' %  (line1.replace('port %s' %  str(port+1),'port <mapi_port>')))
  

• sys.stderr.write('#%s\n' % line1)
  

• clt_err.close()
  

• sys.stderr = sys_err
• os.remove('%s/err.log' % os.getenv('RELSRCDIR'))
• f.close()

def client(x,s, c, dbinit, lang, file):

--- NEW FILE: connections.stable.out --- stdout of test 'connections` in directory 'src/test/Connections` itself:

# 12:08:28 > # 12:08:28 > Mtimeout -timeout 180 /usr/bin/python connections.py connections # 12:08:28 >

server 11 : "include sql;" !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !WARNING: BBPdir: initializing BBP. # MonetDB Server v5.0.0_beta2_1 # 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_Connections # Visit http://monetdb.cwi.nl/ for further information

server 12 : "include sql;" # MonetDB Server v5.0.0_beta2_1 # 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_Connections_test1 # Visit http://monetdb.cwi.nl/ for further information

server 12 : "include sql;", client 1: SQL % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length

server 12 : "include sql;", client 2: SQL % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length [ "localhost", "mTests_src_test_Connections_test1", "test_db", "sql" ] % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length [ "localhost", "mTests_src_test_Connections_test1", "test_db", "sql" ] % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length [ "localhost", "mTests_src_test_Connections_test1", "test_db", "sql" ] % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length

server 12 : "include sql;", client 3: SQL % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length [ "localhost", "mTests_src_test_Connections_test1", "localhost_mTests_src_test_Connections_test1_monetdb", "sql" ] % sys.connections, sys.connections, sys.connections, sys.connections # table_name % server, db, db_alias, language # name % char, char, char, char # type % 1024, 64, 1024, 1024 # length

# 12:18:14 > # 12:18:14 > Done. # 12:18:14 >

--- NEW FILE: connections.stable.err --- stderr of test 'connections` in directory 'src/test/Connections` itself:

# 12:08:28 > # 12:08:28 > Mtimeout -timeout 180 /usr/bin/python connections.py connections # 12:08:28 >

server 11 : "include sql;"

mserver: "Mtimeout -timeout 60 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs" --set "xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs" --set mapi_port=<mapi_port> --set xrpc_port=<xrpc_port> --set monet_prompt= --trace --dbname "mTests_src_test_Connections" --dbinit="include sql;"" #mserver: "Mtimeout -timeout 60 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs" --set "xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs" --set mapi_port=34118 --set xrpc_port=40549 --set monet_prompt= --trace --dbname "mTests_src_test_Connections" --dbinit="include sql;"" # builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu # builtin opt gdk_version = 1.17.1 # builtin opt monet_pid = 3601 # builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB # builtin opt exec_prefix = ${prefix} # builtin opt gdk_dbname = tst # builtin opt gdk_dbfarm = ${prefix}/var/MonetDB # builtin opt gdk_debug = 8 # builtin opt gdk_mem_bigsize = 262144 # builtin opt gdk_vm_minsize = 137438953472 # builtin opt gdk_alloc_map = yes # builtin opt gdk_mem_pagebits = 14 # builtin opt monet_admin = adm # builtin opt monet_prompt = > # builtin opt monet_welcome = yes # builtin opt monet_mod_path = ${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin # builtin opt monet_daemon = yes # builtin opt host = localhost # builtin opt mapi_port = 50000 # builtin opt mapi_noheaders = no # builtin opt mapi_debug = 0 # builtin opt mapi_clients = 2 # builtin opt sql_debug = 0 # builtin opt sql_logdir = ${prefix}/var/MonetDB/sql_logs # builtin opt xquery_logdir = ${prefix}/var/MonetDB/xquery_logs # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff # builtin opt standoff_start = start # builtin opt standoff_end = end # config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5 # config opt config = ${prefix}/etc/monetdb5.conf # config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5 # config opt exec_prefix = ${prefix} # config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm # config opt gdk_dbname = demo # config opt gdk_alloc_map = no # config opt gdk_embedded = no # config opt gdk_debug = 0 # config opt monet_mod_path = ${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin # config opt monet_daemon = no # config opt monet_welcome = yes # config opt delay = 120 # config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal # config opt mal_listing = 15 # config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt # config opt mapi_port = 0 # config opt sql_debug = 0 # config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs # config opt pf_httpd_port = 8080 # config opt xquery_output = dm # config opt xquery_cacheMB = 100 # config opt xquery_logdir = ${prefix}/var/MonetDB5/xquery_logs # cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf # cmdline opt gdk_debug = 10 # cmdline opt monet_mod_path = /ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin # cmdline opt gdk_dbfarm = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm # cmdline opt sql_logdir = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs # cmdline opt xquery_logdir = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs # cmdline opt mapi_port = 31021 # cmdline opt xrpc_port = 44351 # cmdline opt monet_prompt = # cmdline opt gdk_dbname = mTests_src_test_Connections #warning: please don't forget to set your vault key! #(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf)

server 12 : "include sql;"

remote mserver: "Mtimeout -timeout 60 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs" --set "xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs" --set mapi_port=<mapi_port> --set xrpc_port=<xrpc_port> --set monet_prompt= --trace --dbname "mTests_src_test_Connections_test1" --dbinit="include sql;"" #remote mserver: "Mtimeout -timeout 60 mserver5 "--config=/ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs" --set "xquery_logdir=/ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs" --set mapi_port=34119 --set xrpc_port=40549 --set monet_prompt= --trace --dbname "mTests_src_test_Connections_test1" --dbinit="include sql;"" # builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu # builtin opt gdk_version = 1.17.1 # builtin opt monet_pid = 3611 # builtin opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB # builtin opt exec_prefix = ${prefix} # builtin opt gdk_dbname = tst # builtin opt gdk_dbfarm = ${prefix}/var/MonetDB # builtin opt gdk_debug = 8 # builtin opt gdk_mem_bigsize = 262144 # builtin opt gdk_vm_minsize = 137438953472 # builtin opt gdk_alloc_map = yes # builtin opt gdk_mem_pagebits = 14 # builtin opt monet_admin = adm # builtin opt monet_prompt = > # builtin opt monet_welcome = yes # builtin opt monet_mod_path = ${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin # builtin opt monet_daemon = yes # builtin opt host = localhost # builtin opt mapi_port = 50000 # builtin opt mapi_noheaders = no # builtin opt mapi_debug = 0 # builtin opt mapi_clients = 2 # builtin opt sql_debug = 0 # builtin opt sql_logdir = ${prefix}/var/MonetDB/sql_logs # builtin opt xquery_logdir = ${prefix}/var/MonetDB/xquery_logs # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff # builtin opt standoff_start = start # builtin opt standoff_end = end # config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5 # config opt config = ${prefix}/etc/monetdb5.conf # config opt prefix = /ufs/goncalve/scratch/MonetDB/MonetDB5 # config opt exec_prefix = ${prefix} # config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm # config opt gdk_dbname = demo # config opt gdk_alloc_map = no # config opt gdk_embedded = no # config opt gdk_debug = 0 # config opt monet_mod_path = ${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin # config opt monet_daemon = no # config opt monet_welcome = yes # config opt delay = 120 # config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal # config opt mal_listing = 15 # config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt # config opt mapi_port = 0 # config opt sql_debug = 0 # config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs # config opt pf_httpd_port = 8080 # config opt xquery_output = dm # config opt xquery_cacheMB = 100 # config opt xquery_logdir = ${prefix}/var/MonetDB5/xquery_logs # cmdline opt config = /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf # cmdline opt gdk_debug = 10 # cmdline opt monet_mod_path = /ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/MonetDB5/lib/MonetDB5/bin # cmdline opt gdk_dbfarm = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/dbfarm # cmdline opt sql_logdir = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/sql_logs # cmdline opt xquery_logdir = /ufs/goncalve/scratch/MonetDB/MonetDB5/var/MonetDB5/xquery_logs # cmdline opt mapi_port = 31022 # cmdline opt xrpc_port = 44351 # cmdline opt monet_prompt = # cmdline opt gdk_dbname = mTests_src_test_Connections_test1 #warning: please don't forget to set your vault key! #(see /ufs/goncalve/scratch/MonetDB/MonetDB5/etc/monetdb5.conf)

server 12 : "include sql;", client 1: SQL

client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=<mapi_port> " #client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35647 " !ERROR mapi_reconnect: connect: Connection refused MAPI = monetdb@localhost:34118 QUERY = connect to 'localhost' port 34 database 'mTests_src_test_Connections_test1' as 'test_db_1' user 'monetdb' password 'monetdb' language 'sql'; ERROR = !IOException:mserver.connect:Could not connect: Setup connection failed MAPI = monetdb@localhost:34118 QUERY = connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db_1' language 'sql'; ERROR = !syntax error, unexpected LANGUAGE, expecting USER in: "connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db_1' language" MAPI = monetdb@localhost:34118 QUERY = connect to 'localhost' database 'mTests_src_test_Connections_test1'; ERROR = !syntax error, unexpected SCOLON, expecting USER in: "connect to 'localhost' database 'mTests_src_test_Connections_test1';" MAPI = monetdb@localhost:34118 QUERY = connect 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db_1' user 'monetdb' password 'monetdb' language 'sql'; ERROR = !syntax error, unexpected STRING, expecting TO in: "connect 'localhost'" MAPI = monetdb@localhost:34118 QUERY = connect to 'localhost' port 34119 as 'test_db_1' user 'monetdb' password 'monetdb' language 'sql'; ERROR = !syntax error, unexpected AS, expecting DATABASE in: "connect to 'localhost' port 34119 as" MAPI = monetdb@localhost:34118 QUERY = connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' language 'sql'; ERROR = !syntax error, unexpected LANGUAGE, expecting PASSWORD in: "connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' language" MAPI = monetdb@localhost:34118 QUERY = disconnect 'test_db_1'; ERROR = !DISCONNECT CATALOG: no such db_alias 'test_db_1'

server 12 : "include sql;", client 2: SQL

client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=<mapi_port> " #client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=34118 " MAPI = monetdb@localhost:34118 QUERY = connect to 'localhost' port 341195 database 'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' password 'monetdb' language 'sql'; ERROR = !CONNECT TO: this connection already exists or the db_alias 'test_db' was already used! MAPI = monetdb@localhost:34118 QUERY = connect to 'localhost' port 34119 database 'mTests_src_test_Connections_test1' as 'test' user 'monetdb' password 'monetdb' language 'sql'; ERROR = !CONNECT TO: this connection already exists or the db_alias 'test' was already used! MAPI = monetdb@localhost:34118 QUERY = connect to 'localhost' port 4000 database 'dmo' as 'test_db' user 'monetdb' password 'monetdb' language 'sql'; ERROR = !CONNECT TO: this connection already exists or the db_alias 'test_db' was already used! MAPI = monetdb@localhost:34118 QUERY = disconnect 'test_db'; ERROR = !DISCONNECT CATALOG: no such db_alias 'test_db' MAPI = monetdb@localhost:34118 QUERY = disconnect 'test_tb'; ERROR = !DISCONNECT CATALOG: no such db_alias 'test_tb'

server 12 : "include sql;", client 3: SQL

client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=<mapi_port> " #client1: "Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35647 "

# 12:08:39 > # 12:08:39 > Done. # 12:08:39 >

---

Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D... _______________________________________________ Monetdb-sql-checkins mailing list Monetdb-sql-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins