Mysql not working

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Mysql not working

Postby MontiMoran » 08. June 2017 10:54

Mysql is not working after get 0 kb free in the hard disk, the server start to fail, I get free space but now doesn't work.
I tried:
sudo /opt/lampp/lampp stop
sudo /opt/lampp/lampp start
sudo rm /opt/lampp/var/mysql/pc-name.pid

In /opt/lampp/var/mysql/pc-name.err:

2017-06-08 10:48:48 1676 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2017-06-08 10:48:48 140226944194368 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2017-06-08 10:48:48 140226944194368 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 1821 ...
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Using SSE crc32 instructions
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Completed initialization of buffer pool
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: 128 rollback segment(s) are active.
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Waiting for purge to start
2017-06-08 10:48:48 140226944194368 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 2955665
2017-06-08 10:48:48 140226555000576 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-06-08 10:48:48 140226944194368 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-08 10:48:48 140226944194368 [Note] Recovering after a crash using tc.log
2017-06-08 10:48:48 140226944194368 [ERROR] Can't init tc log
2017-06-08 10:48:48 140226944194368 [ERROR] Aborting
MontiMoran
 
Posts: 1
Joined: 08. June 2017 10:47
XAMPP version: 5.6.30
Operating System: Ubuntu

Re: Mysql not working

Postby Nobbie » 08. June 2017 23:02

Ouch, that looks like a bad crash. Due to the full file sýstem, InnoDB even could not create a recovery log. I think your database is corrupted, do you have a backup?

P.S.: With 'Cant init tc.log' searching in Google i found a fix, look for any tc.log file in /opt/lampp ( somewhere in a mysql folder or so) and delete it. Then try again.
Nobbie
 
Posts: 13171
Joined: 09. March 2008 13:04

Re: Mysql not working

Postby hieupham8x » 02. August 2019 10:04

Nobbie wrote:Ouch, that looks like a bad crash. Due to the full file sýstem, InnoDB even could not create a recovery log. I think your database is corrupted, do you have a backup?

P.S.: With 'Cant init tc.log' searching in Google i found a fix, look for any tc.log file in /opt/lampp ( somewhere in a mysql folder or so) and delete it. Then try again.

I meet this error. I delete tc.log file. Restart XAMPP and OK.
Thanks Nobbie :D
hieupham8x
 
Posts: 1
Joined: 02. August 2019 10:01
XAMPP version: 5.6
Operating System: Ubuntu 16.04


Return to XAMPP for Linux

Who is online

Users browsing this forum: RobyRu62 and 29 guests