mariadb does not run

[Lucio Crusca]

Until yesterday I had mariadb 10.6 running on my system (bookworm/sid).
It was behaving strangely, so I decided to stop it, uninstall it, remove
all databases during uninstall (it's a developer system, so no real data
to save there) and install it again.

Before reinstalling it, I checked that /var/lib/mysql did not exist
anymore. I even manually removed /etc/mysql along with all the contained
files and purged dbconfig-common (just in case it matters), then I
rebooted the system and finally I installed mariadb-server with its
dependencies using aptitude. Installation went through without errors,
but it did not ask me to set a password for the mariadb root user (maybe
that's ok, I'm not sure).

However now mariadb does not run anymore, complaining with:

# systemctl status mariadb
× mariadb.service - MariaDB 10.6.7 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled;
vendor preset: enabled)
Active: failed (Result: exit-code) since Mon 2022-05-02 10:45:24
CEST; 8min ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 4879 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root
-d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 4880 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 4882 ExecStartPre=/bin/sh -c [ ! -e
/usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..;
/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment
_WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 4890 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS
$_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 4890 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 136ms

mag 02 10:45:24 t470 mariadbd[4890]: 2022-05-02 10:45:24 0 [ERROR] Could
not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some
plugins may be not loaded
mag 02 10:45:24 t470 mariadbd[4890]: 2022-05-02 10:45:24 0 [ERROR] Can't
open and lock privilege tables: Table 'mysql.servers' doesn't exist
mag 02 10:45:24 t470 mariadbd[4890]: 2022-05-02 10:45:24 0 [Note] Server
socket created on IP: '0.0.0.0'.
mag 02 10:45:24 t470 mariadbd[4890]: 2022-05-02 10:45:24 0 [Note] Server
socket created on IP: '::'.
mag 02 10:45:24 t470 mariadbd[4890]: 2022-05-02 10:45:24 0 [ERROR] Fatal
error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
mag 02 10:45:24 t470 mariadbd[4890]: 2022-05-02 10:45:24 0 [ERROR] Aborting
mag 02 10:45:24 t470 mariadbd[4890]: Warning: Memory not freed: 280
mag 02 10:45:24 t470 systemd[1]: mariadb.service: Main process exited,
code=exited, status=1/FAILURE
mag 02 10:45:24 t470 systemd[1]: mariadb.service: Failed with result
'exit-code'.
mag 02 10:45:24 t470 systemd[1]: Failed to start MariaDB 10.6.7 database
server.

Any clues?

[Lucio Crusca]

Il 02/05/22 12:54, mick crane ha scritto:
> I don't know anything about this but
> https://dba.stackexchange.com/questions/184283/mariadb-10-1-galera-cluster-error
>
> says The source of this error

Thanks but... it's not the same error, nor the same context.

[to...@tuxteam.de]

Have you tried to start the mariadb server by hand?

Cheers
--
t

[Lucio Crusca]

Il 02/05/22 15:46, to...@tuxteam.de ha scritto:

> Have you tried to start the mariadb server by hand?

Yes, I've tried with:

# mysqld_safe

but it exits almost immediately and it logs the same errors reported by
`systemd status mariadb`

[Larry Martell]

mysqld_safe is a shell script - you could try running it with sh -x to
see what it's doing and/or how it fails.

[Lucio Crusca]

Il 02/05/22 17:43, Larry Martell ha scritto:

> mysqld_safe is a shell script - you could try running it with sh -x to
> see what it's doing and/or how it fails.

Here's to you:


# bash -x mysqld_safe
+ KILL_MYSQLD=1
+ MYSQLD=
+ niceness=0
+ nowatch=0
+ mysqld_ld_preload=
+ mysqld_ld_library_path=
+ flush_caches=0
+ numa_interleave=0
+ wsrep_on=0
+ dry_run=0
+ defaults_group_suffix=
+ logging=init
+ want_syslog=0
+ syslog_tag=
+ user=mysql
+ group=mysql
+ pid_file=
+ err_log=
+ err_log_base=
+ skip_err_log=0
+ syslog_tag_mysqld=mysqld
+ syslog_tag_mysqld_safe=mysqld_safe
+ trap '' 1 2 3 15
+ umask 007
+ UMASK=0640
++ echo 0640
++ sed -e 's/[^0246]//g'
+ fmode=0640
++ echo 0640
++ cut -c1
+ octalp=0
++ echo 0640
++ wc -c
++ sed -e 's/ //g'
+ fmlen=5
+ '[' x0 '!=' x0 -o x0640 '!=' x0640 -o x5 '!=' x5 ']'
++ cut -c3-4
++ echo 0640
+ fmode=40
+ fmode=640
+ '[' x0640 '!=' x0640 ']'
+ defaults=
+ case "$1" in
+ wsrep_start_position_opt=
++ dirname mysqld_safe
+ MY_PWD=.
++ cd ./..
++ pwd
+ MY_PWD=/
+ test -n '' -a -d ''
+ test -x //bin/mariadbd
+ test -x //libexec/mariadbd
+ test -x //sbin/mariadbd
+ MY_BASEDIR_VERSION=/
+ ledir=//sbin
++ find_in_bin mariadbd-safe-helper
++ test -x //bin/mariadbd-safe-helper
++ echo //bin/mariadbd-safe-helper
+ helper=//bin/mariadbd-safe-helper
++ find_in_bin my_print_defaults
++ test -x //bin/my_print_defaults
++ echo //bin/my_print_defaults
+ print_defaults=//bin/my_print_defaults
+ command -v //bin/mariadbd-safe-helper --help
+ helper_exist=0
+ test -d //data/mysql
+ test -d //var/mysql
+ DATADIR=/var/lib/mysql
+ test -z ''
+ test -r /var/lib/mysql/my.cnf
+ MYSQL_HOME=/
+ export MYSQL_HOME
+ args=
+ SET_USER=2
++ //bin/my_print_defaults --loose-verbose --mysqld
+ parse_arguments
+ test 2 -eq 2
+ SET_USER=0
+ unrecognized_handling=complain
++ //bin/my_print_defaults --loose-verbose mysqld_safe safe_mysqld
mariadb_safe mariadbd-safe
+ parse_arguments
+ unrecognized_handling=collect
+ parse_arguments
+ '[' -n '' ']'
+ for dir in lib64/mysql/plugin lib64/plugin lib/mysql/plugin lib/plugin
+ '[' -d //lib64/mysql/plugin ']'
+ for dir in lib64/mysql/plugin lib64/plugin lib/mysql/plugin lib/plugin
+ '[' -d //lib64/plugin ']'
+ for dir in lib64/mysql/plugin lib64/plugin lib/mysql/plugin lib/plugin
+ '[' -d //lib/mysql/plugin ']'
+ plugin_dir=//lib/mysql/plugin
+ break
+ '[' -z //lib/mysql/plugin ']'
+ plugin_dir=//lib/mysql/plugin
+ '[' 0 -eq 1 ']'
+ '[' 0 -eq 1 ']'
+ '[' -n '' -o 0 -eq 0 ']'
+ '[' -n '' ']'
+ '[' -n '' ']'
++ uname -n
+ err_log=/var/lib/mysql/t470.err
+ append_arg_to_args --log-error=/var/lib/mysql/t470.err
++ shell_quote_string --log-error=/var/lib/mysql/t470.err
++ echo --log-error=/var/lib/mysql/t470.err
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ args=' --log-error=/var/lib/mysql/t470.err'
+ '[' 0 -eq 1 ']'
+ log_notice 'Logging to '\''/var/lib/mysql/t470.err'\''.'
+ log_generic daemon.notice 'Logging to '\''/var/lib/mysql/t470.err'\''.'
+ '[' 0 -eq 1 ']'
+ priority=daemon.notice
+ shift
++ date '+%y%m%d %H:%M:%S'
+ msg='220502 22:36:41 mysqld_safe Logging to
'\''/var/lib/mysql/t470.err'\''.'
+ echo '220502 22:36:41 mysqld_safe Logging to
'\''/var/lib/mysql/t470.err'\''.'
220502 22:36:41 mysqld_safe Logging to '/var/lib/mysql/t470.err'.
+ case $logging in
+ logging=file
+ USER_OPTION=
+ test -w / -o root = root
+ test mysql '!=' root -o 0 = 1
+ USER_OPTION=--user=mysql
+ GROUP_OPTION=--group=mysql
+ test -n ''
+ test -n ''
+ safe_mysql_unix_port=/run/mysqld/mysqld.sock
++ dirname /run/mysqld/mysqld.sock
+ mysql_unix_port_dir=/run/mysqld
+ '[' '!' -d /run/mysqld -a 0 -eq 0 ']'
+ test -z ''
+ MYSQLD=mariadbd
+ test '!' -x //sbin/mariadbd
+ test -z ''
++ uname -n
+ pid_file=t470.pid
+ append_arg_to_args --pid-file=t470.pid
++ shell_quote_string --pid-file=t470.pid
++ echo --pid-file=t470.pid
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ args=' --log-error=/var/lib/mysql/t470.err --pid-file=t470.pid'
+ case "$pid_file" in
+ pid_file=/var/lib/mysql/t470.pid
+ test -n ''
+ test -n ''
+ test 0 -eq 0
+ NOHUP_NICENESS=nohup
+ nohup nice
++ nice
+ normal_niceness=0
++ nohup nice
+ nohup_niceness=0
+ numeric_nice_values=1
+ for val in $normal_niceness $nohup_niceness
+ case "$val" in
+ for val in $normal_niceness $nohup_niceness
+ case "$val" in
+ test 1 -eq 1
++ expr 0 - 0
+ nice_value_diff=0
+ test 1 -eq 0
+ test -n ''
+ test -f /var/lib/mysql/t470.pid
+ true
+ test 0 -eq 1
+ test 0 -eq 1
++ mysqld_ld_preload_text
++ text=
++ '[' -n '' ']'
++ '[' -n '' ']'
++ echo ''
+ cmd=nohup
+ '[' 0 -eq 1 ']'
+ true
+ test 0 -eq 1
+ test 0 -eq 1
+ for i in "$ledir/$MYSQLD" "$defaults_group_suffix" "$defaults"
"--basedir=$MY_BASEDIR_VERSION" "--datadir=$DATADIR"
"--plugin-dir=$plugin_dir" "$USER_OPTION"
++ shell_quote_string //sbin/mariadbd
++ echo //sbin/mariadbd
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ cmd='nohup //sbin/mariadbd'
+ for i in "$ledir/$MYSQLD" "$defaults_group_suffix" "$defaults"
"--basedir=$MY_BASEDIR_VERSION" "--datadir=$DATADIR"
"--plugin-dir=$plugin_dir" "$USER_OPTION"
++ shell_quote_string ''
++ echo ''
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ cmd='nohup //sbin/mariadbd '
+ for i in "$ledir/$MYSQLD" "$defaults_group_suffix" "$defaults"
"--basedir=$MY_BASEDIR_VERSION" "--datadir=$DATADIR"
"--plugin-dir=$plugin_dir" "$USER_OPTION"
++ shell_quote_string ''
++ echo ''
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ cmd='nohup //sbin/mariadbd '
+ for i in "$ledir/$MYSQLD" "$defaults_group_suffix" "$defaults"
"--basedir=$MY_BASEDIR_VERSION" "--datadir=$DATADIR"
"--plugin-dir=$plugin_dir" "$USER_OPTION"
++ shell_quote_string --basedir=/
++ echo --basedir=/
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ cmd='nohup //sbin/mariadbd --basedir=/'
+ for i in "$ledir/$MYSQLD" "$defaults_group_suffix" "$defaults"
"--basedir=$MY_BASEDIR_VERSION" "--datadir=$DATADIR"
"--plugin-dir=$plugin_dir" "$USER_OPTION"
++ shell_quote_string --datadir=/var/lib/mysql
++ echo --datadir=/var/lib/mysql
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ cmd='nohup //sbin/mariadbd --basedir=/ --datadir=/var/lib/mysql'
+ for i in "$ledir/$MYSQLD" "$defaults_group_suffix" "$defaults"
"--basedir=$MY_BASEDIR_VERSION" "--datadir=$DATADIR"
"--plugin-dir=$plugin_dir" "$USER_OPTION"
++ shell_quote_string --plugin-dir=//lib/mysql/plugin
++ echo --plugin-dir=//lib/mysql/plugin
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ cmd='nohup //sbin/mariadbd --basedir=/ --datadir=/var/lib/mysql
--plugin-dir=//lib/mysql/plugin'
+ for i in "$ledir/$MYSQLD" "$defaults_group_suffix" "$defaults"
"--basedir=$MY_BASEDIR_VERSION" "--datadir=$DATADIR"
"--plugin-dir=$plugin_dir" "$USER_OPTION"
++ shell_quote_string --user=mysql
++ echo --user=mysql
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ cmd='nohup //sbin/mariadbd --basedir=/ --datadir=/var/lib/mysql
--plugin-dir=//lib/mysql/plugin --user=mysql'
+ cmd='nohup //sbin/mariadbd --basedir=/ --datadir=/var/lib/mysql
--plugin-dir=//lib/mysql/plugin --user=mysql
--log-error=/var/lib/mysql/t470.err --pid-file=t470.pid'
+ '[' 0 -eq 1 ']'
+ test -n nohup
+ cmd='nohup //sbin/mariadbd --basedir=/ --datadir=/var/lib/mysql
--plugin-dir=//lib/mysql/plugin --user=mysql
--log-error=/var/lib/mysql/t470.err --pid-file=t470.pid < /dev/null'
+ log_notice 'Starting mariadbd daemon with databases from /var/lib/mysql'
+ log_generic daemon.notice 'Starting mariadbd daemon with databases
from /var/lib/mysql'
+ '[' 0 -eq 1 ']'
+ priority=daemon.notice
+ shift
++ date '+%y%m%d %H:%M:%S'
+ msg='220502 22:36:41 mysqld_safe Starting mariadbd daemon with
databases from /var/lib/mysql'
+ echo '220502 22:36:41 mysqld_safe Starting mariadbd daemon with
databases from /var/lib/mysql'
220502 22:36:41 mysqld_safe Starting mariadbd daemon with databases from
/var/lib/mysql
+ case $logging in
+ '[' 0 -eq 0 ']'
+ echo '220502 22:36:41 mysqld_safe Starting mariadbd daemon with
databases from /var/lib/mysql'
+ //bin/mariadbd-safe-helper mysql log /var/lib/mysql/t470.err
+ fast_restart=0
+ max_fast_restarts=5
+ have_sleep=1
+ expr hxB : '.*x'
+ :
+ max_wsrep_restarts=0
+ true
+ rm -f /var/lib/mysql/t470.pid
++ date +%M%S
+ start_time=3641
+ test 0 -eq 1
+ eval_log_error 'nohup //sbin/mariadbd --basedir=/
--datadir=/var/lib/mysql --plugin-dir=//lib/mysql/plugin --user=mysql
--log-error=/var/lib/mysql/t470.err --pid-file=t470.pid < /dev/null'
+ local 'cmd=nohup //sbin/mariadbd --basedir=/
--datadir=/var/lib/mysql --plugin-dir=//lib/mysql/plugin --user=mysql
--log-error=/var/lib/mysql/t470.err --pid-file=t470.pid < /dev/null'
+ case $logging in
+ '[' 0 -eq 0 ']'
++ shell_quote_string //bin/mariadbd-safe-helper
++ echo //bin/mariadbd-safe-helper
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
++ shell_quote_string /var/lib/mysql/t470.err
++ echo /var/lib/mysql/t470.err
++ sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
+ cmd='nohup //sbin/mariadbd --basedir=/ --datadir=/var/lib/mysql
--plugin-dir=//lib/mysql/plugin --user=mysql
--log-error=/var/lib/mysql/t470.err --pid-file=t470.pid < /dev/null 2>&1
| //bin/mariadbd-safe-helper mysql log /var/lib/mysql/t470.err'
+ test 0 -eq 1
+ eval 'nohup //sbin/mariadbd --basedir=/ --datadir=/var/lib/mysql
--plugin-dir=//lib/mysql/plugin --user=mysql
--log-error=/var/lib/mysql/t470.err --pid-file=t470.pid < /dev/null 2>&1
| //bin/mariadbd-safe-helper mysql log /var/lib/mysql/t470.err'
++ nohup //sbin/mariadbd --basedir=/ --datadir=/var/lib/mysql
--plugin-dir=//lib/mysql/plugin --user=mysql
--log-error=/var/lib/mysql/t470.err --pid-file=t470.pid
++ //bin/mariadbd-safe-helper mysql log /var/lib/mysql/t470.err
++ date +%M%S
+ end_time=3641
+ test '!' -f /var/lib/mysql/t470.pid
+ break
+ log_notice 'mysqld from pid file /var/lib/mysql/t470.pid ended'
+ log_generic daemon.notice 'mysqld from pid file
/var/lib/mysql/t470.pid ended'
+ '[' 0 -eq 1 ']'
+ priority=daemon.notice
+ shift
++ date '+%y%m%d %H:%M:%S'
+ msg='220502 22:36:41 mysqld_safe mysqld from pid file
/var/lib/mysql/t470.pid ended'
+ echo '220502 22:36:41 mysqld_safe mysqld from pid file
/var/lib/mysql/t470.pid ended'
220502 22:36:41 mysqld_safe mysqld from pid file /var/lib/mysql/t470.pid
ended
+ case $logging in
+ '[' 0 -eq 0 ']'
+ echo '220502 22:36:41 mysqld_safe mysqld from pid file
/var/lib/mysql/t470.pid ended'
+ //bin/mariadbd-safe-helper mysql log /var/lib/mysql/t470.err


Seems to me the script is doing what it is supposed to do, but mariadb
exits immediately.

[to...@tuxteam.de]

On Mon, May 02, 2022 at 10:44:58PM +0200, Lucio Crusca wrote:
> Il 02/05/22 17:43, Larry Martell ha scritto:
> > mysqld_safe is a shell script - you could try running it with sh -x to
> > see what it's doing and/or how it fails.
>
> Here's to you:
>

According to this huge mess, the log file is somewhere in
/var/lib/mysql/t470.err (the number '470' is the process
ID, aka PID, so it will change at every start).

Have you had a look at this?

Cheers
--
t

[Lucio Crusca]

Il 03/05/22 07:04, to...@tuxteam.de ha scritto:

> According to this huge mess, the log file is somewhere in
> /var/lib/mysql/t470.err (the number '470' is the process
> ID, aka PID, so it will change at every start).
>

Actually t470 is my hostname so it stays the same.

I had already looked at that logfile and I had already written here that
the error messages in that logfile are the same of those shown by
`systemctl status mariadb`:

https://lists.debian.org/debian-user/2022/05/msg00041.html

which are reported in my first post:

https://lists.debian.org/debian-user/2022/05/msg00027.html

but english is not my native language, maybe I did not express myself
clearly enough. I hope it's now clear.

[to...@tuxteam.de]

On Tue, May 03, 2022 at 08:39:12AM +0200, Lucio Crusca wrote:
> Il 03/05/22 07:04, to...@tuxteam.de ha scritto:
> > According to this huge mess, the log file is somewhere in
> > /var/lib/mysql/t470.err (the number '470' is the process
> > ID, aka PID, so it will change at every start).
> >
>
> Actually t470 is my hostname so it stays the same.

Ah, got it, thanks.

> I had already looked at that logfile and I had already written here that the
> error messages in that logfile are the same of those shown by `systemctl
> status mariadb`:
>
> https://lists.debian.org/debian-user/2022/05/msg00041.html
>
> which are reported in my first post:
>
> https://lists.debian.org/debian-user/2022/05/msg00027.html
>
> but english is not my native language, maybe I did not express myself
> clearly enough. I hope it's now clear.

Sorry I missed that. It's most probably my bad attention spam,
not your English. That one is no worse than mine :-)

