Bug #95034 MTR test_sql_stored_procedures_functions fail probabilistically in debug mode.
Submitted: 16 Apr 2019 3:56 Modified: 16 Apr 2019 8:49
Reporter: jinming liao Email Updates:
Status: Verified Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S7 (Test Cases)
Version:8.0.13, 8.0.15 OS:CentOS (CentOS Linux release 7.2.1511 (Core))
Assigned to: CPU Architecture:x86 (Intel(R) Xeon(R) Gold 6161 CPU @ 2.20GHz)
Tags: debug, Fail probabilistically, mtr

[16 Apr 2019 3:56] jinming liao
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.
[16 Apr 2019 8:49] MySQL Verification Team
Hello jinming liao,

Thank you for the report.
Verified as described with 8.0.15 build.

regards,
Umesh