Test merge-table-limit.Bug-6756.sql (id 7617234e528d) (out)
merge-table-limit.Bug-6756.stable.err.FILTERED 2019-09-21 00:55:41.000000000 +0200merge-table-limit.Bug-6756.test.err.FILTERED 2019-09-21 00:55:41.000000000 +0200
1 Statistics about stderr of test 'merge-table-limit.Bug-6756` in directory 'sql/test/BugTracker-2019`: 1 1 Statistics about stderr of test 'merge-table-limit.Bug-6756` in directory 'sql/test/BugTracker-2019`: 1
2 1 lines, 8 words, 91 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 29 lines, 109 words, 990 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 91 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 29 lines, 109 words, 990 chars in lines not matching '^$|^(\| |)#` 3
4 # 18 lines, 64 words, 695 chars in all lines 4 ! 4 # 52 lines, 195 words, 2101 chars in all lines 4
5 5 5 5
..................
# 18 lines, 64 words,
8 8 8 8
9 # 17:09:07 > 9 ! 9 # 00:55:41 > 9
10 # 17:09:07 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39515" "--set" "mapi_usock=/var/tmp/mtest-7363/.s.monetdb.39515" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/ferreira/repositories/MonetDB-Apr2019/BUILD/var/MonetDB/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" 10 ! 10 # 00:55:41 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34740" "--set" "mapi_usock=/var/tmp/mtest-78755/.s.monetdb.34740" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/Users/monet/scratch/7617234e528d-6-1-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" 10
11 # 17:09:07 > 11 ! 11 # 00:55:41 > 11
12 12 ! 12 12
+ 13 could not find L2.timestamp 13
+ 14 test_message.logentry_no 14
+ 15 test_message.logsource 15
+ 16 test_message.program 16
+ 17 L4.logentry_no 17
+ 18 L6.logsource 18
+ 19 L10.program 19
+ 20 could not find L2.timestamp 20
+ 21 test_message.logentry_no 21
+ 22 test_message.logsource 22
+ 23 test_message.program 23
+ 24 L4.logentry_no 24
+ 25 L6.logsource 25
+ 26 L10.program 26
+ 27 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 27
+ 28 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 28
+ 29 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 29
+ 30 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 30
13 #main thread:!ERROR:MALException:client.quit:Server stopped 13 31 #main thread:!ERROR:MALException:client.quit:Server stopped 31
14 14 32 32
15 # 17:09:08 > 15 ! 33 # 00:55:41 > 33
16 # 17:09:08 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-7363" "--port=39515" 16 ! 34 # 00:55:41 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-78755" "--port=34740" 34
17 # 17:09:08 > 17 ! 35 # 00:55:41 > 35
18 18 ! 36 36
19 19 ! 37 #~ MAPI = (monetdb) /var/tmp/mtest-78755/.s.monetdb.34740 37
20 # 17:09:08 > 20 ! 38 QUERY = SELECT timestamp AS timestamp, logentry_no AS logentry_no, logsource AS logsource, program AS program 38
21 # 17:09:08 > "Done." 21 ! 39 FROM logs.test_message 39
22 # 17:09:08 > 22 ! 40 WHERE processed_timestamp >= '2019-09-09 01:23:58.949' AND processed_timestamp <= '2019-09-09 17:38:58.949' 40
+ 41 ORDER BY timestamp 41
+ 42 LIMIT 2000; 42
+ 43 ERROR = !Error in optimizer garbageCollector 43
+ 44 CODE = 42000 44
+ 45 #~ MAPI = (monetdb) /var/tmp/mtest-78755/.s.monetdb.34740 45
+ 46 QUERY = SELECT timestamp AS timestamp, logentry_no AS logentry_no, logsource AS logsource 46
+ 47 FROM logs.test_message 47
+ 48 WHERE processed_timestamp >= '2019-09-09 01:23:58.949' AND processed_timestamp <= '2019-09-09 17:38:58.949' 48
+ 49 ORDER BY timestamp 49
+ 50 LIMIT 2000; 50
+ 51 ERROR = !Current transaction is aborted (please ROLLBACK) 51
+ 52 CODE = 25005 52
+ 53 53
+ 54 # 00:55:41 > 54
+ 55 # 00:55:41 > "Done." 55
+ 56 # 00:55:41 > 56
23 23 57 57