Looking at the mariadb entry in my process list (Debian Bullseye),
I see (breaking up the long line at spaces):

mysql 2473 0.0 0.6 1608036 98724 ? Sl 06:15 0:03
/usr/sbin/mariadbd --basedir=/usr --datadir=/var/lib/mysql
--plugin-dir=/usr/lib/mysql/plugin --user=mysql
--skip-log-error --pid-file=/run/mysqld/mysqld.pid
--socket=/run/mysqld/mysqld.sock

If I've read the output of your "-x" run correctly, it's trying
to start with "--basedir=/" instead of /usr. This, at least, looks
fishy to me.

Any chance you could try to run a command line as above and see
whether the daemon likes to start?

This would give us something to bisect the problem.

Cheers
--
t

[Lucio Crusca]

Il 03/05/22 09:47, to...@tuxteam.de ha scritto:

> Any chance you could try to run a command line as above and see
> whether the daemon likes to start?

# /usr/sbin/mariadbd --basedir=/usr --datadir=/var/lib/mysql

--plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error
--pid-file=/run/mysqld/mysqld.pid --socket=/run/mysqld/mysqld.sock

2022-05-03 10:12:21 0 [Note] /usr/sbin/mariadbd (server
10.6.7-MariaDB-3) starting as process 47102 ...
2022-05-03 10:12:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-03 10:12:21 0 [Note] InnoDB: Number of pools: 1
2022-05-03 10:12:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-05-03 10:12:21 0 [Note] InnoDB: Using liburing
2022-05-03 10:12:21 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-05-03 10:12:21 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-03 10:12:21 0 [Note] InnoDB: 128 rollback segments are active.
2022-05-03 10:12:21 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-05-03 10:12:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-05-03 10:12:21 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-05-03 10:12:21 0 [Note] InnoDB: 10.6.7 started; log sequence number
33110; transaction id 4
2022-05-03 10:12:21 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-05-03 10:12:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-03 10:12:21 0 [ERROR] Could not open mysql.plugin table: "Table

