Mariadb Hestia 1.9 beta1 error

1

I installed Hestia 1.9 beta1, I see an error in the MariaDB logs

2025-01-12  1:01:20 0 [Note] Starting MariaDB 11.4.4-MariaDB-ubu2404 source revision e9a502df08bad16aa8a354e854f3c014b1380e32 server_uid 48Qsmxa6S0ZjbyXlKTx0ijMRZsQ= as process 1356
2025-01-12  1:01:20 0 [Note] InnoDB: Compressed tables use zlib 1.3
2025-01-12  1:01:20 0 [Note] InnoDB: Number of transaction pools: 1
2025-01-12  1:01:20 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-01-12  1:01:20 0 [Note] InnoDB: Using liburing
2025-01-12  1:01:20 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2025-01-12  1:01:20 0 [Note] InnoDB: Initialized memory pressure event listener
2025-01-12  1:01:20 0 [Note] InnoDB: Completed initialization of buffer pool
2025-01-12  1:01:20 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2025-01-12  1:01:20 0 [Note] InnoDB: End of log at LSN=18193023
2025-01-12  1:01:20 0 [Note] InnoDB: Opened 3 undo tablespaces
2025-01-12  1:01:20 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2025-01-12  1:01:20 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-01-12  1:01:20 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2025-01-12  1:01:20 0 [Note] InnoDB: log sequence number 18193023; transaction id 739
2025-01-12  1:01:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-01-12  1:01:20 0 [Note] Plugin 'wsrep-provider' is disabled.
2025-01-12  1:01:20 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-01-12  1:01:21 0 [Note] InnoDB: Buffer pool(s) load completed at 250112  1:01:21
2025-01-12  1:01:23 0 [Note] Server socket created on IP: '127.0.0.1'.
2025-01-12  1:01:23 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2025-01-12  1:01:23 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '11.4.4-MariaDB-ubu2404'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2025-01-12  1:35:10 52 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

As I see on the server /usr/share/mysql there is no such directory at all. How to reinstall Maria? Although the Wordpress database feels good

[client]
port=3306
socket=/run/mysqld/mysqld.sock
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld_safe]
socket=/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/run/mysqld/mysqld.pid
socket=/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
collation-server = utf8mb4_unicode_520_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4

symbolic-links=0
local-infile=0

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=70
max_user_connections=30
wait_timeout=10
interactive_timeout=50
long_query_time=5

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
2

I rebooted the server several times, now there is no error). Ubuntu version 24.04

2025-01-12  2:08:29 0 [Note] Starting MariaDB 11.4.4-MariaDB-ubu2404 source revision e9a502df08bad16aa8a354e854f3c014b1380e32 server_uid 48Qsmxa6S0ZjbyXlKTx0ijMRZsQ= as process 1403
2025-01-12  2:08:29 0 [Note] InnoDB: Compressed tables use zlib 1.3
2025-01-12  2:08:29 0 [Note] InnoDB: Number of transaction pools: 1
2025-01-12  2:08:29 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-01-12  2:08:29 0 [Note] InnoDB: Using liburing
2025-01-12  2:08:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2025-01-12  2:08:29 0 [Note] InnoDB: Initialized memory pressure event listener
2025-01-12  2:08:29 0 [Note] InnoDB: Completed initialization of buffer pool
2025-01-12  2:08:29 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2025-01-12  2:08:29 0 [Note] InnoDB: End of log at LSN=18481205
2025-01-12  2:08:29 0 [Note] InnoDB: Opened 3 undo tablespaces
2025-01-12  2:08:29 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2025-01-12  2:08:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-01-12  2:08:29 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2025-01-12  2:08:29 0 [Note] InnoDB: log sequence number 18481205; transaction id 914
2025-01-12  2:08:29 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-01-12  2:08:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-01-12  2:08:29 0 [Note] Plugin 'wsrep-provider' is disabled.
2025-01-12  2:08:30 0 [Note] InnoDB: Buffer pool(s) load completed at 250112  2:08:30
2025-01-12  2:08:33 0 [Note] Server socket created on IP: '127.0.0.1'.
2025-01-12  2:08:34 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2025-01-12  2:08:34 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '11.4.4-MariaDB-ubu2404'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
3

