FAQ  •  Register  •  Login

1v1: Recent video list crashes - now with 1v3

<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Sat Dec 29, 2012 11:25 am

1v1: Recent video list crashes - now with 1v3

Hi all, recently upgrade to 1.1 Pro. Worked so far so fine till I did a shutdown/restart. The recent items begin to display but then the TV looses connection to serviio.
thx for your support! (full log file is available on request)

2012-12-29 12:23:18,957 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot read list of 10 last viewed videos
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of 10 last viewed videos
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:135)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:242)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:182)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:165)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:83)
at org.serviio.upnp.service.contentdirectory.ContentDirectoryEngine.browse(ContentDirectoryEngine.java:102)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:66)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:61)
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:192)
Caused by: org.serviio.db.dao.PersistenceException: Cannot read list of 10 last viewed videos
at org.serviio.library.dao.VideoDAOImpl.retrieveLastViewedVideos(VideoDAOImpl.java:842)
at org.serviio.library.local.service.VideoService.getListOfLastViewedVideos(VideoService.java:486)
at org.serviio.upnp.service.contentdirectory.command.video.ListLastViewedVideosCommand.retrieveEntityList(ListLastViewedVideosCommand.java:41)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityItemCommand.retrieveList(AbstractEntityItemCommand.java:51)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:129)
... 18 more
Caused by: java.sql.SQLDataException: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.serviio.library.dao.VideoDAOImpl.retrieveLastViewedVideos(VideoDAOImpl.java:826)
... 22 more
Caused by: java.sql.SQLException: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
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 2201W: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.bindOffsetFetch(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 30 more
2012-12-29 12:23:18,965 WARN [ContentDirectory] Browse for object id 2 failed with exception: org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of 10 last viewed videos
java.lang.RuntimeException: org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of 10 last viewed videos
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:245)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:182)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:165)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:83)
at org.serviio.upnp.service.contentdirectory.ContentDirectoryEngine.browse(ContentDirectoryEngine.java:102)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:66)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:61)
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:192)
Caused by: org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of 10 last viewed videos
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:135)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:242)
... 17 more
Caused by: org.serviio.db.dao.PersistenceException: Cannot read list of 10 last viewed videos
at org.serviio.library.dao.VideoDAOImpl.retrieveLastViewedVideos(VideoDAOImpl.java:842)
at org.serviio.library.local.service.VideoService.getListOfLastViewedVideos(VideoService.java:486)
at org.serviio.upnp.service.contentdirectory.command.video.ListLastViewedVideosCommand.retrieveEntityList(ListLastViewedVideosCommand.java:41)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityItemCommand.retrieveList(AbstractEntityItemCommand.java:51)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:129)
... 18 more
Caused by: java.sql.SQLDataException: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.serviio.library.dao.VideoDAOImpl.retrieveLastViewedVideos(VideoDAOImpl.java:826)
... 22 more
Caused by: java.sql.SQLException: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
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 2201W: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.bindOffsetFetch(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 30 more
2012-12-29 12:23:18,978 DEBUG [ServiceControlRequestHandler] Returning error SOAP message
2012-12-29 12:23:19,122 DEBUG [WebServer] Incoming connection from /192.168.100.66:49112
2012-12-29 12:23:19,122 DEBUG [RendererDAOImpl] Reading a Renderer with ip address 192.168.100.66
Last edited by tombert on Wed Aug 28, 2013 7:03 pm, edited 1 time in total.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sat Dec 29, 2012 12:31 pm

Re: 1v1: Cannot read list of 10 last viewed videos

Try to change the number of items for dynamic categories on the Presentation tab.
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Thu Jan 03, 2013 8:17 am

Re: 1v1: Cannot read list of 10 last viewed videos

Hi
This worked temporarily. I reinstalled serviio and the failure happended again. I changed the number to 5 - it works ... after some days changed it back to 10 and it crashes.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Thu Jan 03, 2013 10:00 am

Re: 1v1: Cannot read list of 10 last viewed videos

Would it be because you have less than 10 viewed videos? Considering it happens after a new install, but didn't happen when you set it to 5.
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Thu Jan 03, 2013 2:18 pm

Re: 1v1: Cannot read list of 10 last viewed videos

Possibly ... but cant say for sure.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Thu Jan 03, 2013 4:53 pm

Re: 1v1: Cannot read list of 10 last viewed videos

I'll check
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sun Jan 06, 2013 2:09 pm

Re: 1v1: Cannot read list of 10 last viewed videos

Do you have a detailed log of what happens just before this exception? There should be some Browse request and a line starting with

  Code:
Retrieving list of XX last viewed videos
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Sun Jan 06, 2013 4:10 pm

Re: 1v1: Cannot read list of 10 last viewed videos

via PM ...
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sun Jan 06, 2013 7:14 pm

Re: 1v1: Cannot read list of 10 last viewed videos

I was able to reproduce it. It seems you have last added as Content only as well as some other categories in the root. In this case the pagination doesn't work properly and would be hard to fix. I fixed the exception, so it' should continue working, but there might be some items missing.
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Mon Jan 07, 2013 7:37 am

Re: 1v1: Cannot read list of 10 last viewed videos

I do have Video Folders (Content only) and Last Viewed Items (Content only) - everything else is disabled.
... but I did not have such problems with 0.6 ...
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Tue Jan 08, 2013 1:51 pm

Re: 1v1: Cannot read list of 10 last viewed videos

No you would not, but there are some code changes related to the user-defined number of items to be returned.
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Wed Aug 28, 2013 7:01 pm

Re: 1v1: Cannot read list of 10 last viewed videos

Hi,

again having this issue with 20 items in view. When setting the number to 5 it works.
I have installed the latest version 1.3.

thx
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Wed Aug 28, 2013 9:34 pm

Re: 1v1: Recent video list crashes - now with 1v3

Can you poste detailed log? Is this with a new install again (I remember last time it crashed when there was less that the requested max. number of items in the Last Added category)
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Thu Aug 29, 2013 5:55 pm

Re: 1v1: Recent video list crashes - now with 1v3

Its a complete new install - deleted old folder and rescanned lib. Heres the log:

2013-08-29 19:52:16,976 DEBUG [RendererDAOImpl] Reading a Renderer with ip address 192.168.100.66
2013-08-29 19:52:16,982 DEBUG [ContentDirectory] Browse() called for renderer KDL-40EX500 (profile sony2010) with parameters: objectID = 2, browseFlag = BrowseDirectChildren, filter = dc:title,av:mediaClass,dc:date,@childCount,res,upnp:class,res@resolution,upnp:album,upnp:genre,upnp:albumArtURI,upnp:albumArtURI@dlna:profileID,dc:creator,res@size,res@duration,res@bitrate,res@protocolInfo, startIndex = 10, count = 10, sortCriteria =
2013-08-29 19:52:16,982 DEBUG [AccessGroupDAOImpl] Reading a AccessGroup (id = 1)
2013-08-29 19:52:16,983 DEBUG [RepositoryDAOImpl] Retrieving list of Repositories for VIDEO (from=10, count=10) [No_Restriction]
2013-08-29 19:52:16,984 DEBUG [RepositoryDAOImpl] Retrieving number of repositories for VIDEO [No_Restriction]
2013-08-29 19:52:16,985 DEBUG [VideoDAOImpl] Retrieving list of 10 last viewed videos (from=10, count=10) [No_Restriction]
2013-08-29 19:52:16,992 ERROR [ContainerNode] Cannot retrieve results of action command: Cannot execute library command for list: Cannot read list of 10 last viewed videos
org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of 10 last viewed videos
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:135)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:242)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:182)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:165)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:83)
at org.serviio.upnp.service.contentdirectory.ContentDirectoryEngine.browse(ContentDirectoryEngine.java:102)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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:66)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:61)
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:192)
Caused by: org.serviio.db.dao.PersistenceException: Cannot read list of 10 last viewed videos
at org.serviio.library.dao.VideoDAOImpl.retrieveLastViewedVideos(VideoDAOImpl.java:842)
at org.serviio.library.local.service.VideoService.getListOfLastViewedVideos(VideoService.java:486)
at org.serviio.upnp.service.contentdirectory.command.video.ListLastViewedVideosCommand.retrieveEntityList(ListLastViewedVideosCommand.java:41)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityItemCommand.retrieveList(AbstractEntityItemCommand.java:51)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:129)
... 18 more
Caused by: java.sql.SQLDataException: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.serviio.library.dao.VideoDAOImpl.retrieveLastViewedVideos(VideoDAOImpl.java:826)
... 22 more
Caused by: java.sql.SQLException: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
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 2201W: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.bindOffsetFetch(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 30 more
2013-08-29 19:52:16,993 WARN [ContentDirectory] Browse for object id 2 failed with exception: org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of 10 last viewed videos
java.lang.RuntimeException: org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of 10 last viewed videos
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:245)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:182)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.findContainerItems(ContainerNode.java:165)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.retrieveContainerItems(ContainerNode.java:83)
at org.serviio.upnp.service.contentdirectory.ContentDirectoryEngine.browse(ContentDirectoryEngine.java:102)
at org.serviio.upnp.service.contentdirectory.ContentDirectory.Browse(ContentDirectory.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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:66)
at org.serviio.upnp.webserver.AbstractRequestHandler.handle(AbstractRequestHandler.java:61)
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:192)
Caused by: org.serviio.upnp.service.contentdirectory.command.CommandExecutionException: Cannot execute library command for list: Cannot read list of 10 last viewed videos
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:135)
at org.serviio.upnp.service.contentdirectory.definition.ContainerNode.executeListAction(ContainerNode.java:242)
... 17 more
Caused by: org.serviio.db.dao.PersistenceException: Cannot read list of 10 last viewed videos
at org.serviio.library.dao.VideoDAOImpl.retrieveLastViewedVideos(VideoDAOImpl.java:842)
at org.serviio.library.local.service.VideoService.getListOfLastViewedVideos(VideoService.java:486)
at org.serviio.upnp.service.contentdirectory.command.video.ListLastViewedVideosCommand.retrieveEntityList(ListLastViewedVideosCommand.java:41)
at org.serviio.upnp.service.contentdirectory.command.AbstractEntityItemCommand.retrieveList(AbstractEntityItemCommand.java:51)
at org.serviio.upnp.service.contentdirectory.command.AbstractCommand.retrieveItemList(AbstractCommand.java:129)
... 18 more
Caused by: java.sql.SQLDataException: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.serviio.library.dao.VideoDAOImpl.retrieveLastViewedVideos(VideoDAOImpl.java:826)
... 22 more
Caused by: java.sql.SQLException: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
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 2201W: Row count for FIRST/NEXT must be >= 1 and row count for LIMIT must be >= 0.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.bindOffsetFetch(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 30 more
2013-08-29 19:52:16,996 DEBUG [ServiceControlRequestHandler] Returning error SOAP message
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Wed Sep 04, 2013 9:32 pm

Re: 1v1: Recent video list crashes - now with 1v3

Thanks, looks like the same issue, damn. Will fix it for next release.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sun Sep 15, 2013 11:32 am

Re: 1v1: Recent video list crashes - now with 1v3

I can't reproduce this. Can you confirm:

1) you are using 1.3.1
2) You have Folders and Last Viewed as Content only, rest disabled
3) How many shared video folder you have (ie how many folders can you see via the Contents only view of Folders)
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Mon Sep 16, 2013 6:24 pm

