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

Crash during ALTER TABLE DROP PARTITION

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1.14
    • 10.1.18

    Description

      I have two hosts running MariaDB with Galera Cluster.

      This DB is used by the Monitoring Application Zabbix.

      The database is very big, more than 200GB of data.

      I have a script to make partitioning in some tables of the database.

      Sometimes, during the partitioning process, MariaDB crashes, with the messages in attachment.

      The partitioning script and my.cnf are also in attachment.

      Any help?

      Thanks

      Attachments

        Issue Links

          Activity

            From the error log:

            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x38d) [0x7f9302c7ff0d]
            Oct 26 10:30:05 npaa2629 mysqld: /lib64/libpthread.so.0(+0xf100) [0x7f930229e100]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(ha_abort_transaction(THD*, THD*, char)+0x9f) [0x7f9302c8a8bf]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(wsrep_abort_thd(void*, void*, char)+0x139) [0x7f9302c315f9]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(wsrep_grant_mdl_exception(MDL_context*, MDL_ticket*, MDL_key const*)+0x2a7) [0x7f9302c22687]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_lock::can_grant_lock(enum_mdl_type, MDL_context*, bool) const+0x11f) [0x7f9302bd649f]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::try_acquire_lock_impl(MDL_request*, MDL_ticket**)+0xf1) [0x7f9302bd7121]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::acquire_lock(MDL_request*, double)+0x2e) [0x7f9302bd768e]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::upgrade_shared_lock(MDL_ticket*, enum_mdl_type, double)+0xae) [0x7f9302bd837e]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_alter_table(THD*, char*, char*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool)+0x12fd) [0x7f9302b8a22d]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x61a) [0x7f9302bd135a]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x1206) [0x7f9302afeb16]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x28e) [0x7f9302b0717e]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(+0x438989) [0x7f9302b07989]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1fb0) [0x7f9302b0a010]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(do_command(THD*)+0x169) [0x7f9302b0aeb9]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(do_handle_one_connection(THD*)+0x18a) [0x7f9302bce62a]
            Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40) [0x7f9302bce800]
            Oct 26 10:30:05 npaa2629 mysqld: /lib64/libpthread.so.0(+0x7dc5) [0x7f9302296dc5]
            Oct 26 10:30:05 npaa2629 mysqld: /lib64/libc.so.6(clone+0x6d) [0x7f93006b8ced]
            Oct 26 10:30:05 npaa2629 mysqld: Trying to get some variables.
            Oct 26 10:30:05 npaa2629 mysqld: Some pointers may be invalid and cause the dump to abort.
            Oct 26 10:30:05 npaa2629 mysqld: Query (0x7f8f41bf8020): ALTER TABLE zabbix.history DROP PARTITION p2016_10_17
            Oct 26 10:30:05 npaa2629 mysqld: Connection ID (thread ID): 501884
            Oct 26 10:30:05 npaa2629 mysqld: Status: NOT_KILLED
            

            elenst Elena Stepanova added a comment - From the error log: Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x38d) [0x7f9302c7ff0d] Oct 26 10:30:05 npaa2629 mysqld: /lib64/libpthread.so.0(+0xf100) [0x7f930229e100] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(ha_abort_transaction(THD*, THD*, char)+0x9f) [0x7f9302c8a8bf] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(wsrep_abort_thd(void*, void*, char)+0x139) [0x7f9302c315f9] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(wsrep_grant_mdl_exception(MDL_context*, MDL_ticket*, MDL_key const*)+0x2a7) [0x7f9302c22687] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_lock::can_grant_lock(enum_mdl_type, MDL_context*, bool) const+0x11f) [0x7f9302bd649f] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::try_acquire_lock_impl(MDL_request*, MDL_ticket**)+0xf1) [0x7f9302bd7121] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::acquire_lock(MDL_request*, double)+0x2e) [0x7f9302bd768e] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::upgrade_shared_lock(MDL_ticket*, enum_mdl_type, double)+0xae) [0x7f9302bd837e] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_alter_table(THD*, char*, char*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool)+0x12fd) [0x7f9302b8a22d] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x61a) [0x7f9302bd135a] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x1206) [0x7f9302afeb16] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x28e) [0x7f9302b0717e] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(+0x438989) [0x7f9302b07989] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1fb0) [0x7f9302b0a010] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(do_command(THD*)+0x169) [0x7f9302b0aeb9] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(do_handle_one_connection(THD*)+0x18a) [0x7f9302bce62a] Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40) [0x7f9302bce800] Oct 26 10:30:05 npaa2629 mysqld: /lib64/libpthread.so.0(+0x7dc5) [0x7f9302296dc5] Oct 26 10:30:05 npaa2629 mysqld: /lib64/libc.so.6(clone+0x6d) [0x7f93006b8ced] Oct 26 10:30:05 npaa2629 mysqld: Trying to get some variables. Oct 26 10:30:05 npaa2629 mysqld: Some pointers may be invalid and cause the dump to abort. Oct 26 10:30:05 npaa2629 mysqld: Query (0x7f8f41bf8020): ALTER TABLE zabbix.history DROP PARTITION p2016_10_17 Oct 26 10:30:05 npaa2629 mysqld: Connection ID (thread ID): 501884 Oct 26 10:30:05 npaa2629 mysqld: Status: NOT_KILLED

            I found a problem on my servers that can be related with this issue.

            I have 16 GB of RAM memory on each server, but the swap memory was with only 2 GB.

            I´ve increased de swap to 16 GB too and since then no crash was observed.

            I still will wait for some days berfore close this problem.

            Thanks.

            rodneyra Rodney Antonio Ramos added a comment - I found a problem on my servers that can be related with this issue. I have 16 GB of RAM memory on each server, but the swap memory was with only 2 GB. I´ve increased de swap to 16 GB too and since then no crash was observed. I still will wait for some days berfore close this problem. Thanks.

            rodneyra This issue looks pretty similar to one fixed in 10.1.18. (MDEV-9416)

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - rodneyra This issue looks pretty similar to one fixed in 10.1.18. ( MDEV-9416 )

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              rodneyra Rodney Antonio Ramos
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.