That file is provided by mariadb-server-core

apt install mariadb-server-core
4

Thank you, as I see it is installed, the error went away by itself)

apt install mariadb-server-core
Reading package lists... Done
Building a dependency tree... Done
Reading status information... Done         
The latest version of the mariadb-server-core package (1:11.4.4+maria~ubu2404) is already installed.
mariadb-server-core is marked as manually installed.
0 packages were updated, 0 new packages were installed, 0 packages were marked for removal, and 0 packages were not updated.
5

It’s strange that the package was installed but the dir doesn’t exist. Does it exist now?

ls -l /usr/share/mysql/
6

I checked it myself, but there is still no catalog)

ls -l /usr/share/mysql/
ls: cannot access '/usr/share/mysql/': No such file or directory

Rebooted Maria again, no error

1 Like
7

I installed 1.9 again now from scratch, I get the same thing

2025-01-15  0:58:55 0 [Note] Starting MariaDB 11.4.4-MariaDB-ubu2404 source revision e9a502df08bad16aa8a354e854f3c014b1380e32 server_uid et/B3VSPXjaEcUUi7spRSZgsot4= as process 1197
2025-01-15  0:58:55 0 [Warning] InnoDB: innodb_open_files 300 should not be greater than the open_files_limit 222
2025-01-15  0:58:55 0 [Note] InnoDB: Compressed tables use zlib 1.3
2025-01-15  0:58:55 0 [Note] InnoDB: Number of transaction pools: 1
2025-01-15  0:58:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-01-15  0:58:55 0 [Note] InnoDB: Using liburing
2025-01-15  0:58:55 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2025-01-15  0:58:55 0 [Note] InnoDB: Initialized memory pressure event listener
2025-01-15  0:58:55 0 [Note] InnoDB: Completed initialization of buffer pool
2025-01-15  0:58:55 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2025-01-15  0:58:56 0 [Note] InnoDB: End of log at LSN=208840
2025-01-15  0:58:56 0 [Note] InnoDB: Opened 3 undo tablespaces
2025-01-15  0:58:56 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2025-01-15  0:58:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-01-15  0:58:56 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2025-01-15  0:58:56 0 [Note] InnoDB: log sequence number 208840; transaction id 162
2025-01-15  0:58:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-01-15  0:58:56 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-01-15  0:58:56 0 [Note] Plugin 'wsrep-provider' is disabled.
2025-01-15  0:58:56 0 [Note] InnoDB: Buffer pool(s) load completed at 250115  0:58:56
2025-01-15  0:59:03 0 [Note] Server socket created on IP: '127.0.0.1'.
2025-01-15  0:59:03 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2025-01-15  0:59:03 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '11.4.4-MariaDB-ubu2404'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2025-01-15  1:03:03 65 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

I reboot the server, the error disappears, but the directory is still missing)

ls -l /usr/share/mysql/
ls: cannot access '/usr/share/mysql/': No such file or directory
8

Did you read this post?

Also, are you using the right my.cnf conf?

1 Like
9

I read that it’s not about the post or the correction, I’m talking about the release, because I’m installing from scratch 1.9, it’s clear that everything can be fixed, now I’m not doing this, I just chose 1.8.12 and updated Maria, but this is testing, so what? It works out for me, so I develop (write) for a possible correction on the part of the release. Or am I missing something?)

