MySQL Forums
Forum List  »  InnoDB clusters

Re: Deadlock BLOB INSERT MySQL 8.0x InnoDB Cluster
Posted by: Frederic Descamps
Date: October 28, 2019 04:12PM

Hi Volker,

Thank you for using MySQL InnoDB Cluster.

I just tied with exact the same files as you and I didn't experienced any issue:

MySQL 127.0.0.1:33060+ ssl sbtest SQL > INSERT INTO `onlineorder_attachments` (`AttachmentGUID`,`Filename`,`File`) VALUES ('00a2b54f-b0cf-4f3a-9bed-02dba853b506', 'M-02-012.jpg', LOAD_FILE('/var/lib/mysql-files/M-02-012.jpg'));
Query OK, 1 row affected (8.9896 sec)


I've the same values as the one you published.

Just for the test could you replace the PK with an auto_increment ?

Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Deadlock BLOB INSERT MySQL 8.0x InnoDB Cluster
537
October 28, 2019 04:12PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.