119423 – Open office service hung

Issue 119423 - Open office service hung

Summary: Open office service hung

Status:	UNCONFIRMED

Alias:	None

Product:	General
Classification:	Code
Component:	code (show other issues)
Version:	OOo 3.3
Hardware:	All All

Importance:	P2 Major (vote)
Target Milestone:	---
Assignee:	AOO issues mailing list
QA Contact:

URL:
Keywords:	needhelp

Depends on:
Blocks:

Reported:	2012-05-27 10:34 UTC by jvchbabu
Modified:	2014-01-19 14:43 UTC (History)
CC List:	3 users (show)

See Also:
Issue Type:	DEFECT
Latest Confirmation in:	---
Developer Difficulty:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.

Description jvchbabu 2012-05-27 10:34:45 UTC

Comment 1 jvchbabu 2012-05-27 11:27:06 UTC

Hi,

 We are using open office spreadsheet API to generate Excel reports.We have the data stored in ArrayList (java) and writing to range of cells. The data is quite huge ie.. 90 thousand rows having 10 columns for each row. 
Two or three users concurrently requested for this particular report then the open office service hung and it's a kind of freeze and no further requests are serviced by open office service until we restart it.
This is happening frequently for every two or three hours. This is production environment and every time to restart the open office service is difficult moreover convincing client for restart. The code segments are given below.

1)The below code is responsible to write a set of rows to a cell range.

XTableColumns xColumns = xCRRange.getColumns();
XCellRangeData rangeData=null; 
Object[][] rangeValues=null; 		    	curCellRange=totalCellRange.getCellRangeByPosition(0, 0, 10, 91000);

rangeData = (XCellRangeData) UnoRuntime.queryInterface(XCellRangeData.class, curCellRange);
rangeValues = rangeData.getDataArray(); 

//we will be iterating valueList(Arraylist) and placing them into rangeValues array

rangeData.setDataArray(rangeValues);// this will set rangevalues to a cell range.

Note: The Three requests are in process and open office service hung we have taken the thread dump.

Thread dump at that moment:

"[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'" daemon prio=10 tid=0x00002aac991bd400 nid=0x6c6e in Object.wait() [0x000000004a7a4000..0x000000004a7a5c10]
   java.lang.Thread.State: WAITING (on object monitor)
	at java.lang.Object.wait(Native Method)
	- waiting on <0x00002aaafe0efe20> (a com.sun.star.lib.uno.environments.remote.JobQueue)
	at com.sun.star.lib.uno.environments.remote.JobQueue.removeJob(JobQueue.java:289)
	- locked <0x00002aaafe0efe20> (a com.sun.star.lib.uno.environments.remote.JobQueue)
	at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:399)
	at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:372)
	at com.sun.star.lib.uno.environments.remote.JavaThreadPool.enter(JavaThreadPool.java:132)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge.sendRequest(java_remote_bridge.java:902)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge.sendRequest(java_remote_bridge.java:851)
	at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.request(ProxyFactory.java:177)
	at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.invoke(ProxyFactory.java:163)
	at $Proxy86.setDataArray(Unknown Source)
	at com.metricstream.systemi.client.openoffice.ExcelProcess.processHorizontalTable(ExcelProcess.java:421)
	at com.metricstream.systemi.client.openoffice.ExcelProcess.processTableRow(ExcelProcess.java:311)
	at com.metricstream.systemi.client.openoffice.ExcelProcess.replaceTextFields(ExcelProcess.java:252)
	at com.metricstream.systemi.client.openoffice.ExcelSpreadsheet.generateSpreadsheet(ExcelSpreadsheet.java:188)
	at com.metricstream.systemi.client.servlet.servant.Reportsexportwordpopup.validateFormData(Reportsexportwordpopup.java:137)
	at com.metricstream.systemi.client.servlet.servant.BaseViewController.serve(BaseViewController.java:461)
	- locked <0x00002aac50384090> (a com.metricstream.systemi.client.servlet.servant.Reportsexportwordpopup)
	at com.metricstream.systemi.client.servlet.FrontController.doRequest(FrontController.java:226)
	at com.metricstream.systemi.client.servlet.FrontController.doPost(FrontController.java:128)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

                                  ***********	
"[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'" daemon prio=10 tid=0x000000005e862c00 nid=0x6c6a in Object.wait() [0x000000004a3a0000..0x000000004a3a1a10]
   java.lang.Thread.State: WAITING (on object monitor)
	at java.lang.Object.wait(Native Method)
	- waiting on <0x00002aaafe07bc80> (a com.sun.star.lib.uno.environments.remote.JobQueue)
	at com.sun.star.lib.uno.environments.remote.JobQueue.removeJob(JobQueue.java:289)
	- locked <0x00002aaafe07bc80> (a com.sun.star.lib.uno.environments.remote.JobQueue)
	at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:399)
	at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:372)
	at com.sun.star.lib.uno.environments.remote.JavaThreadPool.enter(JavaThreadPool.java:132)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge.sendRequest(java_remote_bridge.java:902)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge.sendRequest(java_remote_bridge.java:851)
	at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.request(ProxyFactory.java:177)
	at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.invoke(ProxyFactory.java:163)
	at $Proxy86.setDataArray(Unknown Source)
	at com.metricstream.systemi.client.openoffice.ExcelProcess.processHorizontalTable(ExcelProcess.java:421)
	at com.metricstream.systemi.client.openoffice.ExcelProcess.processTableRow(ExcelProcess.java:311)
	at com.metricstream.systemi.client.openoffice.ExcelProcess.replaceTextFields(ExcelProcess.java:252)
	at com.metricstream.systemi.client.openoffice.ExcelSpreadsheet.generateSpreadsheet(ExcelSpreadsheet.java:188)
	at com.metricstream.systemi.client.servlet.servant.Reportsexportwordpopup.validateFormData(Reportsexportwordpopup.java:137)
	at com.metricstream.systemi.client.servlet.servant.BaseViewController.serve(BaseViewController.java:461)
	- locked <0x00002aabf8a6e268> (a com.metricstream.systemi.client.servlet.servant.Reportsexportwordpopup)
	at com.metricstream.systemi.client.servlet.FrontController.doRequest(FrontController.java:226)
	at com.metricstream.systemi.client.servlet.FrontController.doPost(FrontController.java:128)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
			
		    	

The error log indicates  Disposed of Exceptions.
Error log:
05/23/12 14:41:00.063 CEST ERROR (Thread[[ACTIVE] ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]) [ExcelProcess] exception: com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100 (s:null c:null i:null)
com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.invoke(java_remote_bridge.java:282)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.run(java_remote_bridge.java:170)
05/23/12 14:41:00.063 CEST ERROR (Thread[[ACTIVE] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]) [ExcelProcess] exception: com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100 (s:null c:null i:null)
com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.invoke(java_remote_bridge.java:282)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.run(java_remote_bridge.java:170)
05/23/12 14:41:00.063 CEST ERROR (Thread[[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]) [ExcelProcess] exception: com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100 (s:null c:null i:null)
com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.invoke(java_remote_bridge.java:282)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.run(java_remote_bridge.java:170)
05/23/12 14:41:00.063 CEST ERROR (Thread[[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]) [ExcelProcess] exception: com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100 (s:null c:null i:null)
com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.invoke(java_remote_bridge.java:282)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.run(java_remote_bridge.java:170)
05/23/12 14:41:00.063 CEST ERROR (Thread[[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]) [ExcelProcess] exception: com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100 (s:null c:null i:null)
com.sun.star.lang.DisposedException: com.sun.star.io.IOException: EOF reached - socket,host=localhost,port=8100,localHost=localhost.localdomain,localPort=12958,peerHost=localhost,peerPort=8100
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.invoke(java_remote_bridge.java:282)
	at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.run(java_remote_bridge.java:170)


We are running into this kind of situation for every two or thee hours and open office service requires restart.
The Thread dump indicates that the open office internal processing threads went into some kind of deadlock situation at com.sun.star.lib.uno.environments.remote.JobQueue.removeJob(JobQueue.java:289)
- locked <0x00002aaafe07bc80> (a com.sun.star.lib.uno.environments.remote.JobQueue).

Comment 2 jvchbabu 2012-05-27 11:29:09 UTC

We are willing to provide any additional information to resolve this.

Comment 3 jvchbabu 2012-05-27 11:37:29 UTC

We have encountered similar kind of bug  in the past for word processing and raised bug under bug_id #117817.

Comment 4 zhao xia 2012-05-28 05:12:48 UTC

I couldn't verify if I can reproduce this problem now. But this is API related problem, shouldn't be 341 relese blocker. Target it with AOO35 and place it to AOO next major release propose fix pool.

Comment 5 jvchbabu 2012-05-28 05:19:21 UTC

(In reply to comment #4)
> I couldn't verify if I can reproduce this problem now. But this is API
> related problem, shouldn't be 341 relese blocker. Target it with AOO35 and
> place it to AOO next major release propose fix pool.

 Yeah. I agree with you. We didn't intervene the API threading process.The threads are going into indefinite waiting state during API internal processing and no further requests are processed. This is a major obstacle for us.The same issue we observed in earlier releases also.

Comment 6 Marcus 2012-05-28 08:44:30 UTC

Changed back to AOO340. This is the field to show the version where the problem is happening, not where it should be fixed.

Comment 7 jvchbabu 2012-05-28 09:26:51 UTC

(In reply to comment #6)
> Changed back to AOO340. This is the field to show the version where the
> problem is happening, not where it should be fixed.


The current version of open office we are using is OpenOffice.org.3.3.0(ooo330m20)

Comment 8 Marcus 2012-05-28 10:41:43 UTC

Thanks for your hint. In the meantime I've found another issue that will be used to address this problem in general. Therefore I'll close this issue as duplicate.

*** This issue has been marked as a duplicate of issue 119323 ***

Comment 9 jvchbabu 2012-05-28 10:53:36 UTC

(In reply to comment #8)
> Thanks for your hint. In the meantime I've found another issue that will be
> used to address this problem in general. Therefore I'll close this issue as
> duplicate.
> 
> *** This bug has been marked as a duplicate of bug 119323 ***

It may not be a good idea to mark this bug as duplicate of some other bug, the context we have currently is totally different to the bug we are referring.

Please consider it as separate bug due the criticality of the issue in hand.

Comment 10 jvchbabu 2012-06-05 14:02:59 UTC

This issue is happening consistently.None of the Excel files are exported,please look into this issue and provide approximate time lines for fix.