Details
Description
http://askmonty.org/buildbot/builders/xenial-amd64-valgrind/builds/256
main.subselect_no_exists_to_in w19 [ fail ]
|
Test ended at 2017-01-03 16:55:52 |
|
CURRENT_TEST: main.subselect_no_exists_to_in
|
/home/buildbot/build/client/mysqltest: Error on delete of '/dev/shm/var/19/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory") |
--- /home/buildbot/build/mysql-test/r/subselect_no_exists_to_in.result 2017-01-02 14:29:31.000000000 -0500
|
+++ /home/buildbot/build/mysql-test/r/subselect_no_exists_to_in.reject 2017-01-03 16:55:50.452101900 -0500
|
@@ -7032,7 +7032,7 @@
|
(Select 3 as Revenue, 4 as TemplateID) As `TestCase` |
Group By TestCase.Revenue, TestCase.TemplateID; |
ControlRev
|
-NULL |
+3
|
#
|
# MDEV-7445:Server crash with Signal 6 |
#
|
@@ -7048,10 +7048,10 @@
|
END | |
call procedure2();
|
ControlRev
|
-NULL |
+3
|
call procedure2();
|
ControlRev
|
-NULL |
+3
|
drop procedure procedure2; |
SELECT |
(SELECT user FROM mysql.user |
|
mysqltest: Result length mismatch
|
Attachments
Issue Links
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Stalled
-
The test uses mysql.slow_log in a query, and expects it to be always empty. It does not write anything into the table (it runs with log_output=file, but one of previous tests, main.log_slow, sets log_output=table for a short while. Here is the relevant fragment:
set long_query_time=0.1;
set log_slow_filter='';
set global slow_query_log=1;
set global log_output='TABLE';
select sleep(0.5);
select count(*) FROM mysql.slow_log;
truncate mysql.slow_log;
# Reset used variables
set @@long_query_time=default;
set global slow_query_log= @org_slow_query_log;
set @@log_slow_filter=default;
set @@log_slow_verbosity=default;
set global log_output= default;
On a slow builder it might happen that truncate mysql.slow_log itself takes longer than 0.1 sec and will be written into the table. The solution is to do truncate after the variables have been restored to default values.