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/