Litebans - MySQL Database

[alexteal]

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.

 

[Bailey]

It looks like you need to set the database as a read and write. It's currently only read.

[Krydos]

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

[alexteal]

How do i back up my data & and where can i find the MyISAM database?

Edited February 26, 2018 by alexteal

[Luigi123]

Moved to Customer Service.

[wolstech]

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.

[Krydos]

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.)