Bug #117984 mtr case openssl_cert_generation_debug.test execute fail
Submitted: 15 Apr 9:09 Modified: 16 Apr 8:02
Reporter: ximin liang (OCA) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S7 (Test Cases)
Version:8.0.41 OS:Any
Assigned to: CPU Architecture:Any

[15 Apr 9:09] ximin liang 
Description:
Hello MySQL team:

  Seems there is some problem about mtr case openssl_cert_generation_debug.test. 

How to repeat:
 Repeated with 8.0.41:
 when in $MYSQL_CODE/build/mysql-test/
 if execute:
 ./mtr --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite="auth_sec" --do-test="openssl_cert_generation_debug"

 error happens:
 mysqltest: At line 52: Command "remove_file" failed with error 1. my_errno=2.
[15 Apr 10:09] MySQL Verification Team 
Hello ximin liang,

Thank you for the report and feedback.
I tried to repeat in 8.0.41 build but not seeing any issues at my end. If you are using source build then could you please share exact cmake options used for the build along with the OS details? Thank you.

--

mysql-8.0.41/mysql-test]$ ./mtr --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite="auth_sec" --do-test="openssl_cert_generation_debug" --debug-server --repeat=10
Logging: ./mtr  --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite=auth_sec --do-test=openssl_cert_generation_debug --debug-server --repeat=10
MySQL Version 8.0.41
Checking supported features
 - Binaries are debug compiled
Using suite(s): auth_sec
Collecting tests
Removing old var directory
Creating var directory '/export/home/tmp/ushastry/work/binaries/mysql-8.0.41/mysql-test/var'
Installing system database
Using parallel: 10

==============================================================================
                  TEST NAME                   WORKER RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
[  9%] auth_sec.openssl_cert_generation_debug   w6  [ pass ]  39326
[ 18%] auth_sec.openssl_cert_generation_debug   w2  [ pass ]  39531
[ 27%] auth_sec.openssl_cert_generation_debug   w9  [ pass ]  40729
[ 36%] auth_sec.openssl_cert_generation_debug   w3  [ pass ]  41337
[ 45%] auth_sec.openssl_cert_generation_debug   w1  [ pass ]  41705
[ 54%] auth_sec.openssl_cert_generation_debug   w4  [ pass ]  41434
[ 63%] auth_sec.openssl_cert_generation_debug   w10 [ pass ]  41661
[ 72%] auth_sec.openssl_cert_generation_debug   w7  [ pass ]  42528
[ 81%] auth_sec.openssl_cert_generation_debug   w5  [ pass ]  42536
[ 90%] auth_sec.openssl_cert_generation_debug   w8  [ pass ]  43294
[100%] shutdown_report                          w0  [ pass ]
------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 0 times
Spent 414.081 of 63 seconds executing testcases

Completed: All 11 tests were successful.

regards,
Umesh
[15 Apr 11:20] ximin liang 
Dear MySQL team:
  For release version, mtr passed.
  For debug version, mtr failed. 
  I compiled MySQL source code with debug mode on CentOS, but found this MTR test case failed to pass.
[15 Apr 15:07] MySQL Verification Team 
Hello ximin liang,

Thank you for the report and feedback.
I tried to repeat in 8.0.41/8.4.4/9.2.0 debug builds only. If you are using source build then could you please share exact cmake options used for the build along with the OS details? Thank you.

--

/bv/mybugs/mysql-8.0.41/mysql-test]$ ./mtr --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite="auth_sec" --do-test="openssl_cert_generation_debug" --debug-server
Logging: ./mtr  --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite=auth_sec --do-test=openssl_cert_generation_debug --debug-server
MySQL Version 8.0.41
Checking supported features
 - Binaries are debug compiled
Using suite(s): auth_sec
Collecting tests
Checking leftover processes
Removing old var directory
Creating var directory '/bv/mybugs/mysql-8.0.41/mysql-test/var'
Installing system database
Using parallel: 1

==============================================================================
                  TEST NAME                       RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
[ 50%] auth_sec.openssl_cert_generation_debug    [ pass ]  35968
[100%] shutdown_report                           [ pass ]
------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 0 times
Spent 35.968 of 55 seconds executing testcases

Completed: All 2 tests were successful.

-- 9.2.0

[umshastr@bug117958:/bv/mybugs/mysql-9.2.0/mysql-test]$ ./mtr --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite="auth_sec" --do-test="openssl_cert_generation_debug" --debug-server
Logging: ./mtr  --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite=auth_sec --do-test=openssl_cert_generation_debug --debug-server
MySQL Version 9.2.0
Checking supported features
 - Binaries are debug compiled
Using suite(s): auth_sec
Collecting tests
Removing old var directory
Creating var directory '/bv/mybugs/mysql-9.2.0/mysql-test/var'
Installing system database
Using parallel: 1

==============================================================================
                  TEST NAME                       RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
[ 50%] auth_sec.openssl_cert_generation_debug    [ pass ]  42498
[100%] shutdown_report                           [ pass ]
------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 0 times
Spent 42.498 of 64 seconds executing testcases

Completed: All 2 tests were successful.

-- 8.4.4

[umshastr@bug117958:/bv/mybugs/mysql-8.4.4/mysql-test]$ ./mtr --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite="auth_sec" --do-test="openssl_cert_generation_debug" --debug-server
Logging: ./mtr  --force --parallel=16 --nocheck-testcases --nounit-tests --clean-vardir --retry=0 --max-test-fail=1000 --record --big-test --do-suite=auth_sec --do-test=openssl_cert_generation_debug --debug-server
MySQL Version 8.4.4
Checking supported features
 - Binaries are debug compiled
Using suite(s): auth_sec
Collecting tests
Checking leftover processes
Removing old var directory
Creating var directory '/bv/mybugs/mysql-8.4.4/mysql-test/var'
Installing system database
Using parallel: 1

==============================================================================
                  TEST NAME                       RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
[ 50%] auth_sec.openssl_cert_generation_debug    [ pass ]  41522
[100%] shutdown_report                           [ pass ]
------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 0 times
Spent 41.522 of 63 seconds executing testcases

Completed: All 2 tests were successful.

regards,
Umesh
[16 Apr 2:29] ximin liang 
I compile MySQL source code using this script

Attachment: build_mysql.sh (text/x-sh), 801 bytes.
[16 Apr 8:02] MySQL Verification Team 
Hello ximin liang,

Thank you for the build script, quickly built 8.0.41 using your build script and ran the test case to see if I can reproduce but it works. I suggest you to try recent releases 8.0.42/8.4.5/9.3.0 and report us back with details.
Am I missing something here? Please let me know.

Joining the build and test results shortly.

regards,
Umesh
[16 Apr 8:02] MySQL Verification Team 
build and test results

Attachment: 117984.results (application/octet-stream, text), 3.23 MiB.