2011-05-14 12:00:53,909 WARN [LibraryAdditionsCheckerThread] Cannot add file 09 - Syndicated Inc..mp3 because of an unexpected error. Message: Cannot check if media item exists: 09 - Syndicated Inc..mp3
org.serviio.db.dao.PersistenceException: Cannot check if media item exists: 09 - Syndicated Inc..mp3
at org.serviio.library.dao.MediaItemDAOImpl.isMediaItemPresent(MediaItemDAOImpl.java:89)
at org.serviio.library.service.MediaService.isMediaPresentInLibrary(MediaService.java:36)
at org.serviio.library.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:137)
at org.serviio.library.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:123)
at org.serviio.library.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:123)
at org.serviio.library.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:123)
at org.serviio.library.metadata.LibraryAdditionsCheckerThread.run(LibraryAdditionsCheckerThread.java:73)
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, FOLDER, Tablelock
Waiting XID : {7884468, IS} , APP, SELECT media_item.file_name as file_name, media_item.folder_id as folder_id, repository.folder as root_folder FROM media_item, repository, folder WHERE folder.id = media_item.folder_id AND repository.id = folder.repository_id AND media_item.file_name = ?
Granted XID : {7884472, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {7884472, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {7884468, IS}
. The selected victim is XID : 7884468.
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.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source)
at org.serviio.library.dao.MediaItemDAOImpl.isMediaItemPresent(MediaItemDAOImpl.java:68)
... 6 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, FOLDER, Tablelock
Waiting XID : {7884468, IS} , APP, SELECT media_item.file_name as file_name, media_item.folder_id as folder_id, repository.folder as root_folder FROM media_item, repository, folder WHERE folder.id = media_item.folder_id AND repository.id = folder.repository_id AND media_item.file_name = ?
Granted XID : {7884472, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {7884472, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {7884468, IS}
. The selected victim is XID : 7884468.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, FOLDER, Tablelock
Waiting XID : {7884468, IS} , APP, SELECT media_item.file_name as file_name, media_item.folder_id as folder_id, repository.folder as root_folder FROM media_item, repository, folder WHERE folder.id = media_item.folder_id AND repository.id = folder.repository_id AND media_item.file_name = ?
Granted XID : {7884472, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {7884472, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {7884468, IS}
. The selected victim is XID : 7884468.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking2.lockContainer(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseContainerHandle.useContainer(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(Unknown Source)
at org.apache.derby.impl.store.access.heap.Heap.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
at org.apache.derby.impl.store.access.BackingStoreHashTableFromScan.<init>(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.createBackingStoreHashtableFromScan(Unknown Source)
at org.apache.derby.impl.sql.execute.HashScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.JoinResultSet.openRight(Unknown Source)
at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 10 more