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 - jq 上傳圖片成功后添加一個新的上傳框時出現問題2. html5 - 最近在自學react 求一個react表單提交的例子3. 老師您好!我有一個問題、4. mysql - 千萬數據 分頁，當偏移量 原來越大時，怎么優化速度5. 網站上有個圖標改不了了 求幫忙 是用svg寫的6. python - django中普通用戶如何利用admin修改自己的信息？7. python - Django ManyToManyField 字段數據在 admin后臺 顯示不正確，這是怎么回事？8. 我和老師的代碼對照了幾遍沒發現問題，但是瀏覽器打開就有問題了，求解9. python - 《flask web 開發》一書，數據庫中多對多關系的實現問題？10. python - angular route 與 django urls 沖突怎么解決？
網公網安備