Re: #1036 - Table 'gain' is read only
I tried many things and discovered, that service mysql stop did not stop mysql. I had to kill it afterwards with kill -9
I tried now to use in /etc/my.cnf the values for :
innodb_force_recovery = 0
1, 0, 2, 0, 3, 0, 4, 0, 5, 0, 6, 0
With 1,2,3,4,5,6 I can start mysql, with 0 not!
With innodb_force_recovery = 0
service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
root@ronald-desktop:/etc/init.d# ps ax|grep mysql
32177 pts/24 S+ 0:00 grep --color=auto mysql
root@ronald-desktop:/etc/init.d# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since 六 2016-11-05 13:28:26 CST; 35s ago
Docs: man:systemd-sysv-generator(8)
Process: 30908 ExecStop=/etc/init.d/mysql stop (code=exited, status=1/FAILURE)
Process: 31390 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
11月 05 13:27:56 ronald-desktop mysqld[31585]: InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
11月 05 13:27:56 ronald-desktop mysqld[31585]: InnoDB: crash recovery and ignore that table.
11月 05 13:27:56 ronald-desktop mysqld[31585]: InnoDB: 3) If the file system or the disk is broken, and you cannot remove
11月 05 13:27:56 ronald-desktop mysqld[31585]: InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
11月 05 13:27:56 ronald-desktop mysqld[31585]: InnoDB: and force InnoDB to continue crash recovery here.
11月 05 13:28:26 ronald-desktop mysql[31390]: ...fail!
11月 05 13:28:26 ronald-desktop systemd[1]: mysql.service: Control process exited, code=exited status=1
11月 05 13:28:26 ronald-desktop systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
11月 05 13:28:26 ronald-desktop systemd[1]: mysql.service: Unit entered failed state.
11月 05 13:28:26 ronald-desktop systemd[1]: mysql.service: Failed with result 'exit-code'.
What can I do?
Subject
Views
Written By
Posted
836
November 02, 2016 07:07PM
403
November 03, 2016 10:53AM
450
November 03, 2016 06:05PM
351
November 03, 2016 06:49PM
359
November 03, 2016 08:26PM
438
November 03, 2016 08:34PM
394
November 03, 2016 10:39PM
647
November 03, 2016 10:56PM
Re: #1036 - Table 'gain' is read only
619
November 04, 2016 11:38PM
732
November 05, 2016 12:09AM
532
November 05, 2016 12:16AM
517
November 05, 2016 03:05AM
462
November 05, 2016 04:04AM
409
November 05, 2016 04:19PM