MySQL Forums
Forum List  »  InnoDB

Re: #1036 - Table 'gain' is read only
Posted by: Ronald Wiplinger
Date: November 04, 2016 11:38PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
687
November 02, 2016 07:07PM
Re: #1036 - Table 'gain' is read only
496
November 04, 2016 11:38PM
340
November 05, 2016 04:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.