brew mysql - fail #5815
Replies: 1 comment
-
Outdated, finally i removed whole databases and create from dumps again. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Output of
brew config
Output of
brew doctor
Description of issue
I have issue with brew service mysql. It happens to me once for a time. To be honest, this part of brew is little black box to me. So..
Now, when I launch macOS and try to start Homebrew, there I can see brew service mysql as "stopped".
When I try
brew services start mysql
I got:In folder "/Users/michalkuba/Library/LaunchAgents/" isn`t any file starting with name homebrew..
Even ChatGPT isn`t helpful.
I
ve tried many uninstalls, installs etc., but without success. Important for me is don
t loose my databases, if it is possible.Please, can you give me a hint? Or do you need more informations about my brew setup. Let me know!
Thanks
EDIT:
This is in my /opt/homebrew/var/mysql/mysql_error.log logfile:
v error logu přímo v opt/homebrew/var/mysql/mysql_error.log je
2024-12-19T11:15:12.6NZ mysqld_safe Logging to '/opt/homebrew/var/mysql/mysql_error.log'.
2024-12-19T11:15:12.6NZ mysqld_safe Starting mysqld daemon with databases from /opt/homebrew/var/mysql
2024-12-19T11:15:12.572839Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-12-19T11:15:12.739475Z 0 [System] [MY-010116] [Server] /opt/homebrew/opt/mysql/bin/mysqld (mysqld 9.0.1) starting as process 92590
2024-12-19T11:15:12.741984Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-12-19T11:15:12.742177Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-12-19T11:15:12.742344Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /opt/homebrew/var/mysql/ is case insensitive
2024-12-19T11:15:12.747625Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-19T11:15:12.783418Z 1 [ERROR] [MY-012224] [InnoDB] Header page consists of zero bytes in datafile: ./ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/9.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-12-19T11:15:12.783950Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-12-19T11:15:12.783984Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-12-19T11:15:12.785580Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-12-19T11:15:12.785668Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-12-19T11:15:12.785820Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-12-19T11:15:12.788520Z 0 [System] [MY-010910] [Server] /opt/homebrew/opt/mysql/bin/mysqld: Shutdown complete (mysqld 9.0.1) Homebrew.
2024-12-19T11:15:12.788532Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-12-19T11:15:12.6NZ mysqld_safe mysqld from pid file /opt/homebrew/var/mysql/Michal-MacBook-Pro.local.pid ended
241219 12:15:13 mysqld_safe Starting mariadbd daemon with databases from /opt/homebrew/var/mysql
2024-12-19 12:15:13 0 [Note] Starting MariaDB 11.6.2-MariaDB-log source revision d8dad8c3b54cd09fefce7bc3b9749f427eed9709 server_uid bmY3JH0XCFYRjlXwMrc32flfHEU= as process 92698
2024-12-19 12:15:13 0 [Warning] Setting lower_case_table_names=2 because file system for /opt/homebrew/var/mysql/ is case insensitive
2024-12-19 12:15:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-12-19 12:15:13 0 [Note] InnoDB: Number of transaction pools: 1
2024-12-19 12:15:13 0 [Note] InnoDB: Using generic crc32 instructions
2024-12-19 12:15:13 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-12-19 12:15:13 0 [Note] InnoDB: Completed initialization of buffer pool
2024-12-19 12:15:13 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
2024-12-19 12:15:13 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-12-19 12:15:13 0 [Note] InnoDB: Starting shutdown...
2024-12-19 12:15:14 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-12-19 12:15:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-12-19 12:15:14 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-12-19 12:15:14 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
2024-12-19 12:15:14 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-12-19 12:15:14 0 [ERROR] Aborting
241219 12:15:14 mysqld_safe mysqld from pid file /opt/homebrew/var/mysql/Michal-MacBook-Pro.local.pid ended
Beta Was this translation helpful? Give feedback.
All reactions