Test wlr20.py (id 0177627dc2e1) (err)
wlr20.stable.out.FILTERED 2019-09-20 21:15:42.210892796 +0200wlr20.test.out.FILTERED 2019-09-20 21:15:42.212892779 +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 21 lines, 100 words, 396 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 28 lines, 87 words, 1099 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 21 lines, 100 words, 396 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 28 lines, 87 words, 1099 chars in lines not matching '^$|^(\| |)#` 3
4 # 57 lines, 247 words, 1926 chars in all lines 4 ! 4 # 97 lines, 409 words, 3849 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: 40_geom.sql 43
+ 44 # loading sql script: 40_json.sql 44
+ 45 # loading sql script: 41_md5sum.sql 45
+ 46 # loading sql script: 45_uuid.sql 46
+ 47 # loading sql script: 46_profiler.sql 47
+ 48 # loading sql script: 51_sys_schema_extension.sql 48
+ 49 # loading sql script: 60_wlcr.sql 49
+ 50 # loading sql script: 72_fits.sql 50
+ 51 # loading sql script: 74_netcdf.sql 51
+ 52 # loading sql script: 75_lidar.sql 52
+ 53 # loading sql script: 75_shp.sql 53
+ 54 # loading sql script: 75_storagemodel.sql 54
+ 55 # loading sql script: 80_statistics.sql 55
+ 56 # loading sql script: 80_udf.sql 56
+ 57 # loading sql script: 85_bam.sql 57
+ 58 # loading sql script: 90_generator.sql 58
+ 59 # loading sql script: 99_system.sql 59
24 # MonetDB/SQL module loaded 24 60 # MonetDB/SQL module loaded 60
25 #call replicate('mTests_sql_test_wlcr',1); 25 ! 61 #replay log file:/export/scratch1/home/monet/testing/0177627dc2e1-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000000 61
26 #Waiting for replay scheduler to stop 26 ! 62 #run tlimit tag 2019-09-20T21:15:38.000 62
27 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 27 ! 63 function user.wlr():void; 63
28 #select * from tmp; 28 ! 64 wlr.transaction(0:lng, "2019-09-20T21:15:38.000":str, "monetdb":str); 64
29 % sys.tmp, sys.tmp # table_name 29 ! 65 wlr.catalog("create table tmp0(i int, s string);":str); 65
30 % i, s # name 30 ! 66 wlr.commit(); 66
31 % int, clob # type 31 ! 67 end user.wlr; 67
32 % 1, 0 # length 32 ! 68 #replay log file:/export/scratch1/home/monet/testing/0177627dc2e1-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 68
+ 69 #run tlimit tag 2019-09-20T21:15:38.000 69
+ 70 function user.wlr():void; 70
+ 71 wlr.transaction(1:lng, "2019-09-20T21:15:38.000":str, "monetdb":str); 71
+ 72 wlr.action("insert into tmp0 values(1,\\'gaap\\'), (2,\\'sleep\\');":str); 72
+ 73 wlr.append("sys":str, "tmp0":str, "i":str, 1:int, 2:int); 73
+ 74 wlr.append("sys":str, "tmp0":str, "s":str, "gaap":str, "sleep":str); 74
+ 75 wlr.commit(); 75
+ 76 end user.wlr; 76
+ 77 #replay log file:/export/scratch1/home/monet/testing/0177627dc2e1-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000002 77
+ 78 #run tlimit tag 2019-09-20T21:15:38.000 78
+ 79 function user.wlr():void; 79
+ 80 wlr.transaction(2:lng, "2019-09-20T21:15:38.000":str, "monetdb":str); 80
+ 81 wlr.catalog("drop table tmp0;":str); 81
+ 82 wlr.commit(); 82
+ 83 end user.wlr; 83
+ 84 function user.SQLstatement():void; 84
+ 85 wlr.catalog("create table tmp(i int, s string);":str); 85
+ 86 wlr.commit(); 86
+ 87 end user.SQLstatement; 87
+ 88 function user.SQLstatement():void; 88
+ 89 wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 89
+ 90 wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 90
+ 91 wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 91
+ 92 wlr.commit(); 92
+ 93 end user.SQLstatement; 93
33 #call replicate('mTests_sql_test_wlcr',2); 33 94 #call replicate('mTests_sql_test_wlcr',2); 94
34 #Waiting for replay scheduler to stop 34 ! 95 #Waiting for replay scheduler to stop at 95
35 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 35 -
36 #select * from tmp; 36 -
37 % sys.tmp, sys.tmp # table_name 37 -
38 % i, s # name 38 -
39 % int, clob # type 39 -
40 % 1, 5 # length 40 -
41 [ 1, "hello" ] 41 -
42 [ 2, "world" ] 42 -
43 #call replicate('mTests_sql_test_wlcr',4); 43 96 #call replicate('mTests_sql_test_wlcr',4); 96
44 #Waiting for replay scheduler to stop 44 ! 97 #Waiting for replay scheduler to stop at 97
45 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000002 45 ! 98 98
46 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000003 46 ! 99 # 21:15:42 > 99
47 #select * from tmp; 47 ! 100 # 21:15:42 > "Done." 100
48 % sys.tmp, sys.tmp # table_name 48 ! 101 # 21:15:42 > 101
49 % i, s # name 49 -
50 % int, clob # type 50 -
51 % 1, 5 # length 51 -
52 [ 1, "hello" ] 52 -
53 [ 2, "world" ] 53 -
54 [ 3, "blah" ] 54 -
55 [ 4, "bloh" ] 55 -
56 [ 5, "red" ] 56 -
57 [ 6, "fox" ] 57 -
58 58 -
59 # 13:22:30 > 59 -
60 # 13:22:30 > "Done." 60 -
61 # 13:22:30 > 61 -
62 62 102 102