'mysql.plugin' doesn't exist". Some plugins may be not loaded

2022-05-03 10:12:21 0 [Note] InnoDB: Buffer pool(s) load completed at
220503 10:12:21
2022-05-03 10:12:21 0 [ERROR] Can't open and lock privilege tables:

Table 'mysql.servers' doesn't exist

2022-05-03 10:12:21 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-05-03 10:12:21 0 [Note] Server socket created on IP: '::'.
2022-05-03 10:12:21 0 [ERROR] Fatal error: Can't open and lock privilege

tables: Table 'mysql.db' doesn't exist

2022-05-03 10:12:21 0 [ERROR] Aborting

Warning: Memory not freed: 280

> This would give us something to bisect the problem.

I'm afraid it does not, at least it does not give me anything, since it
shows the same error messages as before.

[to...@tuxteam.de]

On Tue, May 03, 2022 at 10:14:55AM +0200, Lucio Crusca wrote:
> Il 03/05/22 09:47, to...@tuxteam.de ha scritto:
> > Any chance you could try to run a command line as above and see
> > whether the daemon likes to start?
>
> # /usr/sbin/mariadbd --basedir=/usr --datadir=/var/lib/mysql
> --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error
> --pid-file=/run/mysqld/mysqld.pid --socket=/run/mysqld/mysqld.sock