ls -l /usr/share/mariadb/
total 2936
drwxr-xr-x 2 root root    4096 янв 15 00:55 bulgarian
drwxr-xr-x 2 root root    4096 янв 15 00:55 charsets
drwxr-xr-x 2 root root    4096 янв 15 00:55 chinese
drwxr-xr-x 2 root root    4096 янв 15 00:55 czech
drwxr-xr-x 2 root root    4096 янв 15 00:55 danish
-rwxr-xr-x 1 root root    3527 окт 30 17:38 debian-start.inc.sh
drwxr-xr-x 2 root root    4096 янв 15 00:55 dutch
-rwxr-xr-x 1 root root      27 окт 30 17:38 echo_stderr
drwxr-xr-x 2 root root    4096 янв 15 00:55 english
drwxr-xr-x 2 root root    4096 янв 15 00:55 estonian
-rw-r--r-- 1 root root 2165262 окт 30 17:38 fill_help_tables.sql
drwxr-xr-x 2 root root    4096 янв 15 00:55 french
drwxr-xr-x 2 root root    4096 янв 15 00:55 georgian
drwxr-xr-x 2 root root    4096 янв 15 00:55 german
drwxr-xr-x 2 root root    4096 янв 15 00:55 greek
drwxr-xr-x 2 root root    4096 янв 15 00:55 hindi
drwxr-xr-x 2 root root    4096 янв 15 00:55 hungarian
drwxr-xr-x 2 root root    4096 янв 15 00:55 italian
drwxr-xr-x 2 root root    4096 янв 15 00:55 japanese
drwxr-xr-x 2 root root    4096 янв 15 00:55 korean
-rw-r--r-- 1 root root    1683 окт 30 18:15 maria_add_gis_sp_bootstrap.sql
-rw-r--r-- 1 root root    1958 окт 30 17:38 mariadb_performance_tables.sql
-rw-r--r-- 1 root root  623733 окт 30 18:15 mariadb_sys_schema.sql
-rw-r--r-- 1 root root    3327 окт 30 17:38 mariadb_system_tables_data.sql
-rw-r--r-- 1 root root   30685 окт 30 17:38 mariadb_system_tables.sql
-rw-r--r-- 1 root root   10506 окт 30 17:38 mariadb_test_data_timezone.sql
-rw-r--r-- 1 root root    1786 окт 30 17:38 mariadb_test_db.sql
-rwxr-xr-x 1 root root    9594 окт 30 18:15 mini-benchmark
drwxr-xr-x 2 root root    4096 янв 15 00:55 norwegian
drwxr-xr-x 2 root root    4096 янв 15 00:55 norwegian-ny
drwxr-xr-x 2 root root    4096 янв 15 00:55 polish
drwxr-xr-x 2 root root    4096 янв 15 00:55 portuguese
drwxr-xr-x 2 root root    4096 янв 15 00:55 romanian
drwxr-xr-x 2 root root    4096 янв 15 00:55 russian
drwxr-xr-x 2 root root    4096 янв 15 00:55 serbian
drwxr-xr-x 2 root root    4096 янв 15 00:55 slovak
drwxr-xr-x 2 root root    4096 янв 15 00:55 spanish
drwxr-xr-x 2 root root    4096 янв 15 00:55 swahili
drwxr-xr-x 2 root root    4096 янв 15 00:55 swedish
drwxr-xr-x 2 root root    4096 янв 15 00:55 ukrainian
-rw-r--r-- 1 root root    3474 окт 30 18:15 wsrep.cnf
-rwxr-xr-x 1 root root    4979 окт 30 18:15 wsrep_notify
10

I had exactly the same problem with language because /usr/share/mysql/ doesn’t exist when installing MariaDB 11.4 and it’s being referenced by my.cnf conf file provided by Hestia. Please, try the fix as shown in the other post.

11

Yes, thanks again, I did it like this

ln -s /usr/share/mariadb /usr/share/mysql

And the Russian language appeared, that’s right. By the way, the errors that I indicated when opening the topic are also not present in PHPadmin, and that’s good).
I would like to note that when upgrading from 10 to 11 according to the instructions on the forum, there is no such difficulty.
I checked, and it’s there in 1.8.12 after the update

ls -l /usr/share/mysql/
ls: cannot access '/usr/share/mysql/': No such file or directory

I’ll apply the fix now too.

Is it possible to do this out of the box or will I have to fix it after installation every time?

12

Seems version 10.x creates the symbolic link but version 11.4 doesn’t. MariaDB is deprecating the use of mysql references. For example, check the first line when executing mysql command:

❯ mysql -V
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
mysql from 11.4.4-MariaDB, client 15.2 for debian-linux-gnu (x86_64) using  EditLine wrapper

As you are upgrading from version 10.x to 11.x, the dir was already created so you don’t have the same issues as installing from scratch.

13

Right now, if you want to use version 11.4 you should create the symbolic manually or modify the my.cnf conf file. It should be great to fix it from Hestia side but as Hestia supports mysql and mariadb, some changes should be done because both share a few confs.

14

Yes, yes, I’m talking about the release 1.9 Hestia, it would be nice if these changes were already in place.

1 Like