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

crash after alter table drop index is executed on slave

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 5.7.20-19
    • 5.7.24-26, 8.0.13-3
    • MyRocks
    • None

    Description

      It is possible that mysqld could use up to 

      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3982488 K  bytes of memory

      Hope that's ok; if not, decrease some variables in the equation.

       

      Thread pointer: 0x562774bb6000

      Attempting backtrace. You can use the following information to find out

      where mysqld died. If you see no messages after this, something went

      terribly wrong...

      stack_bottom = 7f21e5710e38 thread_stack 0x40000

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(my_print_stacktrace+0x2c)[0x56275df8e7dc]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(handle_fatal_signal+0x479)[0x56275d8b9819]

      /lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f21e51fb0c0]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/lib/plugin/ha_rocksdb.so(_ZN7myrocks20Rdb_transaction_impl8set_syncEb+0x12)[0x7f21ce4e4c92]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/lib/plugin/ha_rocksdb.so(+0x265d54)[0x7f21ce4c5d54]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_Z14ha_prepare_lowP3THDb+0x59)[0x56275d906c79]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_Z15ha_commit_transP3THDbb+0x291)[0x56275d906621]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_ZN19System_table_access11close_tableEP3THDP5TABLEP18Open_tables_backupbb+0x5a)[0x56275df336fa]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_ZN25Gtid_table_access_context6deinitEP3THDP5TABLEbb+0x27)[0x56275def5087]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_ZN20Gtid_table_persistor4saveEP3THDPK4Gtid+0x197)[0x56275def56a7]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_ZN10Gtid_state4saveEP3THD+0x22)[0x56275def2712]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_Z18commit_owned_gtidsP3THDbPb+0x86)[0x56275d905a96]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_Z15ha_commit_transP3THDbb+0x37)[0x56275d9063c7]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_Z17trans_commit_stmtP3THD+0x30)[0x56275de02310]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_Z21mysql_execute_commandP3THDb+0x2b8a)[0x56275dd5c04a]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x3dd)[0x56275dd6046d]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_ZN15Query_log_event14do_apply_eventEPK14Relay_log_infoPKcm+0x7ec)[0x56275df0184c]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(_Z27slave_worker_exec_job_groupP12Slave_workerP14Relay_log_info+0x23a)[0x56275df60e3a]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(handle_slave_worker+0x35b)[0x56275df42b8b]

      /home/db_test/mysql-5.7.20-v4-rc-linux-x86_64/bin/mysqld(pfs_spawn_thread+0x1b1)[0x56275e307241]

      /lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f21e51f1494]

      /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f21e3c48acf]

       

      Trying to get some variables.

      Some pointers may be invalid and cause the dump to abort.

      Query (562d7bdc7def): alter table user_top_song_pika drop index idx_utime

      Connection ID (thread ID): 20

      Status: NOT_KILLED

       

      The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

      information that should help you find out what is causing the crash.

      2018-08-16T03:01:51.442072Z mysqld_safe Number of processes running now: 0

      Attachments

        1. master.cnf
          0.9 kB
        2. slave.cnf
          0.9 kB

        Activity

          People

            george.lorch George Lorch (Inactive)
            tomwang tom wang
            Votes:
            0 Vote for this issue
            Watchers:
            4 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 - 5 hours
                5h

                Smart Checklist