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

Assertion Failure buf0buf.cc:4318:page_size.equals_to(space_page_size)

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 8.0.25-15 (Q2 2021), 8.0.27-18 (Q4 2021), 8.0.26-17 (Q3 2021 feature release), 8.0.28-19 (Q1 2022)
    • 8.0.29-21 (Q2 2022)
    • None
    • None

    Description

      MySQL server crashes with the attached MTR testcase. The crash is reproducible on both Percona Server and MySQL(upstream). The crash is successfully reproducible in 8.0.28, 8.0.27, 8.0.26, 8.0.25 (did not check before that).

      Currently, the bug impacts only debug builds.

       

      Stacktrace:

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x0000563c24573462 in my_write_core (sig=6) at /home/mohit.joshi/mysql-8.0/mysys/stacktrace.cc:396
      #2  0x0000563c23301dd5 in handle_fatal_signal (sig=6) at /home/mohit.joshi/mysql-8.0/sql/signal_handler.cc:225
      #3  <signal handler called>
      #4  __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x00007f076187a859 in __GI_abort () at abort.c:79
      #6  0x0000563c23301f5e in my_server_abort () at /home/mohit.joshi/mysql-8.0/sql/signal_handler.cc:284
      #7  0x0000563c24569067 in my_abort () at /home/mohit.joshi/mysql-8.0/mysys/my_init.cc:264
      #8  0x0000563c24a4eabe in ut_dbg_assertion_failed (expr=0x563c269f2528 "page_size.equals_to(space_page_size)",
          file=0x563c269f06b0 "/home/mohit.joshi/mysql-8.0/storage/innobase/buf/buf0buf.cc", line=4318) at /home/mohit.joshi/mysql-8.0/storage/innobase/ut/ut0dbg.cc:99
      #9  0x0000563c24aff998 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=2, guess=0x0, mode=Page_fetch::PEEK_IF_IN_POOL,
          file=0x563c269e8ee0 "/home/mohit.joshi/mysql-8.0/storage/innobase/btr/btr0sea.cc", line=1271, mtr=0x7f073c260890, dirty_with_no_latch=false)
          at /home/mohit.joshi/mysql-8.0/storage/innobase/buf/buf0buf.cc:4318
      #10 0x0000563c24ae5b60 in btr_search_drop_page_hash_when_freed (page_id=..., page_size=...) at /home/mohit.joshi/mysql-8.0/storage/innobase/btr/btr0sea.cc:1270
      #11 0x0000563c24ae5f31 in btr_drop_next_batch (page_size=..., first=0x7f073c260ea0, last=0x7f073c260ea8) at /home/mohit.joshi/mysql-8.0/storage/innobase/btr/btr0sea.cc:1337
      #12 0x0000563c24ae61d6 in btr_drop_ahi_for_table (table=0x7f06a821e648) at /home/mohit.joshi/mysql-8.0/storage/innobase/btr/btr0sea.cc:1374
      #13 0x0000563c24905f5a in row_drop_table_from_cache (table=0x7f06a821e648, trx=0x7f075403d098) at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0mysql.cc:4158
      #14 0x0000563c249072e9 in row_drop_table_for_mysql (name=0x7f073c261910 "test/tt_4", trx=0x7f075403d098, nonatomic=true, handler=0x0)
          at /home/mohit.joshi/mysql-8.0/storage/innobase/row/row0mysql.cc:4556
      #15 0x0000563c247018b8 in innobase_basic_ddl::delete_impl<dd::Table> (thd=0x7f06a800abb0, name=0x7f073c263060 "./test/tt_4", dd_tab=0x7f06a8def7b8, td=0x0)
          at /home/mohit.joshi/mysql-8.0/storage/innobase/handler/ha_innodb.cc:15258
      #16 0x0000563c246d7960 in ha_innobase::delete_table (this=0x7f06a8e26730, name=0x7f073c263060 "./test/tt_4", table_def=0x7f06a8def7b8)
          at /home/mohit.joshi/mysql-8.0/storage/innobase/handler/ha_innodb.cc:16296
      #17 0x0000563c22c23e33 in handler::ha_delete_table (this=0x7f06a8e26730, name=0x7f073c263060 "./test/tt_4", table_def=0x7f06a8def7b8) at /home/mohit.joshi/mysql-8.0/sql/handler.cc:5262
      #18 0x0000563c22c1a68e in ha_delete_table (thd=0x7f06a800abb0, table_type=0x563c2adefcc0, path=0x7f073c263060 "./test/tt_4", db=0x7f06a8e231c8 "test", alias=0x7f06a8e22a38 "tt_4",
          table_def=0x7f06a8def7b8, generate_warning=true) at /home/mohit.joshi/mysql-8.0/sql/handler.cc:2706
      #19 0x0000563c2319c76d in drop_base_table (thd=0x7f06a800abb0, drop_ctx=..., table=0x7f06a8e22b40, atomic=true, post_ddl_htons=0x7f073c2645d0, fk_invalidator=0x7f073c264600,
          safe_to_release_mdl=0x7f073c263420, foreach_table_root=0x7f073c2634b0) at /home/mohit.joshi/mysql-8.0/sql/sql_table.cc:2951
      #20 0x0000563c2319da52 in mysql_rm_table_no_locks (thd=0x7f06a800abb0, tables=0x7f06a8e22b40, if_exists=false, drop_temporary=false, drop_database=false,
          dropped_non_atomic_flag=0x7f073c264551, post_ddl_htons=0x7f073c2645d0, fk_invalidator=0x7f073c264600, safe_to_release_mdl=0x7f073c264580)
          at /home/mohit.joshi/mysql-8.0/sql/sql_table.cc:3330
      #21 0x0000563c231994e2 in mysql_rm_table (thd=0x7f06a800abb0, tables=0x7f06a8e22b40, if_exists=false, drop_temporary=false) at /home/mohit.joshi/mysql-8.0/sql/sql_table.cc:1668
      #22 0x0000563c230cd683 in mysql_execute_command (thd=0x7f06a800abb0, first_level=true) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:3778
      #23 0x0000563c230d30e7 in dispatch_sql_command (thd=0x7f06a800abb0, parser_state=0x7f073c265aa0, update_userstat=false) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:5466
      #24 0x0000563c230c82ef in dispatch_command (thd=0x7f06a800abb0, com_data=0x7f073c266b70, command=COM_QUERY) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:2031
      #25 0x0000563c230c635b in do_command (thd=0x7f06a800abb0) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1414
      #26 0x0000563c232ea3a8 in handle_connection (arg=0x563c2af13cb0) at /home/mohit.joshi/mysql-8.0/sql/conn_handler/connection_handler_per_thread.cc:308
      #27 0x0000563c24e38385 in pfs_spawn_thread (arg=0x563c2b07a0f0) at /home/mohit.joshi/mysql-8.0/storage/perfschema/pfs.cc:2948
      #28 0x00007f0761a52609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #29 0x00007f0761977163 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      Attachments

        Issue Links

          Activity

            People

              rahul.malik Rahul Malik
              mohit.joshi Mohit Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 day, 5 hours, 30 minutes
                  1d 5h 30m

                  Smart Checklist