Hi Jeff,
Yes, that was a typo on my part. Sorry. /var/lib/mysql was empty.
Probably an installation issue but as I said it is moot at this point.
On 7/22/2024 10:00 AM, Jeff Dyke wrote:
But i said, /var/*lib/*mysql. Huuuuuuge difference.
On Mon, Jul 22, 2024 at 9:59 AM gw1500 <[email protected]> wrote:
Hi Jeff,
Thanks for the reply. As I said /var/log/mysql is empty. However
this is a moot point now. I uninstalled maria and installed mysql
clean.
On 7/22/2024 1:05 AM, Jeff Dyke wrote:
Since it was Aria as well, this may not be the final issue, but
every time i see "*[ERROR] Plugin 'InnoDB' registration as a
STORAGE ENGINE failed." *Its due to old ib_logfiles which can be
cleared. They would be in /var/lib/mysql. Also check if you
have "undo00N" logs, normally N = 3. These can safely be cleared
as they will be rebuilt when mariadb finds them missing.
HTH
On Sun, Jul 21, 2024 at 12:32 PM gw1500 via discuss
<[email protected]> wrote:
I've just installed maria on ubuntu but cannot start mariadb:
*× mariadb.service - MariaDB 10.6.18 database server
Loaded: loaded (/lib/systemd/system/mariadb.service;
enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Sun 2024-07-21
16:12:47 UTC; 54s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 3483 ExecStartPre=/usr/bin/install -m 755 -o
mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 3484 ExecStartPre=/bin/sh -c systemctl
unset-environment _WSREP_START_POSITION (code=exited,
status=0/SUCCESS)
Process: 3486 ExecStartPre=/bin/sh -c [ ! -e
/usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..;
/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set>
Process: 3515 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS
$_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited,
status=1/FAILURE)
Main PID: 3515 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 114ms
Jul 21 16:12:47 dap002 mariadbd[3515]: 2024-07-21 16:12:47 0
[ERROR] InnoDB: Plugin initialization aborted with error
Generic error
Jul 21 16:12:47 dap002 mariadbd[3515]: 2024-07-21 16:12:47 0
[Note] InnoDB: Starting shutdown...
Jul 21 16:12:47 dap002 mariadbd[3515]: 2024-07-21 16:12:47 0
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jul 21 16:12:47 dap002 mariadbd[3515]: 2024-07-21 16:12:47 0
[Note] Plugin 'FEEDBACK' is disabled.
Jul 21 16:12:47 dap002 mariadbd[3515]: 2024-07-21 16:12:47 0
[ERROR] Could not open mysql.plugin table: "Unknown storage
engine 'Aria'". Some plugins may be not loaded
Jul 21 16:12:47 dap002 mariadbd[3515]: 2024-07-21 16:12:47 0
[ERROR] Failed to initialize plugins.
Jul 21 16:12:47 dap002 mariadbd[3515]: 2024-07-21 16:12:47 0
[ERROR] Aborting
Jul 21 16:12:47 dap002 systemd[1]: mariadb.service: Main
process exited, code=exited, status=1/FAILURE
Jul 21 16:12:47 dap002 systemd[1]: mariadb.service: Failed
with result 'exit-code'.
Jul 21 16:12:47 dap002 systemd[1]: Failed to start MariaDB
10.6.18 database server.
*I searched for this error (Unknown storage engine Aria) but
the solution is to remove the log from /var/log/mysql.
However, that directory is empty. If ubuntu puts that log
somewhere else I cannot find it. Can someone point me in the
right direction for resolving this? TIA.
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
