Bug #99064 main.mysql_client_test is unstable
Submitted: 25 Mar 2020 7:11 Modified: 25 Mar 2020 8:00
Reporter: zhijun long Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:8.0.19 OS:Any
Assigned to: CPU Architecture:Any

[25 Mar 2020 7:11] zhijun long
Description:
./mtr  main.mysql_client_test --parallel=24 --repeat=20

[ 80%] main.mysql_client_test                   w18 [ pass ]  212260
[ 85%] main.mysql_client_test                   w12 [ fail ]
        Test ended at 2020-03-25 14:14:07

CURRENT_TEST: main.mysql_client_test
mysqltest: At line 36: Command "shutdown_server" failed with error 2. my_errno=175.
In included file ./include/shutdown_mysqld.inc: 37
included from /home/ci/perf/mysql-8.0.19/bin/mysql-test/t/mysql_client_test.test: 47

The result from queries just before the failure was:
  - 1: name: 'v_dbl_1'/'v_dbl_1'; table: 'p1'/'p1'; db: 'client_test_db'; catalog: 'def'; length: 4; max_length: 0; type: 5; decimals: 2
  - 2: name: 'v_dec_1'/'v_dec_1'; table: 'p1'/'p1'; db: 'client_test_db'; catalog: 'def'; length: 8; max_length: 0; type: 246; decimals: 3
  - 3: name: 'v_int_1'/'v_int_1'; table: 'p1'/'p1'; db: 'client_test_db'; catalog: 'def'; length: 11; max_length: 0; type: 3; decimals: 0
  - 4: name: 'v_str_2'/'v_str_2'; table: 'p1'/'p1'; db: 'client_test_db'; catalog: 'def'; length: 256; max_length: 0; type: 254; decimals: 0
  - 5: name: 'v_dbl_2'/'v_dbl_2'; table: 'p1'/'p1'; db: 'client_test_db'; catalog: 'def'; length: 5; max_length: 0; type: 5; decimals: 3
  - 6: name: 'v_dec_2'/'v_dec_2'; table: 'p1'/'p1'; db: 'client_test_db'; catalog: 'def'; length: 9; max_length: 0; type: 246; decimals: 4
  - 7: name: 'v_int_2'/'v_int_2'; table: 'p1'/'p1'; db: 'client_test_db'; catalog: 'def'; length: 11; max_length: 0; type: 3; decimals: 0
Data:
  str: 'test_1'; dbl: 12.340000; dec: '567.891'; int: 2345; str: 'test_2'; dbl: 67.891000; dec: '234.6789'; int: 6789;
EOF
mysql_stmt_next_result(): 0; field_count: 0
# ------------------------------------

SET @@global.general_log= @old_general_log;
SET @@global.slow_query_log= @old_slow_query_log;
#
# Bug#24963580 INFORMATION_SCHEMA:MDL_REQUEST::
# INIT_WITH_SOURCE(MDL_KEY::ENUM_MDL_NAMESPACE
#
# Shut server down.
safe_process[16878]: Child process: 16882, exit: 1

 - the logfile can be found in '/home/ci/perf/mysql-8.0.19/bin/mysql-test/var/log/main.mysql_client_test/mysql_client_test.log'

 - found 'core.15871' (0/5)

Trying 'dbx' to get a backtrace
Core was generated by `/home/ci/perf/mysql-8.0.19/bin/bin/mysqld --defaults-group-suffix=.1 --defaults'.
Program terminated with signal SIGABRT, Aborted.
#0  0x00007faaaf01b9d1 in pthread_kill () from /lib64/libpthread.so.0
[Current thread is 1 (Thread 0x7faaaf42e980 (LWP 15871))]
#0  0x00007faaaf01b9d1 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000004608e9b in my_write_core (sig=6) at /home/ci/perf/mysql-8.0.19/mysys/stacktrace.cc:306
#2  0x00000000032ef756 in handle_fatal_signal (sig=6) at /home/ci/perf/mysql-8.0.19/sql/signal_handler.cc:169
#3  <signal handler called>
#4  0x00007faaaf017f47 in pthread_join () from /lib64/libpthread.so.0
#5  0x0000000004605651 in my_thread_join (thread=0x7994f80 <signal_thread_id>, value_ptr=0x0) at /home/ci/perf/mysql-8.0.19/mysys/my_thread.cc:101
#6  0x0000000002f6d81a in mysqld_main (argc=77, argv=0x89743a8) at /home/ci/perf/mysql-8.0.19/sql/mysqld.cc:7138
#7  0x0000000002f5a6b6 in main (argc=14, argv=0x7ffe0e304eb8) at /home/ci/perf/mysql-8.0.19/sql/main.cc:25

How to repeat:
see Description.

./mtr  main.mysql_client_test --parallel=24 --repeat=20

Suggested fix:
none.
[25 Mar 2020 8:00] MySQL Verification Team
Hello zhijun long,

Thank you for the report and feedback.

regards,
Umesh