Re: #1036 - Table 'gain' is read only

[Ronald Wiplinger]

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?