airavata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcus Christie (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AIRAVATA-3124) Error when updating the job submission interface.
Date Wed, 07 Aug 2019 19:12:00 GMT

    [ https://issues.apache.org/jira/browse/AIRAVATA-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16902406#comment-16902406
] 

Marcus Christie commented on AIRAVATA-3124:
-------------------------------------------

Here's the error I'm seeing on the backend:
{noformat}
2019-07-15 13:11:55,057 [pool-9-thread-41] 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.appcatalog.ComputeResourceRepository.updateSSHJobSubmission(C
omputeResourceRepository.java:252)
        at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.updateSSHJobSubmissionDetails(Registr
yServerHandler.java:3128)
        at org.apache.airavata.registry.api.RegistryService$Processor$updateSSHJobSubmissionDetails.getResult(RegistryS
ervice.java:17574)
        at org.apache.airavata.registry.api.RegistryService$Processor$updateSSHJobSubmissionDetails.getResult(RegistryS
ervice.java:17558)
        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)
        ... 11 common frames omitted
Caused by: org.apache.openjpa.persistence.EntityExistsException: (conn:17627) Column 'RESOURCE_JOB_MANAGER_ID'
cannot be null {prepstmnt 375510392 
UPDATE SSH_JOB_SUBMISSION 
    SET CREATION_TIME = ?, RESOURCE_JOB_MANAGER_ID = ?, UPDATE_TIME = ? 
    WHERE JOB_SUBMISSION_INTERFACE_ID = ? 
[params=(null) null, (null) null, (Timestamp) 2019-07-15 13:11:55.047, (String) SSH_81b6f3f9-49a5-4970-abe0-3023e9b7cfd9]}
[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(BatchingPreparedStatementManagerImpl.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)
        ... 18 common frames omitted
...
{noformat}

> Error when updating the job submission interface.
> -------------------------------------------------
>
>                 Key: AIRAVATA-3124
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-3124
>             Project: Airavata
>          Issue Type: Sub-task
>          Components: PGA PHP Web Gateway
>    Affects Versions: 0.18
>         Environment: https://staging.scigap.org/
>            Reporter: Eroma
>            Assignee: Marcus Christie
>            Priority: Minor
>         Attachments: Screen Shot 2019-07-15 at 1.12.18 PM.png
>
>
> # In order to create a new compute resource, added the initial description and the queue
details.
>  # Submitted the job submission interface and realized it needed an update.
>  # Changed the MPI Parallelism Prefixes and clicked update and that threw an exception
>  # Did the update again and it again threw the exception
>  # But when queried again the change seem to be saved irrespective of the exception thrown.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

Mime
View raw message