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-2758) Registry-refactoring: error saving compute resource
Date Fri, 04 May 2018 21:09:00 GMT

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

Marcus Christie commented on AIRAVATA-2758:
-------------------------------------------

There were several columns on COMPUTE_RESOURCE that were NOT NULL in the group-based-auth
environment, but are actually nullable in both the appcatalog-mysql.sql schema and in ComputeResourceEntity.java.

So I changed the database to make those columns nullable.
{code:sql}
MariaDB [app_catalog]> alter table COMPUTE_RESOURCE modify column CREATION_TIME TIMESTAMP
DEFAULT NOW() null;
MariaDB [app_catalog]> alter table COMPUTE_RESOURCE modify column CPUS_PER_NODE int default
0 null;
MariaDB [app_catalog]> alter table COMPUTE_RESOURCE modify column DEFAULT_NODE_COUNT int
default 0 null;
MariaDB [app_catalog]> alter table COMPUTE_RESOURCE modify column DEFAULT_CPU_COUNT int
default 0 null;
MariaDB [app_catalog]> alter table COMPUTE_RESOURCE modify column DEFAULT_WALLTIME int
default 0 null;
MariaDB [app_catalog]> alter table COMPUTE_RESOURCE modify column UPDATE_TIME timestamp
default '0000-00-00 00:00:00' null;
{code}


> Registry-refactoring: error saving compute resource
> ---------------------------------------------------
>
>                 Key: AIRAVATA-2758
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-2758
>             Project: Airavata
>          Issue Type: Bug
>            Reporter: Marcus Christie
>            Assignee: Marcus Christie
>            Priority: Major
>
> Exception:
> {noformat}
> 2018-04-19 19:42:49,852 [pool-9-thread-32] ERROR o.a.t.server.TThreadPoolServer  - Error
occurred during processing of 
> message.
> 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:594)
>         at org.apache.airavata.registry.core.repositories.appcatalog.AppCatAbstractRepository.execute(AppCatAbstractRep
> ository.java:120)
>         at org.apache.airavata.registry.core.repositories.appcatalog.ComputeResourceRepository.saveComputeResource(Comp
> uteResourceRepository.java:81)
>         at org.apache.airavata.registry.core.repositories.appcatalog.ComputeResourceRepository.saveComputeResourceDescr
> iptorData(ComputeResourceRepository.java:62)
>         at org.apache.airavata.registry.core.repositories.appcatalog.ComputeResourceRepository.addComputeResource(Compu
> teResourceRepository.java:56)
>         at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.registerComputeResource(RegistryServe
> rHandler.java:3494)
>         at org.apache.airavata.registry.api.RegistryService$Processor$registerComputeResource.getResult(RegistryService
> .java:16315)
>         at org.apache.airavata.registry.api.RegistryService$Processor$registerComputeResource.getResult(RegistryService
> .java:16299)
>         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.lib.jdbc.ReportingSQLException: (conn:38772) Column 'CPUS_PER_NODE'
cannot be null {prepstmnt 165675255 
> INSERT INTO COMPUTE_RESOURCE (RESOURCE_ID, CPUS_PER_NODE, 
>         CREATION_TIME, DEFAULT_CPU_COUNT, DEFAULT_NODE_COUNT, 
>         DEFAULT_WALLTIME, ENABLED, GATEWAY_USAGE_EXECUTABLE, 
>         GATEWAY_USAGE_MODULE_LOAD_CMD, GATEWAY_USAGE_REPORTING, 
>         HOST_NAME, MAX_MEMORY_NODE, RESOURCE_DESCRIPTION, UPDATE_TIME) 
>     VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
> [params=(String) mike.hpc.lsu.edu_ef1fb102-ad2f-4ab1-ac89-29740eae088e, (null) null,
(null) null, (null) null, (null) null, (null) null, (short) 1, (null) null, (null) null, (int)
0, (String) mike.hpc.lsu.edu, (int) 0, (String) SuperMike-II, named after LSU's original large
Linux cluster named S..., (null) null]} [code=1048, state=23000]
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162)
>         at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
>         at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741)
>         at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267)
>         at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:118)
>         ... 30 common frames omitted
> 2018-04-19 19:42:49,853 [pool-24-thread-49] ERROR o.a.a.a.s.h.AiravataServerHandler 
- Error while saving compute resource...
> org.apache.thrift.transport.TTransportException: null
>         at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
>         at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)
>         at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:424)
>         at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:321)
>         at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:225)
>         at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:77)
>         at org.apache.airavata.registry.api.RegistryService$Client.recv_registerComputeResource(RegistryService.java:5050)
>         at org.apache.airavata.registry.api.RegistryService$Client.registerComputeResource(RegistryService.java:5037)
>         at org.apache.airavata.api.server.handler.AiravataServerHandler.registerComputeResource(AiravataServerHandler.java:2834)
>         at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$87957acb.CGLIB$registerComputeResource$61(<generated>)
>         at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$87957acb$$FastClassByGuice$$d0320b40.invoke(<generated>)
>         at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
>         at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
>         at org.apache.airavata.service.security.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:57)
>         at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
>         at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:55)
>         at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$87957acb.registerComputeResource(<generated>)
>         at org.apache.airavata.api.Airavata$Processor$registerComputeResource.getResult(Airavata.java:19500)
>         at org.apache.airavata.api.Airavata$Processor$registerComputeResource.getResult(Airavata.java:19484)
>         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)
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message