Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6620

Assertion range_end >= range_start fails in log0online.c on select from I_S.INNODB_CHANGED_PAGES (#2)

    XMLWordPrintable

    Details

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: