Corrupted JIRA Issue

[Michael Cappio]

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:

System Error

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:

1. a description of your problem
2. cut & paste the error and system information found below
3. attach the application server log file ( /home/adminserver/atlassian-jira-3.13.2/bin/atlassian-jira.log )

Cause:
java.lang.ArrayIndexOutOfBoundsException

Stack Trace: [hide]

java.lang.ArrayIndexOutOfBoundsException

Referer URL: http://igbudevworkflow.us.oracle.com/secure/Dashboard.jspa

Build Information:
Uptime : N/A
Edition : Enterprise
Version : 3.13.2
Build Number : 335
Atlassian Partner : null
Installation Type : Standalone
Server 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 MB
Free Memory: 1402 MB
Used Memory: 570 MB
Total PermGen Memory: 176 MB
Free PermGen Memory: 69 MB
Used PermGen Memory: 106 MB

System Information:
System Date : Tuesday, 03 Apr 2012
System Time : 11:58:51
Current Working Directory : /home/adminserver/atlassian-jira-3.13.2/bin
Java Version : 1.5.0_11
Java Vendor : Sun Microsystems Inc.
JVM Version : 1.0
JVM Vendor : Sun Microsystems Inc.
JVM Implementation Version : 1.5.0_11-b03
Java Runtime : Java(TM) 2 Runtime Environment, Standard Edition
Java VM : Java HotSpot(TM) Server VM
User Name : root
User Timezone : America/New_York
User Locale : English (United States)
System Encoding : UTF-8
Operating System : Linux 2.6.9-5.ELsmp
OS Architecture : i386
Application Server Container :
Database type : oracle10g
Database JNDI address : java:comp/env/jdbc/JiraDS
Database URL : Hidden
Database version : Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options
Database driver : Oracle JDBC driver 10.2.0.1.0
External user management : OFF
Crowd integration : OFF
JVM 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:

Installed languages:	Chinese (China) Chinese (Taiwan) Czech (Czech Republic) Danish (Denmark) Dutch (Belgium) English (UK) French (France) German (Germany) German (Switzerland) Hungarian (Hungary) Italian (Italy) Japanese (Japan) Norwegian (Norway) Polish (Poland) Portuguese (Brazil) Russian (Russia) Slovak (Slovakia) Spanish (Spain) Turkish (Turkey)
Default language:	English (United States) - System Default

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...

Request Logging
0 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...

[Michael Cappio]

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 exception
java.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)

[Dieter]

Could you paste a little bit more of the stack trace in atlassian-jira.log ?