Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.9, 10.1.11
-
None
-
Centos 5 custom version.
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:
# 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.
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)
|
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.
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