[AIRAVATA-741] Airavata startup fails when Airavata is pointed to a new database

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6
• Fix Version/s: 0.6
• Environment: Airavata-RC3 webapp; Mysql
• Assignee: Heshan Theekshana Suriyaarachchi
• Reporter: Heshan Theekshana Suriyaarachchi
• Created: 25/Jan/13 15:55
• Updated: 25/Jan/13 17:48
• Resolved: 25/Jan/13 17:48

Description

Steps to reproduce.

1) Create a new database named persistent_data_2.
2) Updating the authenticators.xml and airavata-server.properties files.
3) Start Tomcat.

Following is the stacktrace.

[INFO] Database already created for Registry!
60 airavata_data INFO [localhost-startStop-1] openjpa.Runtime - Starting OpenJPA 2.2.0
162 airavata_data INFO [localhost-startStop-1] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary".
org.apache.axis2.deployment.DeploymentException: Table 'persistent_data_2.Users' doesn't exist

{prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]} [code=1146, state=42S02]
at org.apache.axis2.deployment.repository.util.ArchiveReader.processServiceGroup(ArchiveReader.java:150)
at org.apache.axis2.deployment.ServiceDeployer.deploy(ServiceDeployer.java:81)
at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:659)
at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:337)
at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:241)
at org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:131)
at org.apache.axis2.deployment.WarBasedAxisConfigurator.loadServices(WarBasedAxisConfigurator.java:284)
at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:95)
at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:525)
at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:443)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5026)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5313)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1100)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1618)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.axis2.deployment.DeploymentException: Table 'persistent_data_2.Users' doesn't exist {prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]}

[code=1146, state=42S02]
at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:431)
at org.apache.axis2.deployment.repository.util.ArchiveReader.buildServiceGroup(ArchiveReader.java:101)
at org.apache.axis2.deployment.repository.util.ArchiveReader.processServiceGroup(ArchiveReader.java:143)
... 28 more
Caused by: org.apache.axis2.deployment.DeploymentException: Table 'persistent_data_2.Users' doesn't exist

{prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]} [code=1146, state=42S02]
at org.apache.axis2.deployment.ServiceBuilder.loadServiceLifeCycleClass(ServiceBuilder.java:521)
at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:205)
... 30 more
Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> org.apache.openjpa.persistence.PersistenceException: Table 'persistent_data_2.Users' doesn't exist {prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]}

[code=1146, state=42S02]
FailedObject: admin [org.apache.openjpa.util.StringId] [java.lang.String]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:86)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:309)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:112)
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1036)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:994)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:911)
at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:231)
at org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:487)
at org.apache.airavata.persistance.registry.jpa.resources.UserResource.save(UserResource.java:129)
at org.apache.airavata.registry.services.RegistryService.initializeDB(RegistryService.java:145)
at org.apache.airavata.registry.services.RegistryService.startUp(RegistryService.java:66)
at org.apache.axis2.deployment.ServiceBuilder.loadServiceLifeCycleClass(ServiceBuilder.java:518)
... 31 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'persistent_data_2.Users' doesn't exist

{prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]} [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$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1146)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:265)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1750)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:255)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:547)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:349)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:304)
... 42 more
[ERROR] The airavata-registry-service-0.6-SNAPSHOT.jar service, which is not valid, caused Table 'persistent_data_2.Users' doesn't exist {prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]}

[code=1146, state=42S02]
org.apache.axis2.deployment.DeploymentException: Table 'persistent_data_2.Users' doesn't exist

{prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]} [code=1146, state=42S02]
at org.apache.axis2.deployment.repository.util.ArchiveReader.processServiceGroup(ArchiveReader.java:150)
at org.apache.axis2.deployment.ServiceDeployer.deploy(ServiceDeployer.java:81)
at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:659)
at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:337)
at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:241)
at org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:131)
at org.apache.axis2.deployment.WarBasedAxisConfigurator.loadServices(WarBasedAxisConfigurator.java:284)
at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:95)
at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:525)
at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:443)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5026)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5313)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1100)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1618)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.axis2.deployment.DeploymentException: Table 'persistent_data_2.Users' doesn't exist {prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]}

[code=1146, state=42S02]
at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:431)
at org.apache.axis2.deployment.repository.util.ArchiveReader.buildServiceGroup(ArchiveReader.java:101)
at org.apache.axis2.deployment.repository.util.ArchiveReader.processServiceGroup(ArchiveReader.java:143)
... 28 more
Caused by: org.apache.axis2.deployment.DeploymentException: Table 'persistent_data_2.Users' doesn't exist

{prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]} [code=1146, state=42S02]
at org.apache.axis2.deployment.ServiceBuilder.loadServiceLifeCycleClass(ServiceBuilder.java:521)
at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:205)
... 30 more
Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> org.apache.openjpa.persistence.PersistenceException: Table 'persistent_data_2.Users' doesn't exist {prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]}

[code=1146, state=42S02]
FailedObject: admin [org.apache.openjpa.util.StringId] [java.lang.String]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:86)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:309)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:112)
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1036)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:994)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:911)
at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:231)
at org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:487)
at org.apache.airavata.persistance.registry.jpa.resources.UserResource.save(UserResource.java:129)
at org.apache.airavata.registry.services.RegistryService.initializeDB(RegistryService.java:145)
at org.apache.airavata.registry.services.RegistryService.startUp(RegistryService.java:66)
at org.apache.axis2.deployment.ServiceBuilder.loadServiceLifeCycleClass(ServiceBuilder.java:518)
... 31 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'persistent_data_2.Users' doesn't exist

{prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]} [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$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1146)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:265)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1750)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:255)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:547)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:349)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:304)
... 42 more
[INFO] org.apache.axis2.deployment.DeploymentException: Table 'persistent_data_2.Users' doesn't exist {prepstmnt 1448464820 SELECT t0.password FROM Users t0 WHERE t0.user_name = ? [params=(String) admin]}

[code=1146, state=42S02]
[INFO] Deploying Web service: airavata-gfac-axis2-interface-0.6-SNAPSHOT.jar - file:/home/heshan/Dev/setup/prabhash/airavata-0.6/apache-tomcat-7.0.28/webapps/airavata-server/WEB-INF/services/airavata-gfac-axis2-interface-0.6-SNAPSHOT.jar
[INFO] Deploying Web service: airavata-levenshtein-distance-service-0.6-SNAPSHOT.aar - file:/home/heshan/Dev/setup/prabhash/airavata-0.6/apache-tomcat-7.0.28/webapps/airavata-server/WEB-INF/services/airavata-levenshtein-distance-service-0.6-SNAPSHOT.aar
Jan 25, 2013 10:52:56 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /home/heshan/Dev/setup/prabhash/airavata-0.6/apache-tomcat-7.0.28/webapps/ROOT
Jan 25, 2013 10:52:56 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Jan 25, 2013 10:52:56 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Jan 25, 2013 10:52:56 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 7961 ms
[ERROR] Table 'persistent_data_2.Host_Descriptor' doesn't exist

{prepstmnt 1011181816 SELECT t1.gateway_name, t1.owner, t0.host_descriptor_xml, t2.user_name, t2.password FROM Host_Descriptor t0 LEFT OUTER JOIN Gateway t1 ON t0.gateway_name = t1.gateway_name LEFT OUTER JOIN Users t2 ON t0.updated_user = t2.user_name WHERE t0.gateway_name = ? AND t0.host_descriptor_ID = ? [params=(String) default, (String) LocalHost]} [code=1146, state=42S02]
<openjpa-2.2.0-r422266:1244990 fatal general error> org.apache.openjpa.persistence.PersistenceException: Table 'persistent_data_2.Host_Descriptor' doesn't exist {prepstmnt 1011181816 SELECT t1.gateway_name, t1.owner, t0.host_descriptor_xml, t2.user_name, t2.password FROM Host_Descriptor t0 LEFT OUTER JOIN Gateway t1 ON t0.gateway_name = t1.gateway_name LEFT OUTER JOIN Users t2 ON t0.updated_user = t2.user_name WHERE t0.gateway_name = ? AND t0.host_descriptor_ID = ? [params=(String) default, (String) LocalHost]}

[code=1146, state=42S02]
FailedObject: org.apache.airavata.persistance.registry.jpa.model.Host_Descriptor-org.apache.airavata.persistance.registry.jpa.model.Host_Descriptor_PK@1 [org.apache.openjpa.util.ObjectId] [java.lang.String]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:86)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:309)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:112)
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1036)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:994)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:911)
at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:231)
at org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:487)
at org.apache.airavata.persistance.registry.jpa.resources.GatewayResource.isExists(GatewayResource.java:461)
at org.apache.airavata.persistance.registry.jpa.resources.GatewayResource.isHostDescriptorExists(GatewayResource.java:491)
at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.isHostDescriptorExists(AiravataJPARegistry.java:391)
at org.apache.airavata.client.impl.ApplicationManagerImpl.isHostDescriptorExists(ApplicationManagerImpl.java:386)
at org.apache.airavata.xbaya.interpretor.WorkflowInterpretorSkeleton$1.run(WorkflowInterpretorSkeleton.java:168)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'persistent_data_2.Host_Descriptor' doesn't exist

