Changeset: b6b5dbb0d585 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b6b5dbb0d585
Modified Files:
sql/test/wlcr/Tests/wlc01.py
sql/test/wlcr/Tests/wlc01.stable.out
sql/test/wlcr/Tests/wlc100.py
sql/test/wlcr/Tests/wlc100.stable.out
sql/test/wlcr/Tests/wlc20.py
sql/test/wlcr/Tests/wlc20.stable.out
sql/test/wlcr/Tests/wlc21.py
sql/test/wlcr/Tests/wlc21.stable.out
sql/test/wlcr/Tests/wlc30.py
sql/test/wlcr/Tests/wlc30.stable.out
sql/test/wlcr/Tests/wlc40.py
sql/test/wlcr/Tests/wlc40.stable.out
sql/test/wlcr/Tests/wlc50.py
sql/test/wlcr/Tests/wlc50.stable.out
sql/test/wlcr/Tests/wlc70.py
sql/test/wlcr/Tests/wlc70.stable.out
Branch: default
Log Message:
Trace the actual content of the WLC files
diffs (truncated from 683 to 300 lines):
diff --git a/sql/test/wlcr/Tests/wlc01.py b/sql/test/wlcr/Tests/wlc01.py
--- a/sql/test/wlcr/Tests/wlc01.py
+++ b/sql/test/wlcr/Tests/wlc01.py
@@ -35,3 +35,22 @@ sys.stdout.write(sout)
sys.stdout.write(cout)
sys.stderr.write(serr)
sys.stderr.write(cerr)
+
+def listfiles(path):
+ for f in os.listdir(path):
+ if f.find('wlc') >= 0 and f != 'wlc_logs':
+ file = path + os.path.sep + f
+ sys.stdout.write(file + "\n")
+ try:
+ x = open(file)
+ s = x.read()
+ lines = s.split('\n')
+ for l in lines:
+ sys.stdout.write('#' + l + '\n')
+ x.close()
+ except IOError:
+ sys.stderr.write('Failure to read file ' + file + '\n')
+
+listfiles(dbfarm + os.path.sep + tstdb)
+listfiles(dbfarm + os.path.sep + tstdb + os.path.sep + 'wlc_logs')
+
diff --git a/sql/test/wlcr/Tests/wlc01.stable.out
b/sql/test/wlcr/Tests/wlc01.stable.out
--- a/sql/test/wlcr/Tests/wlc01.stable.out
+++ b/sql/test/wlcr/Tests/wlc01.stable.out
@@ -68,6 +68,26 @@ stdout of test 'wlc01` in directory 'sql
% 1, 5 # length
[ 1, "hello" ]
[ 2, "world" ]
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config
+#logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/
+#id=2
+#write=2019-08-14T10:03:32.000
+#state=1
+#batches=2
+#beat=0
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001
+# wlr.transaction(1:lng, "2019-08-14T10:03:32.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000
+# wlr.transaction(0:lng, "2019-08-14T10:03:32.000":str, "monetdb":str);
+# wlr.catalog("create table tmp(i int, s string);":str);
+# wlr.commit();
+#
# 21:28:51 >
# 21:28:51 > "Done."
diff --git a/sql/test/wlcr/Tests/wlc100.py b/sql/test/wlcr/Tests/wlc100.py
--- a/sql/test/wlcr/Tests/wlc100.py
+++ b/sql/test/wlcr/Tests/wlc100.py
@@ -31,3 +31,21 @@ sys.stdout.write(sout)
sys.stdout.write(cout)
sys.stderr.write(serr)
sys.stderr.write(cerr)
+
+def listfiles(path):
+ for f in os.listdir(path):
+ if f.find('wlc') >= 0 and f != 'wlc_logs':
+ file = path + os.path.sep + f
+ sys.stdout.write(file + "\n")
+ try:
+ x = open(file)
+ s = x.read()
+ lines = s.split('\n')
+ for l in lines:
+ sys.stdout.write('#' + l + '\n')
+ x.close()
+ except IOError:
+ sys.stderr.write('Failure to read file ' + file + '\n')
+
+listfiles(dbfarm + os.path.sep + tstdb)
+listfiles(dbfarm + os.path.sep + tstdb + os.path.sep + 'wlc_logs')
diff --git a/sql/test/wlcr/Tests/wlc100.stable.out
b/sql/test/wlcr/Tests/wlc100.stable.out
--- a/sql/test/wlcr/Tests/wlc100.stable.out
+++ b/sql/test/wlcr/Tests/wlc100.stable.out
@@ -25,6 +25,81 @@ stdout of test 'wlc100` in directory 'sq
% int, clob # type
% 2, 19 # length
[ 40, "after being stopped" ]
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config
+#logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/
+#id=10
+#write=2019-08-14T10:05:49.000
+#state=2
+#batches=10
+#beat=0
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000008
+# wlr.transaction(8:lng, "2019-08-14T10:05:49.000":str, "monetdb":str);
+# wlr.catalog("create table tmp70(i int, s string);":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004
+# wlr.transaction(4:lng, "2019-08-14T10:05:44.000":str, "monetdb":str);
+# wlr.action("update tmp set i = 3 where i = 1;":str);
+# wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003
+# wlr.transaction(3:lng, "2019-08-14T10:05:41.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000009
+# wlr.transaction(9:lng, "2019-08-14T10:05:49.000":str, "monetdb":str);
+# wlr.action("insert into tmp70 values(1,\\'hello\\'),
(2,\\'world\\');":str);
+# wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int);
+# wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007
+# wlr.transaction(7:lng, "2019-08-14T10:05:48.000":str, "monetdb":str);
+# wlr.action("delete from tmp;":str);
+# wlr.clear_table("sys":str, "tmp":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001
+# wlr.transaction(1:lng, "2019-08-14T10:05:39.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005
+# wlr.transaction(5:lng, "2019-08-14T10:05:44.000":str, "monetdb":str);
+# wlr.action("update tmp set s = \\'blah\\';":str);
+# wlr.update("sys":str, "tmp":str, "s":str, 0@0:oid, "blah":str);
+# wlr.update("sys":str, "tmp":str, "s":str, 1@0:oid, "blah":str);
+# wlr.update("sys":str, "tmp":str, "s":str, 2@0:oid, "blah":str);
+# wlr.update("sys":str, "tmp":str, "s":str, 3@0:oid, "blah":str);
+# wlr.update("sys":str, "tmp":str, "s":str, 4@0:oid, "blah":str);
+# wlr.update("sys":str, "tmp":str, "s":str, 5@0:oid, "blah":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006
+# wlr.transaction(6:lng, "2019-08-14T10:05:46.000":str, "monetdb":str);
+# wlr.action("delete from tmp where i < 4;":str);
+# wlr.delete("sys":str, "tmp":str, 0@0:oid, 0@0:oid, 0@0:oid);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002
+# wlr.transaction(2:lng, "2019-08-14T10:05:40.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000
+# wlr.transaction(0:lng, "2019-08-14T10:05:39.000":str, "monetdb":str);
+# wlr.catalog("create table tmp(i int, s string);":str);
+# wlr.commit();
+#
# 21:26:02 >
# 21:26:02 > "Done."
diff --git a/sql/test/wlcr/Tests/wlc20.py b/sql/test/wlcr/Tests/wlc20.py
--- a/sql/test/wlcr/Tests/wlc20.py
+++ b/sql/test/wlcr/Tests/wlc20.py
@@ -30,3 +30,21 @@ sys.stdout.write(sout)
sys.stdout.write(cout)
sys.stderr.write(serr)
sys.stderr.write(cerr)
+
+def listfiles(path):
+ for f in os.listdir(path):
+ if f.find('wlc') >= 0 and f != 'wlc_logs':
+ file = path + os.path.sep + f
+ sys.stdout.write(file + "\n")
+ try:
+ x = open(file)
+ s = x.read()
+ lines = s.split('\n')
+ for l in lines:
+ sys.stdout.write('#' + l + '\n')
+ x.close()
+ except IOError:
+ sys.stderr.write('Failure to read file ' + file + '\n')
+
+listfiles(dbfarm + os.path.sep + tstdb)
+listfiles(dbfarm + os.path.sep + tstdb + os.path.sep + 'wlc_logs')
diff --git a/sql/test/wlcr/Tests/wlc20.stable.out
b/sql/test/wlcr/Tests/wlc20.stable.out
--- a/sql/test/wlcr/Tests/wlc20.stable.out
+++ b/sql/test/wlcr/Tests/wlc20.stable.out
@@ -28,6 +28,33 @@ stdout of test 'wlc20` in directory 'sql
[ 2, "world" ]
[ 3, "blah" ]
[ 4, "bloh" ]
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config
+#logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/
+#id=3
+#write=2019-08-14T10:03:32.000
+#state=1
+#batches=3
+#beat=0
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001
+# wlr.transaction(1:lng, "2019-08-14T10:03:32.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002
+# wlr.transaction(2:lng, "2019-08-14T10:03:32.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000
+# wlr.transaction(0:lng, "2019-08-14T10:03:32.000":str, "monetdb":str);
+# wlr.catalog("create table tmp(i int, s string);":str);
+# wlr.commit();
+#
# 21:28:52 >
# 21:28:52 > "Done."
diff --git a/sql/test/wlcr/Tests/wlc21.py b/sql/test/wlcr/Tests/wlc21.py
--- a/sql/test/wlcr/Tests/wlc21.py
+++ b/sql/test/wlcr/Tests/wlc21.py
@@ -30,3 +30,21 @@ sys.stdout.write(sout)
sys.stdout.write(cout)
sys.stderr.write(serr)
sys.stderr.write(cerr)
+
+def listfiles(path):
+ for f in os.listdir(path):
+ if f.find('wlc') >= 0 and f != 'wlc_logs':
+ file = path + os.path.sep + f
+ sys.stdout.write(file + "\n")
+ try:
+ x = open(file)
+ s = x.read()
+ lines = s.split('\n')
+ for l in lines:
+ sys.stdout.write('#' + l + '\n')
+ x.close()
+ except IOError:
+ sys.stderr.write('Failure to read file ' + file + '\n')
+
+listfiles(dbfarm + os.path.sep + tstdb)
+listfiles(dbfarm + os.path.sep + tstdb + os.path.sep + 'wlc_logs')
diff --git a/sql/test/wlcr/Tests/wlc21.stable.out
b/sql/test/wlcr/Tests/wlc21.stable.out
--- a/sql/test/wlcr/Tests/wlc21.stable.out
+++ b/sql/test/wlcr/Tests/wlc21.stable.out
@@ -30,6 +30,40 @@ stdout of test 'wlc21` in directory 'sql
[ 4, "bloh" ]
[ 5, "red" ]
[ 6, "fox" ]
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config
+#logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/
+#id=4
+#write=2019-08-14T10:03:34.000
+#state=1
+#batches=4
+#beat=0
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003
+# wlr.transaction(3:lng, "2019-08-14T10:03:34.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001
+# wlr.transaction(1:lng, "2019-08-14T10:03:32.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002
+# wlr.transaction(2:lng, "2019-08-14T10:03:32.000":str, "monetdb":str);
+# wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str);
+# wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int);
+# wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str);
+# wlr.commit();
+#
+/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000
+# wlr.transaction(0:lng, "2019-08-14T10:03:32.000":str, "monetdb":str);
+# wlr.catalog("create table tmp(i int, s string);":str);
+# wlr.commit();
+#
# 21:28:52 >
# 21:28:52 > "Done."
diff --git a/sql/test/wlcr/Tests/wlc30.py b/sql/test/wlcr/Tests/wlc30.py
--- a/sql/test/wlcr/Tests/wlc30.py
+++ b/sql/test/wlcr/Tests/wlc30.py
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
