You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@airavata.apache.org by "Marcus Christie (JIRA)" <ji...@apache.org> on 2019/05/13 13:06:00 UTC
[jira] [Commented] (AIRAVATA-3038) Getting 'Internal Server Error'
when saving first group resource profile of the gateway
[ https://issues.apache.org/jira/browse/AIRAVATA-3038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838524#comment-16838524 ]
Marcus Christie commented on AIRAVATA-3038:
-------------------------------------------
This error is occurring in the API server:
{noformat}
2019-05-10 19:47:01,247 [pool-9-thread-5] 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.AbstractRepository.update(AbstractRepository.java:53)
at org.apache.airavata.registry.core.repositories.appcatalog.GroupResourceProfileRepository.updateGroupResource
Profile(GroupResourceProfileRepository.java:87)
at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.updateGroupResourceProfile(RegistrySe
rverHandler.java:2341)
at org.apache.airavata.registry.api.RegistryService$Processor$updateGroupResourceProfile.getResult(RegistryServ
ice.java:19034)
at org.apache.airavata.registry.api.RegistryService$Processor$updateGroupResourceProfile.getResult(RegistryServ
ice.java:19018)
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)
... 12 common frames omitted
Caused by: org.apache.openjpa.persistence.EntityExistsException: (conn:287152) Column 'CREATION_TIME' cannot be null {p
repstmnt 113482013
UPDATE GROUP_RESOURCE_PROFILE
SET CREATION_TIME = ?, UPDATE_TIME = ?
WHERE GROUP_RESOURCE_PROFILE_ID = ?
[params=(null) null, (long) 1557517621123, (String) ced644f6-480c-47b7-856f-ef7974416ef8]} [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)
... 19 common frames omitted
...
{noformat}
For some reason it's trying to set CREATION_TIME to null.
> Getting 'Internal Server Error' when saving first group resource profile of the gateway
> ---------------------------------------------------------------------------------------
>
> Key: AIRAVATA-3038
> URL: https://issues.apache.org/jira/browse/AIRAVATA-3038
> Project: Airavata
> Issue Type: Bug
> Components: Django Portal
> Affects Versions: 0.18
> Environment: https://pfec-hydro.scigap.org
> Reporter: Eroma
> Assignee: Marcus Christie
> Priority: Major
> Fix For: 0.19
>
> Attachments: Screen Shot 2019-05-10 at 3.52.24 PM.png
>
>
> # A new django portal gateway and was creating the first group resource profile.
> # Added the name and selected gateway user group in share.
> # Then added the compute resource and saved.
> # Then clicked on save in resource profile page
> # Getting the internal server error.
> #
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)