Hello,
I've got problems with MariaDB not working.
1) "systemctl status mariadb.service":
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled;
vendor preset: disabled)
Active: failed (Result: exit-code) since Fri 2017-01-27 13:04:10
CET; 13s ago
Process: 4574 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS
$_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 4519 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery
] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] &&
systemctl set-environment _WSREP_START_POSITION=$VAR
Process: 4517 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 4574 (code=exited, status=1/FAILURE)
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [Note] Starting crash recovery...
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [Note] Crash recovery finished.
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454332160 [Warning] Failed to load slave replication state from
table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos'
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [ERROR] Can't open and lock privilege tables: Table
'mysql.servers' doesn't exist
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [Note] Server socket created on IP: '::'.
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.user' doesn't exist
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Main process
exited, code=exited, status=1/FAILURE
Jan 27 13:04:10 tuchola systemd[1]: Failed to start MariaDB database server.
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Unit entered failed
state.
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Failed with result
'exit-code'.
2) "journalctl -xe":
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB)
starting as process 4574 ...
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: GCC builtin __atomic_thread_fence() is
used for memory barrier
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Compressed tables use zlib 1.2.11
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Using Linux native AIO
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Using SSE crc32 instructions
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Completed initialization of buffer pool
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Highest supported file format is Barracuda.
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: The log sequence numbers 0 and 0 in
ibdata files do not match the log sequence number 1600749 in the
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Database was not shutdown normally!
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Starting crash recovery.
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Reading tablespace information from the
.ibd files...
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Restoring possible half-written data pages
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: from the doublewrite buffer...
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: 128 rollback segment(s) are active.
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Waiting for purge to start
Jan 27 13:04:09 tuchola mysqld[4574]: 2017-01-27 13:04:09
140214454369792 [Note] InnoDB: Percona XtraDB (http://www.percona.com)
5.6.34-79.1 started; log sequence number 1600749
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [Note] Plugin 'FEEDBACK' is disabled.
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140213863028480 [Note] InnoDB: Dumping buffer pool(s) not yet started
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [ERROR] Could not open mysql.plugin table. Some plugins
may be not loaded
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [Note] Recovering after a crash using mysql-bin
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [Note] Starting crash recovery...
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [Note] Crash recovery finished.
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454332160 [Warning] Failed to load slave replication state from
table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos'
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [ERROR] Can't open and lock privilege tables: Table
'mysql.servers' doesn't exist
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [Note] Server socket created on IP: '::'.
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10
140214454369792 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.user' doesn't exist
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Main process
exited, code=exited, status=1/FAILURE
Jan 27 13:04:10 tuchola systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Unit entered failed
state.
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Failed with result
'exit-code'.
Jan 27 13:04:10 tuchola sudo[4514]: pam_unix(sudo:session): session
closed for user root
Sorry, but those messages are not very expressive to me. I also tried to
re-install mariadb, removing /var/lib/mysql (no important data had been
in there until now ...)
It seems to me, database data hadn't been re-created, but how can I get
mariadb working now?
BTW, is there a possibility to do a clean-up after package uninstall?
Kind regards
Peter
