-
Bug
-
Resolution: Fixed
-
Medium
-
3.7
-
None
-
System Info
System Date Tuesday, 12 Dec 2006
System Time 10:33:44
Current Working Directory /home/andreask/projects/atlassian/jira
Java Version 1.4.2_12
Java Vendor Sun Microsystems Inc.
JVM Version 1.0
JVM Vendor Sun Microsystems Inc.
JVM Implementation Version 1.4.2_12-b03
Java Runtime Java(TM) 2 Runtime Environment, Standard Edition
Java VM Java HotSpot(TM) Client VM
User Name andreask
User Timezone Australia/ACT
User Locale English (Australia)
System Encoding UTF-8
Operating System Linux 2.6.17-10-generic
OS Architecture i386
Application Server Container Resin/3.0.14
Database type postgres72
Database JNDI address java:comp/env/jdbc/JiraDS
Database version 8.0.7
Database driver PostgreSQL Native Driver PostgreSQL 8.1 JDBC3 with SSL (build 408)Java VM Memory Statistics
Total Memory 127 MB
Free Memory 102 MB
Used Memory 25 MB
Memory Graph80 % Free (Force garbage collection)
JIRA Info
Uptime 1 minute, 7 seconds
Edition Enterprise
Version 3.7
Build Number 181
Atlassian Partner
Installation Type EAR / WAR
Server ID A1IJ-623Z-0CXZ-GMPCDatabase Statistics
Issues 13983
Projects 9
Custom Fields 30
Workflows 7
Users 7354
Groups 14File Paths
Location of entityengine.xml file:/home/andreask/projects/atlassian/jira/src/webapp/WEB-INF/classes/entityengine.xml
Location of atlassian-jira.log /home/andreask/projects/atlassian/jira/atlassian-jira.log
Location of indexes /tmp/jira-support/indexes
Listeners
FrozenCommentTrans-Conf
com.atlassian.jira.toolkit.listener.AutoTransitionListener
Action ID: 131
Event ID: 6
Only do when current user is the Assignee?: false
Only do when current user is the Reporter?: true
Project Key: CSP
Status: 10003
FrozenCommentTrans-Jira
com.atlassian.jira.toolkit.listener.AutoTransitionListener
Action ID: 131
Event ID: 6
Only do when current user is the Assignee?: false
Only do when current user is the Reporter?: true
Project Key: JSP
Status: 10003
InactiveCommentTrans-Conf
com.atlassian.jira.toolkit.listener.AutoTransitionListener
Action ID: 231
Event ID: 6
Only do when current user is the Assignee?: false
Only do when current user is the Reporter?: true
Project Key: CSP
Status: 10002
InactiveCommentTrans-Jira
com.atlassian.jira.toolkit.listener.AutoTransitionListener
Action ID: 231
Event ID: 6
Only do when current user is the Assignee?: false
Only do when current user is the Reporter?: true
Project Key: JSP
Status: 10002
Issue Cache Listener
com.atlassian.jira.event.listeners.cache.IssueCacheListener
Mail Listener
com.atlassian.jira.event.listeners.mail.MailListener
WaitingOnCustCommentTrans
com.atlassian.jira.toolkit.listener.AutoTransitionListener
Action ID: 31
Event ID: 6
Only do when current user is the Assignee?: false
Only do when current user is the Reporter?: true
Project Key: JSP
Status: 10000
WaitingOnCustCommentTrans-Conf
com.atlassian.jira.toolkit.listener.AutoTransitionListener
Action ID: 31
Event ID: 6
Only do when current user is the Assignee?: false
Only do when current user is the Reporter?: true
Project Key: CSP
Status: 10000Services
Backup
com.atlassian.jira.service.services.export.ExportService
Delay: 1440 minutes
USEZIP: Zip
DIR_NAME: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/backups/
Confluence Support Auto Close with Timeout
com.atlassian.jira.jelly.service.JellyService
Delay: 1440 minutes
output-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jelly-confluence-close.log
input-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/confluence-support-close.xml
Confluence Support Inactive Service
com.atlassian.jira.jelly.service.JellyService
Delay: 1440 minutes
output-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jelly-confluence-inactive.log
input-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/confluence-support-inactive.xml
Confluence Support POP service
com.atlassian.jira.service.services.pop.PopService
Delay: 1 minutes
handler: Create Or Comment Handler
popserver: POP-Server CSP
handler.params: project=CSP, createusers=true, stripquotes=true, issuetype=1, bulk=forward
usessl: No SSL
forwardEmail: confluence-support@atlassian.com
JIRA Support Auto Close with Timeout
com.atlassian.jira.jelly.service.JellyService
Delay: 1440 minutes
output-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jelly-close.log
input-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jira-support-close.xml
JIRA Support Auto Send Service
com.atlassian.jira.toolkit.service.SupportService
Delay: 1 minutes
handler: Create Support Issue Handler
popserver: JIRA Auto POP Box
handler.params: project=JSP,issuetype=1,createusers=true
usessl: No SSL
forwardEmail: support@atlassian.com
JIRA Support Inactive Service
com.atlassian.jira.jelly.service.JellyService
Delay: 1440 minutes
output-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jelly-inactive.log
input-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jira-support-inactive.xml
JIRA Support new POP service
com.atlassian.jira.service.services.pop.PopService
Delay: 1 minutes
handler: Create Or Comment Handler
popserver: POP server - JSP
handler.params: project=JSP, issuetype=1, createusers=true, stripquotes=true, bulk=forward
usessl: No SSL
forwardEmail: jira-support@atlassian.com
Mail Queue Service
com.atlassian.jira.service.services.mail.MailQueueService
Delay: 1 minutesPlugins
Admin Menu Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
Browse Project Operations Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
Custom Field Types & Searchers - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Issue Operations Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Issue Tab Panels Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Issue Views Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
JIRA Toolkit Plugin - 0.7.12
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Portlets Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Preset Filters Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
Project Panels Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Project Role Actors Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Renderer Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Reports Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Top Navigation Bar Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
User Navigation Bar Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
View Project Operations Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
Web Resources Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Webwork Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Wiki Renderer Macros Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Workflow Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
EnabledSystem Info System Date Tuesday, 12 Dec 2006 System Time 10:33:44 Current Working Directory /home/andreask/projects/atlassian/jira Java Version 1.4.2_12 Java Vendor Sun Microsystems Inc. JVM Version 1.0 JVM Vendor Sun Microsystems Inc. JVM Implementation Version 1.4.2_12-b03 Java Runtime Java(TM) 2 Runtime Environment, Standard Edition Java VM Java HotSpot(TM) Client VM User Name andreask User Timezone Australia/ACT User Locale English (Australia) System Encoding UTF-8 Operating System Linux 2.6.17-10-generic OS Architecture i386 Application Server Container Resin/3.0.14 Database type postgres72 Database JNDI address java:comp/env/jdbc/JiraDS Database version 8.0.7 Database driver PostgreSQL Native Driver PostgreSQL 8.1 JDBC3 with SSL (build 408) Java VM Memory Statistics Total Memory 127 MB Free Memory 102 MB Used Memory 25 MB Memory Graph 80 % Free (Force garbage collection) JIRA Info Uptime 1 minute, 7 seconds Edition Enterprise Version 3.7 Build Number 181 Atlassian Partner Installation Type EAR / WAR Server ID A1IJ-623Z-0CXZ-GMPC Database Statistics Issues 13983 Projects 9 Custom Fields 30 Workflows 7 Users 7354 Groups 14 File Paths Location of entityengine.xml file:/home/andreask/projects/atlassian/jira/src/webapp/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log /home/andreask/projects/atlassian/jira/atlassian-jira.log Location of indexes /tmp/jira-support/indexes Listeners FrozenCommentTrans-Conf com.atlassian.jira.toolkit.listener.AutoTransitionListener Action ID: 131 Event ID: 6 Only do when current user is the Assignee?: false Only do when current user is the Reporter?: true Project Key: CSP Status: 10003 FrozenCommentTrans-Jira com.atlassian.jira.toolkit.listener.AutoTransitionListener Action ID: 131 Event ID: 6 Only do when current user is the Assignee?: false Only do when current user is the Reporter?: true Project Key: JSP Status: 10003 InactiveCommentTrans-Conf com.atlassian.jira.toolkit.listener.AutoTransitionListener Action ID: 231 Event ID: 6 Only do when current user is the Assignee?: false Only do when current user is the Reporter?: true Project Key: CSP Status: 10002 InactiveCommentTrans-Jira com.atlassian.jira.toolkit.listener.AutoTransitionListener Action ID: 231 Event ID: 6 Only do when current user is the Assignee?: false Only do when current user is the Reporter?: true Project Key: JSP Status: 10002 Issue Cache Listener com.atlassian.jira.event.listeners.cache.IssueCacheListener Mail Listener com.atlassian.jira.event.listeners.mail.MailListener WaitingOnCustCommentTrans com.atlassian.jira.toolkit.listener.AutoTransitionListener Action ID: 31 Event ID: 6 Only do when current user is the Assignee?: false Only do when current user is the Reporter?: true Project Key: JSP Status: 10000 WaitingOnCustCommentTrans-Conf com.atlassian.jira.toolkit.listener.AutoTransitionListener Action ID: 31 Event ID: 6 Only do when current user is the Assignee?: false Only do when current user is the Reporter?: true Project Key: CSP Status: 10000 Services Backup com.atlassian.jira.service.services.export.ExportService Delay: 1440 minutes USEZIP: Zip DIR_NAME: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/backups/ Confluence Support Auto Close with Timeout com.atlassian.jira.jelly.service.JellyService Delay: 1440 minutes output-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jelly-confluence-close.log input-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/confluence-support-close.xml Confluence Support Inactive Service com.atlassian.jira.jelly.service.JellyService Delay: 1440 minutes output-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jelly-confluence-inactive.log input-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/confluence-support-inactive.xml Confluence Support POP service com.atlassian.jira.service.services.pop.PopService Delay: 1 minutes handler: Create Or Comment Handler popserver: POP-Server CSP handler.params: project=CSP, createusers=true, stripquotes=true, issuetype=1, bulk=forward usessl: No SSL forwardEmail: confluence-support@atlassian.com JIRA Support Auto Close with Timeout com.atlassian.jira.jelly.service.JellyService Delay: 1440 minutes output-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jelly-close.log input-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jira-support-close.xml JIRA Support Auto Send Service com.atlassian.jira.toolkit.service.SupportService Delay: 1 minutes handler: Create Support Issue Handler popserver: JIRA Auto POP Box handler.params: project=JSP,issuetype=1,createusers=true usessl: No SSL forwardEmail: support@atlassian.com JIRA Support Inactive Service com.atlassian.jira.jelly.service.JellyService Delay: 1440 minutes output-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jelly-inactive.log input-file: /opt/j2ee/domains/atlassian.com/support/webapps/atlassian-jira/data/files/jelly/jira-support-inactive.xml JIRA Support new POP service com.atlassian.jira.service.services.pop.PopService Delay: 1 minutes handler: Create Or Comment Handler popserver: POP server - JSP handler.params: project=JSP, issuetype=1, createusers=true, stripquotes=true, bulk=forward usessl: No SSL forwardEmail: jira-support@atlassian.com Mail Queue Service com.atlassian.jira.service.services.mail.MailQueueService Delay: 1 minutes Plugins Admin Menu Sections - 1.0 Plugin by Atlassian Software Systems Enabled Browse Project Operations Sections - 1.0 Plugin by Atlassian Software Systems Enabled Custom Field Types & Searchers - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Issue Operations Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Issue Tab Panels Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Issue Views Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled JIRA Toolkit Plugin - 0.7.12 Plugin by Atlassian Software Systems Pty Ltd Enabled Portlets Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Preset Filters Sections - 1.0 Plugin by Atlassian Software Systems Enabled Project Panels Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Project Role Actors Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Renderer Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Reports Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Top Navigation Bar Sections - 1.0 Plugin by Atlassian Software Systems Enabled User Navigation Bar Sections - 1.0 Plugin by Atlassian Software Systems Enabled View Project Operations Sections - 1.0 Plugin by Atlassian Software Systems Enabled Web Resources Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Webwork Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Wiki Renderer Macros Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Workflow Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled
-
3.07
-
When exporting data from support.atlassian.com, the export fails with an OutOfMemoryException. This is due to the large number of records in the notificationinstance table ( more than 1.4 million). Tests were carried out using both the PostgreSQL JDBC2 and JDBC3 drivers.
The root cause of this problem is the large number of records in the notificationinstance table. This is caused by the javamail api not providing an easy way to set the message-id (to something unique like jira.atlassian.com/JRA-11345). Instead we currently use and record the unique message ID generated by the mail server to thread e-mail in JIRA. There is however a workaround for this problem here. Once this gets implemented, we can get rid of the notificationinstance table all together.
Workaround
For normal backups, disabling the XML backup and replacing it with native backups is an effective strategy.
If upgrading, rather than using an XML export it is possible to use a backup of the database generated by the DBMS. For example:
- Create a database backup using the native DB tools (for example mysqldump in MySQL).
- Create a new database and restore that backup into it.
- Point the new JIRA instance to that database by either modifying the dbconfig.xml or using the JIRA Configuration Tool.
- Start up the new instance - it will perform upgrade tasks on the database similar to if an XML backup was imported.
The only side effect of this is it will use the schema from the backed up database - if the schema changes in later versions and we don't have upgrade tasks to modify that schema there may be minor problems such as documented in JIRA 4.0 Database Schema Changes for MySQL and Oracle. This only applies if upgrading from particularly old version such as 3.13.x and lower and can be corrected as in that documentation.
- is caused by
-
-
- Closed
-
- is duplicated by
-
-
- Closed
-
- is related to
-
JRASERVER-9979 NotificationInstance's should have a creation date, and a service to clean them up
- Closed