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

          Activity

            People

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            Juan Juan Telleria
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: