← Back to team overview

maria-discuss team mailing list archive

Re: INSERT IGNORE (and other SQL commands) fail with: Deadlock found when trying to get lock;


Hi Alex

> DELETE bug seems to be present only in MariaDB version of Galera
> cluster, hopefully it will be fixed soon. If it is of any help, you
> could upgrade to the latest upstream release from Codership.
> INSERT bug is confirmed in the upstream and is tracked here:
> https://bugs.launchpad.net/codership-mysql/5.6/+bug/1255147

Thank you. I managed to work around those problems.

Now a new 'Deadlock' problem arrises from time to time.

When a user successfully logs in to the IMAP server, we register the timestamp 
of that last login:

"UPDATE user set lastLogin=Now() where concat(userid,'@',domain)='$USER'"

In about 4 of 5 cases, this is successfull.
In one of 5 cases we get a Deadlock error.

Any hints what causes that problem? Can't we user NOW() because not all of the 
cluster members might have the same timestamp?

Mit freundlichen Grüssen

Benoit Panizzon
I m p r o W a r e   A G    -    

Zurlindenstrasse 29             Tel  +41 61 826 93 07
CH-4133 Pratteln                Fax  +41 61 826 93 02
Schweiz                         Web  http://www.imp.ch

Follow ups