Bug #79901 TDE: test cases get hang on FreeBSD

• Submitted: 9 Jan 2016 2:02
• Modified: 6 Feb 2016 19:29
• Reporter: Allen Lai
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.7.11
• OS: Any
• CPU Architecture: Any

[9 Jan 2016 2:02] Allen Lai

Description:
TDE test cases keep hanging on FreeBSD.
It only happens in trunk branch.

Thread is waiting in row_mysql_lock_data_dictionary_func:

Thread 1 (Thread 8147e4800 (LWP 101091/mysqld)):
#0  0x0000000801ecfe1c in pthread_cleanup_pop () from /lib/libthr.so.3
#1  0x0000000801ece2de in _pthread_cond_wait () from /lib/libthr.so.3
#2  0x00000000010f93f6 in os_event::wait_low (this=0x808bff658, reset_sig_count=<value optimized out>)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/os/os0event.cc:165
#3  0x0000000001173bb5 in sync_array_wait_event (arr=0x80a7f04f8, cell=@0x7fffdd3a0770)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/sync/sync0arr.cc:475
#4  0x0000000001176169 in rw_lock_x_lock_wait_func (lock=0x80d7dddf8, threshold=0,
    file_name=0x157a478 "/export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc", line=12215)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/sync/sync0rw.cc:510
#5  0x0000000001175b6f in rw_lock_x_lock_low (lock=0x80d7dddf8, pass=<value optimized out>,
    file_name=0x157a478 "/export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc", line=12215)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/sync/sync0rw.cc:591
#6  0x0000000001175884 in rw_lock_x_lock_func (lock=0x80d7dddf8, pass=0,
    file_name=0x157a478 "/export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc", line=12215)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/sync/sync0rw.cc:729
#7  0x000000000113ae55 in row_mysql_lock_data_dictionary_func (trx=0x80a800ab8,
    file=0x157a478 "/export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc", line=12215) at sync0rw.ic:704
#8  0x000000000108a631 in ha_innobase::create (this=<value optimized out>, name=<value optimized out>, form=<value optimized out>,
    create_info=<value optimized out>, file_per_table=<value optimized out>)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:12215
#9  0x0000000000a5c929 in ha_create_table (thd=<value optimized out>, path=<value optimized out>, db=0x82c406f80 "test", table_name=0x82c4069c8 "t1",
    create_info=0x7fffdd3a4510, update_create_info=<value optimized out>, table_def=<value optimized out>)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/sql/handler.cc:4799
#10 0x00000000008f281d in create_table_impl (thd=0x82c93f000, db=0x82c406f80 "test", table_name=0x82c4069c8 "t1", path=0x7fffdd3a2ed0 "./test/t1",
    create_info=0x7fffdd3a4510, alter_info=<value optimized out>, internal_tmp_table=<value optimized out>, key_info=<value optimized out>,
    key_count=<value optimized out>, is_sql_layer_system_table=<value optimized out>, tmp_table_def=0x7fff00000000)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/sql/sql_table.cc:2004
#11 0x00000000008f1510 in mysql_create_table_no_lock (thd=<value optimized out>, db=<value optimized out>, table_name=<value optimized out>,
    create_info=<value optimized out>, alter_info=<value optimized out>, select_field_count=<value optimized out>)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/sql/sql_table.cc:5846
#12 0x00000000008f2a5b in mysql_create_table (thd=0x82c93f000, create_table=0x82c406a00, create_info=0x7fffdd3a4510, alter_info=0x7fffdd3a4468)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/sql/sql_table.cc:5894
#13 0x000000000089e957 in mysql_execute_command (thd=0x82c93f000, first_level=true)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:3216
#14 0x0000000000898819 in mysql_parse (thd=0x82c93f000, parser_state=<value optimized out>)
    at /export/home/pb2/build/sb_0-17539871-1452190315.45/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:5514
#15 0x00000000008977ba in dispatch_command (thd=0x82c93f000, com_data=<value optimized out>, command=<value optimized out>)

How to repeat:
See test case failure.

[6 Feb 2016 19:29] Daniel Price

Posted by developer:
 
Fixed as of the upcoming 5.7.12, 5.8.0 release, and here's the changelog entry:

Tabespace encryption-related operations resulted in a hang on FreeBSD.