Test wlr100.py (id 3c6cbe78e1fe) (err)
wlr100.stable.out.FILTERED 2019-09-08 13:52:38.224913600 +0200wlr100.test.out.FILTERED 2019-09-08 13:52:38.224913600 +0200
1 Statistics about stdout of test 'wlr100` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlr100` in directory 'sql/test/wlcr`: 1
2 16 lines, 39 words, 1414 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 12 lines, 19 words, 1293 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 16 lines, 39 words, 1414 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 12 lines, 19 words, 1293 chars in lines not matching '^$|^(\| |)#` 3
4 # 110 lines, 408 words, 5118 chars in all lines 4 ! 4 # 98 lines, 352 words, 4589 chars in all lines 4
5 5 5 5
..................
# MonetDB 5 server v11.26.0
14 # This is an unreleased version 14 14 # This is an unreleased version 14
15 # Serving database 'mTests_sql_test_wlcr-clone', using 8 threads 15 ! 15 # Serving database 'mTests_sql_test_wlcr-clone', using 6 threads 15
16 # Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers 16 ! 16 # Compiled for x86_64-pc-winnt/64bit 16
17 # Found 15.589 GiB available main-memory. 17 ! 17 # Found 29.999 GiB available main-memory. 17
18 # Copyright (c) 1993-July 2008 CWI. 18 + 18 # Copyright (c) 1993 - July 2008 CWI. 18
19 # Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved 19 ! 19 # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved 19
20 # Visit http://www.monetdb.org/ for further information 20 ! 20 # Visit https://www.monetdb.org/ for further information 20
21 # Listening for connection requests on mapi:monetdb://vienna.da.cwi.nl:42547/ 21 ! 21 # Listening for connection requests on mapi:monetdb://win2k12r2:61061/ 21
22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-30891/.s.monetdb.42547 22 -
23 # MonetDB/GIS module loaded 23 22 # MonetDB/GIS module loaded 22
24 # MonetDB/SQL module loaded 24 23 # MonetDB/SQL module loaded 23
25 #sleep 1000 ms 25 ! 24 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc.config 24
26 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr-clone/../mTests_sql_test_wlcr/master/mTests_sql_test_wlcr_000000000029 26 ! 25 #logs=C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\ 25
27 #sleep 1000 ms 27 -
28 #call waitformaster(); 28 -
29 #waiting for master 29 < 30 29 -
30 #in sync with master 30 == 30 30 -
31 #select * from tmp; 31 -
32 % sys.tmp, sys.tmp # table_name 32 -
33 % i, s # name 33 -
34 % int, clob # type 34 -
35 % 1, 0 # length 35 -
36 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 36 -
37 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 37 -
38 #id=10 38 26 #id=10 26
..................
#beat=0
43 # 43 31 # 31
44 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000008 44 ! 32 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000000 32
45 # wlr.transaction(8:lng, "2019-08-14T12:11:30.000":str, "monetdb":str); 45 ! 33 # wlr.transaction(0:lng, "2019-09-09T02:52:21.000":str, "monetdb":str); 33
46 # wlr.catalog("create table tmp70(i int, s string);":str); 46 - 34 # wlr.catalog("create table tmp(i int, s string);":str); 34
47 # wlr.commit(); 47 35 # wlr.commit(); 35
48 # 48 36 # 36
49 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 49 ! 37 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000001 37
50 # wlr.transaction(4:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 50 ! 38 # wlr.transaction(1:lng, "2019-09-09T02:52:21.000":str, "monetdb":str); 38
51 # wlr.action("update tmp set i = 3 where i = 1;":str); 51 ! 39 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 39
52 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 52 ! 40 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 40
+ 41 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 41
53 # wlr.commit(); 53 42 # wlr.commit(); 42
54 # 54 43 # 43
55 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 55 ! 44 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000002 44
56 # wlr.transaction(3:lng, "2019-08-14T12:11:21.000":str, "monetdb":str); 56 ! 45 # wlr.transaction(2:lng, "2019-09-09T02:52:23.000":str, "monetdb":str); 45
+ 46 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 46
+ 47 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 47
+ 48 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 48
+ 49 # wlr.commit(); 49
+ 50 # 50
+ 51 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000003 51
+ 52 # wlr.transaction(3:lng, "2019-09-09T02:52:24.000":str, "monetdb":str); 52
57 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 57 53 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 53
..................
# wlr.commit();
61 # 61 57 # 57
62 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000009 62 ! 58 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000004 58
63 # wlr.transaction(9:lng, "2019-08-14T12:11:30.000":str, "monetdb":str); 63 ! 59 # wlr.transaction(4:lng, "2019-09-09T02:52:26.000":str, "monetdb":str); 59
64 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 64 ! 60 # wlr.action("update tmp set i = 3 where i = 1;":str); 60
65 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 65 ! 61 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 61
66 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 66 -
67 # wlr.commit(); 67 -
68 # 68 -
69 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 69 -
70 # wlr.transaction(7:lng, "2019-08-14T12:11:28.000":str, "monetdb":str); 70 -
71 # wlr.action("delete from tmp;":str); 71 -
72 # wlr.clear_table("sys":str, "tmp":str); 72 -
73 # wlr.commit(); 73 -
74 # 74 -
75 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 75 -
76 # wlr.transaction(1:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 76 -
77 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 77 -
78 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 78 -
79 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 79 -
80 # wlr.commit(); 80 62 # wlr.commit(); 62
81 # 81 63 # 63
82 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 82 ! 64 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000005 64
83 # wlr.transaction(5:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 83 ! 65 # wlr.transaction(5:lng, "2019-09-09T02:52:26.000":str, "monetdb":str); 65
84 # wlr.action("update tmp set s = \\'blah\\';":str); 84 66 # wlr.action("update tmp set s = \\'blah\\';":str); 66
..................
# wlr.commit();
92 # 92 74 # 74
93 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 93 ! 75 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000006 75
94 # wlr.transaction(6:lng, "2019-08-14T12:11:26.000":str, "monetdb":str); 94 ! 76 # wlr.transaction(6:lng, "2019-09-09T02:52:27.000":str, "monetdb":str); 76
95 # wlr.action("delete from tmp where i < 4;":str); 95 77 # wlr.action("delete from tmp where i < 4;":str); 77
..................
# wlr.commit();
98 # 98 80 # 80
99 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 99 ! 81 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000007 81
100 # wlr.transaction(2:lng, "2019-08-14T12:11:19.000":str, "monetdb":str); 100 ! 82 # wlr.transaction(7:lng, "2019-09-09T02:52:29.000":str, "monetdb":str); 82
101 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 101 ! 83 # wlr.action("delete from tmp;":str); 83
102 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 102 ! 84 # wlr.clear_table("sys":str, "tmp":str); 84
103 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 103 -
104 # wlr.commit(); 104 85 # wlr.commit(); 85
105 # 105 86 # 86
106 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 106 ! 87 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000008 87
107 # wlr.transaction(0:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 107 ! 88 # wlr.transaction(8:lng, "2019-09-09T02:52:33.000":str, "monetdb":str); 88
108 # wlr.catalog("create table tmp(i int, s string);":str); 108 + 89 # wlr.catalog("create table tmp70(i int, s string);":str); 89
+ 90 # wlr.commit(); 90
+ 91 # 91
+ 92 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000009 92
+ 93 # wlr.transaction(9:lng, "2019-09-09T02:52:33.000":str, "monetdb":str); 93
+ 94 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 94
+ 95 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 95
+ 96 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 96
109 # wlr.commit(); 109 97 # wlr.commit(); 97