Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-695

LP #1202252: Assertion range_end >= range_start fails in log0online.c on select from I_S.INNODB_CHANGED_PAGES

Details

    Description

      **Reported in Launchpad by Elena Stepanova last update 16-07-2014 09:10:08

      https://mariadb.atlassian.net/browse/MDEV-4791

      SELECT * FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES WHERE start_lsn < 10 AND end_lsn > 20 ;

      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/sysdeps/unix/sysv/linux/raise.c:64
      #5 0x00007f445a6c2b8b in __GI_abort () at abort.c:91
      #6 0x0000000000addbb1 in log_online_setup_bitmap_file_range (bitmap_files=0x7f444f37beb8, range_start=20, range_end=10) at Percona-Server/storage/innobase/log/log0online.c:1284
      #7 0x0000000000ade58c in log_online_bitmap_iterator_init (i=0x7f444f37beb0, min_lsn=20, max_lsn=10) at Percona-Server/storage/innobase/log/log0online.c:1566
      #8 0x000000000098f229 in i_s_innodb_changed_pages_fill (thd=0x28646d0, tables=0x7f4444004e68, cond=0x7f444403e9b0) at Percona-Server/storage/innobase/handler/i_s.cc:7494
      #9 0x00000000006681a2 in do_fill_table (thd=0x28646d0, table_list=0x7f4444004e68, join_table=0x7f444403e4e0) at Percona-Server/sql/sql_show.cc:7462
      #10 0x00000000006685c0 in get_schema_tables_result (join=0x7f444403ca70, executed_place=PROCESSED_BY_JOIN_EXEC) at Percona-Server/sql/sql_show.cc:7568
      #11 0x00000000006205d8 in JOIN::exec (this=0x7f444403ca70) at Percona-Server/sql/sql_select.cc:1960
      #12 0x0000000000622a91 in mysql_select (thd=0x28646d0, rref_pointer_array=0x2866b98, tables=0x7f4444004e68, wild_num=1, fields=..., conds=0x7f4444005988, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f4444006038, unit=0x2866390, select_lex=0x28669b0) at Percona-Server/sql/sql_select.cc:2645
      #13 0x000000000061abca in handle_select (thd=0x28646d0, lex=0x28662d0, result=0x7f4444006038, setup_tables_done_option=0) at Percona-Server/sql/sql_select.cc:313
      #14 0x00000000005f61ff in execute_sqlcom_select (thd=0x28646d0, all_tables=0x7f4444004e68) at Percona-Server/sql/sql_parse.cc:4819
      #15 0x00000000005eec86 in mysql_execute_command (thd=0x28646d0) at Percona-Server/sql/sql_parse.cc:2322
      #16 0x00000000005f8452 in mysql_parse (thd=0x28646d0, rawbuf=0x7f4444004bd0 "SELECT * FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES WHERE start_lsn < 10 AND end_lsn > 20", length=91, parser_state=0x7f444f37dff0) at Percona-Server/sql/sql_parse.cc:5889
      #17 0x00000000005ebfab in dispatch_command (command=COM_QUERY, thd=0x28646d0, packet=0x28f0c81 "SELECT * FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES WHERE start_lsn < 10 AND end_lsn > 20 ", packet_length=92) at Percona-Server/sql/sql_parse.cc:1079
      #18 0x00000000005eb1eb in do_command (thd=0x28646d0) at Percona-Server/sql/sql_parse.cc:789
      #19 0x00000000006d4713 in do_handle_one_connection (thd_arg=0x28646d0) at Percona-Server/sql/sql_connect.cc:1487
      #20 0x00000000006d413f in handle_one_connection (arg=0x28646d0) at Percona-Server/sql/sql_connect.cc:1402
      #21 0x00000000008e917c in pfs_spawn_thread (arg=0x28d3b20) at Percona-Server/storage/perfschema/pfs.cc:1015
      #22 0x00007f445b488e9a in start_thread (arg=0x7f444f37f700) at pthread_create.c:308
      #23 0x00007f445a77ccbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
      #24 0x0000000000000000 in ?? ()

      bzr version-info
      revision-id: [email protected]
      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist