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

Error while add a primary key on an empty created table on MariadDB 10.6.1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.6
    • N/A
    • None
    • None

    Description

      In MariaDB 10.6.1 and other versions when I created a new empty table and tried to add a PK I got this exception:

      `> add primary key on table_1 (date, id_a, id_b) ...Exception: SQLSTATE[HY000]: General error: 1194 Table 'table_1' is marked as crashed and should be repaired`

      If I do the same thing on a table already created and populated nothing go wrong.

      MariaDB runs on a docker container.

      Attachments

        Activity

          People

            Unassigned Unassigned
            frossi Francesco Rossi
            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.