Details
Critical
Description
CREATE TABLE `users_cookie` (
`uid` int(11) NOT NULL,
`u_cookie` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`u_cookie_time` int(11) NOT NULL,
`is_ban` tinyint(1) NOT NULL DEFAULT '0',
`protect_L3` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`,`u_cookie`),
KEY `u_cookie` (`u_cookie`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!50100 PARTITION BY KEY (uid)
PARTITIONS 6 */;
Reindex innodb Index (upgrade mariadb 5.3 to 5.5.28a)
[SQL] alter table bb_users_cook engine = innodb;
[Err] 1062 - Duplicate entry '<uid>-<hash>' for key 'PRIMARY'
i test table and not finded dublicate
mariadb 5.3 good work
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
I will close it as incomplete for now. Please see the questions above, and if you can provide the information, please add it to the report to re-open it.
Thank you.
Hi,
I have some additional questions/requests for you.
1) Did you run mysql_upgrade after upgrading from 5.3 to 5.5?
2) Would it be possible to provide a full dump of the problematic table? You can upload it to the private section of our FTP, so nobody but MariaDB developers would have access to it (ftp://ftp.askmonty.org/private/).
3) In your description you quote CREATE for the table `users_cookie`, but ALTER for `bb_users_cook`. Which one you actually have a problem with? If that's bb_users_cook, could you please paste SHOW CREATE for this table?
4) Please run CHECK TABLE on the problematic table and paste its output.
5) Please paste the contents of the server error log since the upgrade. Even better if you have a fragment of log since the last server start before the upgrade, please then include it too.
6) Did you use XtraDB or InnoDB in 5.3? Which one are you using now? If in doubt, please run SHOW ENGINES and SHOW PLUGINS and paste their output in regard to InnoDB.
Thanks.