The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-05-21. For the latest, interactive version please visit https://mariadb.com/kb/.

Does deadlock occur when partition creation and INSRT processing occur at the same time?

Please tell me if a deadlock occurs when the following processing (a) and (b) occur simultaneously. Also, please let me know if there is a workaround. Or is it a bug?

In the past results, the process of (a) ends in an instant, Since the process (b) occurred at the same time, an event that did not complete the process occurred.

(a) Create PARTITION in table History-A with ALTER TABLE.

(b) When updating table A,      Execute Insert processing (records before and after update) on table History-A by trigger processing.

OS :CentOS Linux release 7.6.1810 MariaDB:10.3.17-MariaDB-log MariaDB Server

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.