The Ultimate Guide to High Availability with MariaDB

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

Comments

Comments loading...
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.