airavata-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Heshan Suriyaarachchi (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (AIRAVATA-741) Airavata startup fails when Airavata is pointed to a new database
Date Fri, 25 Jan 2013 17:49:13 GMT

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

Heshan Suriyaarachchi resolved AIRAVATA-741.
--------------------------------------------

       Resolution: Fixed
    Fix Version/s: 0.6

Fixed in trunk. Committed revision 1438616.
                
> 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
>             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

Mime
View raw message