alexteal Posted February 26, 2018 Share Posted February 26, 2018 I'm getting the following error:[18:16:11 ERROR]: [LiteBans] An unexpected database error has occurred. [18:16:11 WARN]: [LiteBans] java.sql.BatchUpdateException: InnoDB: Running in read-only mode [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065) [18:16:11 WARN]: [LiteBans] at litebans.aB.executeBatch(aB.java:16) [18:16:11 WARN]: [LiteBans] at litebans.ae.executeBatch(ae.java) [18:16:11 WARN]: [LiteBans] at litebans.ax.a(ax.java:29) [18:16:11 WARN]: [LiteBans] at litebans.cQ.a(cQ.java:105) [18:16:11 WARN]: [LiteBans] at litebans.bu.h(bu.java:170) [18:16:11 WARN]: [LiteBans] at litebans.bu.a(bu.java:569) [18:16:11 WARN]: [LiteBans] at litebans.bu.a(bu.java:692)[18:16:11 WARN]: [LiteBans] at litebans.D.a(D.java:276) [18:16:11 WARN]: [LiteBans] at litebans.C.b(C.java:31) [18:16:11 WARN]: [LiteBans] at litebans.x.run(x.java:6) [18:16:11 ERROR]: [LiteBans] Failed to execute: 'INSERT INTO litebans_bans (uuid,ip,reason,banned_by_uuid,banned_by_name,time,until,server_scope,server_origin,silent,ipban,active) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)'. [18:16:11 ERROR]: [LiteBans] An unexpected database error has occurred. [18:16:11 WARN]: [LiteBans] java.sql.SQLException: InnoDB: Running in read-only mode [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325) [18:16:11 WARN]: [LiteBans] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310) [18:16:11 WARN]: [LiteBans] at litebans.aq.executeUpdate(aq.java:5) [18:16:11 WARN]: [LiteBans] at litebans.aF.executeUpdate(aF.java) [18:16:11 WARN]: [LiteBans] at litebans.ax.b(ax.java:1) [18:16:11 WARN]: [LiteBans] at litebans.cQ.b(cQ.java:32) [18:16:11 WARN]: [LiteBans] at litebans.bu.b(bu.java:640) [18:16:11 WARN]: [LiteBans] at litebans.D.a(D.java:29) [18:16:11 WARN]: [LiteBans] at litebans.C.b(C.java:31) [18:16:11 WARN]: [LiteBans] at litebans.x.run(x.java:6) [18:16:11 INFO]: An internal error occurred while attempting to perform this command. The Author of the plugin said the disc of the database is full or the database is corrupt, as i can see the database is not full but if it was corrupt what can I do to fix it without deleting the data inside? Thanks. Quote Link to comment Share on other sites More sharing options...
Bailey Posted February 26, 2018 Share Posted February 26, 2018 It looks like you need to set the database as a read and write. It's currently only read. Quote Link to comment Share on other sites More sharing options...
Krydos Posted February 26, 2018 Share Posted February 26, 2018 We're aware. InnoDB on Johnny is damaged. We recommend MyISAM for exactly this reason...InnoDB breaks way too easily (we've lost an entire server's worth of InnoDB data numerous times, but have never lost a MyISAM table in our 10+ years in operation). For now, the only thing you can (and should) do is back up your data while it's accessible. The failure was caused by the servers being improperly shut down due to a power outage at HE the other day. The entire data center went down, not just us. When we attempt to repair it, it's quite likely that some or all of the data will be lost, so there's a good chance you'll need the backups to get your site working again.Source: https://www.helionet.org/index/topic/31947-innodb-is-in-read-only-mode/?p=144357 Quote Link to comment Share on other sites More sharing options...
alexteal Posted February 26, 2018 Author Share Posted February 26, 2018 (edited) How do i back up my data & and where can i find the MyISAM database? Edited February 26, 2018 by alexteal Quote Link to comment Share on other sites More sharing options...
Luigi123 Posted February 27, 2018 Share Posted February 27, 2018 Moved to Customer Service. Quote Link to comment Share on other sites More sharing options...
wolstech Posted February 27, 2018 Share Posted February 27, 2018 MyISAM is a data storage engine. When creating your database or installing your software, the script that generates the database decides this. You may need to modify the installer for the software to use MyISAM. As for backups, you can do that in cPanel using the backup options (a full account backup contains the databases, and there is also an option to back up just individual databases), or by using PhpMyAdmin to export the database you want to back up. I'd provide a link but Johnny is being slow at the moment. Quote Link to comment Share on other sites More sharing options...
Krydos Posted February 27, 2018 Share Posted February 27, 2018 You can backup everything (including databases) at:https://johnny.heliohost.org:2083/frontend/paper_lantern/backup/index.html You can change your storage engine with this code: ALTER TABLE table_name ENGINE = MyISAM; Also we highly recommend taking frequent backups. Take a backup after each major change to your site, and also once a week or so would be a good idea. Source: https://www.helionet.org/index/topic/31947-innodb-is-in-read-only-mode/?p=144534 (Please don't ask the same question multiple times.) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.