I'm on JIRA 3.13.2 Enterprise. A new JIRA was created by a user, and it seems to be corrupted. I would like to delete this issue, but I can't using the JIRA application. Is there any way to delete an issue directly from the database? It is throwing the following error when attempting to display this issue:
A system error has occurred.
Please try submitting this problem via the Support Request Page
Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information:
Cause: java.lang.ArrayIndexOutOfBoundsException
Stack Trace: [hide]
java.lang.ArrayIndexOutOfBoundsException
Referer URL: http://igbudevworkflow.us.oracle.com/secure/Dashboard.jspa
Build Information: Uptime : N/AEdition : EnterpriseVersion : 3.13.2Build Number : 335Atlassian Partner : nullInstallation Type : StandaloneServer ID : A5XO-PQ2X-UXRJ-SUDM
Server Information: Application Server: Apache Tomcat/5.5.26 Servlet Version: 2.4
File Paths: Location of entityengine.xml: file:/home/adminserver/atlassian-jira-3.13.2/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: /home/adminserver/atlassian-jira-3.13.2/bin/atlassian-jira.log
Memory Information: Total Memory: 1972 MBFree Memory: 1402 MBUsed Memory: 570 MBTotal PermGen Memory: 176 MBFree PermGen Memory: 69 MBUsed PermGen Memory: 106 MB
System Information: System Date : Tuesday, 03 Apr 2012System Time : 11:58:51Current Working Directory : /home/adminserver/atlassian-jira-3.13.2/binJava Version : 1.5.0_11Java Vendor : Sun Microsystems Inc.JVM Version : 1.0JVM Vendor : Sun Microsystems Inc.JVM Implementation Version : 1.5.0_11-b03Java Runtime : Java(TM) 2 Runtime Environment, Standard EditionJava VM : Java HotSpot(TM) Server VMUser Name : rootUser Timezone : America/New_YorkUser Locale : English (United States)System Encoding : UTF-8Operating System : Linux 2.6.9-5.ELsmpOS Architecture : i386Application Server Container : Database type : oracle10gDatabase JNDI address : java:comp/env/jdbc/JiraDSDatabase URL : HiddenDatabase version : Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining optionsDatabase driver : Oracle JDBC driver 10.2.0.1.0External user management : OFFCrowd integration : OFFJVM Input Arguments : -XX:MaxPermSize=128m -Xms2048m -Xmx2048m -Djava.awt.headless=true -Datlassian.standalone=JIRA -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Djava.endorsed.dirs=/home/adminserver/atlassian-jira-3.13.2/common/endorsed -Dcatalina.base=/home/adminserver/atlassian-jira-3.13.2 -Dcatalina.home=/home/adminserver/atlassian-jira-3.13.2 -Djava.io.tmpdir=/home/adminserver/atlassian-jira-3.13.2/temp
Language Info:
Request Information: - Request URL: http://igbudevworkflow.us.oracle.com/500page.jsp<br< a="">> - Scheme: http - Server: igbudevworkflow.us.oracle.com - Port: 80 - URI: /500page.jsp - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: Request Attributes - javax.servlet.forward.request_uri : /browse/OIPA-4221 - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /browse - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.error.message : - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - javax.servlet.error.servlet_name : quicklink - atlassian.core.seraph.original.url : /browse/OIPA-4221 - javax.servlet.error.exception : java.lang.ArrayIndexOutOfBoundsException - os_securityfilter_already_filtered : true - com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true - javax.servlet.error.request_uri : /browse/OIPA-4221 - javax.servlet.error.status_code : 500 - com.atlassian.jira.web.filters.RequestCleanupFilter_already_filtered : true - __sitemesh__filterapplied : true - jira.webwork.cleanup : false - loginfilter.already.filtered : true - webwork.result : Value stack =========== ===========
Request Logging0 log statements generated by this request:
Listeners - Issue Cache Listener (com.atlassian.jira.event.listeners.cache.IssueCacheListener) - Issue Index Listener (com.atlassian.jira.event.listeners.search.IssueIndexListener) - Mail Listener (com.atlassian.jira.event.listeners.mail.MailListener)
Services - Backup Service (com.atlassian.jira.service.services.export.ExportService) - Delay: 1440 minutes - USEZIP: Zip - DIR_NAME: /home/adminserver/JIRA-backups - Mail Queue Service (com.atlassian.jira.service.services.mail.MailQueueService) - Delay: 1 minutes - PAS BugDB (com.atlassian.jira.service.services.imap.ImapService) - Delay: 1 minutes - handler: BugDB Mail Handler - usessl: SSL (POP/S) - Subversion Revision Indexing Service (com.atlassian.jira.plugin.ext.subversion.revisions.RevisionIndexService) - Delay: 60 minutes - VCS Update Service (com.atlassian.jira.service.services.vcs.VcsService) - Delay: 30 minutes
Plugins - Admin Menu Sections 1.0 - Plugin by Atlassian Pty Ltd - Enabled - AdminServer Jira Extension Plugin 1.0 - Plugin by AdminServer, Inc. - Disabled - Browse Project Operations Sections 1.0 - Plugin by Atlassian Pty Ltd - Enabled - BugDB Updater 1.0.1 - Plugin by Oracle Insurance Internal - Disabled - BugDb Issue Handler 1.0.8 - Plugin by null - Disabled - Clone and Move Plugin 1.2.4 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Content Link Resolvers Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Custom Field Types & Searchers 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Database Values JIRA Plugin 0.3.1 - Plugin by Wim Deblauwe - Enabled - Firefox plugin 1.0 - Plugin by Jelmer Kuperus - Enabled - FishEye Plugin 2.2.2 - Plugin by Atlassian Software Systems - Enabled - Issue Operations Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Issue Spawn Plugin 1.2.0 - Plugin by Oracle Insurance Internal - Enabled - Issue Tab Panels Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Issue Views Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Bamboo Plugin 2.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - JIRA Calendar Plugin 1.9 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Charting Plugin 1.4.1 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Footer 1.0 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Linker Plugin 1.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - JIRA Subversion plugin 0.10.4.2 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Suite Utilities 0.6.5 - Plugin by Quadratica SRL - Enabled - JIRA Toolkit Plugin 0.7.30 - Plugin by Atlassian Pty Ltd - Enabled - Portlets Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Preset Filters Sections 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Project Panels Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Project Role Actors Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - RPC JIRA Plugin 3.13.1 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Renderer Component Factories Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Renderer Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Reports Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - SLA Report 0.1 - Plugin by BrightGen - Enabled - Searchable Attachment Plugin 0.1 - Plugin by phil - Enabled - Top Navigation Bar 1.0 - Plugin by Atlassian Pty Ltd - Enabled - User Format 1.0 - Plugin by Atlassian Pty Ltd - Enabled - User Navigation Bar Sections 1.0 - Plugin by Atlassian Pty Ltd - Enabled - User Profile Links 1.0 - Plugin by Atlassian Pty Ltd - Enabled - View Project Operations Sections 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Web Resources Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Webwork Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Wiki Renderer Macros Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled - Workflow Action Field 0.2 - Plugin by phil - Enabled - Workflow Plugin 1.0 - Plugin by Atlassian Pty Ltd - Enabled
Here's the first error with array index out of bounds (or as much as I can fit...):
2012-03-31 09:09:51,561 http-10.140.167.52-80-Processor21 ERROR talina].[localhost].[/].[quicklink]] Servlet.service() for servlet quicklink threw exceptionjava.lang.ArrayIndexOutOfBoundsException: 48 at oracle.jdbc.driver.DateTimeCommonAccessor.computeJulianDay(DateTimeCommonAccessor.java:414) at oracle.jdbc.driver.DateTimeCommonAccessor.getMillis(DateTimeCommonAccessor.java:453) at oracle.jdbc.driver.DateAccessor.getTimestamp(DateAccessor.java:123) at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:796) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:212) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:533) at org.ofbiz.core.entity.EntityListIterator.currentGenericValue(EntityListIterator.java:160) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:237) at org.ofbiz.core.entity.EntityListIterator.getCompleteList(EntityListIterator.java:299) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:596) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:792) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:777) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:754) at com.atlassian.jira.issue.managers.DefaultIssueManager.getIssue(DefaultIssueManager.java:71) at com.atlassian.jira.issue.managers.DefaultIssueManager.getIssueObject(DefaultIssueManager.java:223) at sun.reflect.GeneratedMethodAccessor452.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:71)
It looks like you're new here. Sign in or register to get started.
