[MDEV-4031] Bug in core storage Duplicate entry '<uid>-<hash>' for key 'PRIMARY' Created: 2013-01-14  Updated: 2013-01-18  Resolved: 2013-01-18

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.28a
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Aleai Sumity (Inactive) Assignee: Elena Stepanova
Resolution: Incomplete Votes: 0
Labels: freebsd, upgrade
Environment:
  1. uname -por
    FreeBSD 9.0-RELEASE amd64


 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

 Comments   
Comment by Elena Stepanova [ 2013-01-14 ]

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.

Comment by Elena Stepanova [ 2013-01-18 ]

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.

Generated at Thu Feb 08 06:53:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.