Debian 9 + MariaDB 10.2.12 issue

staff_nowa

Verified User
Joined
Mar 10, 2018
Messages
71
Hello,

I found strange issue with MariaDB

1. Installed newest Debian 8.
2. Upgrade Debian 8 to Debian 9.
3. Received message "The service 'mysqld' on server * is currently down
4. Found errors in /usr/local/mysql/data/*.err

Issue after install newest Debian after that installed DirectAdmin

2018-03-21 10:10:29 140076203263808 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Uses event mutexes
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Using Linux native AIO
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Number of pools: 1
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Using SSE2 crc32 instructions
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Completed initialization of buffer pool
2018-03-21 10:10:29 140075437168384 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-21 10:10:29 140076203263808 [Note] InnoDB: 5.7.20 started; log sequence number 1619198
2018-03-21 10:10:29 140075046266624 [Note] InnoDB: Loading buffer pool(s) from /home/mysql/ib_buffer_pool
2018-03-21 10:10:29 140075046266624 [Note] InnoDB: Buffer pool(s) load completed at 180321 10:10:29
2018-03-21 10:10:29 140076203263808 [Note] Plugin 'FEEDBACK' is disabled.
2018-03-21 10:10:29 140076203263808 [Note] Recovering after a crash using tc.log
2018-03-21 10:10:29 140076203263808 [Note] Starting crash recovery...
2018-03-21 10:10:29 140076203263808 [Note] Crash recovery finished.
2018-03-21 10:10:29 140076203263808 [ERROR] Can't open and lock privilege tables: Table './mysql/servers.MYI' is read only
2018-03-21 10:10:30 140076203263808 [Note] Server socket created on IP: '::'.
2018-03-21 10:10:30 140076203263808 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user.MYI' is read only
 
Last edited:
Top