Test wlr50.py (id 3c6cbe78e1fe) (err)
wlr50.stable.out.FILTERED 2019-09-08 12:33:43.894333354 +0200wlr50.test.out.FILTERED 2019-09-08 12:33:43.900333402 +0200
1 Statistics about stdout of test 'wlr50` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlr50` in directory 'sql/test/wlcr`: 1
2 14 lines, 37 words, 1175 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 10 lines, 17 words, 1242 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 14 lines, 37 words, 1175 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 10 lines, 17 words, 1242 chars in lines not matching '^$|^(\| |)#` 3
4 # 95 lines, 352 words, 4633 chars in all lines 4 ! 4 # 127 lines, 526 words, 5686 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 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr-clone/../mTests_sql_test_wlcr/master/mTests_sql_test_wlcr_000000000018 24 ! 24 # SQL catalog created, loading sql scripts once 24
25 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr-clone/../mTests_sql_test_wlcr/master/mTests_sql_test_wlcr_000000000019 25 ! 25 # loading sql script: 09_like.sql 25
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_000000000020 26 ! 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
27 # MonetDB/SQL module loaded 27 64 # MonetDB/SQL module loaded 64
28 #select * from tmp; 28 ! 65 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc.config 65
29 % sys.tmp, sys.tmp # table_name 29 -
30 % i, s # name 30 -
31 % int, clob # type 31 -
32 % 1, 0 # length 32 -
33 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 33 -
34 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 34 ! 66 #logs=/export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/ 66
35 #id=8 35 67 #id=8 67
..................
#beat=0
40 # 40 72 # 72
41 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 41 ! 73 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 73
42 # wlr.transaction(4:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 42 ! 74 # wlr.transaction(3:lng, "2019-09-08T12:33:35.000":str, "monetdb":str); 74
43 # wlr.action("update tmp set i = 3 where i = 1;":str); 43 -
44 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 44 -
45 # wlr.commit(); 45 -
46 # 46 -
47 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 47 -
48 # wlr.transaction(3:lng, "2019-08-14T12:11:21.000":str, "monetdb":str); 48 -
49 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 49 75 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 75
..................
# wlr.commit();
53 # 53 79 # 79
54 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 54 ! 80 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 80
55 # wlr.transaction(7:lng, "2019-08-14T12:11:28.000":str, "monetdb":str); 55 ! 81 # wlr.transaction(2:lng, "2019-09-08T12:33:34.000":str, "monetdb":str); 81
56 # wlr.action("delete from tmp;":str); 56 ! 82 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 82
57 # wlr.clear_table("sys":str, "tmp":str); 57 ! 83 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 83
+ 84 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 84
58 # wlr.commit(); 58 85 # wlr.commit(); 85
59 # 59 86 # 86
60 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 60 ! 87 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 87
61 # wlr.transaction(1:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 61 ! 88 # wlr.transaction(0:lng, "2019-09-08T12:33:32.000":str, "monetdb":str); 88
+ 89 # wlr.catalog("create table tmp(i int, s string);":str); 89
+ 90 # wlr.commit(); 90
+ 91 # 91
+ 92 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 92
+ 93 # wlr.transaction(6:lng, "2019-09-08T12:33:39.000":str, "monetdb":str); 93
+ 94 # wlr.action("delete from tmp where i < 4;":str); 94
+ 95 # wlr.delete("sys":str, "tmp":str, 0@0:oid, 0@0:oid, 0@0:oid); 95
+ 96 # wlr.commit(); 96
+ 97 # 97
+ 98 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 98
+ 99 # wlr.transaction(4:lng, "2019-09-08T12:33:37.000":str, "monetdb":str); 99
+ 100 # wlr.action("update tmp set i = 3 where i = 1;":str); 100
+ 101 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 101
+ 102 # wlr.commit(); 102
+ 103 # 103
+ 104 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 104
+ 105 # wlr.transaction(1:lng, "2019-09-08T12:33:32.000":str, "monetdb":str); 105
62 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 62 106 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 106
..................
# wlr.commit();
66 # 66 110 # 110
67 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 67 ! 111 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 111
68 # wlr.transaction(5:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 68 ! 112 # wlr.transaction(5:lng, "2019-09-08T12:33:37.000":str, "monetdb":str); 112
69 # wlr.action("update tmp set s = \\'blah\\';":str); 69 113 # wlr.action("update tmp set s = \\'blah\\';":str); 113
..................
# wlr.commit();
77 # 77 121 # 121
78 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 78 ! 122 /export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 122
79 # wlr.transaction(6:lng, "2019-08-14T12:11:26.000":str, "monetdb":str); 79 ! 123 # wlr.transaction(7:lng, "2019-09-08T12:33:41.000":str, "monetdb":str); 123
80 # wlr.action("delete from tmp where i < 4;":str); 80 - 124 # wlr.action("delete from tmp;":str); 124
81 # wlr.delete("sys":str, "tmp":str, 0@0:oid, 0@0:oid, 0@0:oid); 81 ! 125 # wlr.clear_table("sys":str, "tmp":str); 125
82 # wlr.commit(); 82 -
83 # 83 -
84 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 84 -
85 # wlr.transaction(2:lng, "2019-08-14T12:11:19.000":str, "monetdb":str); 85 -
86 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 86 -
87 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 87 -
88 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 88 -
89 # wlr.commit(); 89 -
90 # 90 -
91 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 91 -
92 # wlr.transaction(0:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 92 -
93 # wlr.catalog("create table tmp(i int, s string);":str); 93 -
94 # wlr.commit(); 94 126 # wlr.commit(); 126