soeben hat sich mein MySQL-Server wieder verabschiedet. Weder am Server noch an den Websites wurde etwas gemacht. Lediglich vorgestern erhielt ich eine Nachricht von Plesk, dass Plesk nicht aktualisiert werden konnte.
In der /etc/mysql/my.cnf habe ich "# MySQL error log" den Eintrag "log_error = hostname_error.log"
Die hostname_error.log hatte ich mir mal angeschaut:
160812 12:10:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160812 12:10:23 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set
160812 12:10:23 [Note] /usr/sbin/mysqld (mysqld 10.0.26-MariaDB-0+deb8u1) starting as process 1585 ...
160812 12:10:23 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160812 12:10:23 [Note] InnoDB: The InnoDB memory heap is disabled
160812 12:10:23 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160812 12:10:23 [Note] InnoDB: Memory barrier is not used
160812 12:10:23 [Note] InnoDB: Compressed tables use zlib 1.2.8
160812 12:10:23 [Note] InnoDB: Using Linux native AIO
160812 12:10:23 [Note] InnoDB: Using CPU crc32 instructions
160812 12:10:23 [Note] InnoDB: Initializing buffer pool, size = 512.0M
160812 12:10:23 [Note] InnoDB: Completed initialization of buffer pool
160812 12:10:23 [Note] InnoDB: Highest supported file format is Barracuda.
160812 12:10:23 [Note] InnoDB: 128 rollback segment(s) are active.
160812 12:10:23 [Note] InnoDB: Waiting for purge to start
160812 12:10:23 [Note] InnoDB: Percona XtraDB (
http://www.percona.com) 5.6.30-76.3 started; log sequence number 59935440741
160812 12:10:23 [Note] Plugin 'FEEDBACK' is disabled.
160812 12:10:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160812 12:10:23 [Note] Recovering after a crash using hostname_binlog
160812 12:10:23 [Note] Starting crash recovery...
160812 12:10:23 [Note] Crash recovery finished.
160812 12:10:23 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
160812 12:10:23 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
160812 12:10:23 [Note] Server socket created on IP: '::'.
160812 12:10:23 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
160812 12:10:24 mysqld_safe mysqld from pid file /var/lib/mysql/servidor22.befla.com.mx.pid ended