You are not logged in.

#1 2015-12-18 14:14:10

anthillsocial
Member
Registered: 2013-02-18
Posts: 82

mysql not starting "[ERROR] Can't init tc log"

I recently performed an upgrade, rebooted and now mysql isnt starting.
The key error seems to be "[ERROR] Can't init tc log"
Though Im not sure how to fix it.... any tips?

journalctl -f SYSLOG_IDENTIFIER=mysqld
-----------------------------------------------------------------------------------
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] /usr/bin/mysqld (mysqld 10.1.9-MariaDB) starting as process 7903 ...
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: The InnoDB memory heap is disabled
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Memory barrier is not used
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Compressed tables use zlib 1.2.8
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Using Linux native AIO
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Using CPU crc32 instructions
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Completed initialization of buffer pool
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Highest supported file format is Barracuda.
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: 128 rollback segment(s) are active.
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB: Waiting for purge to start
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 2545546
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690472605440 [Note] InnoDB: Dumping buffer pool(s) not yet started
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] Plugin 'FEEDBACK' is disabled.
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [Note] Recovering after a crash using tc.log
Dec 18 14:08:52 risky.theanthillsocial.co.uk mysqld[7903]: 2015-12-18 14:08:52 139690886637440 [ERROR] Can't init tc log
Dec 18 14:07:21 risky.theanthillsocial.co.uk mysqld[7240]: 2015-12-18 14:07:21 140576698533760 [ERROR] Aborting

Last edited by anthillsocial (2015-12-18 14:15:47)

Offline

#2 2015-12-18 17:49:38

Slithery
Forum Moderator
From: Norfolk, UK
Registered: 2013-12-01
Posts: 3,381

Re: mysql not starting "[ERROR] Can't init tc log"

Are you actually running MySQL or is it MariaDB?

Have you tried this and this?


No, it didn't "fix" anything. It just shifted the brokeness one space to the right. - jasonwryan
Closing -- for deletion; Banning -- for muppetry. - jasonwryan

aur - dotfiles

Online

#3 2016-01-16 17:28:52

bdagerman
Member
Registered: 2013-11-15
Posts: 1

Re: mysql not starting "[ERROR] Can't init tc log"

I just ran into this error, "Can't init tc log", running MariaDB.

mysql --version
mysql  Ver 15.1 Distrib 10.1.10-MariaDB, for Linux (x86_64) using readline 5.1

I ended up deleting the tc.log file in /var/lib/mysql. When I started mysql again, it created a new tc.log and started up.

Some background on my problem. I had let the partition with /var on it get full. After a reboot mysql wouldn't start, and tc.log was 0B. I cleared up some space but until I deleted tc.log, mysql wouldn't start.

Offline

#4 2016-04-03 20:54:12

wolfdogg
Member
From: Portland, OR, USA
Registered: 2011-05-21
Posts: 545

Re: mysql not starting "[ERROR] Can't init tc log"

Solved my issue clean, Thanks! 

bdagerman wrote:

I ended up deleting the tc.log file in /var/lib/mysql. When I started mysql again, it created a new tc.log and started up.


Node.js, PHP Software Architect and Engineer (Full-Stack/DevOps)
GitHub  | LinkedIn

Offline

#5 2019-08-27 11:24:32

davelowe1977
Member
Registered: 2019-08-27
Posts: 1

Re: mysql not starting "[ERROR] Can't init tc log"

This solution of deleting tc.log solved my problem on Debian 9 stable too.
Thank you very much!

Offline

#6 2019-08-27 11:30:11

V1del
Forum Moderator
Registered: 2012-10-16
Posts: 7,256

Re: mysql not starting "[ERROR] Can't init tc log"

Glad to hear, closing this 3 year old thread though.

Closing.

Offline

Board footer

Powered by FluxBB