topic Failed to read transform InputStream into rendition doclib in Alfresco Forum

Failed to read transform InputStream into rendition doclib

sergus_dev — Fri, 26 Mar 2021 15:41:32 GMT

Hello.

What mean this exception:

Failed to read transform InputStream into rendition doclib on workspace://SpacesStore/f2ea6b7e-625e-40d5-a1a0-4a552d3ecea7

and how can I fix it?

Re: Failed to read transform InputStream into rendition doclib

EddieMay — Fri, 26 Mar 2021 15:53:10 GMT

Hi @sergus_dev

Could you provide the whole of the error output? That might make it easier for someone to help you.

Thanks,

Re: Failed to read transform InputStream into rendition doclib

sergus_dev — Fri, 26 Mar 2021 16:01:39 GMT

This all what I have in log file.

There are many such failed and after I received that:

2021-03-26T15:52:01.083170364Z  2021-03-26 15:52:01,080  ERROR [impl.jobexecutor.AcquireJobsRunnableImpl] [Thread-53] exception during job acquisition: Could not open JDBC Connection for transaction; nested exception is org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
2021-03-26T15:52:01.083234474Z  org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
2021-03-26T15:52:01.083252308Z 	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:305)
2021-03-26T15:52:01.083267065Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:378)
2021-03-26T15:52:01.083285159Z 	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137)
2021-03-26T15:52:01.083346494Z 	at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
2021-03-26T15:52:01.083361241Z 	at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
2021-03-26T15:52:01.083372803Z 	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
2021-03-26T15:52:01.083384705Z 	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
2021-03-26T15:52:01.083396006Z 	at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnableImpl.run(AcquireJobsRunnableImpl.java:54)
2021-03-26T15:52:01.083413409Z 	at java.base/java.lang.Thread.run(Thread.java:834)
2021-03-26T15:52:01.083424810Z Caused by: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
2021-03-26T15:52:01.083436131Z 	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514)
2021-03-26T15:52:01.083448314Z 	at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
2021-03-26T15:52:01.083465526Z 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
2021-03-26T15:52:01.083476567Z 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
2021-03-26T15:52:01.083492497Z 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
2021-03-26T15:52:01.083511552Z 	at org.postgresql.Driver.makeConnection(Driver.java:454)
2021-03-26T15:52:01.083523444Z 	at org.postgresql.Driver.connect(Driver.java:256)
2021-03-26T15:52:01.083537731Z 	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
2021-03-26T15:52:01.083551577Z 	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
2021-03-26T15:52:01.083564020Z 	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
2021-03-26T15:52:01.083577646Z 	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
2021-03-26T15:52:01.083590320Z 	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
2021-03-26T15:52:01.083603634Z 	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:262)
2021-03-26T15:52:01.083616428Z 	... 8 more
2021-03-26T15:52:01.085183438Z 2021-03-26 15:52:01,080  ERROR [util.transaction.SpringAwareUserTransaction] [pool-14-thread-38] Application exception overridden by rollback exception
2021-03-26T15:52:01.085225737Z  java.lang.Exception
2021-03-26T15:52:01.085236447Z 	at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:544)
2021-03-26T15:52:01.085246466Z 	at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:519)
2021-03-26T15:52:01.085277314Z 	at org.alfresco.repo.tenant.AbstractTenantRoutingContentStore.getAllStores(AbstractTenantRoutingContentStore.java:135)
2021-03-26T15:52:01.085288144Z 	at org.alfresco.repo.content.AbstractRoutingContentStore.isWriteSupported(AbstractRoutingContentStore.java:234)
2021-03-26T15:52:01.085297411Z 	at jdk.internal.reflect.GeneratedMethodAccessor915.invoke(Unknown Source)
2021-03-26T15:52:01.085305226Z 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2021-03-26T15:52:01.085313151Z 	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
2021-03-26T15:52:01.085321386Z 	at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:79)
2021-03-26T15:52:01.085330253Z 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
2021-03-26T15:52:01.085337977Z 	at org.alfresco.repo.management.subsystems.CryptodocSubsystemProxyFactory$1.invoke(CryptodocSubsystemProxyFactory.java:60)
2021-03-26T15:52:01.085345802Z 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
2021-03-26T15:52:01.085353446Z 	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
2021-03-26T15:52:01.085361160Z 	at com.sun.proxy.$Proxy29.isWriteSupported(Unknown Source)
2021-03-26T15:52:01.085368915Z 	at org.alfresco.repo.content.cleanup.EagerContentStoreCleaner.deleteFromStores(EagerContentStoreCleaner.java:277)
2021-03-26T15:52:01.085376770Z 	at org.alfresco.repo.content.cleanup.EagerContentStoreCleaner.afterRollback(EagerContentStoreCleaner.java:254)
2021-03-26T15:52:01.085384664Z 	at org.alfresco.util.transaction.TransactionSupportUtil$TransactionSynchronizationImpl.afterCompletion(TransactionSupportUtil.java:602)
2021-03-26T15:52:01.085392730Z 	at org.springframework.transaction.support.TransactionSynchronizationUtils.invokeAfterCompletion(TransactionSynchronizationUtils.java:171)
2021-03-26T15:52:01.085402708Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.invokeAfterCompletion(AbstractPlatformTransactionManager.java:992)
2021-03-26T15:52:01.085411505Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerAfterCompletion(AbstractPlatformTransactionManager.java:967)
2021-03-26T15:52:01.085419449Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.doRollbackOnCommitException(AbstractPlatformTransactionManager.java:909)
2021-03-26T15:52:01.085427294Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:778)
2021-03-26T15:52:01.085434958Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
2021-03-26T15:52:01.085442633Z 	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:533)
2021-03-26T15:52:01.085450498Z 	at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:479)
2021-03-26T15:52:01.085461648Z 	at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:472)
2021-03-26T15:52:01.085474152Z 	at org.alfresco.repo.rendition2.RenditionService2Impl.lambda$consume$4(RenditionService2Impl.java:341)

