Test wlr70.py (id 6b3b1396de21) (err)
wlr70.stable.out.FILTERED 2019-09-20 09:30:25.410906684 +0200wlr70.test.out.FILTERED 2019-09-20 09:30:25.420907118 +0200
1 Statistics about stdout of test 'wlr70` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlr70` in directory 'sql/test/wlcr`: 1
2 22 lines, 67 words, 1526 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 13 lines, 20 words, 1455 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 22 lines, 67 words, 1526 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 13 lines, 20 words, 1455 chars in lines not matching '^$|^(\| |)#` 3
4 # 121 lines, 465 words, 5353 chars in all lines 4 ! 4 # 110 lines, 402 words, 5277 chars in all lines 4
5 5 5 5
..................
# MonetDB 5 server v11.28.0
14 # This is an unreleased version 14 14 # This is an unreleased version 14
15 # Serving database 'mTests_sql_test_wlcr-clone', using 4 threads 15 ! 15 # Serving database 'mTests_sql_test_wlcr-clone', using 8 threads 15
16 # Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers 16 ! 16 # Compiled for powerpc64-unknown-linux-gnu/64bit 16
17 # Found 15.520 GiB available main-memory. 17 ! 17 # Found 255.358 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://zarquon.zarniwoop.org:52305/ 21 ! 21 # Listening for connection requests on mapi:monetdb://power8:53997/ 21
22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-22068/.s.monetdb.52305 22 ! 22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-2078/.s.monetdb.53997 22
23 # MonetDB/GIS module loaded 23 23 # MonetDB/GIS module loaded 23
24 # MonetDB/SQL module loaded 24 24 # MonetDB/SQL module loaded 24
25 #now 2017-05-02T13:16:47.000 tlimit 2017-05-02 11:16:47.000 25 ! 25 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc.config 25
26 #call replicate(now()); 26 ! 26 #logs=/home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/ 26
27 #Waiting for replay scheduler to stop 27 ! 27 #id=11 27
28 #time limit 2017-05-02 11:16:47.000 28 ! 28 #write=2019-09-20T09:30:23.000 28
29 #select * from tmp70; 29 -
30 % sys.tmp70, sys.tmp70 # table_name 30 -
31 % i, s # name 31 -
32 % int, clob # type 32 -
33 % 1, 0 # length 33 -
34 #call replicate(); 34 -
35 #Waiting for replay scheduler to stop 35 -
36 #Waiting for replay scheduler to stop 36 -
37 #Waiting for replay scheduler to stop 37 -
38 #Waiting for replay scheduler to stop 38 -
39 #Waiting for replay scheduler to stop 39 -
40 #select * from tmp70; 40 -
41 % sys.tmp70, sys.tmp70 # table_name 41 -
42 % i, s # name 42 -
43 % int, clob # type 43 -
44 % 1, 5 # length 44 -
45 [ 1, "hello" ] 45 -
46 [ 2, "world" ] 46 -
47 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 47 -
48 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 48 -
49 #id=10 49 -
50 #write=2019-08-14T12:11:30.000 50 -
51 #state=1 51 29 #state=1 29
..................
#write=2019-08-14T12:11:30.000
51 #state=1 51 29 #state=1 29
52 #batches=10 52 ! 30 #batches=11 30
53 #beat=0 53 31 #beat=0 31
54 # 54 32 # 32
55 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000008 55 ! 33 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 33
56 # wlr.transaction(8:lng, "2019-08-14T12:11:30.000":str, "monetdb":str); 56 ! 34 # wlr.transaction(0:lng, "2019-09-20T09:30:10.000":str, "monetdb":str); 34
57 # wlr.catalog("create table tmp70(i int, s string);":str); 57 ! 35 # wlr.catalog("create table tmp0(i int, s string);":str); 35
58 # wlr.commit(); 58 36 # wlr.commit(); 36
59 # 59 37 # 37
60 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 60 ! 38 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 38
61 # wlr.transaction(4:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 61 ! 39 # wlr.transaction(1:lng, "2019-09-20T09:30:10.000":str, "monetdb":str); 39
62 # wlr.action("update tmp set i = 3 where i = 1;":str); 62 ! 40 # wlr.action("insert into tmp0 values(1,\\'gaap\\'), (2,\\'sleep\\');":str); 40
63 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 63 ! 41 # wlr.append("sys":str, "tmp0":str, "i":str, 1:int, 2:int); 41
+ 42 # wlr.append("sys":str, "tmp0":str, "s":str, "gaap":str, "sleep":str); 42
64 # wlr.commit(); 64 43 # wlr.commit(); 43
65 # 65 44 # 44
66 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 66 ! 45 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 45
67 # wlr.transaction(3:lng, "2019-08-14T12:11:21.000":str, "monetdb":str); 67 ! 46 # wlr.transaction(2:lng, "2019-09-20T09:30:10.000":str, "monetdb":str); 46
# wlr. + 47 # wlr.catalog("drop table tmp0;":str); 47
+ 48 # wlr.commit(); 48
+ 49 # wlr.catalog("create table tmp(i int, s string);":str); 49
+ 50 # wlr.commit(); 50
68 action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 68 ! 51 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 51
69 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 69 ! 52 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 52
70 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 70 ! 53 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 53
71 # wlr.commit(); 71 54 # wlr.commit(); 54
72 # 72 55 # 55
73 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000009 73 ! 56 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 56
74 # wlr.transaction(9:lng, "2019-08-14T12:11:30.000":str, "monetdb":str); 74 ! 57 # wlr.transaction(3:lng, "2019-09-20T09:30:11.000":str, "monetdb":str); 57
75 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 75 ! 58 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 58
76 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 76 ! 59 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 59
77 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 77 ! 60 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 60
78 # wlr.commit(); 78 61 # wlr.commit(); 61
79 # 79 62 # 62
80 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 80 ! 63 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 63
81 # wlr.transaction(7:lng, "2019-08-14T12:11:28.000":str, "monetdb":str); 81 ! 64 # wlr.transaction(4:lng, "2019-09-20T09:30:13.000":str, "monetdb":str); 64
82 # wlr.action("delete from tmp;":str); 82 ! 65 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 65
83 # wlr.clear_table("sys":str, "tmp":str); 83 ! 66 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 66
+ 67 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 67
84 # wlr.commit(); 84 68 # wlr.commit(); 68
85 # 85 69 # 69
86 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 86 ! 70 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 70
87 # wlr.transaction(1:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 87 ! 71 # wlr.transaction(5:lng, "2019-09-20T09:30:16.000":str, "monetdb":str); 71
88 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 88 ! 72 # wlr.action("update tmp set i = 3 where i = 1;":str); 72
89 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 89 ! 73 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 73
90 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 90 -
91 # wlr.commit(); 91 74 # wlr.commit(); 74
92 # 92 75 # 75
93 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 93 ! 76 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 76
94 # wlr.transaction(5:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 94 ! 77 # wlr.transaction(6:lng, "2019-09-20T09:30:16.000":str, "monetdb":str); 77
95 # wlr.action("update tmp set s = \\'blah\\';":str); 95 78 # wlr.action("update tmp set s = \\'blah\\';":str); 78
..................
# wlr.commit();
103 # 103 86 # 86
104 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 104 ! 87 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 87
105 # wlr.transaction(6:lng, "2019-08-14T12:11:26.000":str, "monetdb":str); 105 ! 88 # wlr.transaction(7:lng, "2019-09-20T09:30:18.000":str, "monetdb":str); 88
106 # wlr.action("delete from tmp where i < 4;":str); 106 89 # wlr.action("delete from tmp where i < 4;":str); 89
..................
# wlr.commit();
109 # 109 92 # 92
110 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 110 ! 93 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000008 93
111 # wlr.transaction(2:lng, "2019-08-14T12:11:19.000":str, "monetdb":str); 111 ! 94 # wlr.transaction(8:lng, "2019-09-20T09:30:21.000":str, "monetdb":str); 94
112 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 112 ! 95 # wlr.action("delete from tmp;":str); 95
113 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 113 ! 96 # wlr.clear_table("sys":str, "tmp":str); 96
114 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 114 -
115 # wlr.commit(); 115 97 # wlr.commit(); 97
116 # 116 98 # 98
117 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 117 ! 99 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000009 99
118 # wlr.transaction(0:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 118 ! 100 # wlr.transaction(9:lng, "2019-09-20T09:30:23.000":str, "monetdb":str); 100
119 # wlr.catalog("create table tmp(i int, s string);":str); 119 + 101 # wlr.catalog("create table tmp70(i int, s string);":str); 101
+ 102 # wlr.commit(); 102
+ 103 # 103
+ 104 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000010 104
+ 105 # wlr.transaction(10:lng, "2019-09-20T09:30:23.000":str, "monetdb":str); 105
+ 106 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 106
+ 107 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 107
+ 108 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 108
120 # wlr.commit(); 120 109 # wlr.commit(); 109