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

RocksDB: Server Collapse with certain Queries

    XMLWordPrintable

Details

    Description

      When doing Bulk Loads, RocksDB gets stuck with some scheduled bulk load events with "Creating sort index". Under normal circumstances, the procedure should execute in a couple of minutes, but at time of reporting, it has been running for nearly 6 hours without any result...

      SET STATEMENT
            rocksdb_commit_in_the_middle = 1,
            max_statement_time = 10800
      FOR
           CREATE OR REPLACE TABLE t_table
           AS
                SELECT [...]
      

      And if I try to kill the query, it does not get killed, causing performance issues to the whole server, and forcing a serve shutdown.

      Which could be the root cause?

      Attachments

        1. my.ini
          67 kB
          Juan Telleria

        Activity

          People

            psergei Sergei Petrunia
            Juan Juan Telleria
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.