Bug #76844 | handle_fatal_signal (sig=6) in trx_commit_low | trx/trx0trx.cc:1365 | ||
---|---|---|---|
Submitted: | 27 Apr 2015 5:50 | Modified: | 27 Apr 2015 6:52 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.6.23, 5.6.25 | OS: | Linux (CentOS 7) |
Assigned to: | CPU Architecture: | Any | |
Tags: | debug |
[27 Apr 2015 5:50]
Ramesh Sivaraman
[27 Apr 2015 5:51]
Ramesh Sivaraman
Testcase bundle
Attachment: 1430110811_bug_bundle.tar.gz (application/gzip, text), 998.73 KiB.
[27 Apr 2015 6:52]
MySQL Verification Team
Hello Ramesh Sivaraman , Thank you for the bug report and test case. Observed that 5.6.25 debug build is affected. Thanks, Umesh
[27 Apr 2015 6:53]
MySQL Verification Team
// start up scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/76844 bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/76844 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.25/76844/log.err --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --log-bin=binlog --binlog_format=MIXED --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 & Build used: date: 2015-04-24 13:39:44 +0200 build-date: 2015-04-24 14:11:29 +0200 short: 3776da9 branch: mysql-5.6 MySQL source 5.6.25 // extract from error log Version: '5.6.25-enterprise-commercial-advanced-debug-log' socket: '/tmp/mysql_ushastry.sock' port: 15000 MySQL Enterprise Server - Advanced Edition Debug (Commercial) 2015-04-27 08:44:35 10010 [Note] Event Scheduler: scheduler thread started with id 1 2015-04-27 08:44:53 7fbcfc1e9700 InnoDB: Warning: cannot find a free slot for an undo log. Do you have too InnoDB: many active transactions running concurrently? 2015-04-27 08:44:53 7fbcea1fc700 InnoDB: FTS Optimize Removing table test/#sql-271a_2 2015-04-27 08:44:54 7fbcfc1e9700 InnoDB: Warning: cannot find a free slot for an undo log. Do you have too InnoDB: many active transactions running concurrently? 2015-04-27 08:44:54 7fbcfc1e9700 InnoDB: Assertion failure in thread 140449660442368 in file trx0trx.cc line 1364 (gdb) bt #0 0x00007fbd26972771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ae1813 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/mysys/stacktrace.c:422 #2 0x00000000007460b6 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007fbd255785c9 in raise () from /lib64/libc.so.6 #5 0x00007fbd25579cd8 in abort () from /lib64/libc.so.6 #6 0x0000000000d11cdd in trx_commit_low (trx=0x7fbcd0031248, mtr=0x7fbcfc1e52c0) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/storage/innobase/trx/trx0trx.cc:1364 #7 0x0000000000d11d88 in trx_commit (trx=0x7fbcd0031248) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/storage/innobase/trx/trx0trx.cc:1416 #8 0x0000000000d11e4f in trx_commit_for_mysql (trx=0x7fbcd0031248) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/storage/innobase/trx/trx0trx.cc:1634 #9 0x0000000000ba26fc in innobase_commit_low (trx=0x7fbcd0031248) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/storage/innobase/handler/ha_innodb.cc:3400 #10 0x0000000000bacfd7 in innobase_commit (hton=0x2465a00, thd=0x2b84960, commit_trx=false) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/storage/innobase/handler/ha_innodb.cc:3548 #11 0x00000000006548cb in ha_commit_low (thd=0x2b84960, all=false, run_after_commit=false) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/handler.cc:1493 #12 0x0000000000a67853 in MYSQL_BIN_LOG::process_commit_stage_queue (this=0x1937740 <mysql_bin_log>, thd=0x2b84960, first=0x2b84960) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/binlog.cc:6650 #13 0x0000000000a72ab2 in MYSQL_BIN_LOG::ordered_commit (this=0x1937740 <mysql_bin_log>, thd=0x2b84960, all=false, skip_commit=false) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/binlog.cc:7057 #14 0x0000000000a75cb4 in MYSQL_BIN_LOG::commit (this=0x1937740 <mysql_bin_log>, thd=0x2b84960, all=false) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/binlog.cc:6476 #15 0x0000000000654f16 in ha_commit_trans (thd=0x2b84960, all=false, ignore_global_read_lock=false) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/handler.cc:1436 #16 0x00000000008c956e in trans_commit_stmt (thd=0x2b84960) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/transaction.cc:434 #17 0x0000000000801dfc in mysql_execute_command (thd=0x2b84960) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/sql_parse.cc:5037 #18 0x000000000080250a in mysql_parse (thd=0x2b84960, rawbuf=0x7fbcd0004fd0 "UPDATE t1 SET a=1000", length=20, parser_state=0x7fbcfc1e8700) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/sql_parse.cc:6386 #19 0x000000000080412e in dispatch_command (command=COM_QUERY, thd=0x2b84960, packet=0x2c69b01 "UPDATE t1 SET a=1000", packet_length=20) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/sql_parse.cc:1340 #20 0x00000000008059ba in do_command (thd=0x2b84960) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/sql_parse.cc:1037 #21 0x00000000007bb3ed in do_handle_one_connection (thd_arg=0x2b84960) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/sql_connect.cc:982 #22 0x00000000007bb4b3 in handle_one_connection (arg=0x2b84960) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/sql/sql_connect.cc:898 #23 0x0000000000b932f4 in pfs_spawn_thread (arg=0x2bda420) at /export/home/pb2/build/sb_0-15116597-1429882237.93/mysqlcom-pro-5.6.25/storage/perfschema/pfs.cc:1860 #24 0x00007fbd2696ddf3 in start_thread () from /lib64/libpthread.so.0 #25 0x00007fbd2563947d in clone () from /lib64/libc.so.6 (gdb)