jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Mueller <muel...@adobe.com>
Subject Re: java.sql.SQLException: Table './jackrabbit_version_prop' is marked as crashed and last (automatic?) repair failed
Date Thu, 13 Jan 2011 08:08:18 GMT
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" <shailesh.mangal@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)


Mime
View raw message