Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-14985

marketplace package for fixing 5.9.5 database connection errors

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.9.5
    • Fix Version/s: None
    • Component/s: Runtime

      Description

      In 5.9.5, when embedding datasource in nuxeo app, the credentials are not transmitted to the database.

      2014-08-11 11:17:05,457 ERROR [persistence-init-nxactivities] [org.apache.geronimo.connector.outbound.MCFConnectionInterceptor] Error occurred creating ManagedConnection for handle: nullManagedConnection\
      Info: org.apache.geronimo.connector.outbound.ManagedConnectionInfo@58c9a974. mc: null]
      javax.resource.spi.ResourceAllocationException: Unable to obtain physical connection to jdbc:postgresql://nuxeo-poc:5432/postgres
              at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDriverMCF.java:105)
              at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDriverMCF.java:80)
              at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
              at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
              at org.apache.geronimo.connector.outbound.SinglePoolMatchAllConnectionInterceptor.internalGetConnection(SinglePoolMatchAllConnectionInterceptor.java:88)
              at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)
              at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:49)
              at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:109)
              at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
              at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
              at org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66)
              at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:77)
              at org.nuxeo.runtime.jtajca.NuxeoContainer$ConnectionManagerWrapper.allocateConnection(NuxeoContainer.java:935)
              at org.tranql.connector.jdbc.TranqlDataSource.getConnection(TranqlDataSource.java:62)
              at org.nuxeo.runtime.datasource.geronimo.PooledDataSourceFactory$DataSource.getConnection(PooledDataSourceFactory.java:52)
              at org.nuxeo.runtime.datasource.ConnectionHelper.getConnection(ConnectionHelper.java:874)
              at org.nuxeo.runtime.datasource.ConnectionHelper.getConnection(ConnectionHelper.java:847)
              at org.nuxeo.ecm.core.persistence.NuxeoConnectionProvider.getConnection(NuxeoConnectionProvider.java:71)
              at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
              at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
              at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
              at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
              at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
              at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
              at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:646)
              at org.nuxeo.ecm.core.persistence.HibernateConfiguration$1.run(HibernateConfiguration.java:222)
      Caused by: org.postgresql.util.PSQLException: FATAL: no PostgreSQL user name specified in startup packet
              at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
              at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
              at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
              at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
              at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
              at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
              at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
              at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
              at org.postgresql.Driver.makeConnection(Driver.java:393)
              at org.postgresql.Driver.connect(Driver.java:267)
              at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDriverMCF.java:103)
              ... 25 more
      

      Another problem, was the unregistering of the repository storage monitor when hot-reloading bundles that was wrongly fixed in NXP-14910.

      The attached marketplace contains the fix needed to these two bugs.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                slacoin Stéphane Lacoin
                Reporter:
                slacoin Stéphane Lacoin
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: