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

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,760 views 11 18
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot