Delete task timeout

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

2 answers

1 accepted

0 votes
Accepted answer

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

0 votes

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,419 views 15 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you