Hi, Well, this is a MySQL problem. I suggest to search for "Table is marked as crashed and last (automatic?) repair failed" in Google and follow the instructions there.
When using MySQL, it makes sense to use the InnoDB storage engine so tables can't crash. Regards, Thomas On 1/12/11 8:55 PM, "shailesh mangal" <[email protected]> wrote: >We started getting following exception. Occurrence is rare and myisamchk >fixes >the issues. Wondering if there is anything in our code causing this. > > >Version 2.2 (It happened in 1.6 as well) >Persistence Manager: >org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager > >DatabasePersistenceManager.load(438) | failed to read property state: >e18314d8-6e6b-478e-b16e-1e93a3c2cc68/{http://www.jcp.org/jcr/1.0}versionab >leUuid >java.sql.SQLException: Table 'database/jackrabbit_version_prop' is marked >as >crashed and last (automatic?) repair failed > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696) > at >com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:21 >05) > at >com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1367) > at >org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPrep >aredStatement.java:169) > > at >org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPrep >aredStatement.java:169) > > at >org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.execu >teStmt(DatabasePersistenceManager.java:889) > > at >org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.load( >DatabasePersistenceManager.java:413) > > at >org.apache.jackrabbit.core.state.SharedItemStateManager.loadItemState(Shar >edItemStateManager.java:1821) > > at >org.apache.jackrabbit.core.state.SharedItemStateManager.getNonVirtualItemS >tate(SharedItemStateManager.java:1739) > > at >org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(Share >dItemStateManager.java:261) > > at >org.apache.jackrabbit.core.state.LocalItemStateManager.getPropertyState(Lo >calItemStateManager.java:132) > > at >org.apache.jackrabbit.core.state.LocalItemStateManager.getItemState(LocalI >temStateManager.java:174) > > at >org.apache.jackrabbit.core.version.NodeStateEx.getPropertyValue(NodeStateE >x.java:226) > > at >org.apache.jackrabbit.core.version.InternalVersionHistoryImpl.init(Interna >lVersionHistoryImpl.java:130) > > at >org.apache.jackrabbit.core.version.InternalVersionHistoryImpl.<init>(Inter >nalVersionHistoryImpl.java:113) > > at >org.apache.jackrabbit.core.version.InternalVersionManagerBase.createIntern >alVersionItem(InternalVersionManagerBase.java:806) > > at >org.apache.jackrabbit.core.version.InternalVersionManagerImpl.getItem(Inte >rnalVersionManagerImpl.java:329) > > at >org.apache.jackrabbit.core.version.InternalXAVersionManager.getItem(Intern >alXAVersionManager.java:429) > > at >org.apache.jackrabbit.core.version.InternalVersionManagerBase.getVersionHi >story(InternalVersionManagerBase.java:134) > > at >org.apache.jackrabbit.core.version.InternalXAVersionManager.getVersionHist >ory(InternalXAVersionManager.java:58) > > at >org.apache.jackrabbit.core.version.VersionManagerImplBase.getVersionHistor >y(VersionManagerImplBase.java:358) > > at >org.apache.jackrabbit.core.VersionManagerImpl.access$700(VersionManagerImp >l.java:72) > > at >org.apache.jackrabbit.core.VersionManagerImpl$4.perform(VersionManagerImpl >.java:183) > > at >org.apache.jackrabbit.core.VersionManagerImpl$4.perform(VersionManagerImpl >.java:179) > > at >org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java: >200) > at >org.apache.jackrabbit.core.VersionManagerImpl.perform(VersionManagerImpl.j >ava:95) > > at >org.apache.jackrabbit.core.VersionManagerImpl.getVersionHistory(VersionMan >agerImpl.java:179) > > at >org.apache.jackrabbit.core.NodeImpl.getVersionHistory(NodeImpl.java:2940)
