Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.39, 10.0.13, 10.1.0
Description
Note:
It is a variation of the query from MDEV-4791.
The bug MDEV-4791 had two fixes:
- one fix went to 5.5.38 and 10.0.11, it fixes the query described in
MDEV-4791, but not this one; - another fix is supposed to be merged from Percona, it is not yet in MariaDB 5.5 and 10.0 tree; but the chances are, it fixes this query too, because it does not crash on the current Percona server 5.6.
So, we need to wait for the next XtraDB merge to see if it fixes the problem in our 5.5 and 10.0 tree.
# If using MTR, run with --mysqld=--innodb --mysqld=--innodb_changed_pages |
 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES WHERE NOT (start_lsn < 20 OR end_lsn > 10); |
Version: '5.5.40-MariaDB-debug-log' socket: '/data/repo/bzr/5.5/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
140821 17:44:36 InnoDB: Assertion failure in thread 140285801789184 in file log0online.c line 1310
|
InnoDB: Failing assertion: range_end >= range_start
|
#5 0x00007f96d3cff7c0 in *__GI_abort () at abort.c:92
|
#6 0x0000000000ae81d6 in log_online_setup_bitmap_file_range (bitmap_files=0x7f96d561d288, range_start=20, range_end=11) at 5.5/storage/xtradb/log/log0online.c:1310
|
#7 0x0000000000ae8b59 in log_online_bitmap_iterator_init (i=0x7f96d561d280, min_lsn=20, max_lsn=11) at 5.5/storage/xtradb/log/log0online.c:1593
|
#8 0x000000000098dfc8 in i_s_innodb_changed_pages_fill (thd=0x7f96cefc6060, tables=0x7f96c4191330, cond=0x7f96c41c9780) at 5.5/storage/xtradb/handler/i_s.cc:7388
|
#9 0x00000000006bbc31 in get_schema_tables_result (join=0x7f96c4192a28, executed_place=PROCESSED_BY_JOIN_EXEC) at 5.5/sql/sql_show.cc:7767
|
#10 0x000000000066610c in JOIN::exec (this=0x7f96c4192a28) at 5.5/sql/sql_select.cc:2360
|
#11 0x0000000000668941 in mysql_select (thd=0x7f96cefc6060, rref_pointer_array=0x7f96cefc9cc8, tables=0x7f96c4191330, wild_num=1, fields=..., conds=0x7f96c4192318, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f96c4192a08, unit=0x7f96cefc9380, select_lex=0x7f96cefc9a58) at 5.5/sql/sql_select.cc:3094
|
#12 0x000000000065f411 in handle_select (thd=0x7f96cefc6060, lex=0x7f96cefc92d0, result=0x7f96c4192a08, setup_tables_done_option=0) at 5.5/sql/sql_select.cc:319
|
#13 0x00000000006389c3 in execute_sqlcom_select (thd=0x7f96cefc6060, all_tables=0x7f96c4191330) at 5.5/sql/sql_parse.cc:4688
|
#14 0x0000000000631ba5 in mysql_execute_command (thd=0x7f96cefc6060) at 5.5/sql/sql_parse.cc:2233
|
#15 0x000000000063b0d2 in mysql_parse (thd=0x7f96cefc6060, rawbuf=0x7f96c4191078 "SELECT * FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES WHERE NOT (start_lsn < 20 OR end_lsn > 10)", length=96, parser_state=0x7f96d561e630) at 5.5/sql/sql_parse.cc:5799
|
#16 0x000000000062f11d in dispatch_command (command=COM_QUERY, thd=0x7f96cefc6060, packet=0x7f96ceee9061 "SELECT * FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES WHERE NOT (start_lsn < 20 OR end_lsn > 10)", packet_length=96) at 5.5/sql/sql_parse.cc:1079
|
#17 0x000000000062e2a9 in do_command (thd=0x7f96cefc6060) at 5.5/sql/sql_parse.cc:793
|
#18 0x00000000007300aa in do_handle_one_connection (thd_arg=0x7f96cefc6060) at 5.5/sql/sql_connect.cc:1266
|
#19 0x000000000072fb69 in handle_one_connection (arg=0x7f96cefc6060) at 5.5/sql/sql_connect.cc:1181
|
#20 0x0000000000b64819 in pfs_spawn_thread (arg=0x7f96cedb3340) at 5.5/storage/perfschema/pfs.cc:1015
|
#21 0x00007f96d5256b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#22 0x00007f96d3da620d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
Stack trace from:
revision-id: knielsen@knielsen-hq.org-20140813134639-wk760plnzg5wu4x8
|
revno: 4270
|
branch-nick: 5.5
|