[...]

> 2022-05-03 10:12:21 0 [ERROR] Could not open mysql.plugin table: "Table
> 'mysql.plugin' doesn't exist". Some plugins may be not loaded

[...]

> 2022-05-03 10:12:21 0 [ERROR] Can't open and lock privilege tables: Table
> 'mysql.servers' doesn't exist

[...]

> 2022-05-03 10:12:21 0 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.db' doesn't exist

> I'm afraid it does not, at least it does not give me anything, since it
> shows the same error messages as before.

...but at least those seem clearer now to my slow brain :)

The way I interpret this is that mysql isn't finding some tables
it expects at start (possibly parts of the metaschema). I'd expect
those to come along with a new installation. Perhaps something went
astray during your last attempt.

Perhaps uninstalling your mariadb server and re-installing it
seems the best way forward (I think to remember you said you had
no valuable data).

Try `sudo apt purge mariadb-server', watch out for error messages,
then re-install. Perhaps that helps.

Cheers
--
tomás

[Lucio Crusca]

Il 03/05/22 11:28, to...@tuxteam.de scritto:

> Try `sudo apt purge mariadb-server', watch out for error messages,
> then re-install. Perhaps that helps.

I didn't mention that in my first post, but I've already tried purging
and reinstalling several times. The one I reported is only the last one,
e.g. the more comprehensive one that included manual removal of
/etc/mysql and reboot before reinstalling. I always got the same results.

