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

Compatibility check against existing database options failed, Status Code: 2, Status: Corruption: A RocksDB Option file must have a single DBOptions section

    XMLWordPrintable

Details

    Description

      May be expected.
      Claimed to happen when:

      • data directory is on usb stick
      • which is ungracefully removed under heavy load
      • server is killed, the stick is mounted back
      • RocksDB refuses to initialize with:

      171025 08:46:55 mysqld_safe Starting mysqld daemon with databases from /home/a/e1/m7-system2/dt
      2017-10-25  8:46:55 139673647249600 [Note] /usr/sbin/mysqld (mysqld 10.2.9-MariaDB-10.2.9+maria~xenial-log) starting as process 15547 ...
      2017-10-25  8:46:55 139673647249600 [Warning] Setting lower_case_table_names=2 because file system for /home/a/e1/m7-system2/dt/ is case insensitive
      2017-10-25  8:46:55 139673647249600 [Note] RocksDB: 2 column families found
      2017-10-25  8:46:55 139673647249600 [Note] RocksDB: Column Families at start:
      2017-10-25  8:46:55 139673647249600 [Note]   cf=default
      2017-10-25  8:46:55 139673647249600 [Note]     write_buffer_size=67108864
      2017-10-25  8:46:55 139673647249600 [Note]     target_file_size_base=67108864
      2017-10-25  8:46:55 139673647249600 [Note]   cf=__system__
      2017-10-25  8:46:55 139673647249600 [Note]     write_buffer_size=67108864
      2017-10-25  8:46:55 139673647249600 [Note]     target_file_size_base=67108864
      2017-10-25  8:46:55 139673647249600 [ERROR] RocksDB: Compatibility check against existing database options failed, Status Code: 2, Status: Corruption: A RocksDB Option file must have a single DBOptions section
      2017-10-25  8:46:55 139673647249600 [ERROR] Plugin 'ROCKSDB' init function returned error.
      2017-10-25  8:46:55 139673647249600 [ERROR] Plugin 'ROCKSDB' registration as a STORAGE ENGINE failed.
      

      a@henial:e1$ ls -lRa m7-system2/dt/.rocksdb/
      m7-system2/dt/.rocksdb/:
      total 640
      drwxr-xr-x  3 a a  16384 Oct 25 08:46 .
      drwxr-xr-x 46 a a  16384 Oct 25 08:56 ..
      -rw-r--r--  1 a a   1025 Oct 25 08:43 000012.sst
      -rw-r--r--  1 a a 471729 Oct 25 08:44 000015.log
      -rw-r--r--  1 a a     16 Oct 25 08:43 CURRENT
      -rw-r--r--  1 a a     37 Oct 25 08:43 IDENTITY
      -rw-r--r--  1 a a      0 Oct 25 08:43 LOCK
      -rw-r--r--  1 a a      0 Oct 25 08:46 LOG
      -rw-r--r--  1 a a  29862 Oct 25 08:43 LOG.old.1508913810856506
      -rw-r--r--  1 a a  16447 Oct 25 08:43 LOG.old.1508914015620500
      -rw-r--r--  1 a a    190 Oct 25 08:43 MANIFEST-000014
      -rw-r--r--  1 a a      0 Oct 25 08:43 OPTIONS-000019
      -rw-r--r--  1 a a      0 Oct 25 08:43 OPTIONS-000021
      drwxr-xr-x  2 a a  16384 Oct 25 08:43 trash
       
      m7-system2/dt/.rocksdb/trash:
      total 32
      drwxr-xr-x 2 a a 16384 Oct 25 08:43 .
      drwxr-xr-x 3 a a 16384 Oct 25 08:46 ..
      

      Attachments

        Activity

          People

            anikitin Andrii Nikitin (Inactive)
            anikitin Andrii Nikitin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.