Bug ID | 1143215 |
---|---|
Summary | mariadb 10.3.16 after any update Plugin 'ROCKSDB' registration as a STORAGE ENGINE failed |
Classification | openSUSE |
Product | openSUSE Tumbleweed |
Version | Current |
Hardware | All |
OS | openSUSE Factory |
Status | NEW |
Severity | Normal |
Priority | P5 - None |
Component | Other |
Assignee | bnc-team-screening@forge.provo.novell.com |
Reporter | ilya@ilya.pp.ua |
QA Contact | qa-bugs@suse.de |
Found By | --- |
Blocker | --- |
Created attachment 811922 [details]
mariadb.log
After upgrading mariadb to 10.3.16 (currently not yet in Factory), even after
manually starting "sudo mysql_upgrade -u my_admin_user -p", it always leads to
an initialization error of the RocksDB plugin.
Manually running "sudo systemctl restart mariadb" after upgrading or
reinstalling the mariadb package solves the problem.
[ERROR] RocksDB: Error opening instance, Status Code: 5, Status: IO error:
While lock file: ./#rocksdb/LOCK: Resource temporarily unavailable
[ERROR] Plugin 'ROCKSDB' init function returned error.
[ERROR] Plugin 'ROCKSDB' registration as a STORAGE ENGINE failed.
[ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control'
for exclusive use, error: 11. Will retry for 30 seconds
>From important notes.
1 Python2 is not installed on the system.
2 The root @ localhost user has been deleted on the server.
3 In /etc/my.cnf
* skip-network in my.conf (no network, only socket)
* sqlmode default (STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO,
NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION).