[OFBiz] Dev - MS SQL Server and Cancel Orders

[David E. Jones]

Which version of OFBiz are you using? If I remember right in an older 
version there was a dead-lock issue in the order cancel code. This was 
fixed a number of months ago though.

-David


On Apr 4, 2005, at 6:49 AM, Denny Breitenfeld wrote:

> Hi,
>
>   I've searched the wiki, the mailing list, google, MSN's new search 
> server, and I've also debuged the problem. Unfortunatly I can't find 
> an answer to the problem.  When I cancel an order I'm getting the 
> following hang:  (this is the stack trace).
>
> Thread [PoolThread-4] (Suspended)
> SocketInputStream.socketRead0(FileDescriptor, byte[], int, int, int)
> line: not available [native method]
> SocketInputStream.read(byte[], int, int) line: not available
> UtilSocketDataProvider.getArrayOfBytes(byte[], int, int) line: not
> available
> UtilBufferedDataProvider.cacheNextBlock() line: not available
> UtilBufferedDataProvider.getArrayOfBytes(byte[], int, int) line: not
> available
> SQLServerDepacketizingDataProvider.signalStartOfPacket() line: not
> available
>
> SQLServerDepacketizingDataProvider(UtilDepacketizingDataProvider).getAr
> rayOfBytes(byte[], int, int) line: not available
> UtilPagedTempBuffer.write(long, UtilDataProvider, int) line: not
> available
> UtilPagedTempBuffer.write(UtilDataProvider) line: not available
> UtilByteArrayDataProvider.receive() line: not available
> UtilByteOrderedDataReader.receive() line: not available
> TDSCursorRequest(TDSRPCRequest).submitRequest() line: not available
> TDSCursorRequest.sendCursorFetch(int, int, BaseWarnings) line: not
> available
> TDSCursorRequest.openCursor(BaseWarnings) line: not available
> SQLServerImplStatement.execute() line: not available
> BasePreparedStatement(BaseStatement).commonExecute() line: not
> available
> BasePreparedStatement(BaseStatement).executeQueryInternal() line: not
> available
> BasePreparedStatement.executeQuery() line: not available
> SQLProcessor.executeQuery() line: 373
> GenericDAO.selectListIteratorByCondition(ModelEntity,
> EntityCondition, EntityCondition, Collection, List, EntityFindOptions)
> line: 831
> GenericDAO.selectByAnd(ModelEntity, Map, List) line: 632
> GenericHelperDAO.findByAnd(ModelEntity, Map, List) line: 147
> GenericDelegator.findByAnd(ModelEntity, Map, List) line: 852
> GenericDelegator.findByAnd(String, Map, List) line: 837
> GenericDelegator.getRelated(String, Map, List, GenericValue) line:
> 1338
> GenericDelegator.getRelated(String, GenericValue) line: 1284
> GenericValue.getRelated(String) line: 125
> OrderReadHelper.getOrderItems() line: 687
> OrderReadHelper.getValidOrderItems() line: 699
> OrderReadHelper.getOrderGrandTotal() line: 655
> OrderServices.resetGrandTotal(DispatchContext, Map) line: 581
> NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not
> available [native method]
> NativeMethodAccessorImpl.invoke(Object, Object[]) line: not available
> [local variables unavailable]
> DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: not
> available [local variables unavailable]
> Method.invoke(Object, Object[]) line: not available [local variables
> unavailable]
> StandardJavaEngine.serviceInvoker(String, ModelService, Map) line: 101
> StandardJavaEngine.runSync(String, ModelService, Map) line: 63
> ServiceDispatcher.runSync(String, ModelService, Map, boolean) line:
> 280
> ServiceDispatcher.runSync(String, ModelService, Map) line: 171
> WebAppDispatcher(GenericDispatcher).runSync(String, Map) line: 110
> ServiceEcaAction.runAction(String, DispatchContext, Map, Map) line: 77
> ServiceEcaRule.eval(String, DispatchContext, Map, Map, boolean, Set)
> line: 124
> ServiceEcaUtil.evalRules(String, Map, String, DispatchContext, Map,
> Map, boolean) line: 165
> ServiceDispatcher.runSync(String, ModelService, Map, boolean) line:
> 304
> ServiceDispatcher.runSync(String, ModelService, Map) line: 171
> WebAppDispatcher(GenericDispatcher).runSync(String, Map) line: 110
> ServiceEventHandler.invoke(String, String, HttpServletRequest,
> HttpServletResponse) line: 178
> RequestHandler.runEvent(HttpServletRequest, HttpServletResponse,
> String, String, String) line: 363
> RequestHandler.doRequest(HttpServletRequest, HttpServletResponse,
> String, GenericValue, GenericDelegator) line: 238
> ControlServlet.doGet(HttpServletRequest, HttpServletResponse) line:
> 187
> ControlServlet(HttpServlet).service(HttpServletRequest,
> HttpServletResponse) line: 740
> ControlServlet(HttpServlet).service(ServletRequest, ServletResponse)
> line: 853
> ServletHolder.handle(ServletRequest, ServletResponse) line: 354
> WebApplicationHandler$Chain.doFilter(ServletRequest, ServletResponse)
> line: 342
> ContextFilter.doFilter(ServletRequest, ServletResponse, FilterChain)
> line: 228
> WebApplicationHandler$Chain.doFilter(ServletRequest, ServletResponse)
> line: 334
> WebApplicationHandler.dispatch(String, HttpServletRequest,
> HttpServletResponse, ServletHolder) line: 286
> WebApplicationHandler(ServletHandler).handle(String, String,
> HttpRequest, HttpResponse) line: 567
> WebApplicationContext(HttpContext).handle(String, String,
> HttpRequest, HttpResponse) line: 1808
> WebApplicationContext.handle(String, String, HttpRequest,
> HttpResponse) line: 525
> WebApplicationContext(HttpContext).handle(HttpRequest, HttpResponse)
> line: 1758
> Server(HttpServer).service(HttpRequest, HttpResponse) line: 879
> HttpConnection.service(HttpRequest, HttpResponse) line: 790
> HttpConnection.handleNext() line: 952
> HttpConnection.handle() line: 807
> SunJsseListener(SocketListener).handleConnection(Socket) line: 197
> SunJsseListener(ThreadedServer).handle(Object) line: 289
> ThreadPool$PoolThread.run() line: 501
>
>
> I'm using MSSQL Server 8.0 and it has unlimited connections.  I read 
> in a previous mailing that there is a lock on one of the rows, and 
> this caused a hang before. However I then read a fix was put in, and 
> this was in 2004 so i'm not sure if it is the same problem.
>
> Thanks for your help!
>
> Denny
>
> _______________________________________________
> Dev mailing list
> Dev at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/dev
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2363 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/dev/attachments/20050404/324c44ce/smime-0001.bin