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 2018/11/06 19:33:00 UTC
[jira] [Resolved] (AIRAVATA-2686) Error: Table
'app_catalog.workflow_input' doesn't exist {stmnt 1618749395 ALTER TABLE
workflow_input ADD TEMPLATE_ID VARCHAR(255) }
[ https://issues.apache.org/jira/browse/AIRAVATA-2686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marcus Christie resolved AIRAVATA-2686.
---------------------------------------
Resolution: Fixed
No longer an issue.
> 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)