[MDEV-14122] Compatibility check against existing database options failed, Status Code: 2, Status: Corruption: A RocksDB Option file must have a single DBOptions section Created: 2017-10-25  Updated: 2017-10-25  Resolved: 2017-10-25

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 10.2.9
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Andrii Nikitin (Inactive) Assignee: Andrii Nikitin (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None


 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 ..



 Comments   
Comment by Andrii Nikitin (Inactive) [ 2017-10-25 ]

It is 'Not a bug' because there is really no way to guarantee fsync on USB stick . If somebody sees this error - that probably means that Filesystem fakes fsync() calls.

Generated at Thu Feb 08 08:11:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.