truncate table on partitioned Aria table fails with ER_ILLEGAL_HA
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Medium
|
Michael Widenius |
Bug 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.
Hi,
If possible, could you please backup the datadir when the server is down, start server with the general log ON (to file) and provide the datadir backup along with the general log + error log up to the moment when the error occurs?
If you can't shutdown the server, please provide the database dump instead (still, along with the general log).
Thank you.