mysql - mariadb 无法启动服务 macOS

 sumviewbk_405 发布于 2022-11-03 18:36
160802 11:45:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
2016-08-02 11:45:47 4471989184 [Note] /usr/local/Cellar/mariadb/10.1.16/bin/mysqld (mysqld 10.1.16-MariaDB) starting as process 67267 ...
2016-08-02 11:45:47 4471989184 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-02 11:45:47 4471989184 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Memory barrier is not used
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Using SSE crc32 instructions
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Completed initialization of buffer pool
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-02 11:45:47 4471989184 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-02 11:45:47 4471989184 [Note] InnoDB: Waiting for purge to start
2016-08-02 11:45:47 4471989184 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.30-76.3 started; log sequence number 4036637
2016-08-02 11:45:47 123145327255552 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-02 11:45:47 4471989184 [Note] Plugin 'FEEDBACK' is disabled.
2016-08-02 11:45:47 4471989184 [Note] Recovering after a crash using tc.log
2016-08-02 11:45:47 4471989184 [ERROR] Bad magic header in tc log
2016-08-02 11:45:47 4471989184 [ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete tc log and start mysqld with --tc-heuristic-recover={commit|rollback}
2016-08-02 11:45:47 4471989184 [ERROR] Can't init tc log
2016-08-02 11:45:47 4471989184 [ERROR] Aborting

160802 11:45:49 mysqld_safe mysqld from pid file /usr/local/var/mysql/hostname.pid ended

mariadb是透过homebrew装的,很久之前都可以使用(软件版本已经升级过),没有修改过配置,错误日志如上。

1 个回答
  • 用locate命令或者从mysql配置文件里找到tc.log的位置,删掉它,再启动服务。

    2022-11-06 02:06 回答
撰写答案
今天,你开发时遇到什么问题呢?
立即提问
热门标签
PHP1.CN | 中国最专业的PHP中文社区 | PNG素材下载 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有