Insert delayed bug

Description

Hi All,
I am having a problem with insert delayed option with the above mariadb.
Its is returning weird errors.
The max_delayed_threads = 40
I am doing this on a test system. There are no other insert delayed into the queue.
So it cannot be a delayed thread queue problem. The error doesn't make sense even.
Sorry if this has been reported before. Not sure how to search for such a specific error.

The mariadb installed are:

1 2 3 4 5 6 7 # rpm -qa | grep Maria MariaDB-shared-10.1.11-1 MariaDB-connect-engine-10.1.11-1 MariaDB-client-10.1.11-1 MariaDB-compat-10.1.11-1 MariaDB-common-10.1.11-1 MariaDB-server-10.1.11-1

I don't see this in mysql version I was using (5.1), haven't tried on later version.
The reason was am planning migration of the database so I am testing all commands individually. This command is from radius server doing a insert a session to the session table radacct. The values are not important, its just for testing of the command.
I am checking the performance of myisam vs innodb for this table. So I need to old way of inserting to do a proper comparing.

1 2 MariaDB [server1]> INSERT DELAYED INTO radacct (acctsessionid, acctuniqueid, username, groupname, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, acctupdatetime ) VALUES ("aasda1","ascac","ascasc","assfa","reasas","ascac","123","asc",now(),now(),12312,"testa","123asc",10,10,"asca","ascasc","teast","ascasc","ascasc","aasca","teast",12312,123123,now()); Query OK, 1 row affected, 1 warning (0.00 sec)
1 2 MariaDB [server1]> INSERT DELAYED INTO radacct (acctsessionid, acctuniqueid, username, groupname, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, acctupdatetime ) VALUES ("aasda1","ascac","ascasc","assfa","reasas","ascac","123","asc",now(),now(),12312,"testa","123asc",10,10,"asca","ascasc","teast","ascasc","ascasc","aasca","teast",12312,123123,now()); ERROR 1110 (42000): Column 'acctupdatetime' specified twice

Note the two delayed insert are identical.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 The table structure is as follows: CREATE TABLE `radacct` ( `radacctid` bigint(20) NOT NULL AUTO_INCREMENT, `acctsessionid` varchar(64) NOT NULL DEFAULT '', `acctuniqueid` varchar(32) NOT NULL DEFAULT '', `username` varchar(64) NOT NULL DEFAULT '', `groupname` varchar(64) NOT NULL DEFAULT '', `realm` varchar(64) DEFAULT '', `nasipaddress` varchar(15) NOT NULL DEFAULT '', `nasportid` varchar(15) DEFAULT NULL, `nasporttype` varchar(32) DEFAULT NULL, `acctstarttime` datetime DEFAULT NULL, `acctstoptime` datetime DEFAULT NULL, `acctsessiontime` int(11) DEFAULT NULL, `acctauthentic` varchar(32) DEFAULT NULL, `connectinfo_start` varchar(50) DEFAULT NULL, `connectinfo_stop` varchar(50) DEFAULT NULL, `acctinputoctets` bigint(20) DEFAULT NULL, `acctoutputoctets` bigint(20) DEFAULT NULL, `calledstationid` varchar(50) NOT NULL DEFAULT '', `callingstationid` varchar(50) NOT NULL DEFAULT '', `acctterminatecause` varchar(32) NOT NULL DEFAULT '', `servicetype` varchar(32) DEFAULT NULL, `framedprotocol` varchar(32) DEFAULT NULL, `framedipaddress` varchar(15) NOT NULL DEFAULT '', `acctstartdelay` int(11) DEFAULT NULL, `acctstopdelay` int(11) DEFAULT NULL, `acctupdatetime` datetime DEFAULT NULL, `deleted` char(1) DEFAULT '', `objectclass` varchar(64) DEFAULT 'AAA-SessionInfo', PRIMARY KEY (`radacctid`), KEY `username` (`username`), KEY `framedipaddress` (`framedipaddress`), KEY `acctsessionid` (`acctsessionid`), KEY `acctsessiontime` (`acctsessiontime`), KEY `acctuniqueid` (`acctuniqueid`), KEY `acctstarttime` (`acctstarttime`), KEY `acctstoptime` (`acctstoptime`), KEY `nasipaddress` (`nasipaddress`), KEY `acctupdatetime` (`acctupdatetime`), KEY `deleted` (`deleted`), KEY `objectclass` (`objectclass`) ) ENGINE=MyISAM AUTO_INCREMENT=7117 DEFAULT CHARSET=latin1

Regards,

Michael

Environment

Centos 5 custom version.

Status

Assignee

Michael Widenius

Reporter

Michael Van Der Beek

Labels

None

External issue ID

None

External issue ID

None

Fix versions

Affects versions

10.1.9
10.1.11

Priority

Major