[xwiki-users] Documents failing to save. Mysql table crash
Hi I have a problem where creating and saving/editing documents fails. I am using xwiki version 1.1.1 Here are some errors shown from the detailed information page. Error number 3201 in 3: Exception while saving document AVL.test Wrapped Exception: Error number 3211 in 3: Exception while updating archive AVL.test Wrapped Exception: Error number 3212 in 3: Exception while loading archive 1,473,480,338 Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not execute query Also in the same Detailed information report: Wrapped Exception: java.sql.SQLException: Table './macomtech/xwikircs' is marked as crashed and should be repaired at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256) I havent come across this problem before in xwiki or mysql. I could use "repair table xwikircs" in mysql. What else needs to be done to fix problem or is there a better way to fix it? Thanks John -- View this message in context: http://n2.nabble.com/Documents-failing-to-save.-Mysql-table-crash-tp3459900p... Sent from the XWiki- Users mailing list archive at Nabble.com.
John T. Carroll wrote:
Hi
I have a problem where creating and saving/editing documents fails. I am using xwiki version 1.1.1 Here are some errors shown from the detailed information page.
Error number 3201 in 3: Exception while saving document AVL.test Wrapped Exception: Error number 3211 in 3: Exception while updating archive AVL.test Wrapped Exception: Error number 3212 in 3: Exception while loading archive 1,473,480,338 Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not execute query
Also in the same Detailed information report: Wrapped Exception:
java.sql.SQLException: Table './macomtech/xwikircs' is marked as crashed and should be repaired at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
I havent come across this problem before in xwiki or mysql. I could use "repair table xwikircs" in mysql. What else needs to be done to fix problem or is there a better way to fix it?
XWiki should in no way cause a table to crash, since it uses just SQL to talk to the database. This is usually a hardware-related problem, so the mysql documentation can provide more help. -- Sergiu Dumitriu http://purl.org/net/sergiu/
Hi, As sergiu said, if mysql crashes it's not xwiki's fault. It could be mysql or hardware related. My recommendation on mysql crashes is: 1/ run repair or course 2/ run the xwiki sanity check script http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration which can detect incoherences in the DB which could make some xwiki document unloadable. Most of the time the pages can be recovered to a valid state using a rollback to one of the most recent version including the latest one itself. If not clean up is necessary. If mysql crashes repeat themselves, either change hardware, mysql version or find the cause. Ludovic Sergiu Dumitriu a écrit :
John T. Carroll wrote:
Hi
I have a problem where creating and saving/editing documents fails. I am using xwiki version 1.1.1 Here are some errors shown from the detailed information page.
Error number 3201 in 3: Exception while saving document AVL.test Wrapped Exception: Error number 3211 in 3: Exception while updating archive AVL.test Wrapped Exception: Error number 3212 in 3: Exception while loading archive 1,473,480,338 Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not execute query
Also in the same Detailed information report: Wrapped Exception:
java.sql.SQLException: Table './macomtech/xwikircs' is marked as crashed and should be repaired at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
I havent come across this problem before in xwiki or mysql. I could use "repair table xwikircs" in mysql. What else needs to be done to fix problem or is there a better way to fix it?
XWiki should in no way cause a table to crash, since it uses just SQL to talk to the database. This is usually a hardware-related problem, so the mysql documentation can provide more help.
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
participants (3)
-
John T. Carroll -
Ludovic Dubost -
Sergiu Dumitriu