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

Jetty fails with NullPointerExceptions from xapool during imports

    XMLWordPrintable

Details

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      After following the JIRA Jetty install doc, and importing a largish XML backup, JIRA completes successfully but prints an error in the log:

      2007-05-01 14:06:44,499 INFO [jira.action.admin.DataImport] XML successfully parsed
      2007-05-01 14:06:44,502 INFO [jira.action.admin.DataImport] Removing all entries from the database.
      2007-05-01 14:06:44,572 INFO [jira.action.admin.DataImport] All entries removed.
      2007-05-01 14:06:44,574 INFO [jira.action.admin.DataImport] Started storing 1367941 Generic Values
      2007-05-01 14:08:13,891 WARN [jira.util.xml.XMLCleaningReader] Replaced invalid XML character
      (12).
      2007-05-01 14:08:13,905 WARN [jira.util.xml.XMLCleaningReader] Replaced invalid XML character
      (12).
      java.lang.NullPointerException
      at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:200)
      at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:351)
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194)
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
      at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
      at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237)
      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.jira.action.admin.ImportParser$1.run(ImportParser.java:191)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751)
      at java.lang.Thread.run(Thread.java:619)
      java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204)
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
      at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
      at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237)
      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.jira.action.admin.ImportParser$1.run(ImportParser.java:191)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751)
      at java.lang.Thread.run(Thread.java:619)
      2007-05-01 14:10:35,812 ERROR [jira.action.admin.ImportParser] Exception importing entity Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException))
      org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException))
      at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:91)
      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.jira.action.admin.ImportParser$1.run(ImportParser.java:191)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751)
      at java.lang.Thread.run(Thread.java:619)
      org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:239)
      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.jira.action.admin.ImportParser$1.run(ImportParser.java:191)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751)
      at java.lang.Thread.run(Thread.java:619)
      java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:213)
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
      at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
      at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237)
      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.jira.action.admin.ImportParser$1.run(ImportParser.java:191)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751)
      at java.lang.Thread.run(Thread.java:619)
      2007-05-01 14:10:37,172 ERROR [jira.action.admin.DataImport] Error importing data: org.apache.commons.lang.exception.NestableException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException))
      org.apache.commons.lang.exception.NestableException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException))
      at com.atlassian.jira.action.admin.ImportParser.startElement(ImportParser.java:71)
      at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
      at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
      at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
      at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
      at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
      at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
      at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
      at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
      at javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
      at com.atlassian.jira.action.admin.DataImport.doExecute(DataImport.java:119)
      at webwork.action.ActionSupport.execute(ActionSupport.java:153)
      at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57)
      at com.atlassian.jira.action.JiraNonWebActionSupport.execute(JiraNonWebActionSupport.java:27)
      at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
      at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34)
      at com.atlassian.jira.web.action.setup.SetupImport.doExecute(SetupImport.java:81)
      at webwork.action.ActionSupport.execute(ActionSupport.java:153)
      at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57)
      at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
      at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050)
      at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
      at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
      at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354)
      at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226)
      at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
      at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
      at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
      at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
      at org.mortbay.jetty.Server.handle(Server.java:269)
      at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
      at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:701)
      at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:617)
      at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199)
      at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339)
      at org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270)
      at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
      java.lang.NullPointerException
      at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:200)
      at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:351)
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194)
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
      at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
      at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237)
      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.jira.action.admin.ImportParser$1.run(ImportParser.java:191)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751)
      at java.lang.Thread.run(Thread.java:619)
      java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204)
      at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
      at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
      at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
      at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237)
      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.jira.action.admin.ImportParser$1.run(ImportParser.java:191)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751)
      at java.lang.Thread.run(Thread.java:619)
      ....

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: