Bug #87297 Test service_udf_registration.udf_reg_unreg_permissions is unstable
Submitted: 3 Aug 2017 8:40 Modified: 4 Aug 2017 1:57
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:8.0.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: mtr

[3 Aug 2017 8:40] Laurynas Biveinis
Description:
service_udf_registration.udf_reg_unreg_permissions [ fail ]
        Test ended at 2017-08-03 11:21:55

CURRENT_TEST: service_udf_registration.udf_reg_unreg_permissions
--- /Users/laurynas/percona/mysql-8.0.2/mysql-test/suite/service_udf_registration/r/udf_reg_unreg_permissions.result	2017-06-27 14:00:43.000000000 +0300
+++ /Users/laurynas/percona/obj-mysql-8.0.2-asan-debug-openssl/mysql-test/var/log/udf_reg_unreg_permissions.reject	2017-08-03 11:21:54.000000000 +0300
@@ -43,7 +43,7 @@
 SELECT * FROM performance_schema.user_defined_functions
 ORDER BY udf_name;
 UDF_NAME	UDF_RETURN_TYPE	UDF_TYPE	UDF_LIBRARY	UDF_USAGE_COUNT
-myfunc_int	integer	function		1
+myfunc_int	integer	function		2
 connection c1;
 myfunc_int(23)
 23

mysqltest: Result content mismatch

How to repeat:
Mac, CMake options for these particular runs are -DBUILD_CONFIG=mysql_release -DWITH_DEBUG=ON -DWITH_ASAN=ON -DWITH_BOOST=... -DWITH_OPENSSL=/path/to/homebrew/OpenSSL -DWITH_ZLIB=system -DWITH_LZ4=system -DENABLE_DOWNLOADS=ON

$ ./mtr --debug-server udf_reg_unreg_permissions --repeat=1000
[3 Aug 2017 12:58] MySQL Verification Team
I couldn't repeat:

service_udf_registration.udf_reg_unreg_permissions [ pass ]    153
service_udf_registration.udf_reg_unreg_permissions [ pass ]    176
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 186.643 of 2079 seconds executing testcases

Completed: All 1000 tests were successful.

miguel:mysql-test miguel$ ../sql/mysqld-debug --version
/Users/miguel/Downloads/mysql-8.0.2-dmr/sql/mysqld-debug  Ver 8.0.2-dmr-debug-asan for osx10.12 on x86_64 (MySQL Community Server (GPL))
miguel:mysql-test miguel$ system_profiler SPSoftwareDataType
Software:

    System Software Overview:

      System Version: macOS 10.12.6 (16G29)
      Kernel Version: Darwin 16.7.0
[4 Aug 2017 1:57] Erlend Dahl
This problem has been fixed in 8.0.3.