19 Aug
2009
19 Aug
'09
7:11 p.m.
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:
--
Ludovic Dubost
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
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.