Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/Connections/Tests connections.stable.err, NONE, 1.1 connections.stable.out, NONE, 1.1 connections.py, 1.4, 1.5

26 Mar 2007

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
-- 
Sjoerd Mullender


    