cancel
Showing results for 
Search instead for 
Did you mean: 

Bug in xa mode

Eric_Galant1
Champ in-the-making
Champ in-the-making

Hi I have a bug when I active the mode xa nuxeo.db.xaMode=true.

Thanks for your help regards

2023-07-04T22:50:25,962 WARN [main] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent] Command not available: videoWatermarkWithPicture (command ffmpeg not found in system path (descriptor CommandLineDescriptor[available=false,command=ffmpeg,enabled=true,installErrorMessage=,installationDirective=You need to install ffmpeg.,name=videoWatermarkWithPicture,parameterString=-y -i #{sourceFilePath} -i #{pictureFilePath} -filter_complex #{filterComplex} #{outFilePath},readOutput=true,testParameterString=,tester=,timeout=,winCommand=,winParameterString=,winTestParameterString=]). You need to install ffmpeg.) 2023-07-04T22:50:29,767 WARN [main] [org.hibernate.cfg.SettingsFactory] Could not obtain connection to query metadata java.sql.SQLException: Cannot create PoolableConnectionFactory (Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) at org.apache.commons.dbcp2.managed.BasicManagedDataSource.createPoolableConnectionFactory(BasicManagedDataSource.java:252) ~[commons-dbcp2-2.8.0.jar:2.8.0] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:534) ~[commons-dbcp2-2.8.0.jar:2.8.0] at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734) ~[commons-dbcp2-2.8.0.jar:2.8.0] at org.nuxeo.ecm.core.persistence.NuxeoConnectionProvider.getConnection(NuxeoConnectionProvider.java:54) ~[nuxeo-core-persistence-2021.39.6.jar:?] at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111) ~[hibernate-core-3.3.2.GA.jar:3.3.2.GA] at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119) ~[hibernate-core-3.3.2.GA.jar:3.3.2.GA] at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115) ~[hibernate-core-3.3.2.GA.jar:3.3.2.GA] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339) ~[hibernate-core-3.3.2.GA.jar:3.3.2.GA] at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867) ~[hibernate-annotations-3.4.0.GA.jar:3.3.2.GA] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) ~[hibernate-entitymanager-3.4.0.GA.jar:3.4.0.GA] at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:646) ~[hibernate-entitymanager-3.4.0.GA.jar:3.4.0.GA] at org.nuxeo.ecm.core.persistence.HibernateConfiguration.lambda$createEntityManagerFactory$0(HibernateConfiguration.java:158) ~[nuxeo-core-persistence-2021.39.6.jar:?] at org.nuxeo.runtime.transaction.TransactionHelper.runAndCleanupTransactionContext(TransactionHelper.java:748) ~[nuxeo-runtime-jtajca-2021.39.6.jar:?] at org.nuxeo.runtime.transaction.TransactionHelper.lambda$runWithoutTransaction$1(TransactionHelper.java:598) ~[nuxeo-runtime-jtajca-2021.39.6.jar:?] at org.nuxeo.runtime.transaction.TransactionHelper.runWithoutTransactionInternal(TransactionHelper.java:702) [nuxeo-runtime-jtajca-2021.39.6.jar:?] at org.nuxeo.runtime.transaction.TransactionHelper.runWithoutTransaction(TransactionHelper.java:598) [nuxeo-runtime-jtajca-2021.39.6.jar:?] at org.nuxeo.ecm.core.persistence.HibernateConfiguration.createEntityManagerFactory(HibernateConfiguration.java:158) [nuxeo-core-persistence-2021.39.6.jar:?] at org.nuxeo.ecm.core.persistence.HibernateConfiguration.getFactory(HibernateConfiguration.java:151) [nuxeo-core-persistence-2021.39.6.jar:?] at org.nuxeo.ecm.core.persistence.HibernateConfiguration.getFactory(HibernateConfiguration.java:196) [nuxeo-core-persistence-2021.39.6.jar:?] at org.nuxeo.ecm.core.persistence.PersistenceProvider.openPersistenceUnit(PersistenceProvider.java:51) [nuxeo-core-persistence-2021.39.6.jar:?] at org.nuxeo.ecm.core.persistence.PersistenceComponent.start(PersistenceComponent.java:85) [nuxeo-core-persistence-2021.39.6.jar:?] at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.start(RegistrationInfoImpl.java:372) [nuxeo-runtime-2021.39.6.jar:?] at org.nuxeo.runtime.model.impl.ComponentManagerImpl.startComponent(ComponentManagerImpl.java:758) [nuxeo-runtime-2021.39.6.jar:?] at org.nuxeo.runtime.model.impl.ComponentManagerImpl.startComponents(ComponentManagerImpl.java:740) [nuxeo-runtime-2021.39.6.jar:?] at org.nuxeo.runtime.model.impl.ComponentManagerImpl.start(ComponentManagerImpl.java:841) [nuxeo-runtime-2021.39.6.jar:?] at org.nuxeo.runtime.osgi.OSGiRuntimeService.startComponents(OSGiRuntimeService.java:470) [nuxeo-runtime-2021.39.6.jar:?] at org.nuxeo.runtime.osgi.OSGiRuntimeService.frameworkEvent(OSGiRuntimeService.java:485) [nuxeo-runtime-2021.39.6.jar:?] at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:223) [nuxeo-runtime-osgi-2021.39.6.jar:?] at org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(FrameworkLoader.java:244) [nuxeo-runtime-osgi-2021.39.6.jar:?] at org.nuxeo.osgi.application.loader.FrameworkLoader.start(FrameworkLoader.java:143) [nuxeo-runtime-osgi-2021.39.6.jar:?] at org.nuxeo.runtime.deployment.NuxeoStarter.start(NuxeoStarter.java:124) [nuxeo-runtime-deploy-2021.39.6.jar:?] at org.nuxeo.runtime.deployment.NuxeoStarter.contextInitialized(NuxeoStarter.java:93) [nuxeo-runtime-deploy-2021.39.6.jar:?] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4494) [catalina.jar:9.0.76] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4946) [catalina.jar:9.0.76] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.76] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:683) [catalina.jar:9.0.76] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:658) [catalina.jar:9.0.76] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:662) [catalina.jar:9.0.76] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:689) [catalina.jar:9.0.76] at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1888) [catalina.jar:9.0.76] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util-9.0.76.jar:9.0.76] at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118) [?:?] at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:582) [catalina.jar:9.0.76] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472) [catalina.jar:9.0.76] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1617) [catalina.jar:9.0.76] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:318) [catalina.jar:9.0.76] at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) [catalina.jar:9.0.76] at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) [catalina.jar:9.0.76] at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) [catalina.jar:9.0.76] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:893) [catalina.jar:9.0.76] at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:795) [catalina.jar:9.0.76] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.76] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1328) [catalina.jar:9.0.76] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1318) [catalina.jar:9.0.76] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util-9.0.76.jar:9.0.76] at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140) [?:?] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) [catalina.jar:9.0.76] at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:249) [catalina.jar:9.0.76] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.76] at org.apache.catalina.core.StandardService.startInternal(StandardService.java:428) [catalina.jar:9.0.76] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.76] at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:923) [catalina.jar:9.0.76] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.76] at org.apache.catalina.startup.Catalina.start(Catalina.java:772) [catalina.jar:9.0.76] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:347) [bootstrap.jar:9.0.76] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478) [bootstrap.jar:9.0.76] Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

6 REPLIES 6

Eric_Galant1
Champ in-the-making
Champ in-the-making

Hi, The showconf is joined. Thanks,

Konrad_Krenzlin
Confirmed Champ
Confirmed Champ

Just out of curiosity - cause I know nothing about XA mode - does it work with xa mode disabled?

Looking at the Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. may that's the issue? Also in your conf there is a different db host configured.

Yes, it works when the xa mode is disabled.

nuxeo.db.host=db.univ-brest.fr

the host is configured

Sorry, then I cannot help. Was just seeing that error message.

Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.