timeout exceeded sur requête insert correcte
Bonsoir,
je teste une requête qui me semble correcte : INSERT INTO `BU_businessunit` (BU_businessunit , comp_ident) VALUES ('Global Finance', 6);
Code:
1
2
3
4
5
6
7
8
| CREATE TABLE `bu_businessunit` (
`bu_ident` int unsigned NOT NULL AUTO_INCREMENT,
`bu_businessunit` varchar(100) DEFAULT NULL,
`comp_ident` int unsigned NOT NULL,
PRIMARY KEY (`bu_ident`),
KEY `comp_ident` (`comp_ident`),
CONSTRAINT `bu_businessunit_ibfk_1` FOREIGN KEY (`comp_ident`) REFERENCES `co_company` (`comp_ident`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; |
Le SGBD est MySQL et le message d'erreur est :
Citation:
Error Code: 1205. Lock wait timeout exceeded; try restarting transaction
Pourquoi, SVP ?
