Re: [WORKED AROUND] Re: mariadb does not run

2022-05-03 Thread 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 th

[WORKED AROUND] Re: mariadb does not run

2022-05-03 Thread 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?). Unfort

Re: mariadb does not run

2022-05-03 Thread 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-perl1.22-1 amd64Perl5 database interface to the MariaDB/MySQL databases ii libmariadb3:amd64 1:10.6.7-3 amd64

Re: mariadb does not run

2022-05-03 Thread 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 reinstalli

Re: mariadb does not run

2022-05-03 Thread tomas
On Tue, May 03, 2022 at 11:39:12AM +0200, Lucio Crusca wrote: > 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 a

Re: mariadb does not run

2022-05-03 Thread 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,

Re: mariadb does not run

2022-05-03 Thread tomas
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-di

Re: mariadb does not run

2022-05-03 Thread 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/mys

Re: mariadb does not run

2022-05-03 Thread tomas
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). > > > > Ac

Re: mariadb does not run

2022-05-02 Thread 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 lo

Re: mariadb does not run

2022-05-02 Thread tomas
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 s

Re: mariadb does not run

2022-05-02 Thread 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= +

Re: mariadb does not run

2022-05-02 Thread Larry Martell
On Mon, May 2, 2022 at 11:38 AM Lucio Crusca wrote: > > 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

Re: mariadb does not run

2022-05-02 Thread 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`

Re: mariadb does not run

2022-05-02 Thread tomas
On Mon, May 02, 2022 at 02:34:56PM +0200, Lucio Crusca wrote: > 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

Re: mariadb does not run

2022-05-02 Thread mick crane
On 2022-05-02 13:34, Lucio Crusca wrote: 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.

Re: mariadb does not run

2022-05-02 Thread 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.

Re: mariadb does not run

2022-05-02 Thread mick crane
On 2022-05-02 09:55, Lucio Crusca wrote: 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.

mariadb does not run

2022-05-02 Thread Lucio Crusca
rough 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