Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4031

Bug in core storage Duplicate entry '<uid>-<hash>' for key 'PRIMARY'

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 5.5.28a
    • None
    • None
    • # 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

      Attachments

        Activity

          People

            elenst Elena Stepanova
            devzone.my Aleai Sumity (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.