[
https://issues.apache.org/jira/browse/AIRAVATA-741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Heshan Suriyaarachchi reopened AIRAVATA-741:
--------------------------------------------
Assignee: Heshan Suriyaarachchi
> Airavata startup fails when Airavata is pointed to a new database
> -----------------------------------------------------------------
>
> Key: AIRAVATA-741
> URL: https://issues.apache.org/jira/browse/AIRAVATA-741
> Project: Airavata
> Issue Type: Bug
> Affects Versions: 0.6
> Environment: Airavata-RC3 webapp
> Mysql
> Reporter: Heshan Suriyaarachchi
> Assignee: Heshan Suriyaarachchi
> Fix For: 0.6
>
>
> 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
