Fri Aug 12, 2011 1:17 am by Canopus
Hi and thanks again.
I followed your instruction ans deleted 'library" folder.
Now I get this message in logs :
- Code:
Message: Cannot update Video with id 993
org.serviio.db.dao.PersistenceException: Cannot update Video with id 993
at org.serviio.library.dao.VideoDAOImpl.update(VideoDAOImpl.java:209)
at org.serviio.library.dao.VideoDAOImpl.update(VideoDAOImpl.java:43)
at org.serviio.library.service.VideoService.updateVideoInLibrary(VideoService.java:233)
at org.serviio.library.metadata.LibraryUpdatesCheckerThread.updateMetadata(LibraryUpdatesCheckerThread.java:227)
at org.serviio.library.metadata.LibraryUpdatesCheckerThread.run(LibraryUpdatesCheckerThread.java:106)
Caused by: java.sql.SQLException: The conglomerate (257) requested does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.serviio.library.dao.VideoDAOImpl.update(VideoDAOImpl.java:169)
... 4 more
Caused by: java.sql.SQLException: The conglomerate (257) requested does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 18 more
Caused by: ERROR XSAI2: The conglomerate (257) requested does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IFactory.readConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getConstraints(Unknown Source)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getConstraintTableDescriptor(Unknown Source)
at org.apache.derby.iapi.sql.dictionary.ForeignKeyConstraintDescriptor.getReferencedConstraint(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLModStatementNode.createConstraintDependencies(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLModStatementNode.bindConstraints(Unknown Source)
at org.apache.derby.impl.sql.compile.UpdateNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 12 more
But my library is accessible and after rebuilt it most of the "doublon" were gone.
But Scarface and Kill Bill 1 are in double....
Some others must be but I saw this 2 doubles inserts from the beginning of my test.
There is not special files like .srt attached to this movies....
Anymore help will be welcome because it looks like a bug.
Thanks for your time
Florent