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 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 ?


Options: ReplyQuote

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

Sorry, you can't reply to this topic. It has been closed.

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.