[Stephan Seitz]

Am Di, Mai 03, 2022 at 11:39:12 +0200 schrieb Lucio Crusca:
>Il 03/05/22 11:28, to...@tuxteam.de scritto:
>>Try `sudo apt purge mariadb-server', watch out for error messages,
>>then re-install. Perhaps that helps.
>I didn't mention that in my first post, but I've already tried purging
>and reinstalling several times. The one I reported is only the last one,

The package mariadb-server is a meta package. It depends on the current
version of the server package, e.g. mariadb-server-10.5.

>e.g. the more comprehensive one that included manual removal of
>/etc/mysql and reboot before reinstalling. I always got the same
>results.

Make sure that /var/lib/mysql is empty as well after the purge.

Stephan

--
| If your life was a horse, you'd have to shoot it. |

[to...@tuxteam.de]

This is strange. What does dpkg -l "*mariadb*" say?

Cheers
--
t

[Lucio Crusca]

Il 03/05/22 12:05, to...@tuxteam.de ha scritto:

> What does dpkg -l "*mariadb*" say?

# LANG=en dpkg -l "*mariadb*" | grep ^ii
ii libdbd-mariadb-perl 1.22-1 amd64 Perl5 database
interface to the MariaDB/MySQL databases
ii libmariadb3:amd64 1:10.6.7-3 amd64 MariaDB
database client library
ii mariadb-client 1:10.6.7-3 all MariaDB
database client (metapackage depending on the latest version)
ii mariadb-client-10.6 1:10.6.7-3 amd64 MariaDB
database client binaries
ii mariadb-client-core-10.6 1:10.6.7-3 amd64 MariaDB
database core client binaries
ii mariadb-common 1:10.6.7-3 all MariaDB common
configuration files
ii mariadb-server 1:10.6.7-3 all MariaDB
database server (metapackage depending on the latest version)
ii mariadb-server-10.6 1:10.6.7-3 amd64 MariaDB
database server binaries
ii mariadb-server-core-10.6 1:10.6.7-3 amd64 MariaDB
database core server files



Il 03/05/22 11:58, Stephan Seitz ha scritto:

> Make sure that /var/lib/mysql is empty as well after the purge.

Already checked: it's more than empty, it does not exist anymore and it
gets created again upon reinstall.

[Lucio Crusca]

I ended up installing MariaDB 10.8 using the MariaDB unofficial Debian
repository and it works...

That makes me suspect there's a problem with the official
mariadb-server-core-10.6 Debian package, but it's very strange no such
bug has been filed yet (how could that happen only to me?).

Unfortunately I cannot afford keeping my dev system unusable for the
time required to assist maintainers in bisecting the problem. Besides
I'm on Sid, so such bugs are to be expected from time to time.

Thanks anyway for your assistance.

[Greg Wooledge]

On Tue, May 03, 2022 at 04:26:13PM +0200, Lucio Crusca wrote:
> That makes me suspect there's a problem with the official
> mariadb-server-core-10.6 Debian package, but it's very strange no such bug
> has been filed yet (how could that happen only to me?).

For any given bug, *someone* has to be the first to encounter it. If this
particular bug only happens on new installs of the package, and not on
upgrades from stable, it makes sense that relatively few people running
unstable/testing would encounter it.

(Most people running unstable/testing would have already had mariadb
installed and running from an older version, so this would just be an
upgrade. Also, relatively few people who run a mariadb server would be
using unstable/testing. One doesn't typically run a database on an
unstable platform, outside of development situations.)