[ 
https://jira.nuxeo.com/browse/NXP-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=90086#action_90086
 ] 

Arnaud Kervern commented on NXP-6440:
-------------------------------------

ERROR [AsyncEventExecutor] Failed to execute async event default on listener 
auditLoggerListener
javax.persistence.PersistenceException: 
org.hibernate.exception.GenericJDBCException: could not insert: 
[org.nuxeo.ecm.platform.audit.impl.ExtendedInfoImpl$BlobInfo]
        at 
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
        at 
org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:307)
        at 
org.nuxeo.ecm.core.persistence.PersistenceProvider.doCommit(PersistenceProvider.java:100)
        at 
org.nuxeo.ecm.core.persistence.PersistenceProvider.releaseEntityManager(PersistenceProvider.java:129)
        at 
org.nuxeo.ecm.core.persistence.PersistenceProvider.run(PersistenceProvider.java:193)
        at 
org.nuxeo.ecm.platform.audit.service.NXAuditEventsService.logEvents(NXAuditEventsService.java:718)
        at 
org.nuxeo.ecm.platform.audit.listener.AuditEventLogger.handleEvent(AuditEventLogger.java:53)
        at 
org.nuxeo.ecm.core.event.impl.AsyncEventExecutor$Job.run(AsyncEventExecutor.java:163)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:680)
Caused by: org.hibernate.exception.GenericJDBCException: could not insert: 
[org.nuxeo.ecm.platform.audit.impl.ExtendedInfoImpl$BlobInfo]
        at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285)
        at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)
        at 
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
        at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
        at 
org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:304)
        ... 9 more
Caused by: org.postgresql.util.PSQLException: Large Objects may not be used in 
auto-commit mode.
        at 
org.postgresql.largeobject.LargeObjectManager.createLO(LargeObjectManager.java:241)
        at 
org.postgresql.largeobject.LargeObjectManager.createLO(LargeObjectManager.java:228)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.setBlob(AbstractJdbc2Statement.java:2880)
        at 
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setBlob(DelegatingPreparedStatement.java:181)
        at 
org.hibernate.type.SerializableToBlobType.set(SerializableToBlobType.java:80)
        at 
org.hibernate.type.AbstractLobType.nullSafeSet(AbstractLobType.java:57)
        at 
org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2015)
        at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2261)
        ... 18 more

> Cannot insert a blob in Audit using Tomcat / Postgresql
> -------------------------------------------------------
>
>                 Key: NXP-6440
>                 URL: https://jira.nuxeo.com/browse/NXP-6440
>             Project: Nuxeo Enterprise Platform
>          Issue Type: Bug
>          Components: Audit
>            Reporter: Arnaud Kervern
>            Assignee: Stéphane Lacoin
>             Fix For: 5.4.0.2
>
>
> An exception is throwing due to the autocommit is true.
> The reason is a strange tomcat's behavior that set it to true sometimes 
> althought if it is inside a transaction.
> It must be fixed if tomcat datasources are defined as XA, because it 
> explicitly set autocommit to false.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
https://jira.nuxeo.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets

Reply via email to