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

Queries locking if key_cache_segments !=0 and MyISAM variables are modified at runtime

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2, 5.5.30, 5.2.14, 5.3.12
    • Fix Version/s: 10.0.4, 5.5.32
    • Component/s: None
    • Labels:
      None
    • Environment:
      Debian Squeeze x64

      Description

      On a server running with key_cache_segments != 0, doing an INSERT on a MyISAM table and at the same time a SET GLOBAL key_buffer_size or key_cache_block_size (might probably also happen with other variables) with any value => the INSERT query will never end and won't be killable (will stay in killed state but table lock and process will still be active).

      In order to unlock the table, mysqld must be SIGKILL and the table will be crashed at restart.

      ps: I only have tried with INSERT and SELECT, using a SELECT doesn't triggers the bug.

        Attachments

          Activity

            People

            Assignee:
            wlad Vladislav Vaintroub
            Reporter:
            jb-boin Jean Weisbuch
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: