Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-4684

Parsed mail attachments size limited to 4k using Oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Medium
    • None
    • 3.0 Standard Beta
    • Scheduled Tasks

    Description

      The JIRA mail service extracts attachments from mails it reads, and adds them as issue attachments. Apparently this parsing breaks on Oracle if attachments are over 32k, and probably also 4k (see JRA-4361):

      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while setting value: (setString can only process strings of
      less than 32766 chararacters)
      at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:684)
      at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:601)
      at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:436)
      at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:114)
      at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
      at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
      at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
      at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
      at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
      at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
      at com.atlassian.jira.issue.managers.DefaultActionManager.createEmail(DefaultActionManager.java:158)
      at com.atlassian.jira.service.util.handler.EmailHandler.handleMessage(EmailHandler.java:39)
      at com.atlassian.jira.service.services.pop.PopService.run(PopService.java:110)
      at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:53)
      at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:147)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)
      java.sql.SQLException: setString can only process strings of less than 32766 chararacters
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
      at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:4575)
      at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:4546)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.setValue(SQLProcessor.java:452)
      at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:636)
      at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:601)
      at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:436)
      at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:114)
      at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
      at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
      at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
      at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
      at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
      at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
      at com.atlassian.jira.issue.managers.DefaultActionManager.createEmail(DefaultActionManager.java:158)
      at com.atlassian.jira.service.util.handler.EmailHandler.handleMessage(EmailHandler.java:39)
      at com.atlassian.jira.service.services.pop.PopService.run(PopService.java:110)
      at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:53)
      at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:147)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              7ee5c68a815f Jeff Turner
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: