jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shailesh mangal <shailesh.man...@getzephyr.com>
Subject java.sql.SQLException: Table './jackrabbit_version_prop' is marked as crashed and last (automatic?) repair failed
Date Wed, 12 Jan 2011 19:55:13 GMT
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}versionableUuid
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:2105)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1367)
    at 
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)

    at 
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)

    at 
org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.executeStmt(DatabasePersistenceManager.java:889)

    at 
org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.load(DatabasePersistenceManager.java:413)

    at 
org.apache.jackrabbit.core.state.SharedItemStateManager.loadItemState(SharedItemStateManager.java:1821)

    at 
org.apache.jackrabbit.core.state.SharedItemStateManager.getNonVirtualItemState(SharedItemStateManager.java:1739)

    at 
org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(SharedItemStateManager.java:261)

    at 
org.apache.jackrabbit.core.state.LocalItemStateManager.getPropertyState(LocalItemStateManager.java:132)

    at 
org.apache.jackrabbit.core.state.LocalItemStateManager.getItemState(LocalItemStateManager.java:174)

    at 
org.apache.jackrabbit.core.version.NodeStateEx.getPropertyValue(NodeStateEx.java:226)

    at 
org.apache.jackrabbit.core.version.InternalVersionHistoryImpl.init(InternalVersionHistoryImpl.java:130)

    at 
org.apache.jackrabbit.core.version.InternalVersionHistoryImpl.<init>(InternalVersionHistoryImpl.java:113)

    at 
org.apache.jackrabbit.core.version.InternalVersionManagerBase.createInternalVersionItem(InternalVersionManagerBase.java:806)

    at 
org.apache.jackrabbit.core.version.InternalVersionManagerImpl.getItem(InternalVersionManagerImpl.java:329)

    at 
org.apache.jackrabbit.core.version.InternalXAVersionManager.getItem(InternalXAVersionManager.java:429)

    at 
org.apache.jackrabbit.core.version.InternalVersionManagerBase.getVersionHistory(InternalVersionManagerBase.java:134)

    at 
org.apache.jackrabbit.core.version.InternalXAVersionManager.getVersionHistory(InternalXAVersionManager.java:58)

    at 
org.apache.jackrabbit.core.version.VersionManagerImplBase.getVersionHistory(VersionManagerImplBase.java:358)

    at 
org.apache.jackrabbit.core.VersionManagerImpl.access$700(VersionManagerImpl.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.java:95)

    at 
org.apache.jackrabbit.core.VersionManagerImpl.getVersionHistory(VersionManagerImpl.java:179)

    at org.apache.jackrabbit.core.NodeImpl.getVersionHistory(NodeImpl.java:2940)
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message