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] [Assigned] (AIRAVATA-2686) Error: Table 'app_catalog.workflow_input' doesn't exist {stmnt 1618749395 ALTER TABLE workflow_input ADD TEMPLATE_ID VARCHAR(255) }
Date Tue, 06 Nov 2018 19:14:00 GMT

     [ https://issues.apache.org/jira/browse/AIRAVATA-2686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Marcus Christie reassigned AIRAVATA-2686:
-----------------------------------------

    Assignee: Marcus Christie

> Error: Table 'app_catalog.workflow_input' doesn't  exist {stmnt 1618749395  ALTER TABLE
workflow_input ADD TEMPLATE_ID VARCHAR(255) }
> -------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: AIRAVATA-2686
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-2686
>             Project: Airavata
>          Issue Type: Bug
>            Reporter: Marcus Christie
>            Assignee: Marcus Christie
>            Priority: Major
>
> This might be related to the registry-refactoring work. This error occurs the first time
creating an EntityManager in the app catalog (AppCatalogJPAUtils.getEntityManager). Looks
like it is trying to do some database updates to bring tables up to date with the JPA models.
> Stack trace:
> {noformat}
> 2018-02-22 15:16:37,425 [pool-9-thread-2] ERROR o.a.a.r.a.s.h.RegistryServerHandler 
- seagrid
> java.lang.RuntimeException: Failed to get App Catalog EntityManager
>         at org.apache.airavata.registry.core.repositories.appcatalog.AppCatAbstractRepository.execute(AppCatAbstractRep
> ository.java:115)
>         at org.apache.airavata.registry.core.repositories.appcatalog.AppCatAbstractRepository.get(AppCatAbstractReposit
> ory.java:69)
>         at org.apache.airavata.registry.core.repositories.appcatalog.GwyResourceProfileRepository.getGatewayProfile(Gwy
> ResourceProfileRepository.java:81)
>         at org.apache.airavata.registry.api.service.handler.RegistryServerHandler.getGatewayResourceProfile(RegistrySer
> verHandler.java:1993)
>         at org.apache.airavata.registry.api.RegistryService$Processor$getGatewayResourceProfile.getResult(RegistryServi
> ce.java:17447)
>         at org.apache.airavata.registry.api.RegistryService$Processor$getGatewayResourceProfile.getResult(RegistryServi
> ce.java:17431)
>         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.PersistenceException: (conn:1644) Table 'app_catalog.workflow_input'
doesn't 
> exist {stmnt 1618749395 
> ALTER TABLE workflow_input ADD TEMPLATE_ID VARCHAR(255) } [code=1146, state=42S02]
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:559)
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:455)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
>         at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
>         at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:209)
>         at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:22
> 7)
>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:15
> 4)
>         at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60
> )
>         at org.apache.airavata.registry.core.utils.JPAUtil.AppCatalogJPAUtils.getEntityManager(AppCatalogJPAUtils.java:
> 55)
>         at org.apache.airavata.registry.core.repositories.appcatalog.AppCatAbstractRepository.execute(AppCatAbstractRep
> ository.java:113)
>         ... 11 common frames omitted
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn:1644) Table 'app_catalog.workflow_input'
doesn't ex
> ist {stmnt 1618749395 
> ALTER TABLE workflow_input ADD TEMPLATE_ID VARCHAR(255) } [code=1146, state=42S02]
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:231)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)
>         at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:942)
>         at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:114)
>         at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1224)
>         at org.apache.openjpa.jdbc.schema.SchemaTool.addColumn(SchemaTool.java:1057)
>         at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:506)
>         at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:366)
>         at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:343)
>         at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505)
>         ... 22 common frames omitted
> {noformat}



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

Mime
View raw message