LibraryUpdater error
- Code:
20:55:30,648 WARN [LibraryUpdaterThread] Cannot search for updated metadata for title {title}. Message: null
java.lang.NullPointerException
at org.serviio.library.metadata.extractor.embedded.EmbeddedMetadataExtractor.isMetadataUpdated(EmbeddedMetadataExtractor.java:83)
at org.serviio.library.metadata.LibraryUpdaterThread.searchForUpdatedMetadata(LibraryUpdaterThread.java:329)
at org.serviio.library.metadata.LibraryUpdaterThread.run(LibraryUpdaterThread.java:141)
20:55:31,505 WARN [EventDispatcher] Couldn't send event message for subscription ba5cc426-7d33-49a0-b171-14b11d728146, will try until subscription expires
and these:
- Code:
20:42:51,065 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command f or list: null
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command fo r list: null
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.j ava:117)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.j ava:195)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.ja va:123)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:154)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
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.j ava:73)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:46)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:163)
Caused by: java.lang.NullPointerException
at org.serviio.library.dao.FolderDAOImpl.getNumberOfSubFolders(FolderDAOImpl.java:253)
at org.serviio.library.dao.FolderDAOImpl.getNumberOfFoldersAndMediaItems(FolderDAOImpl.java:288)
at org.serviio.library.service.FolderService.getNumberOfFoldersAndMediaItems(FolderService.java:93)
at org.serviio.upnp.service.contentdirectory.command.AbstractListObjectsByFSHierarchyCommand.retrieveIt emCount(AbstractListObjectsByFSHierarchyCommand.java:187)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeCountAction(ContainerNode. java:175)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItemsCount(ActionNo de.java:147)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.instantiateValuesForContainer( ObjectValuesBuilder.java:118)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.buildObjectValues(ObjectValues Builder.java:49)
at org.serviio.upnp.service.contentdirectory.command.AbstractListObjectsByFSHierarchyCommand.retrieveLi st(AbstractListObjectsByFSHierarchyCommand.java:113)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.j ava:111)
... 14 more
Sorry about the formatting, but you get the idea, right...?
What do these mean?
I didn't even have any DLNA clients turned on when this error happened..... weird..
edit:
So i was renaming some files, figuring special characters and whatnot might cause problems. Well in the log, they actually do.
So here I am, renaming files when this clusterfsck pops up:
- Code:
21:26:39,062 INFO [LibraryUpdaterThread] Removing 'Star Wars Attack of the Clones' from Library
21:27:02,574 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot read list of persons with role DIRECTOR for media item 2979
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of persons with role DIRECTOR for media item 2979
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:117)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:195)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.java:123)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:154)
at sun.reflect.GeneratedMethodAccessor254.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:46)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:163)
Caused by: org.serviio.db.dao.PersistenceException: Cannot read list of persons with role DIRECTOR for media item 2979
at org.serviio.library.dao.PersonDAOImpl.retrievePersonsWithRoleForMediaItem(PersonDAOImpl.java:325)
at org.serviio.library.service.PersonService.getListOfPersonsForMediaItem(PersonService.java:53)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.buildObjectValues(ObjectValuesBuilder.java:83)
at org.serviio.upnp.service.contentdirectory.command.AbstractListObjectsByFSHierarchyCommand.retrieveList(AbstractListObjectsByFSHierarchyCommand.java:126)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:111)
... 13 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 : {282780140, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS} , {282780136, IS} , {282780140, IS}
. The selected victim is XID : 282780140.
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.PersonDAOImpl.retrievePersonsWithRoleForMediaItem(PersonDAOImpl.java:322)
... 17 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 : {282780140, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS} , {282780136, IS} , {282780140, IS}
. The selected victim is XID : 282780140.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 27 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 : {282780140, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS} , {282780136, IS} , {282780140, IS}
. The selected victim is XID : 282780140.
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.BulkTableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.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.ProjectRestrictResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.SortResultSet.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)
... 21 more
21:27:02,580 WARN [ContentDirectory] Browse for object id V_F#FOL_R2 failed with exception: null
java.lang.NullPointerException
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:168)
at sun.reflect.GeneratedMethodAccessor254.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:46)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:163)
21:27:02,596 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot read list of persons with role PRODUCER for media item 2967
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of persons with role PRODUCER for media item 2967
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:117)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:195)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.java:123)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:154)
at sun.reflect.GeneratedMethodAccessor254.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:46)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:163)
Caused by: org.serviio.db.dao.PersistenceException: Cannot read list of persons with role PRODUCER for media item 2967
at org.serviio.library.dao.PersonDAOImpl.retrievePersonsWithRoleForMediaItem(PersonDAOImpl.java:325)
at org.serviio.library.service.PersonService.getListOfPersonsForMediaItem(PersonService.java:53)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.buildObjectValues(ObjectValuesBuilder.java:84)
at org.serviio.upnp.service.contentdirectory.command.AbstractListObjectsByFSHierarchyCommand.retrieveList(AbstractListObjectsByFSHierarchyCommand.java:126)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:111)
... 13 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 : {282780136, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS} , {282780136, IS}
. The selected victim is XID : 282780136.
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.PersonDAOImpl.retrievePersonsWithRoleForMediaItem(PersonDAOImpl.java:322)
... 17 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 : {282780136, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS} , {282780136, IS}
. The selected victim is XID : 282780136.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 27 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 : {282780136, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS} , {282780136, IS}
. The selected victim is XID : 282780136.
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.BulkTableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.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.ProjectRestrictResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.SortResultSet.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)
... 21 more
21:27:02,597 WARN [ContentDirectory] Browse for object id V_F#FOL_R2 failed with exception: null
java.lang.NullPointerException
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:168)
at sun.reflect.GeneratedMethodAccessor254.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:46)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:163)
21:27:02,830 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot read list of persons with role PRODUCER for media item 2969
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of persons with role PRODUCER for media item 2969
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:117)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:195)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.java:123)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:154)
at sun.reflect.GeneratedMethodAccessor254.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:46)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:163)
Caused by: org.serviio.db.dao.PersistenceException: Cannot read list of persons with role PRODUCER for media item 2969
at org.serviio.library.dao.PersonDAOImpl.retrievePersonsWithRoleForMediaItem(PersonDAOImpl.java:325)
at org.serviio.library.service.PersonService.getListOfPersonsForMediaItem(PersonService.java:53)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.buildObjectValues(ObjectValuesBuilder.java:84)
at org.serviio.upnp.service.contentdirectory.command.AbstractListObjectsByFSHierarchyCommand.retrieveList(AbstractListObjectsByFSHierarchyCommand.java:126)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:111)
... 13 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 : {282780134, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS}
. The selected victim is XID : 282780134.
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.PersonDAOImpl.retrievePersonsWithRoleForMediaItem(PersonDAOImpl.java:322)
... 17 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 : {282780134, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS}
. The selected victim is XID : 282780134.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 27 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 : {282780134, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS}
. The selected victim is XID : 282780134.
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.BulkTableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.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.ProjectRestrictResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.SortResultSet.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)
... 21 more
21:27:02,831 WARN [ContentDirectory] Browse for object id V_F#FOL_R2 failed with exception: null
java.lang.NullPointerException
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:168)
at sun.reflect.GeneratedMethodAccessor254.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:46)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:163)
21:27:02,843 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot read list of persons with role PRODUCER for media item 3212
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of persons with role PRODUCER for media item 3212
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:117)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:195)
at org.serviio.upnp.service.contentdirectory.definition.ActionNode.retrieveContainerItems(ActionNode.java:123)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:154)
at sun.reflect.GeneratedMethodAccessor254.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:46)
at org.apache.http.protocol.HttpService.doService(HttpService.java:293)
at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:212)
at org.serviio.upnp.webserver.WebServer$WorkerThread.run(WebServer.java:163)
Caused by: org.serviio.db.dao.PersistenceException: Cannot read list of persons with role PRODUCER for media item 3212
at org.serviio.library.dao.PersonDAOImpl.retrievePersonsWithRoleForMediaItem(PersonDAOImpl.java:325)
at org.serviio.library.service.PersonService.getListOfPersonsForMediaItem(PersonService.java:53)
at org.serviio.upnp.service.contentdirectory.command.ObjectValuesBuilder.buildObjectValues(ObjectValuesBuilder.java:84)
at org.serviio.upnp.service.contentdirectory.command.AbstractListObjectsByFSHierarchyCommand.retrieveList(AbstractListObjectsByFSHierarchyCommand.java:126)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:111)
... 13 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 : {282780135, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS}
. The selected victim is XID : 282780135.
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.PersonDAOImpl.retrievePersonsWithRoleForMediaItem(PersonDAOImpl.java:322)
... 17 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 : {282780135, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS}
. The selected victim is XID : 282780135.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 27 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 : {282780135, IS} , APP, SELECT DISTINCT(p.id) as id, p.name as name, p.sort_name as sort_name FROM person p, person_role r, media_item m WHERE r.person_id = p.id AND r.ROLE_TYPE = ? AND r.media_item_id = ?
Granted XID : {282780130, X}
Lock : TABLE, PERSON_ROLE, Tablelock
Waiting XID : {282780130, X} , APP, DELETE FROM cover_image WHERE id = ?
Granted XID : {282780131, IS} , {282780134, IS} , {282780135, IS}
. The selected victim is XID : 282780135.
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.BulkTableScanResultSet.openScanController(Unknown Source)
at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.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.ProjectRestrictResultSet.openCore(Unknown Source)
at org.apache.derby.impl.sql.execute.SortResultSet.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)
... 21 more
Database locks and unhandled exceptions are a bad thing
LG BD - 390