Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1853

PT-1802 is not fixed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 3.2.0
    • Fix Version/s: 3.2.1
    • Component/s: None
    • Labels:
      None
    • Story Points:
      2
    • Sprint:
      Platform Sprint 19
    • Needs Review:
      Yes
    • Needs Doc:
      Yes

      Description

      PT-1802 is not fixed in version 3.2

      How To Repeat.

      Turn ON general log and follow instructions on PT-1802. You will see:

      2020-06-01T12:51:55.180936Z         9 Query     CREATE TABLE `test`.`_joinit_new` (
        `i` int(11) NOT NULL AUTO_INCREMENT,
        `s` varchar(64) DEFAULT NULL,
        `t` time NOT NULL,
        `g` int(11) NOT NULL,
        `j` int(11) NOT NULL DEFAULT '1',
        PRIMARY KEY (`i`),
        KEY `i_fk` (`j`),
          CONSTRAINT `__joinit_ibfk_1` FOREIGN KEY (`j`) REFERENCES `joinit` (`i`) ON UPDATE CASCADE
      ) ENGINE=InnoDB AUTO_INCREMENT=786406 DEFAULT CHARSET=latin1
      

      Suggested fix.

      Add a check to verify there are self-referencing FKs and make the program to not to run unless the new option --disable-fk-checks is used in the command line.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              sveta.smirnova Sveta Smirnova
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 hours, 30 minutes
                  5h 30m