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

altering table returns errno: 168 "Unknown (generic) error from engine"

Details

    Description

      Trying to alter table structure shows this error message ... although table is empty and just created before doing this alter statement.
      ALTER TABLE SUITE_OVERHEIDSLOKET_RELEASE.portal_policy_information MODIFY id INT AUTO_INCREMENT;
      ERROR 1025 (HY000): Error on rename of './SUITE_OVERHEIDSLOKET_RELEASE/portal_policy_information' to './SUITE_OVERHEIDSLOKET_RELEASE/#sql-backup-d1586-2f8c9' (errno: 168 "Unknown (generic) error from engine")

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          marko Marko Mäkelä added a comment -

          Sorry, I only noticed this bug now.

          Can you please provide a self-contained test case, starting with CREATE TABLE and ALTER TABLE? You can obfuscate the table and column names, and possibly omit some columns and indexes, but the SQL statements must be able to reproduce the bug.

          It is also possible that this issue has meanwhile been fixed in MariaDB. Currently the latest release in the 10.6 series is 10.6.16.

          marko Marko Mäkelä added a comment - Sorry, I only noticed this bug now. Can you please provide a self-contained test case, starting with CREATE TABLE and ALTER TABLE ? You can obfuscate the table and column names, and possibly omit some columns and indexes, but the SQL statements must be able to reproduce the bug. It is also possible that this issue has meanwhile been fixed in MariaDB. Currently the latest release in the 10.6 series is 10.6.16.
          Na3omy Neama Ageb added a comment -

          fixed by updating mariadb 10.6.7 to mariadb 10.6.11

          Na3omy Neama Ageb added a comment - fixed by updating mariadb 10.6.7 to mariadb 10.6.11

          People

            marko Marko Mäkelä
            Na3omy Neama Ageb
            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.