Bug #115031 Error deleting partition from partition table
Submitted: 16 May 7:47 Modified: 16 May 10:00
Reporter: xu chunming Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Partitions Severity:S2 (Serious)
Version:5.7.25 OS:Linux
Assigned to: CPU Architecture:x86

[16 May 7:47] xu chunming
Description:
MySQL version´╝Ü5.7.25

Delete a partition in the partition table on the host: alter table test1 drop partition p2024051218. The client received an error: Error 1031 (HY000): Table storage engine for 'done' not have this option. Check the MySQL server error log: [ERROR] Failed to execute action for entry=1048571 from ddl log. Additionally, this SQL statement was recorded in the binlog, causing the replica to execute the SQL statement.

How to repeat:
The reason is unknown and cannot be reproduced.
[16 May 7:49] xu chunming
Sorry, the client received an error: Error 1031 (HY000): Table storage engine for '' doesn't have this option
[16 May 10:00] MySQL Verification Team
Hi Mr. chunming,

Thank you for your bug report.

However, let us inform you that MySQL 5.7 is deprecated for quite some time.

Hence, if you encounter a similar problem with 8.0 release, preferably latest (now it is 8.0.37), please create a new bug report.

Unsupported.