Only showing first n video folders (Samsung D7000)
My Samsung D7000 is only showing videos beginning with A-G. However, my Android phone can see all of them. Can anyone give me some clues as to why that might be?
Looking at the log file, I can see a bunch of errors after reading a file path (see below), but that doesn't seem to begin with "H". I'm confused
- Code:
2011-06-17 00:30:20,971 WARN [LibraryAdditionsCheckerThread] Cannot add file Wacky Races 112 - The Speedy Arkansas Traveller (DVD Rip).XviD.avi because of an unexpected error. Message: Cannot read file path for Folder 114
org.serviio.db.dao.PersistenceException: Cannot read file path for Folder 114
at org.serviio.library.dao.FolderDAOImpl.getFolderPath(FolderDAOImpl.java:148)
at org.serviio.library.dao.MediaItemDAOImpl.isMediaItemPresent(MediaItemDAOImpl.java:75)
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.run(LibraryAdditionsCheckerThread.java:73)
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained within the time requested
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.FolderDAOImpl.getFolderPath(FolderDAOImpl.java:129)
... 5 more
Caused by: java.sql.SQLException: A lock could not be obtained within the time requested
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 15 more
Caused by: ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(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.open(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IForwardScan.init(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2I.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledScan(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.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)
... 9 more
2011-06-17 00:30:41,112 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot get file of media item: 124
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot get file of media item: 124
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:118)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:227)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:168)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:80)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:198)
at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeOperation(ServiceInvoker.java:253)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeService(ServiceInvoker.java:93)
at org.serviio.upnp.webserver.ServiceControlRequestHandler.handleRequest(ServiceControlRequestHandler.java:73)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:54)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.serviio.upnp.webserver.ServiioHttpService.doService(ServiioHttpService.java:58)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:187)
Caused by: org.serviio.db.dao.PersistenceException: Cannot get file of media item: 124
at org.serviio.library.dao.MediaItemDAOImpl.getFile(MediaItemDAOImpl.java:148)
at org.serviio.library.service.MediaService.getFile(MediaService.java:44)
at org.serviio.library.service.SubtitlesService.findSubtitleFile(SubtitlesService.java:47)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.generateSubtitlesURI(ObjectValuesBuilder.java:153)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.buildObjectValues(ObjectValuesBuilder.java:92)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityItemCommand.generateValuesForEntity(AbstractEntityItemCommand.java:120)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityItemCommand.retrieveList(AbstractEntityItemCommand.java:54)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:112)
... 15 more
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 : {5438636, 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.id = ?
Granted XID : {5437645, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5437645, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {5438636, IS}
. The selected victim is XID : 5438636.
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.getFile(MediaItemDAOImpl.java:136)
... 22 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 : {5438636, 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.id = ?
Granted XID : {5437645, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5437645, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {5438636, IS}
. The selected victim is XID : 5438636.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 32 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 : {5438636, 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.id = ?
Granted XID : {5437645, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5437645, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {5438636, IS}
. The selected victim is XID : 5438636.
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.open(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IForwardScan.init(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2I.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledScan(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.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)
... 26 more
2011-06-17 00:30:41,121 WARN [ContentDirectory] Browse for object id V_M failed with exception: null
java.lang.NullPointerException
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:170)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:80)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:198)
at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeOperation(ServiceInvoker.java:253)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeService(ServiceInvoker.java:93)
at org.serviio.upnp.webserver.ServiceControlRequestHandler.handleRequest(ServiceControlRequestHandler.java:73)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:54)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.serviio.upnp.webserver.ServiioHttpService.doService(ServiioHttpService.java:58)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:187)
2011-06-17 00:31:01,250 WARN [LibraryAdditionsCheckerThread] Cannot add file Wacky Races 122 - The Dipsy Doodle Desert Derby (DVD Rip).XviD.avi because of an unexpected error. Message: Cannot check if media item exists: Wacky Races 122 - The Dipsy Doodle Desert Derby (DVD Rip).XviD.avi
org.serviio.db.dao.PersistenceException: Cannot check if media item exists: Wacky Races 122 - The Dipsy Doodle Desert Derby (DVD Rip).XviD.avi
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.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 : {5438637, 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 : {5438641, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5438641, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {5438637, IS}
. The selected victim is XID : 5438637.
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)
... 4 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 : {5438637, 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 : {5438641, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5438641, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {5438637, IS}
. The selected victim is XID : 5438637.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 14 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 : {5438637, 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 : {5438641, IX}
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5438641, X} , APP, DELETE FROM folder WHERE id = ?
Granted XID : {5438637, IS}
. The selected victim is XID : 5438637.
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)
... 8 more
2011-06-17 00:31:12,388 INFO [RendererManager] Stored a new renderer: uuid='89abc8e8-ac34-4390-8a02-af5f545ef5ac', name = 'Windows Media Player', ipAddress='192.168.1.102', profile = '1'
2011-06-17 00:34:53,545 INFO [LibraryAdditionsCheckerThread] Finished looking for newly added files
2011-06-17 00:35:26,327 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot get number of albums for artist: 3443
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot get number of albums for artist: 3443
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:118)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:227)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:168)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:80)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.java:129)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:198)
at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeOperation(ServiceInvoker.java:253)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeService(ServiceInvoker.java:93)
at org.serviio.upnp.webserver.ServiceControlRequestHandler.handleRequest(ServiceControlRequestHandler.java:73)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:54)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.serviio.upnp.webserver.ServiioHttpService.doService(ServiioHttpService.java:58)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:187)
Caused by: org.serviio.db.dao.PersistenceException: Cannot get number of albums for artist: 3443
at org.serviio.library.dao.MusicAlbumDAOImpl.retrieveMusicAlbumsForArtistCount(MusicAlbumDAOImpl.java:223)
at org.serviio.library.service.AudioService.getNumberOfAlbumsForArtist(AudioService.java:354)
at org.serviio.upnp.service.contentdirectory.command.audio.ListAlbumsForArtistCommand.retrieveItemCount(ListAlbumsForArtistCommand.java:69)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeCountAction(ContainerNode.java:207)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItemsCount(ContainerNode.java:114)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItemsCount(ActionNode.java:152)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.instantiateValuesForContainer(ObjectValuesBuilder.java:117)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.buildObjectValues(ObjectValuesBuilder.java:57)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityContainerCommand.generateValuesForEntity(AbstractEntityContainerCommand.java:98)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityContainerCommand.retrieveList(AbstractEntityContainerCommand.java:50)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:112)
... 16 more
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5472378, IS} , APP, SELECT count(distinct(a.id)) as c from music_album a, person_role pr, media_item m WHERE m.album_id = a.id AND pr.media_item_id = m.id AND pr.person_id = ? AND pr.role_type = ?
Granted XID : {5472379, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {5472379, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {5472378, IS}
. The selected victim is XID : 5472378.
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.MusicAlbumDAOImpl.retrieveMusicAlbumsForArtistCount(MusicAlbumDAOImpl.java:215)
... 26 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5472378, IS} , APP, SELECT count(distinct(a.id)) as c from music_album a, person_role pr, media_item m WHERE m.album_id = a.id AND pr.media_item_id = m.id AND pr.person_id = ? AND pr.role_type = ?
Granted XID : {5472379, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {5472379, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {5472378, IS}
. The selected victim is XID : 5472378.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 36 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5472378, IS} , APP, SELECT count(distinct(a.id)) as c from music_album a, person_role pr, media_item m WHERE m.album_id = a.id AND pr.media_item_id = m.id AND pr.person_id = ? AND pr.role_type = ?
Granted XID : {5472379, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {5472379, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {5472378, IS}
. The selected victim is XID : 5472378.
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.open(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IForwardScan.init(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2I.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledScan(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.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.DistinctScalarAggregateResultSet.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)
... 30 more
2011-06-17 00:35:26,331 WARN [ContentDirectory] Browse for object id A_A#INI_75 failed with exception: null
java.lang.NullPointerException
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:170)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:80)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.java:129)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:198)
at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeOperation(ServiceInvoker.java:253)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeService(ServiceInvoker.java:93)
at org.serviio.upnp.webserver.ServiceControlRequestHandler.handleRequest(ServiceControlRequestHandler.java:73)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:54)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.serviio.upnp.webserver.ServiioHttpService.doService(ServiioHttpService.java:58)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:187)
2011-06-17 00:35:52,272 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot get number of albums for artist: 4057
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot get number of albums for artist: 4057
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:118)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:227)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:168)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:80)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.java:129)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:198)
at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeOperation(ServiceInvoker.java:253)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeService(ServiceInvoker.java:93)
at org.serviio.upnp.webserver.ServiceControlRequestHandler.handleRequest(ServiceControlRequestHandler.java:73)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:54)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.serviio.upnp.webserver.ServiioHttpService.doService(ServiioHttpService.java:58)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:187)
Caused by: org.serviio.db.dao.PersistenceException: Cannot get number of albums for artist: 4057
at org.serviio.library.dao.MusicAlbumDAOImpl.retrieveMusicAlbumsForArtistCount(MusicAlbumDAOImpl.java:223)
at org.serviio.library.service.AudioService.getNumberOfAlbumsForArtist(AudioService.java:354)
at org.serviio.upnp.service.contentdirectory.command.audio.ListAlbumsForArtistCommand.retrieveItemCount(ListAlbumsForArtistCommand.java:69)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeCountAction(ContainerNode.java:207)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItemsCount(ContainerNode.java:114)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItemsCount(ActionNode.java:152)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.instantiateValuesForContainer(ObjectValuesBuilder.java:117)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.buildObjectValues(ObjectValuesBuilder.java:57)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityContainerCommand.generateValuesForEntity(AbstractEntityContainerCommand.java:98)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityContainerCommand.retrieveList(AbstractEntityContainerCommand.java:50)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:112)
... 16 more
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5472780, IS} , APP, SELECT count(distinct(a.id)) as c from music_album a, person_role pr, media_item m WHERE m.album_id = a.id AND pr.media_item_id = m.id AND pr.person_id = ? AND pr.role_type = ?
Granted XID : {5472781, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {5472781, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {5472780, IS}
. The selected victim is XID : 5472780.
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.MusicAlbumDAOImpl.retrieveMusicAlbumsForArtistCount(MusicAlbumDAOImpl.java:215)
... 26 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5472780, IS} , APP, SELECT count(distinct(a.id)) as c from music_album a, person_role pr, media_item m WHERE m.album_id = a.id AND pr.media_item_id = m.id AND pr.person_id = ? AND pr.role_type = ?
Granted XID : {5472781, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {5472781, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {5472780, IS}
. The selected victim is XID : 5472780.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 36 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : TABLE, MEDIA_ITEM, Tablelock
Waiting XID : {5472780, IS} , APP, SELECT count(distinct(a.id)) as c from music_album a, person_role pr, media_item m WHERE m.album_id = a.id AND pr.media_item_id = m.id AND pr.person_id = ? AND pr.role_type = ?
Granted XID : {5472781, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {5472781, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {5472780, IS}
. The selected victim is XID : 5472780.
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.open(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IForwardScan.init(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2I.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openCompiledScan(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.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.DistinctScalarAggregateResultSet.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)
... 30 more
2011-06-17 00:35:52,279 WARN [ContentDirectory] Browse for object id A_A#INI_79 failed with exception: null
java.lang.NullPointerException
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:170)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:80)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.java:129)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:198)
at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeOperation(ServiceInvoker.java:253)
at org.serviio.upnp.protocol.soap.ServiceInvoker.invokeService(ServiceInvoker.java:93)
at org.serviio.upnp.webserver.ServiceControlRequestHandler.handleRequest(ServiceControlRequestHandler.java:73)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:54)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.serviio.upnp.webserver.ServiioHttpService.doService(ServiioHttpService.java:58)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:187)