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

Crash while parallel dropping multiple tables under heavy load

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 5.5.34, 5.5.35
    • 5.5.39
    • None
    • None
    • 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

        1. server.cnf
          1 kB
          Tóth István

        Activity

          People

            jplindst Jan Lindström (Inactive)
            stoty Tóth István
            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.