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

ALTER TABLE DROP FOREIGN KEY - unexpected end of stream error

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

            Ascending order - Click to sort in descending order
            rdyas Robert Dyas created issue -
            rdyas Robert Dyas made changes -
            Field Original Value New Value
            Summary ALTER TABLE DROP FOREIGN KEY crashes ALTER TABLE DROP FOREIGN KEY error
            rdyas Robert Dyas made changes -
            Summary ALTER TABLE DROP FOREIGN KEY error ALTER TABLE DROP FOREIGN KEY - unexpected end of stream error
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.3 [ 22126 ]
            Assignee Elena Stepanova [ elenst ] Marko Mäkelä [ marko ]
            Priority Major [ 3 ] Blocker [ 1 ]
            elenst Elena Stepanova made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            marko Marko Mäkelä made changes -
            Affects Version/s 10.3.7 [ 23005 ]
            marko Marko Mäkelä made changes -
            Labels crash ddl instant
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2018-08-03 14:44:58.0 2018-08-03 14:44:58.126
            marko Marko Mäkelä made changes -
            Fix Version/s 10.3.9 [ 23114 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 88607 ] MariaDB v4 [ 154713 ]

            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.