Assertion range_end >= range_start fails in log0online.c on select from I_S.INNODB_CHANGED_PAGES
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Laurynas Biveinis | ||
5.5 |
Fix Released
|
High
|
Laurynas Biveinis | ||
5.6 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
https:/
SELECT * FROM INFORMATION_
Version: '5.5.32-debug-log'
130717 18:19:09 InnoDB: Assertion failure in thread 139931363571456 in file log0online.c line 1284
InnoDB: Failing assertion: range_end >= range_start
#4 0x00007f445a6bf425 in __GI_raise (sig=<optimized out>) at ../nptl/
#5 0x00007f445a6c2b8b in __GI_abort () at abort.c:91
#6 0x0000000000addbb1 in log_online_
#7 0x0000000000ade58c in log_online_
#8 0x000000000098f229 in i_s_innodb_
#9 0x00000000006681a2 in do_fill_table (thd=0x28646d0, table_list=
#10 0x00000000006685c0 in get_schema_
#11 0x00000000006205d8 in JOIN::exec (this=0x7f44440
#12 0x0000000000622a91 in mysql_select (thd=0x28646d0, rref_pointer_
#13 0x000000000061abca in handle_select (thd=0x28646d0, lex=0x28662d0, result=
#14 0x00000000005f61ff in execute_
#15 0x00000000005eec86 in mysql_execute_
#16 0x00000000005f8452 in mysql_parse (thd=0x28646d0, rawbuf=
#17 0x00000000005ebfab in dispatch_command (command=COM_QUERY, thd=0x28646d0, packet=0x28f0c81 "SELECT * FROM INFORMATION_
#18 0x00000000005eb1eb in do_command (thd=0x28646d0) at Percona-
#19 0x00000000006d4713 in do_handle_
#20 0x00000000006d413f in handle_
#21 0x00000000008e917c in pfs_spawn_thread (arg=0x28d3b20) at Percona-
#22 0x00007f445b488e9a in start_thread (arg=0x7f444f37
#23 0x00007f445a77ccbd in clone () at ../sysdeps/
#24 0x0000000000000000 in ?? ()
bzr version-info
revision-id: <email address hidden>
date: 2013-07-12 09:17:29 +0000
build-date: 2013-07-17 19:20:13 +0400
revno: 555
branch-nick: percona-server-5.5
Related branches
- Sergei Glushchenko (community): Approve (g2)
- Sergei Glushchenko (community): Approve (g2)
-
Diff: 216 lines (+142/-1)3 files modifiedmysql-test/suite/innodb/r/percona_changed_pages.result (+66/-0)
mysql-test/suite/innodb/t/percona_changed_pages.test (+65/-1)
storage/innobase/log/log0online.cc (+11/-0)
Thank you for the bug report. Same with 5.6.12:
openxs@ debian7: ~/bzr/percona- 5.5/Percona- Server- 5.5.32- rel31.0$ mysql -uroot -proot test
Warning: Using a password on the command line interface can be insecure.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g. rc60.4- debug-log MySQL Community Server (GPL)
Your MySQL connection id is 40
Server version: 5.6.12-
Copyright (c) 2009-2013 Percona Ireland Ltd.
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT * FROM INFORMATION_ SCHEMA. INNODB_ CHANGED_ PAGES WHERE start_lsn < 10 AND end_lsn > 20 ;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> exit
... mysqld- debug: ready for connections. rc60.4- debug-log' socket: '/var/run/ mysqld/ mysqld. sock' port: 3306 MySQL Community Server (GPL)
2013-07-17 18:51:31 4800 [Note] /usr/sbin/
Version: '5.6.12-
2013-07-17 18:52:04 8faffb70 InnoDB: Assertion failure in thread 2410675056 in file log0online.cc line 1280
InnoDB: Failing assertion: range_end >= range_start
InnoDB: We intentionally generate a memory trap.