Skip to content

When upgrading past 1.1.34, upgrade attempts to drop a non-existing primary key #2482

Closed
@ycaoxa

Description

@ycaoxa

Mariadb version:
[root@rtm73t ~]# mysql -V
mysql Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1

version table in my ENV
MariaDB [cacti]> show create table version;
+---------+-------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------+-------------------------------------------------------------------------------------------------+
| version | CREATE TABLE version (
cacti char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+---------+-------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Error as below:

Upgrading from v1.1.31 (DB 1.1.31) to v1.1.34
++++-++++++++++++++++++++-+-++-+-++-+++-+++++++++-+-+++++-++x++
################################
[Fail] - DB Exec Failed!, Error 1091: Can't DROP 'PRIMARY'; check that column/key exists
+------------------------------+
ALTER IGNORE TABLE version DROP PRIMARY KEY

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugUndesired behaviourinstallerInstallation issueresolvedA fixed issue

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions