← Back to team overview

maria-discuss team mailing list archive

Re: Deadlock on update with same values.

 

Hi Jan

> To be able to help you more I need additional information, I assume that
> you do not have autocommit=1, but could
> you share show create table user ?

I did not set any autocommit statements. So I assume it's 1 as per default.

Sure:

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(30) DEFAULT NULL,
  `passwd` varchar(30) DEFAULT NULL,
  `domain` varchar(30) DEFAULT NULL,
  `homeserver` varchar(30) DEFAULT NULL,
  `quotaInMiB` int(11) DEFAULT '100',
  `password_type` varchar(10) DEFAULT 'plain',
  `spamaction` enum('REJECT','ACCEPT','TAGGING') DEFAULT 'REJECT',
  `spampoint` decimal(5,1) DEFAULT '5.2',
  `virusaction` enum('REJECT','ACCEPT','REPLACE') DEFAULT 'REJECT',
  `keepFwdCopy` tinyint(1) DEFAULT '0',
  `quotaUsed` int(11) DEFAULT '0',
  `extRef` varchar(12) DEFAULT NULL,
  `mandate` int(11) DEFAULT '0',
  `FwdBounceCount` decimal(1,0) DEFAULT '0',
  `FwdActive` tinyint(1) DEFAULT '1',
  `lastActive` datetime DEFAULT '0000-00-00 00:00:00',
  `lastLogin` datetime DEFAULT '0000-00-00 00:00:00',
  `disabled` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `userid` (`userid`,`domain`)
) ENGINE=InnoDB AUTO_INCREMENT=26944 DEFAULT CHARSET=utf8

Kind regards

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

References