Completed: Failed 1/1865 tests, 99.95% were successful _________________________________________ [root@testserver:~]$ cat /usr/local/bin/mysql-test.sh #!/usr/bin/dash /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --parallel=4 --max-test-fail=0 --mysqld=--binlog-format=row --force --suites="main-,binlog-,csv-,funcs_1-,funcs_2-,handler-,heap-,maria-,optimizer_unfixed_bugs-,parts-,percona-,roles-,rpl-,sys_vars-,unit-,vcol-" --skip-test-list=/var/lib/mysql/skip-tests.txt' mysql rm -rf /usr/share/mysql-test/var/* _________________________________________ CURRENT_TEST: main.subselect_no_opts /usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/4/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory") mysqltest: In included file "/usr/share/mysql-test/t/subselect.test": included from /usr/share/mysql-test/t/subselect_no_opts.test at line 12: At line 5903: query 'Select (Select Sum(`TestCase`.Revenue) From mysql.slow_log E Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2) ) As `ControlRev` From (Select 3 as Revenue, 4 as TemplateID) As `TestCase` Group By TestCase.Revenue, TestCase.TemplateID' failed: 1242: Subquery returns more than 1 row The result from queries just before the failure was: < snip > 2 SUBQUERY t2 ref b b 5 test.t1.a 2 Using index DROP TABLE t1,t2; # # MDEV-5991: crash in Item_field::used_tables # create table t1 (c int); select exists(select 1 from t1 group by `c` in (select `c` from t1)); exists(select 1 from t1 group by `c` in (select `c` from t1)) 0 drop table t1; # # MDEV-7565: Server crash with Signal 6 (part 2) # Select (Select Sum(`TestCase`.Revenue) From mysql.slow_log E Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2) ) As `ControlRev` From (Select 3 as Revenue, 4 as TemplateID) As `TestCase` Group By TestCase.Revenue, TestCase.TemplateID; More results from queries before failure can be found in /usr/share/mysql-test/var/4/log/subselect_no_opts.log - saving '/usr/share/mysql-test/var/4/log/main.subselect_no_opts/' to '/usr/share/mysql-test/var/log/main.subselect_no_opts/' ***Warnings generated in error logs during shutdown after running tests: main.grant main.subselect3_jcl6 main.subselect_mat main.strict_autoinc_3heap main.func_time_hires main.failed_auth_3909 main.subselect_extra main.gis-json main.gis main.gis-precise main.subselect_no_opts main.explain main.get_diagnostics main.str_to_datetime_457 main.function_defaults main.execution_constants main.func_weight_string main.empty_server_name-8224 main.func_timestamp main.subselect_cache main.subselect_gis main.gcc296 main.flush_table 2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: localhost, user: root, thread: 164, query: select numeropost as a FROM t1 ORDER BY (SELECT 1 FROM t1 HAVING a=1) 2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: localhost, user: root, thread: 164, query: SELECT a FROM t1 GROUP BY a 2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: localhost, user: root, thread: 164, query: SELECT a FROM t1 GROUP BY a 2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: localhost, user: root, thread: 164, query: SELECT a FROM t1 2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: localhost, user: root, thread: 164, query: SELECT a FROM t1