Jetty fails with NullPointerExceptions from xapool during imports

XMLWordPrintable

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

              Assignee:
              Unassigned
              Reporter:
              Jeff Turner
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: