[zanata-bugs] [Bug 996939] New: Clearing a TM while an import is in progress can fail (almost) silently.

bugzilla at redhat.com bugzilla at redhat.com
Wed Aug 14 10:22:19 UTC 2013 

https://bugzilla.redhat.com/show_bug.cgi?id=996939

            Bug ID: 996939
           Summary: Clearing a TM while an import is in progress can fail
                    (almost) silently.
           Product: Zanata
           Version: 3.0
         Component: Component-UI
          Severity: medium
          Assignee: zanata-dev-internal at redhat.com
          Reporter: djansen at redhat.com
        QA Contact: zanata-qa at redhat.com
                CC: zanata-bugs at redhat.com



Description of problem:
An admin that starts a Clear operation on a TM during another's large TM import
may have the operation appear to complete, but nothing is cleared.

Version-Release number of selected component (if applicable):
3.0

How reproducible:
Moderate sometimes

Steps to Reproduce:
Pre: A large TMX is available, two admin users are signed in (or just use the
same admin with two tabs)
1. As one admin,
- go to Administration, Translation Memory
- start a large import to a TM
2. As another admin,
- go to Administration, Translation Memory
- start the clear of the same TM

Actual results:
Occasionally fails with an exception

Expected results:
Either complete, or lock the operation while import is in progress

Additional info:
20:11:06,632 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]
(DefaultQuartzScheduler_Worker-2) SQL Error: 0, SQLState: null
20:11:06,637 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]
(DefaultQuartzScheduler_Worker-2) javax.resource.ResourceException: IJ000460:
Error checking for a transaction
20:11:06,637 ERROR [org.zanata.process.AsynchronousExecutor]
(DefaultQuartzScheduler_Worker-2) Exception with long running process: Could
not open connection: org.hibernate.exception.GenericJDBCException: Could not
open connection
    at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:56)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:98)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:85)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.persister.entity.AbstractEntityPersister.loadEntityIdByNaturalId(AbstractEntityPersister.java:4782)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.event.internal.DefaultResolveNaturalIdEventListener.loadFromDatasource(DefaultResolveNaturalIdEventListener.java:128)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.event.internal.DefaultResolveNaturalIdEventListener.resolveNaturalId(DefaultResolveNaturalIdEventListener.java:95)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.event.internal.DefaultResolveNaturalIdEventListener.onResolveNaturalId(DefaultResolveNaturalIdEventListener.java:61)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.internal.SessionImpl.fireResolveNaturalId(SessionImpl.java:1100)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:174)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.internal.SessionImpl$BaseNaturalIdLoadAccessImpl.resolveNaturalId(SessionImpl.java:2528)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.internal.SessionImpl$NaturalIdLoadAccessImpl.load(SessionImpl.java:2640)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at org.zanata.dao.TransMemoryDAO.getBySlug(TransMemoryDAO.java:69)
[classes:]
    at
org.zanata.dao.TransMemoryDAO.deleteTransMemoryContents(TransMemoryDAO.java:84)
[classes:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[rt.jar:1.6.0_37]
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[rt.jar:1.6.0_37]
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[rt.jar:1.6.0_37]
    at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_37]
    at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:186)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:104)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.zanata.dao.TransMemoryDAO_$$_javassist_seam_48.deleteTransMemoryContents(TransMemoryDAO_$$_javassist_seam_48.java)
[classes:]
    at
org.zanata.action.TranslationMemoryAction$1.run(TranslationMemoryAction.java:101)
[classes:]
    at
org.zanata.process.AsynchronousExecutor.runAsynchronously(AsynchronousExecutor.java:61)
[classes:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[rt.jar:1.6.0_37]
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[rt.jar:1.6.0_37]
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[rt.jar:1.6.0_37]
    at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_37]
    at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.async.AsynchronousInterceptor.aroundInvoke(AsynchronousInterceptor.java:52)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:186)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:104)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.zanata.process.AsynchronousExecutor_$$_javassist_seam_108.runAsynchronously(AsynchronousExecutor_$$_javassist_seam_108.java)
[classes:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[rt.jar:1.6.0_37]
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[rt.jar:1.6.0_37]
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[rt.jar:1.6.0_37]
    at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_37]
    at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:144)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.async.AsynchronousInvocation$1.process(AsynchronousInvocation.java:62)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.async.Asynchronous$ContextualAsynchronousRequest.run(Asynchronous.java:80)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.async.AsynchronousInvocation.execute(AsynchronousInvocation.java:44)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at
org.jboss.seam.async.QuartzDispatcher$QuartzJob.execute(QuartzDispatcher.java:243)
[jboss-seam-2.3.0.Final.jar:2.3.0.Final]
    at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
[quartz-1.5.2.jar:1.5.2]
    at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
[quartz-1.5.2.jar:1.5.2]
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000460:
Error checking for a transaction
    at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
    at
org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.zanata.database.WrappedDatasourceConnectionProvider.getConnection(WrappedDatasourceConnectionProvider.java:45)
[classes:]
    at
org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
[hibernate-core-4.2.0.Final-redhat-1.jar:4.2.0.Final]
    ... 63 more
Caused by: javax.resource.ResourceException: IJ000460: Error checking for a
transaction
    at
org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:362)
    at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
    at sun.reflect.GeneratedMethodAccessor125.invoke(Unknown Source)
[:1.6.0_37]
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[rt.jar:1.6.0_37]
    at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_37]
    at
net.bull.javamelody.JdbcWrapper$ConnectionManagerInvocationHandler.invoke(JdbcWrapper.java:230)
[javamelody-core-1.41.0.jar:1.41.0]
    at
net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:259)
[javamelody-core-1.41.0.jar:1.41.0]
    at $Proxy25.allocateConnection(Unknown Source)    at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
    ... 67 more
Caused by: javax.resource.ResourceException: IJ000459: Transaction is not
active: tx=TransactionImple < ac, BasicAction:
0:ffff7f000001:-a261080:5209c1d7:101c status: ActionStatus.ABORTED >
    at
org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:352)
    ... 75 more

-- 
You are receiving this mail because:
You are on the CC list for the bug.
Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=Dx2VgA0TUY&a=cc_unsubscribe

More information about the zanata-bugs mailing list