Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1038225
  2. Activity log

Activity log for bug #1038225

Date Who What changed Old value New value Message
2012-08-17 19:27:23 Elena Stepanova bug added bug
2012-08-20 08:54:10 Laurynas Biveinis nominated for series percona-server/5.5
2012-08-20 08:54:10 Laurynas Biveinis bug task added percona-server/5.5
2012-08-20 09:19:10 Laurynas Biveinis percona-server/5.5: status New In Progress
2012-08-20 09:19:14 Laurynas Biveinis percona-server/5.5: importance Undecided Critical
2012-08-20 09:19:17 Laurynas Biveinis percona-server/5.5: assignee Laurynas Biveinis (laurynas-biveinis)
2012-08-20 09:19:24 Laurynas Biveinis percona-server/5.5: milestone 5.5.28-29.0
2012-08-20 09:52:43 Elena Stepanova description Percona XtraDB (http://www.percona.com) 1.1.8-27.0 Version: '5.5.27-debug-log' InnoDB: Assertion failure in thread 140216578594560 in file buf0lru.c line 390 InnoDB: Failing assertion: mutex_own(&buf_pool->mutex) Query (398ffd0): ALTER TABLE t1 ADD PRIMARY KEY (l_orderkey, l_linenumber) Connection ID (thread ID): 1 Status: NOT_KILLED #5 0x00007f86c8d8fb0b in __GI_abort () at abort.c:92 #6 0x00000000009a5e24 in buf_flush_yield (buf_pool=0x35c4fb8, bpage=0x7f86be41eca0) at storage/innobase/buf/buf0lru.c:390 #7 0x00000000009a5f80 in buf_flush_try_yield (buf_pool=0x35c4fb8, bpage=0x7f86be41eca0, processed=1024) at storage/innobase/buf/buf0lru.c:445 #8 0x00000000009a6272 in buf_flush_or_remove_pages (buf_pool=0x35c4fb8, id=10) at storage/innobase/buf/buf0lru.c:569 #9 0x00000000009a62e9 in buf_flush_dirty_pages (buf_pool=0x35c4fb8, id=10) at storage/innobase/buf/buf0lru.c:600 #10 0x00000000009a676a in buf_LRU_flush_or_remove_pages (id=10, buf_remove=BUF_REMOVE_FLUSH_NO_WRITE) at storage/innobase/buf/buf0lru.c:798 #11 0x00000000009e3db0 in fil_delete_tablespace (id=10, evict_all=0) at storage/innobase/fil/fil0fil.c:2385 #12 0x0000000000901f72 in row_drop_table_for_mysql (name=0x39a35d8 "test/t1@00232", trx=0x39a3b88, drop_db=0) at storage/innobase/row/row0mysql.c:3564 #13 0x00000000008f6d85 in row_merge_drop_table (trx=0x39a3b88, table=0x39a1198) at storage/innobase/row/row0merge.c:2672 #14 0x00000000008e2070 in ha_innobase::final_add_index (this=0x3996bb0, add_arg=0x399c0b8, commit=true) at storage/innobase/handler/handler0alter.cc:1026 #15 0x0000000000675e0c in mysql_alter_table (thd=0x38fb310, new_db=0x3990620 "test", new_name=0x39900c0 "t1", create_info=0x7f86b75ba290, table_list=0x39900f8, alter_info=0x7f86b75ba370, order_num=0, order=0x0, ignore=false) at sql/sql_table.cc:6914 #16 0x0000000000894130 in Alter_table_statement::execute (this=0x3990718, thd=0x38fb310) at sql/sql_alter.cc:106 #17 0x00000000005ee1ee in mysql_execute_command (thd=0x38fb310) at sql/sql_parse.cc:4582 #18 0x00000000005f0d3d in mysql_parse (thd=0x38fb310, rawbuf=0x398ffd0 "ALTER TABLE t1 ADD PRIMARY KEY (l_orderkey, l_linenumber)", length=57, parser_state=0x7f86b75bbff0) at sql/sql_parse.cc:5811 #19 0x00000000005e4c01 in dispatch_command (command=COM_QUERY, thd=0x38fb310, packet=0x3987e71 "ALTER TABLE t1 ADD PRIMARY KEY (l_orderkey, l_linenumber)", packet_length=57) at sql/sql_parse.cc:1061 #20 0x00000000005e3edd in do_command (thd=0x38fb310) at sql/sql_parse.cc:788 #21 0x00000000006cb0b8 in do_handle_one_connection (thd_arg=0x38fb310) at sql/sql_connect.cc:1484 #22 0x00000000006caa9e in handle_one_connection (arg=0x38fb310) at sql/sql_connect.cc:1391 #23 0x0000000000aaa0af in pfs_spawn_thread (arg=0x3966020) at storage/perfschema/pfs.cc:1015 #24 0x00007f86c9ac6efc in start_thread (arg=0x7f86b75bd700) at pthread_create.c:304 #25 0x00007f86c8e3959d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112 bzr version-info revision-id: stewart@flamingspork.com-20120815004621-eidt0h6f3yjh0jcc date: 2012-08-15 10:46:21 +1000 build-date: 2012-08-17 23:08:42 +0400 revno: 290 build options: -DCMAKE_BUILD_TYPE=Debug # Test case: # Run as # perl mysql-test-run.pl --mysqld=--innodb_log_buffer_size=64M \ # --mysqld=--innodb_log_file_size=64M --mysqld=--innodb_buffer_pool_size=128M <test name> SET GLOBAL innodb_file_per_table=ON; SET GLOBAL slow_query_log=OFF; USE test; DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( `l_orderkey` int(11) NOT NULL DEFAULT '0', `l_partkey` int(11) DEFAULT NULL, `l_suppkey` int(11) DEFAULT NULL, `l_linenumber` int(11) NOT NULL DEFAULT '0', `l_quantity` double DEFAULT NULL, `l_extendedprice` double DEFAULT NULL, `l_discount` double DEFAULT NULL, `l_tax` double DEFAULT NULL, `l_returnflag` char(1) DEFAULT NULL, `l_linestatus` char(1) DEFAULT NULL, `l_shipDATE` date DEFAULT NULL, `l_commitDATE` date DEFAULT NULL, `l_receiptDATE` date DEFAULT NULL, `l_shipinstruct` char(25) DEFAULT NULL, `l_shipmode` char(10) DEFAULT NULL, `l_comment` varchar(44) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; LOAD DATA LOCAL INFILE 'mdev-444.data' INTO TABLE t1; # Server restart can be replaced by waiting for # Innodb_checkpoint_age to become 0 --enable_reconnect --append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect restart EOF --shutdown_server 60 --source include/wait_until_connected_again.inc ALTER TABLE t1 ADD PRIMARY KEY (l_orderkey, l_linenumber); # Cleanup DROP TABLE t1; # End of the test case Initially encountered on DBT3 S10 data, the description and initial analysis by Timour is also filed as https://mariadb.atlassian.net/browse/MDEV-444. Percona XtraDB (http://www.percona.com) 1.1.8-27.0 Version: '5.5.27-debug-log' InnoDB: Assertion failure in thread 140216578594560 in file buf0lru.c line 390 InnoDB: Failing assertion: mutex_own(&buf_pool->mutex) Query (398ffd0): ALTER TABLE t1 ADD PRIMARY KEY (l_orderkey, l_linenumber) Connection ID (thread ID): 1 Status: NOT_KILLED #5 0x00007f86c8d8fb0b in __GI_abort () at abort.c:92 #6 0x00000000009a5e24 in buf_flush_yield (buf_pool=0x35c4fb8, bpage=0x7f86be41eca0) at storage/innobase/buf/buf0lru.c:390 #7 0x00000000009a5f80 in buf_flush_try_yield (buf_pool=0x35c4fb8, bpage=0x7f86be41eca0, processed=1024) at storage/innobase/buf/buf0lru.c:445 #8 0x00000000009a6272 in buf_flush_or_remove_pages (buf_pool=0x35c4fb8, id=10) at storage/innobase/buf/buf0lru.c:569 #9 0x00000000009a62e9 in buf_flush_dirty_pages (buf_pool=0x35c4fb8, id=10) at storage/innobase/buf/buf0lru.c:600 #10 0x00000000009a676a in buf_LRU_flush_or_remove_pages (id=10, buf_remove=BUF_REMOVE_FLUSH_NO_WRITE) at storage/innobase/buf/buf0lru.c:798 #11 0x00000000009e3db0 in fil_delete_tablespace (id=10, evict_all=0) at storage/innobase/fil/fil0fil.c:2385 #12 0x0000000000901f72 in row_drop_table_for_mysql (name=0x39a35d8 "test/t1@00232", trx=0x39a3b88, drop_db=0) at storage/innobase/row/row0mysql.c:3564 #13 0x00000000008f6d85 in row_merge_drop_table (trx=0x39a3b88, table=0x39a1198) at storage/innobase/row/row0merge.c:2672 #14 0x00000000008e2070 in ha_innobase::final_add_index (this=0x3996bb0, add_arg=0x399c0b8, commit=true) at storage/innobase/handler/handler0alter.cc:1026 #15 0x0000000000675e0c in mysql_alter_table (thd=0x38fb310, new_db=0x3990620 "test", new_name=0x39900c0 "t1", create_info=0x7f86b75ba290, table_list=0x39900f8, alter_info=0x7f86b75ba370, order_num=0, order=0x0, ignore=false) at sql/sql_table.cc:6914 #16 0x0000000000894130 in Alter_table_statement::execute (this=0x3990718, thd=0x38fb310) at sql/sql_alter.cc:106 #17 0x00000000005ee1ee in mysql_execute_command (thd=0x38fb310) at sql/sql_parse.cc:4582 #18 0x00000000005f0d3d in mysql_parse (thd=0x38fb310, rawbuf=0x398ffd0 "ALTER TABLE t1 ADD PRIMARY KEY (l_orderkey, l_linenumber)", length=57, parser_state=0x7f86b75bbff0) at sql/sql_parse.cc:5811 #19 0x00000000005e4c01 in dispatch_command (command=COM_QUERY, thd=0x38fb310, packet=0x3987e71 "ALTER TABLE t1 ADD PRIMARY KEY (l_orderkey, l_linenumber)", packet_length=57) at sql/sql_parse.cc:1061 #20 0x00000000005e3edd in do_command (thd=0x38fb310) at sql/sql_parse.cc:788 #21 0x00000000006cb0b8 in do_handle_one_connection (thd_arg=0x38fb310) at sql/sql_connect.cc:1484 #22 0x00000000006caa9e in handle_one_connection (arg=0x38fb310) at sql/sql_connect.cc:1391 #23 0x0000000000aaa0af in pfs_spawn_thread (arg=0x3966020) at storage/perfschema/pfs.cc:1015 #24 0x00007f86c9ac6efc in start_thread (arg=0x7f86b75bd700) at pthread_create.c:304 #25 0x00007f86c8e3959d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112 bzr version-info revision-id: stewart@flamingspork.com-20120815004621-eidt0h6f3yjh0jcc date: 2012-08-15 10:46:21 +1000 build-date: 2012-08-17 23:08:42 +0400 revno: 290 build options: -DCMAKE_BUILD_TYPE=Debug # Test case: # Run as # perl mysql-test-run.pl --mysqld=--innodb_log_buffer_size=64M \ # --mysqld=--innodb_log_file_size=64M --mysqld=--innodb_buffer_pool_size=128M <test name> SET GLOBAL innodb_file_per_table=ON; SET GLOBAL slow_query_log=OFF; USE test; DROP TABLE IF EXISTS t1; CREATE TABLE t1 (           `l_orderkey` int(11) NOT NULL DEFAULT '0',           `l_partkey` int(11) DEFAULT NULL,           `l_suppkey` int(11) DEFAULT NULL,           `l_linenumber` int(11) NOT NULL DEFAULT '0',           `l_quantity` double DEFAULT NULL,           `l_extendedprice` double DEFAULT NULL,           `l_discount` double DEFAULT NULL,           `l_tax` double DEFAULT NULL,           `l_returnflag` char(1) DEFAULT NULL,           `l_linestatus` char(1) DEFAULT NULL,           `l_shipDATE` date DEFAULT NULL,           `l_commitDATE` date DEFAULT NULL,           `l_receiptDATE` date DEFAULT NULL,           `l_shipinstruct` char(25) DEFAULT NULL,           `l_shipmode` char(10) DEFAULT NULL,           `l_comment` varchar(44) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; LOAD DATA LOCAL INFILE 'mdev-444.data' INTO TABLE t1; # Server restart can be replaced by waiting for # Innodb_checkpoint_age to become 0 --enable_reconnect --append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect restart EOF --shutdown_server 60 --source include/wait_until_connected_again.inc ALTER TABLE t1 ADD PRIMARY KEY (l_orderkey, l_linenumber); # Cleanup DROP TABLE t1; # End of the test case Initially encountered on DBT3 S10 data, the description and initial analysis by Timour is also filed as https://mariadb.atlassian.net/browse/MDEV-444. Upd: sorry, forgot to mention: data file for the LOAD command, in case you need the test case, can be found at https://mariadb.atlassian.net/secure/attachment/12000/mdev-444.data.gz
2012-08-20 10:26:12 Launchpad Janitor branch linked lp:~laurynas-biveinis/percona-server/bug1038225
2012-08-20 10:36:21 Laurynas Biveinis percona-server/5.5: status In Progress Fix Committed
2012-08-23 23:35:32 Stewart Smith percona-server/5.5: milestone 5.5.28-29.0 5.5.27-28.1
2012-08-23 23:40:28 Stewart Smith percona-server/5.5: status Fix Committed Fix Released
2012-08-24 10:35:53 Laurynas Biveinis nominated for series percona-server/5.1
2012-08-24 10:35:53 Laurynas Biveinis bug task added percona-server/5.1
2012-08-24 10:35:58 Laurynas Biveinis percona-server/5.1: status New Invalid
2012-08-25 21:57:43 Joern Heissler bug added subscriber Joern Heissler
2012-09-08 14:22:13 Ryan Brothers bug added subscriber Ryan Brothers
2012-09-17 16:28:26 Alejandra Bedolla Diaz bug task added android-user-issue-20128 (Unity Linux)
2012-09-17 16:37:58 Alejandra Bedolla Diaz android-user-issue-20128 (Unity Linux): assignee Alejandra Bedolla Diaz (diazalejandra2008)
2013-01-24 07:00:18 Laurynas Biveinis android-user-issue-20128 (Unity Linux): assignee Alejandra Bedolla Diaz (diazalejandra2008)
2013-01-24 07:04:09 Roel Van de Paar affects android-user-issue-20128 (Unity Linux) percona-xtradb
2013-01-24 07:04:27 Roel Van de Paar bug task deleted percona-xtradb