Serviio

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

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

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.

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.

Possibly ... but cant say for sure.

I'll check

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

via PM ...

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.

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 ...

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

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

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)

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

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

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)

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

greets

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

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]

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