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

Crash while parallel dropping multiple tables under heavy load

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 5.5.34, 5.5.35
    • Fix Version/s: 5.5.39
    • Component/s: None
    • Labels:
      None
    • Environment:
      SW: Centos 6.5 x86_64 + Official MariaDB repo HW: 2xIntel(R) Xeon(R) CPU E5-2430, 64GB RAM, 4x2GB 7200RPM SATA Disk in RAID10

      Description

      When the crash happens, there are two sets of queries running on the server.

      One set is populating Business Intelligence aggregate tables, the other is refreshing a development copy of a database, using parallel loading.

      The two sets of queries are running on different, independent databases.

      The crash does not occur when only one set of queries (e.g. only the db load queries, or only the BI aggregator queries ) are running.

      The tables that I try to drop are in compressed format.

      The system is IO bound when the crash occurs (iostat consistently shows 100% disk utilization), but not CPU bound.

      The crash occurs when I try to drop several big (multi gigabyte) tables in parallel, as you can see in the attached error log.

        Attachments

          Activity

            People

            • Assignee:
              jplindst Jan Lindström
              Reporter:
              stoty Tóth István
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: