Bug in xa mode

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=

    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.

0 votes

2 answers

628 views

ANSWER



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.

0 votes



Yes, it works when the xa mode is disabled.
07/10/2023

nuxeo.db.host=db.univ-brest.fr nuxeo.db.name=nuxeo nuxeo.db.password= nuxeo.db.port=5432 nuxeo.db.user=nuxeo nuxeo.db.xaMode=true
07/10/2023

the host is configured
07/10/2023

Sorry, then I cannot help. Was just seeing that error message.
07/10/2023


Hi, The showconf is joined. Thanks,

FILES:   showconf.txt
0 votes