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

ALTER TABLE event take infinite time which for example breaks mysql_upgrade

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.5.8, 10.5
    • 10.5.9
    • Events, Locking
    • None

    Description

      Upgrade from mariadb 10.3 to 10.5.8
      mysql_upgrade scripts executes:
      ALTER TABLE event DROP PRIMARY KEY, ADD PRIMARY KEY(db, name)
      this however takes infinite time if there are any events in table event. Its the same if query is executed manualy on mysql database. If events are removed then query is executed ok and mysql_upgrade works fine.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24185 Mariabackup is getting stuck when event_scheduler is running and acquired lock on mysql.event

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24459 FTWL failed when event scheduler ON

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24682 event_scheduler lock problem

          • Major - Major loss of function.
          • Closed

          Activity

            People

              monty Michael Widenius
              naox naox
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.