maria-discuss team mailing list archive

[Jogchum Reitsma <jogchum.reitsma@xxxxxxxxx>]

Op 16-11-2022 om 01:49 schreef Daniel Black:
> > The log from this failure (/var/log/mysqld.log):
> >
> > 2022-11-10 20:22:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
> > 2022-11-10 20:22:34 0 [Note] InnoDB: Number of transaction pools: 1
> > 2022-11-10 20:22:34 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
> > 2022-11-10 20:22:34 0 [Note] InnoDB: Using Linux native AIO
> > 2022-11-10 20:22:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
> > 2022-11-10 20:22:34 0 [Note] InnoDB: Completed initialization of buffer pool
> > 2022-11-10 20:22:34 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
> > 2022-11-10 20:22:34 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
> > 2022-11-10 20:22:34 0 [Note] InnoDB: Starting shutdown...
> > 2022-11-10 20:22:35 0 [ERROR] Plugin 'InnoDB' init function returned error.
> > 2022-11-10 20:22:35 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
> > 2022-11-10 20:22:35 0 [Note] Plugin 'FEEDBACK' is disabled.
> > 2022-11-10 20:22:35 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
> > 2022-11-10 20:22:35 0 [ERROR] Unknown/unsupported storage engine: InnoDB
> > 2022-11-10 20:22:35 0 [ERROR] Aborting
> >
> > ##############################################################################################################################
> >
> > No idea how to solve this, again...
> Read Marko's email again.
>
> 10.8+ won't start without a ib_logfile0. This is what not starting looks like.
>
> Start it with at 10.7 version which will recreate ib_logfile0, and if
> you're lucky, you maybe won't have corrupted data because of this.
> Then try 10.8+.
>
> I just correctedhttps://wiki.archlinux.org/title/MariaDB.
>
> If you see other sites saying delete ib_logfile0, please share your
> experience with them
>
> _______________________________________________
> Mailing list:https://launchpad.net/~maria-discuss
> Post to     :maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe :https://launchpad.net/~maria-discuss
> More help   :https://help.launchpad.net/ListHelp

Hi,

So I downloaded and installed 10.7.7.

Bu now I get

/usr/local/mariadb-10.7.7-linux-systemd-x86_64/bin/mysql
ERROR 2002 (HY000): Can't connect to local server through socket 
'/var/run/mysql/mysql.sock'

For now I have chmod /var/run/mysql to 777, so is writable by me when I 
try to start 10.7.7. But indeed the directory is empty.

In both /etc/my.cnf as ~/.my.cnf the socket is set to 
/var/run/mysql/mysql.sock

Hope you have some ideas to solve this one...

regards, Jogchum