Score:0

mysql server failed when I run mysql.server start

tw flag

I use macOS Big Sur(11.5.1) and MariaDB(10.8.3_1) with Brew. After some manipulations with Docker(my guess) my mysql.server stopped working. I cannot run my local MySQL server.

These lines I have in the console when text command "mysql.server start"

Starting MariaDB
.221028 01:36:17 mysqld_safe Logging to '/usr/local/var/mysql/MacBook-Pro-My.local.err'.
221028 01:36:18 mysqld_safe Starting mariadbd daemon with databases from /usr/local/var/mysql
/usr/local/bin/mysql.server: line 263: kill: (8447) - No such process
/usr/local/bin/mysql.server: line 276: log_failure_msg: command not found

Content from /usr/local/var/mysql/MacBook-Pro-My.local.err

221028 01:42:45 mysqld_safe Starting mariadbd daemon with databases from /usr/local/var/mysql
2022-10-28  1:42:45 0 [Note] /usr/local/opt/mariadb/bin/mariadbd (server 10.8.3-MariaDB) starting as process 11622 ...
2022-10-28  1:42:45 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2022-10-28  1:42:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-10-28  1:42:45 0 [Note] InnoDB: Number of transaction pools: 1
2022-10-28  1:42:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-10-28  1:42:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2022-10-28  1:42:45 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-28  1:42:45 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
2022-10-28  1:42:45 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-10-28  1:42:45 0 [Note] InnoDB: Starting shutdown...
2022-10-28  1:42:45 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-28  1:42:45 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-28  1:42:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-28  1:42:45 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-28  1:42:45 0 [ERROR] Aborting
221028 01:42:45 mysqld_safe mysqld from pid file /usr/local/var/mysql/MacBook-Pro-My.local.pid ended

I've already tried:

  • delete ib_logfile0, it doesn't help
  • reinstall MariaDB using brew, it doesn't help

Please, who knows how to debug this issue or solve it, help me.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.