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

LP:997460 - truncate table on partitioned Aria table fails with ER_ILLEGAL_HA

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Hi,
      I am running Ver 5.5.23-MariaDB-log for Linux on x86_64 (MariaDB Server).

      My application uses lots of the "truncate table" command on tables located in the aria storage engine.

      Every hour I run a series of "truncate table" commands on the tables and am getting these errors:

      Table storage engine for 'TABLE' doesn't have this option

      This happens about 50% of the time when truncate is executed. When I run the command directly on the db, via the mysql client, I don't see the issue. Additionally I don't see any errors in the mysqld log.

      This did not occur on previous versions of mariadb / aria engine, I was actually having other issues that I didn't log a bug for, but they seem to have subsided in favor of this issue in this release.

      Please let me know what I can give you to better diagnose the error. It is occurring all the time in my env so I shouldn't have a problem giving you any data that you need.

      thanks.

      Attachments

        Activity

          People

            monty Michael Widenius
            scottfeldstein Scott Feldstein (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.