Test wlr20.py (id 6b3b1396de21) (err)
wlr20.stable.out.FILTERED 2019-09-20 08:25:04.503058274 +0200wlr20.test.out.FILTERED 2019-09-20 08:25:04.513058727 +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, 1781 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 27 lines, 110 words, 1018 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 34 lines, 93 words, 1781 chars in lines not matching '^$|^(\| |)#` 3
4 # 93 lines, 351 words, 3703 chars in all lines 4 ! 4 # 146 lines, 572 words, 6229 chars in all lines 4
5 5 5 5
..................
# Listening for UNIX domain connection r
23 # MonetDB/GIS module loaded 23 23 # MonetDB/GIS module loaded 23
+ 24 # SQL catalog created, loading sql scripts once 24
+ 25 # loading sql script: 09_like.sql 25
+ 26 # loading sql script: 10_math.sql 26
+ 27 # loading sql script: 11_times.sql 27
+ 28 # loading sql script: 12_url.sql 28
+ 29 # loading sql script: 13_date.sql 29
+ 30 # loading sql script: 14_inet.sql 30
+ 31 # loading sql script: 15_querylog.sql 31
+ 32 # loading sql script: 16_tracelog.sql 32
+ 33 # loading sql script: 17_temporal.sql 33
+ 34 # loading sql script: 18_index.sql 34
+ 35 # loading sql script: 20_vacuum.sql 35
+ 36 # loading sql script: 21_dependency_views.sql 36
+ 37 # loading sql script: 22_clients.sql 37
+ 38 # loading sql script: 23_skyserver.sql 38
+ 39 # loading sql script: 25_debug.sql 39
+ 40 # loading sql script: 26_sysmon.sql 40
+ 41 # loading sql script: 27_rejects.sql 41
+ 42 # loading sql script: 39_analytics.sql 42
+ 43 # loading sql script: 39_analytics_hge.sql 43
+ 44 # loading sql script: 40_geom.sql 44
+ 45 # loading sql script: 40_json.sql 45
+ 46 # loading sql script: 40_json_hge.sql 46
+ 47 # loading sql script: 41_md5sum.sql 47
+ 48 # loading sql script: 45_uuid.sql 48
+ 49 # loading sql script: 46_profiler.sql 49
+ 50 # loading sql script: 51_sys_schema_extension.sql 50
+ 51 # loading sql script: 60_wlcr.sql 51
+ 52 # loading sql script: 72_fits.sql 52
+ 53 # loading sql script: 74_netcdf.sql 53
+ 54 # loading sql script: 75_lidar.sql 54
+ 55 # loading sql script: 75_shp.sql 55
+ 56 # loading sql script: 75_storagemodel.sql 56
+ 57 # loading sql script: 80_statistics.sql 57
+ 58 # loading sql script: 80_udf.sql 58
+ 59 # loading sql script: 80_udf_hge.sql 59
+ 60 # loading sql script: 85_bam.sql 60
+ 61 # loading sql script: 90_generator.sql 61
+ 62 # loading sql script: 90_generator_hge.sql 62
+ 63 # loading sql script: 99_system.sql 63
24 # MonetDB/SQL module loaded 24 64 # MonetDB/SQL module loaded 64
25 MALException:wlr.getMaster:Could not access wlc.config file 25 ! 65 #replay log file:/home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000000 65
26 26 ! 66 #run tlimit tag 2019-09-20T08:24:59.000 66
27 #call replicate('mTests_sql_test_wlcr',1); 27 ! 67 function user.wlr():void; 67
28 #Waiting for replay scheduler to stop 28 ! 68 wlr.transaction(0:lng, "2019-09-20T08:24:59.000":str, "monetdb":str); 68
29 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 29 ! 69 wlr.catalog("create table tmp0(i int, s string);":str); 69
30 #select * from tmp; 30 ! 70 wlr.commit(); 70
31 % sys.tmp, sys.tmp # table_name 31 ! 71 end user.wlr; 71
32 % i, s # name 32 ! 72 #replay log file:/home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 72
33 % int, clob # type 33 ! 73 #run tlimit tag 2019-09-20T08:24:59.000 73
34 % 1, 0 # length 34 ! 74 function user.wlr():void; 74
+ 75 wlr.transaction(1:lng, "2019-09-20T08:24:59.000":str, "monetdb":str); 75
+ 76 wlr.action("insert into tmp0 values(1,\\'gaap\\'), (2,\\'sleep\\');":str); 76
+ 77 wlr.append("sys":str, "tmp0":str, "i":str, 1:int, 2:int); 77
+ 78 wlr.append("sys":str, "tmp0":str, "s":str, "gaap":str, "sleep":str); 78
+ 79 wlr.commit(); 79
+ 80 end user.wlr; 80
+ 81 #replay log file:/home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000002 81
+ 82 #run tlimit tag 2019-09-20T08:24:59.000 82
+ 83 function user.wlr():void; 83
+ 84 wlr.transaction(2:lng, "2019-09-20T08:24:59.000":str, "monetdb":str); 84
+ 85 wlr.catalog("drop table tmp0;":str); 85
+ 86 wlr.commit(); 86
+ 87 end user.wlr; 87
+ 88 function user.SQLstatement():void; 88
+ 89 wlr.catalog("create table tmp(i int, s string);":str); 89
+ 90 wlr.commit(); 90
+ 91 end user.SQLstatement; 91
+ 92 function user.SQLstatement():void; 92
+ 93 wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 93
+ 94 wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 94
+ 95 wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 95
+ 96 wlr.commit(); 96
+ 97 end user.SQLstatement; 97
35 #call replicate('mTests_sql_test_wlcr',2); 35 98 #call replicate('mTests_sql_test_wlcr',2); 98
36 #Waiting for replay scheduler to stop 36 ! 99 #Waiting for replay scheduler to stop at 99
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 100 #call replicate('mTests_sql_test_wlcr',4); 100
46 #Waiting for replay scheduler to stop 46 ! 101 #Waiting for replay scheduler to stop at 101
47 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000002 47 ! 102 /home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc.config 102
48 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000003 48 ! 103 #logs=/home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/ 103
49 #select * from tmp; 49 ! 104 #id=5 104
50 % sys.tmp, sys.tmp # table_name 50 ! 105 #write=2019-09-20T08:25:01.000 105
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 106 #state=1 106
..................
#write=2019-08-14T12:11:21.000
64 #state=1 64 106 #state=1 106
65 #batches=4 65 ! 107 #batches=5 107
66 #beat=0 66 108 #beat=0 108
67 # 67 109 # 109
68 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 68 ! 110 /home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 110
69 # wlr.transaction(3:lng, "2019-08-14T12:11:21.000":str, "monetdb":str); 69 ! 111 # wlr.transaction(0:lng, "2019-09-20T08:24:59.000":str, "monetdb":str); 111
70 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 70 ! 112 # wlr.catalog("create table tmp0(i int, s string);":str); 112
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 113 # wlr.commit(); 113
74 # 74 114 # 114
75 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 75 ! 115 /home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 115
76 # wlr.transaction(1:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 76 ! 116 # wlr.transaction(1:lng, "2019-09-20T08:24:59.000":str, "monetdb":str); 116
+ 117 # wlr.action("insert into tmp0 values(1,\\'gaap\\'), (2,\\'sleep\\');":str); 117
+ 118 # wlr.append("sys":str, "tmp0":str, "i":str, 1:int, 2:int); 118
+ 119 # wlr.append("sys":str, "tmp0":str, "s":str, "gaap":str, "sleep":str); 119
+ 120 # wlr.commit(); 120
+ 121 # 121
+ 122 /home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 122
+ 123 # wlr.transaction(2:lng, "2019-09-20T08:24:59.000":str, "monetdb":str); 123
+ 124 # wlr.catalog("drop table tmp0;":str); 124
+ 125 # wlr.commit(); 125
+ 126 # wlr.catalog("create table tmp(i int, s string);":str); 126
+ 127 # wlr.commit(); 127
77 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 77 128 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 128
..................
# wlr.commit();
81 # 81 132 # 132
82 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 82 ! 133 /home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 133
83 # wlr.transaction(2:lng, "2019-08-14T12:11:19.000":str, "monetdb":str); 83 ! 134 # wlr.transaction(3:lng, "2019-09-20T08:25:00.000":str, "monetdb":str); 134
84 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 84 135 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 135
..................
# wlr.commit();
88 # 88 139 # 139
89 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 89 ! 140 /home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 140
90 # wlr.transaction(0:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 90 ! 141 # wlr.transaction(4:lng, "2019-09-20T08:25:01.000":str, "monetdb":str); 141
91 # wlr.catalog("create table tmp(i int, s string);":str); 91 ! 142 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 142
+ 143 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 143
+ 144 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 144
92 # wlr.commit(); 92 145 # wlr.commit(); 145