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/ >> <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]