Re: Failed to read transform InputStream into rendition doclib

sergus_dev — Fri, 26 Mar 2021 16:13:18 GMT

Unfortunately thats all what I have.

I received many exception like this and than this:

2021-03-26T15:52:06.085990874Z 2021-03-26 15:52:06,085 ERROR [impl.jobexecutor.AcquireJobsRunnableImpl] [Thread-53] exception during job acquisition: Could not open JDBC Connection for transaction; nested exception is org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
2021-03-26T15:52:06.086016532Z org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
2021-03-26T15:52:06.086037491Z at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:305)
2021-03-26T15:52:06.086044014Z at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:378)
2021-03-26T15:52:06.086048532Z at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137)
2021-03-26T15:52:06.086052570Z at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
2021-03-26T15:52:06.086057599Z at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
2021-03-26T15:52:06.086063981Z at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
2021-03-26T15:52:06.086068940Z at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
2021-03-26T15:52:06.086074791Z at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnableImpl.run(AcquireJobsRunnableImpl.java:54)
2021-03-26T15:52:06.086080682Z at java.base/java.lang.Thread.run(Thread.java:834)
2021-03-26T15:52:06.086085030Z Caused by: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
2021-03-26T15:52:06.086089328Z at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514)
2021-03-26T15:52:06.086093346Z at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
2021-03-26T15:52:06.086097373Z at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
2021-03-26T15:52:06.086101371Z at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
2021-03-26T15:52:06.086104547Z at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
2021-03-26T15:52:06.086107783Z at org.postgresql.Driver.makeConnection(Driver.java:454)
2021-03-26T15:52:06.086110748Z at org.postgresql.Driver.connect(Driver.java:256)
2021-03-26T15:52:06.086114295Z at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
2021-03-26T15:52:06.086117431Z at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
2021-03-26T15:52:06.086120497Z at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
2021-03-26T15:52:06.086123492Z at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
2021-03-26T15:52:06.086126458Z at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
2021-03-26T15:52:06.086129443Z at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:262)
2021-03-26T15:52:06.086134032Z ... 8 more
2021-03-26T15:52:06.992037189Z 2021-03-26 15:52:06,9