Re: 1v1: Recent video list crashes - now with 1v3

Hi, I am on Holiday till Friday ... will check this on WE.

greets
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Sat Sep 21, 2013 10:21 am

Re: 1v1: Recent video list crashes - now with 1v3

Hi,

I am using the download serviio-1.3-linux.tar.gz

Video, Folders and "Last Viewed" is set to "Display Content only", everything else disabled.

There is only one folder visible called "Videos" (in the Library I have only one folder added) and then below the last viewed items.


thx
<<

tombert

User avatar

DLNA master

Posts: 217

Joined: Wed Oct 13, 2010 8:01 pm

Post Tue Dec 03, 2013 9:11 pm

Re: 1v1: Recent video list crashes - now with 1v3

Hi,

with 1v3v1 (install from scratch) the behaviour changed to endless loop:

2013-12-03 22:07:36,912 DEBUG [VideoDAOImpl] Retrieving list of 10 last viewed videos (from=10, count=10) [No_Restriction]
2013-12-03 22:07:36,912 DEBUG [VideoDAOImpl] Retrieving number of 10 last viewed videos [No_Restriction]
2013-12-03 22:07:36,929 DEBUG [ServiceControlRequestHandler] Returning OK SOAP message
2013-12-03 22:07:36,995 DEBUG [ServiioHttpService] Incoming request from /192.168.100.66:43230: POST /serviceControl HTTP/1.1, headers = [X-AV-Physical-Unit-Info: pa="BRAVIA KDL-40EX500";,X-AV-Client-Info: av=5.0; cn="Sony Corporation"; mn="BRAVIA KDL-40EX500"; mv="1.7";,Host: 192.168.100.1:8895,User-Agent: UPnP/1.0 DLNADOC/1.50,Content-Length: 640,Content-Type: text/xml; charset="utf-8",SOAPACTION: "urn:schemas-upnp-org:service:ContentDirectory:1#Browse"]]
2013-12-03 22:07:36,995 DEBUG [RendererDAOImpl] Reading a Renderer with ip address 192.168.100.66
2013-12-03 22:07:36,995 DEBUG [ServiceControlRequestHandler] ServiceControl request received for action '"urn:schemas-upnp-org:service:ContentDirectory:1#Browse"' from 192.168.100.66
2013-12-03 22:07:36,995 DEBUG [RendererDAOImpl] Reading a Renderer with ip address 192.168.100.66
2013-12-03 22:07:36,998 DEBUG [ContentDirectory] Browse() called for renderer KDL-40EX500 (profile sony2010) with parameters: objectID = 2, browseFlag = BrowseDirectChildren, filter = dc:title,av:mediaClass,dc:date,@childCount,res,upnp:class,res@resolution,upnp:album,upnp:genre,upnp:albumArtURI,upnp:albumArtURI@dlna:profileID,dc:creator,res@size,res@duration,res@bitrate,res@protocolInfo, startIndex = 10, count = 10, sortCriteria =
2013-12-03 22:07:37,000 DEBUG [AccessGroupDAOImpl] Reading a AccessGroup (id = 1)
2013-12-03 22:07:37,016 DEBUG [RepositoryDAOImpl] Retrieving list of Repositories for VIDEO (from=10, count=10) [No_Restriction]
2013-12-03 22:07:37,017 DEBUG [RepositoryDAOImpl] Retrieving number of repositories for VIDEO [No_Restriction]
2013-12-03 22:07:37,018 DEBUG [VideoDAOImpl] Retrieving list of 10 last viewed videos (from=10, count=10) [No_Restriction]
2013-12-03 22:07:37,018 DEBUG [VideoDAOImpl] Retrieving number of 10 last viewed videos [No_Restriction]
2013-12-03 22:07:37,106 DEBUG [ServiceControlRequestHandler] Returning OK SOAP message
2013-12-03 22:07:37,170 DEBUG [ServiioHttpService] Incoming request from /192.168.100.66:43231: POST /serviceControl HTTP/1.1, headers = [X-AV-Physical-Unit-Info: pa="BRAVIA KDL-40EX500";,X-AV-Client-Info: av=5.0; cn="Sony Corporation"; mn="BRAVIA KDL-40EX500"; mv="1.7";,Host: 192.168.100.1:8895,User-Agent: UPnP/1.0 DLNADOC/1.50,Content-Length: 640,Content-Type: text/xml; charset="utf-8",SOAPACTION: "urn:schemas-upnp-org:service:ContentDirectory:1#Browse"]]
2013-12-03 22:07:37,170 DEBUG [RendererDAOImpl] Reading a Renderer with ip address 192.168.100.66
2013-12-03 22:07:37,170 DEBUG [ServiceControlRequestHandler] ServiceControl request received for action '"urn:schemas-upnp-org:service:ContentDirectory:1#Browse"' from 192.168.100.66
2013-12-03 22:07:37,170 DEBUG [RendererDAOImpl] Reading a Renderer with ip address 192.168.100.66
2013-12-03 22:07:37,173 DEBUG [ContentDirectory] Browse() called for renderer KDL-40EX500 (profile sony2010) with parameters: objectID = 2, browseFlag = BrowseDirectChildren, filter = dc:title,av:mediaClass,dc:date,@childCount,res,upnp:class,res@resolution,upnp:album,upnp:genre,upnp:albumArtURI,upnp:albumArtURI@dlna:profileID,dc:creator,res@size,res@duration,res@bitrate,res@protocolInfo, startIndex = 10, count = 10, sortCriteria =
2013-12-03 22:07:37,173 DEBUG [AccessGroupDAOImpl] Reading a AccessGroup (id = 1)
2013-12-03 22:07:37,186 DEBUG [RepositoryDAOImpl] Retrieving list of Repositories for VIDEO (from=10, count=10) [No_Restriction]
2013-12-03 22:07:37,187 DEBUG [RepositoryDAOImpl] Retrieving number of repositories for VIDEO [No_Restriction]
2013-12-03 22:07:37,187 DEBUG [VideoDAOImpl] Retrieving list of 10 last viewed videos (from=10, count=10) [No_Restriction]
2013-12-03 22:07:37,187 DEBUG [VideoDAOImpl] Retrieving number of 10 last viewed videos [No_Restriction]
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Wed Dec 18, 2013 9:43 pm

Re: 1v1: Recent video list crashes - now with 1v3

Ok, I think I fixed it for 1.4 - hopefully it didn't break something else ;-)

Return to Serviio Support & Help

Who is online

Users browsing this forum: Google [Bot] and 21 guests

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