A
A
Anton B2020-02-28 08:17:35
MySQL
Anton B, 2020-02-28 08:17:35

Why does error 1062 occur?

Hello.

Server Version: 10.3.22-MariaDB-0+deb10u1 - Debian 10

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=2002280000000127419 DEFAULT CHARSET=utf8mb4
 PARTITION BY RANGE (`id`)
(PARTITION `d200226` VALUES LESS THAN (2002270000000000000) ENGINE = InnoDB,
 PARTITION `d200227` VALUES LESS THAN (2002280000000000000) ENGINE = InnoDB,
 PARTITION `d200228` VALUES LESS THAN (2002290000000000000) ENGINE = InnoDB)

Error 1062 occurs intermittently when pasting
INSERT INTO `background` (`name`, `data`, `priority`, `time`, `status`, `add`) VALUES ('move', '{\"id\":2002280000000000448,\"frame\":18}', 1, 1582840572, 0, 1582840572)

I searched on the Internet, they advised me to change innodb_autoinc_lock_mode from 1 to 2, but this did not help, errors still occur.

Question : what to do?

Thanks for answers.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question