Test lateral-join-crash.Bug-6613.sql (id 7617234e528d) (out)
lateral-join-crash.Bug-6613.stable.err.FILTERED 2019-09-21 02:10:26.473417379 +0200lateral-join-crash.Bug-6613.test.err.FILTERED 2019-09-21 02:10:26.483417841 +0200
1 Statistics about stderr of test 'lateral-join-crash.Bug-6613` in directory 'sql/test/BugTracker-2018`: 1 1 Statistics about stderr of test 'lateral-join-crash.Bug-6613` in directory 'sql/test/BugTracker-2018`: 1
2 1 lines, 8 words, 92 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 170 lines, 666 words, 11850 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 92 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 170 lines, 666 words, 11850 chars in lines not matching '^$|^(\| |)#` 3
4 # 23 lines, 98 words, 1135 chars in all lines 4 ! 4 # 188 lines, 726 words, 12484 chars in all lines 4
5 5 5 5
..................
# 23 lines, 98 words,
8 8 8 8
9 # 00:28:46 > 9 ! 9 # 02:10:15 > 9
10 # 00:28:46 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34098" "--set" "mapi_usock=/var/tmp/mtest-13250/.s.monetdb.34098" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2018" "--set" "embedded_c=true" 10 ! 10 # 02:10:15 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=8" "--set" "mapi_open=true" "--set" "mapi_port=33196" "--set" "mapi_usock=/var/tmp/mtest-48275/.s.monetdb.33196" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/home/monet/testing/7617234e528d-7-1-2/tests/sql/dbfarm/mTests_sql_test_BugTracker-2018" "--set" "embedded_c=true" 10
11 # 00:28:46 > 11 ! 11 # 02:10:15 > 11
12 12 ! 12 12
13 #WARNING To speedup generator.series a bulk operator implementation is needed 13 ! 13 mserver5: /home/monet/testing/7617234e528d-7-1-2/MonetDB/sql/backends/monet5/rel_bin.c:1576: rel2bin_table: Assertion `0' failed. 13
14 # X_39:bat[:hge] := batmal.multiplex("generator":str, "series":str, X_38:bat[:hge], X_37:bat[:hge]); 14 ! 14 14
15 #client2:!ERROR:ParseException:SQLparser:42S22!SELECT: no such column 't.meter' 15 ! 15 Aborted 15
16 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 16 ! 16 PID: 128327 (mserver5) 16
17 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 17 ! 17 UID: 1004 (monet) 17
18 #main thread:!ERROR:MALException:client.quit:Server stopped 18 ! 18 GID: 1004 (monet) 18
19 19 ! 19 Signal: 6 (ABRT) 19
20 # 00:28:47 > 20 ! 20 Timestamp: Sat 2019-09-21 02:10:16 CEST (10s ago) 20
21 # 00:28:47 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13250" "--port=34098" 21 ! 21 Command Line: mserver5 --debug=10 --set gdk_nr_threads 8 --set mapi_open true --set mapi_port 33196 --set mapi_usock /var/tmp/mtest-48275/.s.monetdb.33196 --set monet_prompt --forcemito --set gdk_vm_maxsize 8589934592 --dbpath=/home/monet/testing/7617234e528d-7-1-2/tests/sql/dbfarm/mTests_sql_test_BugTracker-2018 --set embedded_c true 21
22 # 00:28:47 > 22 ! 22 Executable: /home/monet/testing/7617234e528d-7-1-2/install/bin/mserver5 22
23 23 ! 23 Control Group: /user.slice/user-1004.slice/session-18249.scope 23
24 24 ! 24 Unit: session-18249.scope 24
25 # 00:28:47 > 25 ! 25 Slice: user-1004.slice 25
26 # 00:28:47 > "Done." 26 ! 26 Session: 18249 26
27 # 00:28:47 > 27 ! 27 Owner UID: 1004 (monet) 27
+ 28 Boot ID: 4ba92a54f72741f8b17802ab88fda45e 28
+ 29 Machine ID: a998d3c0aae64c3687c63b8f30bf5431 29
+ 30 Hostname: power8 30
+ 31 Storage: /var/lib/systemd/coredump/core.mserver5.1004.4ba92a54f72741f8b17802ab88fda45e.128327.1569024616000000.lz4 31
+ 32 Message: Process 128327 (mserver5) of user 1004 dumped core. 32
+ 33 33
+ 34 Stack trace of thread 128356: 34
+ 35 #0 0x00007fffa81a6ec4 raise (libc.so.6) 35
+ 36 #1 0x00007fffa8188428 abort (libc.so.6) 36
+ 37 #2 0x00007fffa819aff0 __assert_fail_base (libc.so.6) 37
+ 38 #3 0x00007fffa819b08c __assert_fail (libc.so.6) 38
+ 39 #4 0x00007fff99a09138 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 39
+ 40 #5 0x00007fff99a09138 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 40
+ 41 #6 0x00007fff999fded0 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 41
+ 42 #7 0x00007fff99a09240 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 42
+ 43 #8 0x00007fff999fdf70 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 43
+ 44 #9 0x00007fff99a0b1a0 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 44
+ 45 #10 0x00007fff999fde30 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 45
+ 46 #11 0x00007fff99a0bba8 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 46
+ 47 #12 0x00007fff99a27cd4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 47
+ 48 #13 0x00007fff99a29e7c n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 48
+ 49 #14 0x00007fff999ec110 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 49
+ 50 #15 0x00007fffa94c661c n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 50
+ 51 #16 0x00007fffa94c7c08 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 51
+ 52 #17 0x00007fffa94c8458 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 52
+ 53 #18 0x00007fffa94c8c34 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 53
+ 54 #19 0x00007fffa9598c3c n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 54
+ 55 #20 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 55
+ 56 #21 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 56
+ 57 #22 0x00007fffa837c388 start_thread (libpthread.so.0) 57
+ 58 58
+ 59 Stack trace of thread 128331: 59
+ 60 #0 0x00007fffa827bb34 __poll (libc.so.6) 60
+ 61 #1 0x00007fffa95965ec n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 61
+ 62 #2 0x00007fffa95965ec n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 62
+ 63 #3 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 63
+ 64 #4 0x00007fffa837c388 start_thread (libpthread.so.0) 64
+ 65 65
+ 66 Stack trace of thread 128342: 66
+ 67 #0 0x00007fffa8389ddc do_futex_wait.constprop.1 (libpthread.so.0) 67
+ 68 #1 0x00007fffa8389f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 68
+ 69 #2 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 69
+ 70 #3 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 70
+ 71 #4 0x00007fffa949f104 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 71
+ 72 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 72
+ 73 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 73
+ 74 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 74
+ 75 75
+ 76 Stack trace of thread 128340: 76
+ 77 #0 0x00007fffa8389ddc do_futex_wait.constprop.1 (libpthread.so.0) 77
+ 78 #1 0x00007fffa8389f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 78
+ 79 #2 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 79
+ 80 #3 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 80
+ 81 #4 0x00007fffa949f104 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 81
+ 82 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 82
+ 83 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 83
+ 84 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 84
+ 85 85
+ 86 Stack trace of thread 128327: 86
+ 87 #0 0x00007fffa8275af4 __read (libc.so.6) 87
+ 88 #1 0x00007fffa81f3480 _IO_file_read (libc.so.6) 88
+ 89 #2 0x00007fffa81f4670 _IO_file_underflow@@GLIBC_2.3 (libc.so.6) 89
+ 90 #3 0x00007fffa81f5f1c _IO_default_uflow (libc.so.6) 90
+ 91 #4 0x00007fffa81f5b94 __uflow (libc.so.6) 91
+ 92 #5 0x00007fffa81e3064 _IO_getline_info (libc.so.6) 92
+ 93 #6 0x00007fffa81e1414 _IO_fgets (libc.so.6) 93
+ 94 #7 0x00007fffa8e92af4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libstream.so.13.0.2) 94
+ 95 #8 0x00007fffa8e92af4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libstream.so.13.0.2) 95
+ 96 #9 0x00007fffa9481610 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 96
+ 97 #10 0x00007fffa94c9678 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 97
+ 98 #11 0x00007fffa94c6558 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 98
+ 99 #12 0x00007fffa94c7c08 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 99
+ 100 #13 0x00007fffa94c8458 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 100
+ 101 #14 0x0000000010003878 n/a (/home/monet/testing/7617234e528d-7-1-2/install/bin/mserver5) 101
+ 102 102
+ 103 Stack trace of thread 128347: 103
+ 104 #0 0x00007fffa8389ddc do_futex_wait.constprop.1 (libpthread.so.0) 104
+ 105 #1 0x00007fffa8389f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 105
+ 106 #2 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 106
+ 107 #3 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 107
+ 108 #4 0x00007fffa949f104 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 108
+ 109 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 109
+ 110 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 110
+ 111 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 111
+ 112 112
+ 113 Stack trace of thread 128348: 113
+ 114 #0 0x00007fffa8389ddc do_futex_wait.constprop.1 (libpthread.so.0) 114
+ 115 #1 0x00007fffa8389f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 115
+ 116 #2 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 116
+ 117 #3 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 117
+ 118 #4 0x00007fffa949f104 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 118
+ 119 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 119
+ 120 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 120
+ 121 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 121
+ 122 122
+ 123 Stack trace of thread 128351: 123
+ 124 #0 0x00007fffa838c838 __nanosleep (libpthread.so.0) 124
+ 125 #1 0x00007fffa92ab240 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 125
+ 126 #2 0x00007fffa92ab240 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 126
+ 127 #3 0x00007fff99b4ccb4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 127
+ 128 #4 0x00007fff99a8c21c n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 128
+ 129 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 129
+ 130 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 130
+ 131 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 131
+ 132 132
+ 133 Stack trace of thread 128344: 133
+ 134 #0 0x00007fffa8389ddc do_futex_wait.constprop.1 (libpthread.so.0) 134
+ 135 #1 0x00007fffa8389f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 135
+ 136 #2 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 136
+ 137 #3 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 137
+ 138 #4 0x00007fffa949f104 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 138
+ 139 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 139
+ 140 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 140
+ 141 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 141
+ 142 142
+ 143 Stack trace of thread 128352: 143
+ 144 #0 0x00007fffa838c838 __nanosleep (libpthread.so.0) 144
+ 145 #1 0x00007fffa92ab240 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 145
+ 146 #2 0x00007fffa92ab240 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 146
+ 147 #3 0x00007fff99b65db8 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 147
+ 148 #4 0x00007fff99a8c27c n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/monetdb5/lib_sql.so) 148
+ 149 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 149
+ 150 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 150
+ 151 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 151
+ 152 152
+ 153 Stack trace of thread 128330: 153
+ 154 #0 0x00007fffa838c838 __nanosleep (libpthread.so.0) 154
+ 155 #1 0x00007fffa92ab240 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 155
+ 156 #2 0x00007fffa92ab240 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 156
+ 157 #3 0x00007fffa94beb64 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 157
+ 158 #4 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 158
+ 159 #5 0x00007fffa837c388 start_thread (libpthread.so.0) 159
+ 160 160
+ 161 Stack trace of thread 128341: 161
+ 162 #0 0x00007fffa8389ddc do_futex_wait.constprop.1 (libpthread.so.0) 162
+ 163 #1 0x00007fffa8389f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 163
+ 164 #2 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 164
+ 165 #3 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 165
+ 166 #4 0x00007fffa949f104 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 166
+ 167 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 167
+ 168 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 168
+ 169 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 169
+ 170 170
+ 171 Stack trace of thread 128350: 171
+ 172 #0 0x00007fffa8389ddc do_futex_wait.constprop.1 (libpthread.so.0) 172
+ 173 #1 0x00007fffa8389f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 173
+ 174 #2 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 174
+ 175 #3 0x00007fffa949e128 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 175
+ 176 #4 0x00007fffa949f104 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libmonetdb5.so.27.0.3) 176
+ 177 #5 0x00007fffa9243a90 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 177
+ 178 #6 0x00007fffa92a78c4 n/a (/home/monet/testing/7617234e528d-7-1-2/install/lib/libbat.so.18.0.4) 178
+ 179 #7 0x00007fffa837c388 start_thread (libpthread.so.0) 179
+ 180 180
+ 181 # 02:10:16 > 181
+ 182 # 02:10:16 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-48275" "--port=33196" 182
+ 183 # 02:10:16 > 183
+ 184 184
+ 185 #~ MAPI = (monetdb) /var/tmp/mtest-48275/.s.monetdb.33196 185
+ 186 ACTION= mapi_query_done 186
+ 187 QUERY = select t.meter, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t(meter); 187
+ 188 ERROR = !write error on stream 188
+ 189 189
+ 190 # 02:10:26 > 190
+ 191 # 02:10:26 > "Done." 191
+ 192 # 02:10:26 > 192
28 28 193 193