Test upgrade.SQL.py (id 9f8602e8c51d) (err)
upgrade.stable.out.32bit.FILTERED 2018-10-18 00:01:53.334349000 -0700upgrade.test.out.FILTERED 2018-10-18 00:01:53.334349000 -0700
1 Statistics about stdout of test 'upgrade` in directory 'sql/test/testdb-upgrade-chain`: 1 1 Statistics about stdout of test 'upgrade` in directory 'sql/test/testdb-upgrade-chain`: 1
2 15 lines, 81 words, 528 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 17 words, 130 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 15 lines, 81 words, 528 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 17 words, 130 chars in lines not matching '^$|^(\| |)#` 3
4 # 46 lines, 212 words, 1605 chars in all lines 4 ! 4 # 25 lines, 110 words, 932 chars in all lines 4
5 5 5 5
..................
# 46 lines, 212 words,
8 8 8 8
9 # 15:17:06 > 9 ! 9 # 00:01:53 > 9
10 # 15:17:06 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/ufs/sjoerd/Monet-stable/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=36250" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_test_testdb-upgrade-chain" "--set" "mal_listing=0" 10 ! 10 # 00:01:53 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33030" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\9f8602e8c51d-9-1-1\tests\sql\dbfarm\mTests_sql_test_testdb-upgrade-chain" "--set" "embedded_c=true" 10
11 # 15:17:06 > 11 ! 11 # 00:01:53 > 11
12 12 ! 12 12
13 # MonetDB 5 server v11.11.8 (hg id: 34fcf4e7226d+) 13 ! 13 # MonetDB 5 server v11.32.0 "default-9f8602e8c51d" 13
14 # This is an unreleased version 14 ! 14 # Serving database 'mTests_sql_test_testdb-upgrade-chain', using 6 threads 14
15 # Serving database 'mTests_test_testdb-upgrade-chain', using 8 threads 15 ! 15 # Compiled for i686-pc-winnt/32bit 15
16 # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked 16 ! 16 # Found 1.999 GiB available main-memory. 16
17 # Found 15.629 GiB available main-memory. 17 ! 17 # Copyright (c) 1993 - July 2008 CWI. 17
18 # Copyright (c) 1993-July 2008 CWI. 18 ! 18 # Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved 18
19 # Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved 19 ! 19 # Visit https://www.monetdb.org/ for further information 19
20 # Visit http://www.monetdb.org/ for further information 20 ! 20 # Listening for connection requests on mapi:monetdb://win2k12r2:33030/ 20
21 # Listening for connection requests on mapi:monetdb://madrid.ins.cwi.nl:36250/ 21 -
22 # MonetDB/GIS module loaded 22 21 # MonetDB/GIS module loaded 21
23 Running database upgrade commands: 23 ! 22 22
24 set schema sys; 24 ! 23 23
25 drop table sys.systemfunctions; 25 ! 24 ! Server not ready; skipping attempt to start client! 24
26 create view sys.systemfunctions as select id as function_id from sys.functions where system; 26 ! 25 25
27 grant select on sys.systemfunctions to public; 27 ! 26 26
28 update sys._tables set system = true where name = 'systemfunctions' and schema_id = (select id from sys.schemas where name = 'sys'); 28 ! 27 # 00:01:53 > 27
29 set schema "sys"; 29 ! 28 # 00:01:53 > "Done." 28
30 commit; 30 ! 29 # 00:01:53 > 29
31 31 -
32 # MonetDB/SQL module loaded 32 -
33 33 -
34 Ready. 34 -
35 35 -
36 # 16:03:29 > 36 -
37 # 16:03:29 > "/usr/bin/python" "upgrade.SQL.py" "upgrade" 37 -
38 # 16:03:29 > 38 -
39 39 -
40 #select count(*) from testschema.smallstring; 40 -
41 % testschema.L3 # table_name 41 -
42 % L # name 42 -
43 # L3 # name 43 -
44 % bigint # type 44 -
45 % 2 # length 45 -
46 [ 66 ] 46 -
47 47 -
48 # 15:17:06 > 48 -
49 # 15:17:06 > "Done." 49 -
50 # 15:17:06 > 50 -
51 51 30 30