Description:
[ 13%] test_service_sql_api.test_sql_stored_procedures_functions [ fail ]
Test ended at 2019-04-16 11:20:27
CURRENT_TEST: test_service_sql_api.test_sql_stored_procedures_functions
--- /xxx/mysql-8.0.13/mysql-test/suite/test_service_sql_api/r/test_sql_stored_procedures_functions.result 2018-10-07 11:44:22.000000000 +0300
+++ /xxx/mysql-8.0.13/mysql-test/var/log/test_sql_stored_procedures_functions.reject 2019-04-16 06:20:27.583000000 +0300
@@ -466,8 +466,8 @@
[CS_TEXT_REPRESENTATION]
[meta] rows: 1
[meta] cols: 1
- [meta] server status: 2
- [meta] server status: AUTOCOMMIT
+ [meta] server status: 34
+ [meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
[meta] warning count: 0
[meta][field] db name: mysql
@@ -489,8 +489,8 @@
[data][ROUTINES.SPECIFIC_NAME][ 4][proc]
- [end] server status: 2
- [end] server status: AUTOCOMMIT
+ [end] server status: 34
+ [end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED
[end] warning count: 0
[end] affected rows: 0
[end] insert id : 0
mysqltest: Result content mismatch
safe_process[11137]: Child process: 11138, exit: 1
How to repeat:
Create a new file test_list in mysql-test dir and write the following:
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
test_service_sql_api.test_sql_stored_procedures_functions
...
...
...
test_service_sql_api.test_sql_stored_procedures_functions
Run this command:
./mtr --do-test-list=test_list
The reason to do so:
When we run ./mtr --suite=test_service_sql_api, this failure will appear probabilistically. In order to reproduce this problem, we run this use case multiple times following the above methord.
Suggested fix:
This test case just install the test_sql_stored_procedures_functions plugin, and then cat the contents of the installing log.
I don't know the details of this plugin, so don't know how to fix it.