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

DELETE with CASCADE constraints takes long time and then crashes the instance with Signal 6

    Details

      Description

      Running DELETE on a table with a single ROW which causes a cascade constraint to trigger hangs for long time (about 20 minutes in the reported case) and then crashes the instance with:

      InnoDB: ###### Diagnostic info printed to the standard error stream
      2017-08-10 19:08:35 140481422710528 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server becau
      se it appears to be hung.
      170810 19:08:35 [ERROR] mysqld got signal 6 ;

      To reproduce:

      1) Import attached dump

      2) Execute:

      DELETE FROM BRc273a13dfda91b1add89;

      3) Wait ~20 minutes

      On 10.1 the same completes successfully in 15 seconds.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                claudio.nanni Claudio Nanni
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: