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

Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE' failed in pagecache_read on ADD PARTITION

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.5.25, 5.3.7, 5.2.12, 5.1.62
    • Fix Version/s: 5.5.27, 5.3.8
    • Component/s: None
    • Labels:

      Description

      Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE' failed

      #6  0x00007f51dc202d4d in __GI___assert_fail (assertion=0xdfd000 "block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE", file=<optimized out>, line=3417, function=<optimized out>) at assert.c:81
      #7  0x000000000097e8cb in pagecache_read (pagecache=0x1d249e0, file=0x2493af8, pageno=1, level=0, buff=0x24d6170 "\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245"..., type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, page_link=0x7f51d18e42d8) at storage/maria/ma_pagecache.c:3413
      #8  0x00000000009beed1 in _ma_scan_block_record (info=0x24936f0, record=0x24911d0 "\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\360\021I\002", record_pos=0, skip_deleted=1 '\001') at storage/maria/ma_blockrec.c:5413
      #9  0x00000000009ababd in maria_scan (info=0x24936f0, record=0x24911d0 "\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\360\021I\002") at storage/maria/ma_scan.c:54
      #10 0x0000000000955e1e in ha_maria::rnd_next (this=0x2491608, buf=0x24911d0 "\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\360\021I\002") at storage/maria/ha_maria.cc:2372
      #11 0x00000000005a73b4 in handler::ha_rnd_next (this=0x2491608, buf=0x24911d0 "\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\360\021I\002") at sql/sql_class.h:4263
      #12 0x0000000000c7c05a in ha_partition::copy_partitions (this=0x2490b18, copied=0x7f51d18e4ba8, deleted=0x7f51d18e4bb0) at sql/ha_partition.cc:1768
      #13 0x0000000000c7bec2 in ha_partition::change_partitions (this=0x2490b18, create_info=0x7f51d18e6560, path=0x7f51d18e4950 "./test/t", copied=0x7f51d18e4ba8, deleted=0x7f51d18e4bb0, pack_frm_data=0x0, pack_frm_len=0) at sql/ha_partition.cc:1712
      #14 0x00000000007c693a in handler::ha_change_partitions (this=0x2490b18, create_info=0x7f51d18e6560, path=0x7f51d18e4950 "./test/t", copied=0x7f51d18e4ba8, deleted=0x7f51d18e4bb0, pack_frm_data=0x0, pack_frm_len=0) at sql/handler.cc:3705
      #15 0x000000000091ce4d in mysql_change_partitions (lpt=0x7f51d18e4ba0) at sql/sql_partition.cc:5511
      #16 0x000000000091fc11 in fast_alter_partition_table (thd=0x22ff280, table=0x244ddc0, alter_info=0x7f51d18e6660, create_info=0x7f51d18e6560, table_list=0x2401bc8, db=0x2402190 "test", table_name=0x2401b90 "t", fast_alter_table=0x248de60) at sql/sql_partition.cc:6820
      #17 0x00000000006abcc4 in mysql_alter_table (thd=0x22ff280, new_db=0x2402190 "test", new_name=0x2401b90 "t", create_info=0x7f51d18e6560, table_list=0x2401bc8, alter_info=0x7f51d18e6660, order_num=0, order=0x0, ignore=false, require_online=false) at sql/sql_table.cc:6521
      #18 0x00000000009331b6 in Alter_table_statement::execute (this=0x24023b0, thd=0x22ff280) at sql/sql_alter.cc:106
      #19 0x00000000006135aa in mysql_execute_command (thd=0x22ff280) at sql/sql_parse.cc:4459
      #20 0x000000000061674d in mysql_parse (thd=0x22ff280, rawbuf=0x2401ac8 "ALTER TABLE t ADD PARTITION PARTITIONS 2", length=40, parser_state=0x7f51d18e7500) at sql/sql_parse.cc:5736
      #21 0x0000000000609fc3 in dispatch_command (command=COM_QUERY, thd=0x22ff280, packet=0x23fa2b1 "ALTER TABLE t ADD PARTITION PARTITIONS 2", packet_length=40) at sql/sql_parse.cc:1055
      #22 0x000000000060927a in do_command (thd=0x22ff280) at sql/sql_parse.cc:794
      #23 0x000000000070a69f in do_handle_one_connection (thd_arg=0x22ff280) at sql/sql_connect.cc:1253
      #24 0x000000000070a08a in handle_one_connection (arg=0x22ff280) at sql/sql_connect.cc:1168
      #25 0x0000000000bffcbf in pfs_spawn_thread (arg=0x2482c50) at storage/perfschema/pfs.cc:1015
      #26 0x00007f51dcf44efc in start_thread (arg=0x7f51d18e8700) at pthread_create.c:304
      #27 0x00007f51dc2b759d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      bzr version-info

      revision-id: igor@askmonty.org-20120624161011-v9cilsq09qv4a2li
      date: 2012-06-24 09:10:11 -0700
      build-date: 2012-06-25 02:28:39 +0400
      revno: 3458

      Also reproducible on maria/5.1 revno 3151, maria/5.2 revno 3162, maria/5.3 revno 3550.

      Test case:

      --source include/have_partition.inc
      CREATE TABLE t ( i INT ) ENGINE=Aria
        PARTITION BY HASH(i) PARTITIONS 2;
      INSERT INTO t VALUES (1),(2),(2),(3),(4);
      ALTER TABLE t ADD PARTITION PARTITIONS 2;
       

        Attachments

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: