Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.22
-
None
-
None
-
Linux 4.19.0-8-cloud-amd64 #1 SMP Debian 4.19.98-1 (2020-01-26) x86_64 GNU/Linux
Description
Table
CREATE TABLE `background` ( |
`id` bigint(20) NOT NULL AUTO_INCREMENT, |
`name` varchar(255) NOT NULL DEFAULT '', |
`data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '[]', |
`priority` tinyint(4) NOT NULL DEFAULT 0, |
`time` int(11) NOT NULL DEFAULT 0, |
`attempt` int(11) NOT NULL DEFAULT 0, |
`status` tinyint(4) NOT NULL DEFAULT 0, |
`add` int(11) NOT NULL DEFAULT 0, |
`update` int(11) NOT NULL DEFAULT 0, |
PRIMARY KEY (`id`), |
KEY `status` (`status`) |
) ENGINE=InnoDB AUTO_INCREMENT=2004210000000344340 DEFAULT CHARSET=utf8mb4 |
PARTITION BY RANGE (`id`) |
(PARTITION `d200419` VALUES LESS THAN (2004200000000000000) ENGINE = InnoDB, |
PARTITION `d200420` VALUES LESS THAN (2004210000000000000) ENGINE = InnoDB, |
PARTITION `d200421` VALUES LESS THAN (2004220000000000000) ENGINE = InnoDB) |
Query
INSERT INTO `background` (`name`, `data`, `priority`, `time`, `status`, `add`) VALUES ('battle.move', '{\"battle_id\":2004220000000001939,\"frame\":2}', 1, 1587516303, 0, 1587516303) |
Error
1062 Duplicate entry '2004210000000245501' for key 'PRIMARY' |
Additional Information
- Default configuration
- No replication
- Used transactions
- The error occurs under high load, a lot of application thread work with the table