Delete task timeout

[Sergio Perez Aranda]

Hello,

we have a task that has three subtasks.

When we try to delete the parent or any of the children JIRA seems to hang out and when any user tries to access to a task, or even to indexing in administration, the system shows the "ongoing" icon but there is not response and we need to restart the server.

Thanks.

Sergio

[Sergio Perez Aranda · Accepted solution]

I have the log but I don't know how to attach it. I cannot find which is the exact problem.

Maybe this helps?

2016-07-06 09:03:08,373 http-nio-8080-exec-10 WARN sperez 520x652x10 56wwyj 10.161.99.47 /secure/admin/IndexAdmin.jspa [c.a.j.issue.index.DefaultIndexManager] Exception during index consistency check: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: Error getting the next result (The server returned an unspecified error.) 2016-07-06 09:03:08,377 http-nio-8080-exec-20 WARN elopez 507x441x1 1fyvyxc 10.161.99.62 /secure/DeleteIssue.jspa [c.a.jira.index.AccumulatingResultBuilder] Indexing failed for Issue - '11353' 2016-07-06 09:03:08,379 http-nio-8080-exec-25 WARN sperez 509x517x4 1tm0u89 10.161.99.47 /browse/RFCNEGONT-2 [c.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.atlassian.util.concurrent.LazyReference$InitializationException - com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: Error getting the next result (The server returned an unspecified error.)'. 2016-07-06 09:03:08,382 http-nio-8080-exec-19 WARN elopez 508x477x2 1fyvyxc 10.161.99.62 /rest/greenhopper/1.0/xboard/issue/details.json [c.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.atlassian.util.concurrent.LazyReference$InitializationException - com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: Error getting the next result (The server returned an unspecified error.)'. 2016-07-06 09:03:08,385 http-nio-8080-exec-22 WARN sperez 509x514x3 1tm0u89 10.161.99.47 /rest/greenhopper/1.0/xboard/issue/details.json [c.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.atlassian.util.concurrent.LazyReference$InitializationException - com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: Error getting the next result (The server returned an unspecified error.)'. 2016-07-06 09:03:08,387 http-nio-8080-exec-10 ERROR sperez 520x652x10 56wwyj 10.161.99.47 /secure/admin/IndexAdmin.jspa [o.a.c.c.C.[Catalina].[localhost].[/]] Error during mapping java.lang.NullPointerException  at org.apache.catalina.mapper.Mapper.internalMapWrapper(Mapper.java:842)  at org.apache.catalina.mapper.Mapper.map(Mapper.java:712)  at org.apache.catalina.core.ApplicationContext.getRequestDispatcher(ApplicationContext.java:503)  at org.apache.catalina.core.ApplicationContextFacade.getRequestDispatcher(ApplicationContextFacade.java:221)  at org.apache.catalina.core.ApplicationHttpRequest.getRequestDispatcher(ApplicationHttpRequest.java:303)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at javax.servlet.ServletRequestWrapper.getRequestDispatcher(ServletRequestWrapper.java:291)  at webwork.view.taglib.IncludeTag.include(IncludeTag.java:53)  at webwork.view.taglib.ui.ComponentTag.doEndTag(ComponentTag.java:269)  at jsp.secure.admin.jira.views.indexing_jsp._jspx_meth_aui_005fcomponent_005f4(indexing_jsp.java:1220)  at jsp.secure.admin.jira.views.indexing_jsp._jspx_meth_ww_005fif_005f3(indexing_jsp.java:1169)  at jsp.secure.admin.jira.views.indexing_jsp._jspx_meth_page_005fapplyDecorator_005f0(indexing_jsp.java:236)  at jsp.secure.admin.jira.views.indexing_jsp._jspService(indexing_jsp.java:128)  at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)  ... 125 filtered  at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)  ... 50 filtered  at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:59)  ... 147 filtered  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  at java.lang.Thread.run(Thread.java:745) 2016-07-06 09:03:08,387 http-nio-8080-exec-20 WARN elopez 507x441x1 1fyvyxc 10.161.99.62 /secure/DeleteIssue.jspa [c.a.jira.index.AccumulatingResultBuilder] com.mysema.query.QueryException: Caught SQLException for select WORKLOG.id, WORKLOG.issueid, WORKLOG.author, WORKLOG.grouplevel, WORKLOG.rolelevel, WORKLOG.worklogbody, WORKLOG.created, WORKLOG.updateauthor, WORKLOG.updated, WORKLOG.startdate, WORKLOG.timeworked, PROJECT_ROLE.id, PROJECT_ROLE.name, PROJECT_ROLE.description     from dbo.worklog WORKLOG     left join dbo.projectrole PROJECT_ROLE     on PROJECT_ROLE.id = WORKLOG.rolelevel     where WORKLOG.issueid = ?     order by WORKLOG.created asc java.lang.RuntimeException: com.mysema.query.QueryException: Caught SQLException for select WORKLOG.id, WORKLOG.issueid, WORKLOG.author, WORKLOG.grouplevel, WORKLOG.rolelevel, WORKLOG.worklogbody, WORKLOG.created, WORKLOG.updateauthor, WORKLOG.updated, WORKLOG.startdate, WORKLOG.timeworked, PROJECT_ROLE.id, PROJECT_ROLE.name, PROJECT_ROLE.description from dbo.worklog WORKLOG left join dbo.projectrole PROJECT_ROLE on PROJECT_ROLE.id = WORKLOG.rolelevel where WORKLOG.issueid = ? order by WORKLOG.created asc  at com.atlassian.jira.index.DefaultIndex$Failure.<init>(DefaultIndex.java:123)  at com.atlassian.jira.issue.index.DefaultIssueIndexer.lambda$reindexIssues$56(DefaultIssueIndexer.java:216)  at com.atlassian.jira.issue.index.DefaultIssueIndexer$$Lambda$228/1310755851.perform(Unknown Source)  at com.atlassian.jira.issue.index.DefaultIssueIndexer.lambda$null$57(DefaultIssueIndexer.java:348)  at com.atlassian.jira.issue.index.DefaultIssueIndexer$$Lambda$230/1798281968.get(Unknown Source)  at com.atlassian.jira.index.SimpleIndexingStrategy.get(SimpleIndexingStrategy.java:9)  at com.atlassian.jira.index.SimpleIndexingStrategy.get(SimpleIndexingStrategy.java:5)  at com.atlassian.jira.issue.index.DefaultIssueIndexer.lambda$perform$58(DefaultIssueIndexer.java:346)  at com.atlassian.jira.issue.index.DefaultIssueIndexer$$Lambda$229/1054165047.consume(Unknown Source)  at com.atlassian.jira.util.collect.CollectionUtil.foreach(CollectionUtil.java:44)  at com.atlassian.jira.util.collect.CollectionUtil.foreach(CollectionUtil.java:59)  at com.atlassian.jira.issue.util.IssueObjectIssuesIterable.foreach(IssueObjectIssuesIterable.java:28)  at com.atlassian.jira.issue.index.DefaultIssueIndexer.perform(DefaultIssueIndexer.java:321)  at com.atlassian.jira.issue.index.DefaultIssueIndexer.reindexIssues(DefaultIssueIndexer.java:176)  at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssues(DefaultIndexManager.java:613)  at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssueObjects(DefaultIndexManager.java:489)  at com.atlassian.jira.issue.index.DefaultIndexManager.reIndex(DefaultIndexManager.java:513)  at com.atlassian.jira.issue.index.DefaultIndexManager.reIndex(DefaultIndexManager.java:495)  ... 3 filtered  at java.lang.reflect.Method.invoke(Method.java:497)  at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:83)  at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:28)  at com.sun.proxy.$Proxy13.reIndex(Unknown Source)  at com.atlassian.jira.issue.link.DefaultIssueLinkManager.reindexLinkedIssues(DefaultIssueLinkManager.java:145)  at com.atlassian.jira.issue.link.DefaultIssueLinkManager.removeIssueLinkInternal(DefaultIssueLinkManager.java:236)  at com.atlassian.jira.issue.link.DefaultIssueLinkManager.deleteIssueLinksFromIssue(DefaultIssueLinkManager.java:313)  at com.atlassian.jira.issue.link.DefaultIssueLinkManager.removeIssueLinksInternal(DefaultIssueLinkManager.java:298)  at com.atlassian.jira.issue.link.DefaultIssueLinkManager.removeIssueLinksNoChangeItems(DefaultIssueLinkManager.java:276)  at com.atlassian.jira.issue.managers.DefaultIssueDeleteHelper.removeIssueLinks(DefaultIssueDeleteHelper.java:191)  at com.atlassian.jira.issue.managers.DefaultIssueDeleteHelper.deleteIssue(DefaultIssueDeleteHelper.java:130)  at com.atlassian.jira.issue.managers.DefaultIssueDeleteHelper.removeSubTasks(DefaultIssueDeleteHelper.java:246)  at com.atlassian.jira.issue.managers.DefaultIssueDeleteHelper.deleteIssue(DefaultIssueDeleteHelper.java:129)  at com.atlassian.jira.issue.managers.DefaultIssueManager.deleteIssue(DefaultIssueManager.java:897)  at com.atlassian.jira.bc.issue.DefaultIssueService.delete(DefaultIssueService.java:392)  at com.atlassian.jira.bc.issue.DefaultIssueService.delete(DefaultIssueService.java:362)  at com.atlassian.jira.web.action.issue.DeleteIssue.doExecute(DeleteIssue.java:27)  ... 1 filtered  at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:67)  ... 7 filtered  at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)  ... 50 filtered  at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:59)  ... 147 filtered  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  at java.lang.Thread.run(Thread.java:745) Caused by: com.mysema.query.QueryException: Caught SQLException for select WORKLOG.id, WORKLOG.issueid, WORKLOG.author, WORKLOG.grouplevel, WORKLOG.rolelevel, WORKLOG.worklogbody, WORKLOG.created, WORKLOG.updateauthor, WORKLOG.updated, WORKLOG.startdate, WORKLOG.timeworked, PROJECT_ROLE.id, PROJECT_ROLE.name, PROJECT_ROLE.description from dbo.worklog WORKLOG left join dbo.projectrole PROJECT_ROLE on PROJECT_ROLE.id = WORKLOG.rolelevel where WORKLOG.issueid = ? order by WORKLOG.created asc  at com.mysema.query.sql.Configuration.translate(Configuration.java:451)  at com.mysema.query.sql.AbstractSQLQuery.list(AbstractSQLQuery.java:285)  at com.atlassian.jira.issue.worklog.DatabaseWorklogStore.lambda$getByIssue$188(DatabaseWorklogStore.java:197)  at com.atlassian.jira.issue.worklog.DatabaseWorklogStore$$Lambda$235/962897359.runQuery(Unknown Source)  at com.atlassian.jira.database.DbConnectionManagerImpl.executeQuery(DbConnectionManagerImpl.java:88)  at com.atlassian.jira.issue.worklog.DatabaseWorklogStore.getByIssue(DatabaseWorklogStore.java:191)  at com.atlassian.jira.issue.worklog.DefaultWorklogManager.getByIssue(DefaultWorklogManager.java:99)  at com.atlassian.jira.issue.index.DefaultWorklogRetriever.apply(DefaultWorklogRetriever.java:19)  at com.atlassian.jira.issue.index.DefaultWorklogRetriever.apply(DefaultWorklogRetriever.java:14)  at com.atlassian.jira.issue.index.DefaultIssueIndexer$DefaultDocumentCreationStrategy$1.apply(DefaultIssueIndexer.java:663)  at com.atlassian.jira.issue.index.DefaultIssueIndexer$DefaultDocumentCreationStrategy$1.apply(DefaultIssueIndexer.java:659)  at com.atlassian.jira.issue.index.DefaultIssueIndexer$DefaultDocumentCreationStrategy.get(DefaultIssueIndexer.java:651)  at com.atlassian.jira.issue.index.DefaultIssueIndexer.lambda$reindexIssues$56(DefaultIssueIndexer.java:181)  ... 248 more Caused by: java.sql.SQLException: The server returned an unspecified error.  at net.sourceforge.jtds.jdbc.TdsCore.tdsDoneToken(TdsCore.java:3679)  at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2472)  at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:805)  at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:611)  at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)  at com.mysema.query.sql.AbstractSQLQuery.list(AbstractSQLQuery.java:249)  ... 259 more

Kid regards,

Sergio

[Nic Brough -Adaptavist-]

What does the log say the system is doing at the point you try this delete?  ( jira-home/logs/atlassian-jira.log )