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

    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: