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

ALTER TABLE DROP FOREIGN KEY - unexpected end of stream error

    XMLWordPrintable

Details

    Description

      On 10.3.8 when you issue the following command:

      ALTER TABLE `p1b` COMMENT 'drop fk test', DROP FOREIGN KEY p1b_ibfk_1

      it generates the following error:

      (conn=41) unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

      Note that this has worked without issue in all prior 10.1 and 10.2 versions we have used. Also, note that the following does NOT generate an error and does work correctly:

      ALTER TABLE `p1b` DROP FOREIGN KEY p1b_ibfk_1

      Also the following works correctly:

      ALTER TABLE `p1b` COMMENT 'add fk test', ADD  FOREIGN KEY (`p1`) REFERENCES `p1` (`p1_ID`) ON DELETE RESTRICT ON UPDATE CASCADE

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18771 crash when modifying column name and comment at the same time

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-11369 Instant add column for InnoDB

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-13134 Introduce ALTER TABLE attributes ALGORITHM=NOCOPY and ALGORITHM=INSTANT

          • Major - Major loss of function.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              rdyas Robert Dyas
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.