MariaDb Error on new Yunohost installation

My YunoHost server

**Hardware: Raspberry Pi at home
**YunoHost version: 4.1.7.1. (Stable)
**I have access to my server : through the webadmin
**Are you in a special context or did you perform some particular tweaking on your YunoHost instance ?: no
**If yes, please explain:

Description of my issue

Hello,

I have freshly installed Younohost on a Raspberry Pi 4. On the Post installation process there was a Message that a Script could not executed correctly, I believe it was something like 34_mysql… but at the End there was a message that post installation was completed.

I then rebooted my Rpi and looked again on the Webinterface. In the Services Menu is shown that the mysql service is not running and I cannot start the service due to an Error.

I looked in the Forum for similar Errors but didnt find a clue.
Can someone here please help me with this problem?

Thank You! :slight_smile:

Here are the Logs:

journalctl:

– Logs begin at Fri 2021-02-05 17:14:26 GMT, end at Fri 2021-02-05 17:28:02 GMT. –
Feb 05 17:14:41 systemd[1]: Starting MariaDB 10.3.27 database server…
Feb 05 17:14:42 mysqld[782]: 2021-02-05 17:14:42 0 [Warning] option ‘table_open_cache’: unsigned value 4 adjusted to 10
Feb 05 17:14:42 mysqld[782]: 2021-02-05 17:14:42 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 782 …
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Using Linux native AIO
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Uses event mutexes
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Number of pools: 1
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Using generic crc32 instructions
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Feb 05 17:14:43 mysqld[782]: 2021-02-05 17:14:43 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=48579
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: Starting final batch to recover 13 pages from redo log.
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: Waiting for purge to start
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: 10.3.27 started; log sequence number 1601327; transaction id 8
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] InnoDB: Cannot open ‘/var/lib/mysql/ib_buffer_pool’ for reading: No such file or directory
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] Plugin ‘FEEDBACK’ is disabled.
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] Recovering after a crash using tc.log
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] Starting crash recovery…
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] Crash recovery finished.
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [Note] Server socket created on IP: ‘::’.
Feb 05 17:14:44 mysqld[782]: 2021-02-05 17:14:44 0 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
Feb 05 17:14:44 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 05 17:14:44 systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Feb 05 17:14:44 systemd[1]: Failed to start MariaDB 10.3.27 database server.

and /var/log/mysql/error.log:

2021-02-05 16:45:46 0 [Note] InnoDB: Using Linux native AIO
2021-02-05 16:45:47 0 [Note] InnoDB: The first innodb_system data file ‘ibdata1’ did not exist. A new tablespace will be created!
2021-02-05 16:45:47 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-05 16:45:47 0 [Note] InnoDB: Uses event mutexes
2021-02-05 16:45:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-05 16:45:47 0 [Note] InnoDB: Number of pools: 1
2021-02-05 16:45:47 0 [Note] InnoDB: Using generic crc32 instructions
2021-02-05 16:45:47 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-02-05 16:45:49 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-05 16:45:50 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-05 16:45:50 0 [Note] InnoDB: Setting file ‘./ibdata1’ size to 12 MB. Physically writing the file full; Please wait …
2021-02-05 16:45:50 0 [Note] InnoDB: File ‘./ibdata1’ size is now 12 MB.
2021-02-05 16:45:50 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
2021-02-05 16:45:50 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
2021-02-05 16:45:59 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-02-05 16:45:59 0 [Note] InnoDB: New log files created, LSN=44897
2021-02-05 16:45:59 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2021-02-05 16:46:06 0 [Note] InnoDB: Doublewrite buffer created
2021-02-05 16:46:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-05 16:46:07 0 [Note] InnoDB: Creating foreign key constraint system tables.
2021-02-05 16:46:07 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2021-02-05 16:46:07 0 [Note] InnoDB: Creating sys_virtual system tables.
2021-02-05 16:46:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-05 16:46:07 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-02-05 16:46:07 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2021-02-05 16:46:07 0 [Note] InnoDB: 10.3.27 started; log sequence number 0; transaction id 7
2021-02-05 16:46:07 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2021-02-05 16:46:07 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-02-05 16:46:08 0 [ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist
2021-02-05 16:46:08 0 [Note] Server socket created on IP: ‘127.0.0.1’.
2021-02-05 16:46:08 0 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist

(Probably a regression of the new image … I’m testing a new one but in the meantime you can try using https://build.yunohost.org/releases_archive/yunohost-buster-4.0.8-rpi-stable.zip … just be careful that in 4.0 there was some small issues with the use of yunohost.local )

Hi there,

I was facing what seemed to be the same problem in the same context.
It looks like I solved it doing the following:

sudo apt --reinstall install mariadb-client-10.3 mariadb-client-core-10.3 mariadb-common mariadb-server mariadb-server-10.3 mariadb-server-core-10.3

I hope this helps…

1 Like

Thanks for this helpful post.
I’ve had the same problem, and I could solved it with the reinstall.

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.