问"MySQL错误代码1114:表已满“不断出现

EN

CREATE TABLE `tblp` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `index_dat` (`datum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

    CREATE TABLE `tblpdet` (
        `id` int unsigned NOT NULL,
        `katbr` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `redid` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`redid`),
  KEY `Index_2` (`id`),
  KEY `idx_katbr` (`katbr`),
  CONSTRAINT `FK_tblpdet_1` FOREIGN KEY (`id`) REFERENCES `tblp` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

select katbr, min(date(datum)) 
from tblp p 
join tblpdet d on p.id = d.id
group by katbr;

select katbr, min(redid)
from tblpdet 
group by katbr;

> innodb_data_file_path=ibdata1:12M:autoextend
> innodb_buffer_pool_size=51539607552