[AIRAVATA-3269] Failed to updateProcess: Column 'TASK_ID' cannot be null

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Component/s: Registry API
• Assignee: Marcus Christie
• Reporter: Marcus Christie
• Created: 06/Nov/19 21:46
• Updated: 12/Nov/19 23:16
• Resolved: 08/Nov/19 20:32

Description

2019-11-06 14:21:34,784 [pool-9-thread-1461] ERROR o.a.a.r.c.r.AbstractRepository  - Failed to execute transaction
org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back.  See the nested exceptions for 
details on the errors that occurred.
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:595)
        at org.apache.airavata.registry.core.repositories.AbstractRepository.execute(AbstractRepository.java:119)
        at org.apache.airavata.registry.core.repositories.expcatalog.ProcessRepository.saveProcess(ProcessRepository.ja
va:83)
        at org.apache.airavata.registry.core.repositories.expcatalog.ProcessRepository.saveProcessModelData(ProcessRepo
sitory.java:51)
        at org.apache.airavata.registry.core.repositories.expcatalog.ProcessRepository.updateProcess(ProcessRepository.
java:132)
        at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.updateProcess(RegistryServerHandler.j
ava:934)
        at org.apache.airavata.registry.api.RegistryService$Processor$updateProcess.getResult(RegistryService.java:1630
2)
        at org.apache.airavata.registry.api.RegistryService$Processor$updateProcess.getResult(RegistryService.java:1628
6)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.openjpa.persistence.EntityExistsException: The transaction has been rolled back.  See the nested 
exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2374)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2211)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
        at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
        ... 13 common frames omitted
Caused by: org.apache.openjpa.persistence.EntityExistsException: (conn:84976) Column 'TASK_ID' cannot be null {prepstmn
t 870350989 
UPDATE JOB 
    SET TASK_ID = ? 
    WHERE JOB_ID = ? AND TASK_ID = ? 
[params=(null) null, (String) 4875659.m2, (String) TASK_0b2a2005-6375-4cb7-a17a-0d1bd46a0a9b]} [code=1048, state=23000]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4988)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java
:144)
        at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatement
ManagerImpl.java:79)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:
100)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:107)
        at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59
)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
        ... 20 common frames omitted