You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by shailesh mangal <sh...@getzephyr.com> on 2011/01/12 20:55:13 UTC
java.sql.SQLException: Table './jackrabbit_version_prop' is marked as crashed and last (automatic?) repair failed
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)
Re: java.sql.SQLException: Table './jackrabbit_version_prop' is
marked as crashed and last (automatic?) repair failed
Posted by Thomas Mueller <mu...@adobe.com>.
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" <sh...@getzephyr.com>
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)