DB Timeout response to emby/Users/Items?Recursive=true&IncludeitemTypes=Season

[GlennNZ 92]

Hi Luke,

 

Been getting timeout errors for the below query:

 

2016-08-08 14:53:05.4002 Info HttpServer: HTTP Response 200 to 192.168.1.40. Time: 10156ms (slow). http://192.168.1.206:8096/emby/Users/-23---/Items?ExcludeLocationTypes=Virtual&Recursive=true&IncludeItemTypes=Series

This one fine - big DB:

 

But this one for below: Timeouts ?

http://192.168.1.206:8096/emby/Users/-Removed-/Items?Recursive=true&IncludeItemTypes=Season

(likewise through swagger)

2016-08-08 15:06:49.9362 Error ServiceStackHost: Error occured while Processing Request: Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
	*** Error Report ***
	Version: 3.1.6062.16456
	Command line: C:\Users\Vwin7\AppData\Roaming\Emby-Server\System\MediaBrowser.ServerApplication.exe
	Operating system: Microsoft Windows NT 6.2.9200.0
	Processor count: 4
	64-Bit OS: True
	64-Bit Process: True
	Program data path: C:\Users\Vwin7\AppData\Roaming\Emby-Server
	Application Path: C:\Users\Vwin7\AppData\Roaming\Emby-Server\System\MediaBrowser.ServerApplication.exe
	Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
	System.IO.IOException
	   at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
	   at SocketHttpListener.Net.ResponseStream.InternalWrite(Byte[] buffer, Int32 offset, Int32 count)
	   at SocketHttpListener.Net.ResponseStream.Write(Byte[] buffer, Int32 offset, Int32 count)
	   at System.IO.StreamWriter.Flush(Boolean flushStream, Boolean flushEncoder)
	   at ServiceStack.Text.JsonSerializer.SerializeToStream[T](T value, Stream stream)
	   at ServiceStack.Serialization.JsonDataContractSerializer.SerializeToStream[T](T obj, Stream stream)
	   at ServiceStack.HttpResponseExtensionsInternal.WriteErrorToResponse(IResponse httpRes, IRequest httpReq, String contentType, String operationName, String errorMessage, Exception ex, Int32 statusCode)
	   at ServiceStack.ServiceStackHost.HandleUncaughtException(IRequest httpReq, IResponse httpRes, String operationName, Exception ex)
	   at ServiceStack.HostContext.RaiseAndHandleUncaughtException(IRequest httpReq, IResponse httpRes, String operationName, Exception ex)
	   at ServiceStack.HttpResponseExtensionsInternal.HandleResponseWriteException(Exception originalEx, IRequest request, IResponse response, String defaultContentType)
	   at ServiceStack.HttpResponseExtensionsInternal.<WriteToResponse>d__6.MoveNext()
	--- End of stack trace from previous location where exception was thrown ---
	   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
	   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
	   at ServiceStack.Host.RestHandler.<ProcessRequestAsync>d__13.MoveNext()
	InnerException: System.Net.Sockets.SocketException
	An established connection was aborted by the software in your host machine
	   at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
	   at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
	
2016-08-08 15:06:49.9362 Info HttpServer: HTTP Response 500 to 192.168.1.40. Time: 809836ms. http://192.168.1.206:8096/emby/Users/358b90452ca2412eb4ecc54b11e2f0b3/Items?Recursive=true&IncludeItemTypes=Season

Any thoughts

 

Tah

 

Glenn