Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6, 10.7.3
-
linux
Description
I have table that passes mysqlcheck just fine. After exporting the tablespace, and importing it in another database, the table becomes corrupted.
test.tableset
|
Warning : InnoDB: The B-tree of index PRIMARY is corrupted.
|
Warning : InnoDB: Index 'suffix' contains 5 entries, should be 18446744073709551615.
|
error : Corrupt
|
After recreating a fresh table this doesn't occur so the ibd might very well be corrupt - but that would indicate another issue as the server does not seem hindered by this corruption while operating normally.
I've attached the exported tablespace with the cfg; the structure of this table is:
CREATE TABLE `tableset` (
|
`setid` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
`prefix` varchar(12) CHARACTER SET latin1 NOT NULL DEFAULT '',
|
`frontend` enum('Y','N') CHARACTER SET latin1 NOT NULL DEFAULT 'N',
|
`datestr` int(10) unsigned NOT NULL DEFAULT 0,
|
`interval` enum('monthly','weekly') CHARACTER SET latin1 NOT NULL DEFAULT 'monthly',
|
`version` tinyint(3) unsigned NOT NULL DEFAULT 0,
|
`updatewindow` varchar(11) CHARACTER SET latin1 NOT NULL DEFAULT '',
|
`source` enum('pcreeks','perceel','perceel-bag','adres-bag','adres-bag-onbebouwd','pcreeks-rws','pcreeks-convert','perceel-convert') CHARACTER SET latin1 NOT NULL,
|
`deliverysource` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'none',
|
`status` enum('empty','ready','match-id','disabled') CHARACTER SET latin1 NOT NULL DEFAULT 'ready',
|
`symsearch_version` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
|
`comments` varchar(30) CHARACTER SET latin1 NOT NULL DEFAULT '',
|
PRIMARY KEY (`setid`),
|
UNIQUE KEY `suffix` (`prefix`)
|
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci ROW_FORMAT=DYNAMIC `PAGE_COMPRESSED`=1;
|
Attachments
Issue Links
- relates to
-
-
- Closed
-