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

Create table w/o pkey crashed DB w/ internal error 1173

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.19
    • None
    • Data Definition - Create Table
    • None
    • RHEL8, VMWare

    Description

      Create a table w/o primary key. The database crashed with internal error 1173 as seen from MariaDB error log file.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35898 Create table w/o pkey crashed DB w/ internal error 1173

          • Major - Major loss of function.
          • Closed

          Activity

            serg Sergei Golubchik added a comment -

            Presuming you don't use Mroonga, this could happen if you have enabled @@innodb_force_primary_key=1 on the slave, but not on the master. And created an InnoDB table without a primary key on the master. A slave, naturally, won't be able to replicate such a CREATE TABLE statement.

            serg Sergei Golubchik added a comment - Presuming you don't use Mroonga, this could happen if you have enabled @@innodb_force_primary_key=1 on the slave, but not on the master. And created an InnoDB table without a primary key on the master. A slave, naturally, won't be able to replicate such a CREATE TABLE statement.

            People

              Unassigned Unassigned
              LawrenceMan Lawrence Man
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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