mysql - mariadb 无法启动服务 macOS
问题描述
160802 11:45:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql2016-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 insensitive2016-08-02 11:45:47 4471989184 [Note] InnoDB: Using mutexes to ref count buffer pool pages2016-08-02 11:45:47 4471989184 [Note] InnoDB: The InnoDB memory heap is disabled2016-08-02 11:45:47 4471989184 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2016-08-02 11:45:47 4471989184 [Note] InnoDB: Memory barrier is not used2016-08-02 11:45:47 4471989184 [Note] InnoDB: Compressed tables use zlib 1.2.82016-08-02 11:45:47 4471989184 [Note] InnoDB: Using SSE crc32 instructions2016-08-02 11:45:47 4471989184 [Note] InnoDB: Initializing buffer pool, size = 128.0M2016-08-02 11:45:47 4471989184 [Note] InnoDB: Completed initialization of buffer pool2016-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 start2016-08-02 11:45:47 4471989184 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.30-76.3 started; log sequence number 40366372016-08-02 11:45:47 123145327255552 [Note] InnoDB: Dumping buffer pool(s) not yet started2016-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.log2016-08-02 11:45:47 4471989184 [ERROR] Bad magic header in tc log2016-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 log2016-08-02 11:45:47 4471989184 [ERROR] Aborting160802 11:45:49 mysqld_safe mysqld from pid file /usr/local/var/mysql/hostname.pid ended
mariadb是透过homebrew装的,很久之前都可以使用(软件版本已经升级过),没有修改过配置,错误日志如上。
问题解答
回答1:用locate命令或者从mysql配置文件里找到tc.log的位置,删掉它,再启动服务。
相关文章:
1. javascript - 如何用最快的速度C#或Python开发一个桌面应用程序来访问我的网站?2. javascript - 项目用IE浏览器打开修改前端内容,后台数据修改了,但是前端页面内容不变,用谷歌浏览器测试前端页面可以刷新,求大神解决。3. javascript - 看一些高手写代码单独用 “$”和“_” 来表示变量,什么时候单独使用这两个字符?4. 前端 - 使用vue2服务端渲染的时候,如何在服务端请求数据,然后给vue渲染5. mysql 存储过程 和 函数有什么用??6. python - 关于beautifulsoup获取文档内容7. java - springMVC配置的controller无法返回jsp文件8. html5 - video ios不能播放怎么办?9. javascript - weex和node,js到底是怎样一个关系呢?10. mysql - jdbc的问题
