Bug #96079 large_tests.innodb_innochecksum_3gb test failing with debug build.
Submitted: 2 Jul 2019 15:19 Modified: 20 Jul 2020 7:36
Reporter: lalit Choudhary Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:8.0.16 OS:Any
Assigned to: CPU Architecture:Any

[2 Jul 2019 15:19] lalit Choudhary
Description:
large_tests.innodb_innochecksum_3gb test failing with debug build.

$ cmake .. -DWITH_SSL=system -DCMAKE_BUILD_TYPE=Debug -DWITH_DEBUG=1 -DWITH_VALGRIND=1 -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_SSL=system -DDOWNLOAD_BOOST=1 -DWITH_BOOST=../

./mtr innodb_innochecksum_3gb

Thread 1 (Thread 0x7f773251d880 (LWP 4727)):
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1  0x000055ffc5a045d7 in my_write_core (sig=6) at /home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/mysys/stacktrace.cc:284
#2  0x000055ffc4625814 in handle_fatal_signal (sig=6) at /home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/sql/signal_handler.cc:168
#3  <signal handler called>
#4  0x00007f7730752bf9 in __GI___poll (fds=0x55ffc99127c0, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
#5  0x000055ffc4613ae2 in Mysqld_socket_listener::listen_for_connection_event (this=0x55ffc9914120) at /home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/sql/conn_handler/socket_connection.cc:1329
#6  0x000055ffc42b6642 in Connection_acceptor<Mysqld_socket_listener>::connection_event_loop (this=0x55ffc9901f90) at /home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/sql/conn_handler/connection_acceptor.h:64
#7  0x000055ffc42a94cb in mysqld_main (argc=68, argv=0x55ffc96b3728) at /home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/sql/mysqld.cc:6793
#8  0x000055ffc42960aa in main (argc=7, argv=0x7ffddde206e8) at /home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/sql/main.cc:25

------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 1 times
Spent 0.000 of 1021 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): large_tests.innodb_innochecksum_3gb

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases

mysql-test logs:

CURRENT_TEST: large_tests.innodb_innochecksum_3gb
safe_process[4804]: Child process: 4805, aborted by signal: 6
mysqltest got signal 6
mysqltest: At line 59: LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/input.dat' IGNORE INTO TABLE tab2
conn->name: default
Attempting backtrace.
stack_bottom = 0 thread_stack 0x10000
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x119033) [0x56139337c033]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0xb94a2) [0x56139331c4a2]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0xb94d6) [0x56139331c4d6]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890) [0x7fd97dbc2890]
/lib/x86_64-linux-gnu/libpthread.so.0(recv+0x1a) [0x7fd97dbc17ea]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x1b8be8) [0x56139341bbe8]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x1b91ab) [0x56139341c1ab]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x1b940e) [0x56139341c40e]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x1daac2) [0x56139343dac2]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x1dabc8) [0x56139343dbc8]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x1db584) [0x56139343e584]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x1db841) [0x56139343e841]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x18e51a) [0x5613933f151a]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x18eba6) [0x5613933f1ba6]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x19f3c1) [0x5613934023c1]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0x1b18ea) [0x5613934148ea]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0xa2de6) [0x561393305de6]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0xb71c3) [0x56139331a1c3]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0xb89af) [0x56139331b9af]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0xbaa93) [0x56139331da93]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7) [0x7fd97c314b97]
/home/lalit/git/mysql-boost-8.0.16/mysql-8.0.16/bld/runtime_output_directory//mysqltest(+0xa172a) [0x56139330472a]
Writing a core file.
safe_process[4804]: Child process: 4805, killed by signal: 6

How to repeat:
$ cmake .. -DWITH_SSL=system -DCMAKE_BUILD_TYPE=Debug -DWITH_DEBUG=1 -DWITH_VALGRIND=1 -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_SSL=system -DDOWNLOAD_BOOST=1 -DWITH_BOOST=../

./mtr innodb_innochecksum_3gb
[3 Jul 2019 8:50] MySQL Verification Team
Hello lalit,

Thank you for the report and feedback.

regards,
Umesh
[20 Jul 2020 7:36] Erlend Dahl
We can't repeat this on 8.0.20.