{prepstmnt 1011181816 SELECT t1.gateway_name, t1.owner, t0.host_descriptor_xml, t2.user_name, t2.password FROM Host_Descriptor t0 LEFT OUTER JOIN Gateway t1 ON t0.gateway_name = t1.gateway_name LEFT OUTER JOIN Users t2 ON t0.updated_user = t2.user_name WHERE t0.gateway_name = ? AND t0.host_descriptor_ID = ? [params=(String) default, (String) LocalHost]} [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$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1146)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:265)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1750)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:255)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:547)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:349)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:304)
... 12 more
NestedThrowables:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'persistent_data_2.Host_Descriptor' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:267)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1144)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:265)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1750)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:255)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:547)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:349)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:304)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:112)
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1036)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:994)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:911)
at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:231)
at org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:487)
at org.apache.airavata.persistance.registry.jpa.resources.GatewayResource.isExists(GatewayResource.java:461)
at org.apache.airavata.persistance.registry.jpa.resources.GatewayResource.isHostDescriptorExists(GatewayResource.java:491)
at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.isHostDescriptorExists(AiravataJPARegistry.java:391)
at org.apache.airavata.client.impl.ApplicationManagerImpl.isHostDescriptorExists(ApplicationManagerImpl.java:386)
at org.apache.airavata.xbaya.interpretor.WorkflowInterpretorSkeleton$1.run(WorkflowInterpretorSkeleton.java:168)
org.apache.airavata.client.api.AiravataAPIInvocationException: Error invoking API
at org.apache.airavata.client.impl.ApplicationManagerImpl.isHostDescriptorExists(ApplicationManagerImpl.java:388)
at org.apache.airavata.xbaya.interpretor.WorkflowInterpretorSkeleton$1.run(WorkflowInterpretorSkeleton.java:168)
Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> org.apache.openjpa.persistence.PersistenceException: Table 'persistent_data_2.Host_Descriptor' doesn't exist {prepstmnt 1011181816 SELECT t1.gateway_name, t1.owner, t0.host_descriptor_xml, t2.user_name, t2.password FROM Host_Descriptor t0 LEFT OUTER JOIN Gateway t1 ON t0.gateway_name = t1.gateway_name LEFT OUTER JOIN Users t2 ON t0.updated_user = t2.user_name WHERE t0.gateway_name = ? AND t0.host_descriptor_ID = ? [params=(String) default, (String) LocalHost]}

[code=1146, state=42S02]
FailedObject: org.apache.airavata.persistance.registry.jpa.model.Host_Descriptor-org.apache.airavata.persistance.registry.jpa.model.Host_Descriptor_PK@1 [org.apache.openjpa.util.ObjectId] [java.lang.String]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:86)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:309)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:112)
at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1036)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:994)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:911)
at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:231)
at org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:487)
at org.apache.airavata.persistance.registry.jpa.resources.GatewayResource.isExists(GatewayResource.java:461)
at org.apache.airavata.persistance.registry.jpa.resources.GatewayResource.isHostDescriptorExists(GatewayResource.java:491)
at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.isHostDescriptorExists(AiravataJPARegistry.java:391)
at org.apache.airavata.client.impl.ApplicationManagerImpl.isHostDescriptorExists(ApplicationManagerImpl.java:386)
... 1 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'persistent_data_2.Host_Descriptor' doesn't exist

{prepstmnt 1011181816 SELECT t1.gateway_name, t1.owner, t0.host_descriptor_xml, t2.user_name, t2.password FROM Host_Descriptor t0 LEFT OUTER JOIN Gateway t1 ON t0.gateway_name = t1.gateway_name LEFT OUTER JOIN Users t2 ON t0.updated_user = t2.user_name WHERE t0.gateway_name = ? AND t0.host_descriptor_ID = ? [params=(String) default, (String) LocalHost]}

[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$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1146)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:265)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1750)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:255)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:547)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:349)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:304)
... 12 more