Test wlr20.py (id 66579176a253) (err)
wlr20.stable.out.FILTERED 2019-09-21 08:32:48.363642100 +0200wlr20.test.out.FILTERED 2019-09-21 08:32:48.363642100 +0200
1 Statistics about stdout of test 'wlr20` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlr20` in directory 'sql/test/wlcr`: 1
2 27 lines, 110 words, 1018 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 34 lines, 93 words, 1757 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 27 lines, 110 words, 1018 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 34 lines, 93 words, 1757 chars in lines not matching '^$|^(\| |)#` 3
4 # 93 lines, 351 words, 3703 chars in all lines 4 ! 4 # 136 lines, 517 words, 5758 chars in all lines 4
5 5 5 5
..................
# MonetDB/GIS module loaded
24 # MonetDB/SQL module loaded 24 54 # MonetDB/SQL module loaded 54
25 MALException:wlr.getMaster:Could not access wlc.config file 25 ! 55 #replay log file:C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\\mTests_sql_test_wlcr_000000000000 55
26 26 ! 56 #run tlimit tag 2019-09-22T02:32:42.000 56
27 #call replicate('mTests_sql_test_wlcr',1); 27 ! 57 function user.wlr():void; 57
28 #Waiting for replay scheduler to stop 28 ! 58 wlr.transaction(0:lng, "2019-09-22T02:32:42.000":str, "monetdb":str); 58
29 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 29 ! 59 wlr.catalog("create table tmp0(i int, s string);":str); 59
30 #select * from tmp; 30 ! 60 wlr.commit(); 60
31 % sys.tmp, sys.tmp # table_name 31 ! 61 end user.wlr; 61
32 % i, s # name 32 ! 62 #replay log file:C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\\mTests_sql_test_wlcr_000000000001 62
33 % int, clob # type 33 ! 63 #run tlimit tag 2019-09-22T02:32:42.000 63
34 % 1, 0 # length 34 ! 64 function user.wlr():void; 64
+ 65 wlr.transaction(1:lng, "2019-09-22T02:32:42.000":str, "monetdb":str); 65
+ 66 wlr.action("insert into tmp0 values(1,\\'gaap\\'), (2,\\'sleep\\');":str); 66
+ 67 wlr.append("sys":str, "tmp0":str, "i":str, 1:int, 2:int); 67
+ 68 wlr.append("sys":str, "tmp0":str, "s":str, "gaap":str, "sleep":str); 68
+ 69 wlr.commit(); 69
+ 70 end user.wlr; 70
+ 71 #replay log file:C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\\mTests_sql_test_wlcr_000000000002 71
+ 72 #run tlimit tag 2019-09-22T02:32:42.000 72
+ 73 function user.wlr():void; 73
+ 74 wlr.transaction(2:lng, "2019-09-22T02:32:42.000":str, "monetdb":str); 74
+ 75 wlr.catalog("drop table tmp0;":str); 75
+ 76 wlr.commit(); 76
+ 77 end user.wlr; 77
+ 78 function user.SQLstatement():void; 78
+ 79 wlr.catalog("create table tmp(i int, s string);":str); 79
+ 80 wlr.commit(); 80
+ 81 end user.SQLstatement; 81
+ 82 function user.SQLstatement():void; 82
+ 83 wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 83
+ 84 wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 84
+ 85 wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 85
+ 86 wlr.commit(); 86
+ 87 end user.SQLstatement; 87
35 #call replicate('mTests_sql_test_wlcr',2); 35 88 #call replicate('mTests_sql_test_wlcr',2); 88
36 #Waiting for replay scheduler to stop 36 ! 89 #Waiting for replay scheduler to stop at 89
37 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 37 -
38 #select * from tmp; 38 -
39 % sys.tmp, sys.tmp # table_name 39 -
40 % i, s # name 40 -
41 % int, clob # type 41 -
42 % 1, 5 # length 42 -
43 [ 1, "hello" ] 43 -
44 [ 2, "world" ] 44 -
45 #call replicate('mTests_sql_test_wlcr',4); 45 90 #call replicate('mTests_sql_test_wlcr',4); 90
46 #Waiting for replay scheduler to stop 46 ! 91 #Waiting for replay scheduler to stop at 91
47 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000002 47 ! 92 C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc.config 92
48 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000003 48 ! 93 #logs=C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\ 93
49 #select * from tmp; 49 ! 94 #id=5 94
50 % sys.tmp, sys.tmp # table_name 50 ! 95 #write=2019-09-22T02:32:45.000 95
51 % i, s # name 51 -
52 % int, clob # type 52 -
53 % 1, 5 # length 53 -
54 [ 1, "hello" ] 54 -
55 [ 2, "world" ] 55 -
56 [ 3, "blah" ] 56 -
57 [ 4, "bloh" ] 57 -
58 [ 5, "red" ] 58 -
59 [ 6, "fox" ] 59 -
60 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 60 -
61 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 61 -
62 #id=4 62 -
63 #write=2019-08-14T12:11:21.000 63 -
64 #state=1 64 96 #state=1 96
..................
#beat=0
67 # 67 99 # 99
68 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 68 ! 100 C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000000 100
69 # wlr.transaction(3:lng, "2019-08-14T12:11:21.000":str, "monetdb":str); 69 ! 101 # wlr.transaction(0:lng, "2019-09-22T02:32:42.000":str, "monetdb":str); 101
70 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 70 ! 102 # wlr.catalog("create table tmp0(i int, s string);":str); 102
71 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 71 -
72 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 72 -
73 # wlr.commit(); 73 103 # wlr.commit(); 103
74 # 74 104 # 104
75 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 75 ! 105 C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000001 105
76 # wlr.transaction(1:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 76 ! 106 # wlr.transaction(1:lng, "2019-09-22T02:32:42.000":str, "monetdb":str); 106
+ 107 # wlr.action("insert into tmp0 values(1,\\'gaap\\'), (2,\\'sleep\\');":str); 107
+ 108 # wlr.append("sys":str, "tmp0":str, "i":str, 1:int, 2:int); 108
+ 109 # wlr.append("sys":str, "tmp0":str, "s":str, "gaap":str, "sleep":str); 109
+ 110 # wlr.commit(); 110
+ 111 # 111
+ 112 C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000002 112
+ 113 # wlr.transaction(2:lng, "2019-09-22T02:32:42.000":str, "monetdb":str); 113
+ 114 # wlr.catalog("drop table tmp0;":str); 114
+ 115 # wlr.commit(); 115
+ 116 # wlr.catalog("create table tmp(i int, s string);":str); 116
+ 117 # wlr.commit(); 117
77 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 77 118 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 118
..................
# wlr.commit();
81 # 81 122 # 122
82 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 82 ! 123 C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000003 123
83 # wlr.transaction(2:lng, "2019-08-14T12:11:19.000":str, "monetdb":str); 83 ! 124 # wlr.transaction(3:lng, "2019-09-22T02:32:43.000":str, "monetdb":str); 124
84 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 84 125 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 125
..................
# wlr.commit();
88 # 88 129 # 129
89 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 89 ! 130 C:\monettesting\66579176a253-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000004 130
90 # wlr.transaction(0:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 90 ! 131 # wlr.transaction(4:lng, "2019-09-22T02:32:45.000":str, "monetdb":str); 131
91 # wlr.catalog("create table tmp(i int, s string);":str); 91 ! 132 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 132
+ 133 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 133
+ 134 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 134
92 # wlr.commit(); 92 135 # wlr.commit(); 135