FAQ  •  Register  •  Login

LibraryUpdater error

<<

fizze

Serviio lover

Posts: 88

Joined: Wed Dec 02, 2009 8:27 am

Location: Austria

Post Wed Dec 30, 2009 7:56 pm

LibraryUpdater error

I see tons of these in my log file:
  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 ;) :twisted:
Intel SS4200 - Ubuntu Server 8.04
LG BD - 390
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17212

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Wed Dec 30, 2009 11:22 pm

Re: LibraryUpdater error

Some of these should be fixed in 0.3.1 already, will look into the other ones.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17212

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Thu Dec 31, 2009 12:57 pm

Re: LibraryUpdater error

Itseems tome that your DB is corrupt, most of these exceptions should not normally occur, that's why I don't deal with them. Try to delete folder library/db (stop Serviio first) and it should get back to normal. Mind you, you will lose your settings and metadata.

Not sure why this happened... did you do something with the DB using external tools?
<<

fizze

Serviio lover

Posts: 88

Joined: Wed Dec 02, 2009 8:27 am

Location: Austria

Post Thu Dec 31, 2009 3:00 pm

Re: LibraryUpdater error

Other than insert my library locations using ij, no.
Alright, I'll try to rebuild it from scratch.

On a sidenote: media without metadata DOES appear in serviio, right?
Intel SS4200 - Ubuntu Server 8.04
LG BD - 390
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17212

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Thu Dec 31, 2009 3:41 pm

Re: LibraryUpdater error

fizze wrote:On a sidenote: media without metadata DOES appear in serviio, right?

Without metadata from the online sources - yes. Using priority extraction it'll only get as much as possible from the other extractors, ie local dvd cover and embedded information (e.g. file name, file length, FFmpeg generated thumbnail, etc)

Return to User experiences

Who is online

Users browsing this forum: No registered users and 9 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.