airavata-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Viknes Balasubramanee (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AIRAVATA-879) Derby database does not get created the first time you start the airavata server from a distribution
Date Wed, 03 Jul 2013 17:18:21 GMT
Viknes Balasubramanee created AIRAVATA-879:
----------------------------------------------

             Summary: Derby database does not get created the first time you start the airavata
server from a distribution
                 Key: AIRAVATA-879
                 URL: https://issues.apache.org/jira/browse/AIRAVATA-879
             Project: Airavata
          Issue Type: Bug
          Components: Distribution
    Affects Versions: 0.8
         Environment: Windows, Linux
            Reporter: Viknes Balasubramanee


The following error occurs when you start airavata server for the first time after you extract
it from the server binary distribution.

Mon Jul 01 15:13:32 EDT 2013 : Apache Derby Network Server - 10.9.1.0 - (1344872) started
and ready to accept connection
s on port 1527
DriverClassName=org.apache.derby.jdbc.ClientDriver,Url=jdbc:derby://localhost:1527/persistent_data;create=true;user=aira
vata;password=airavata,Username=airavata,Password=airavata,validationQuery=SELECT 1 from Configuration,MaxActive=10,MaxI
dle=5,MinIdle=2,MaxWait=60000,testWhileIdle=true,testOnBorrow=true
52  airavata_data  INFO   [Thread-8] openjpa.Runtime - Starting OpenJPA 2.2.0
[ERROR] Error while initializing the Airavata API
org.apache.airavata.client.api.exception.AiravataAPIInvocationException: Error while initializing
the Airavata API
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:64)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:43)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:39)
        at org.apache.airavata.wsmg.msgbox.MsgBoxServiceLifeCycle$1.run(MsgBoxServiceLifeCycle.java:117)
Caused by: org.apache.airavata.client.api.exception.AiravataAPIInvocationException: Error
while initializing the Airavat
a API
        at org.apache.airavata.client.AiravataClient.initialize(AiravataClient.java:163)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:61)
        ... 3 more
Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> org.apache.openjpa.persistence.PersistenceException:
Cann
ot create PoolableConnectionFactory (Schema 'AIRAVATA' does not exist)
        at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102)
        at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)
        at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1510)
        at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:518)
        at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:443)
        at org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:104)
        at org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68)
        at org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83)
        at org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:
968)
        at org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:
959)
        at org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:638)
        at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
        at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227
)
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154
)
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)

        at org.apache.airavata.persistance.registry.jpa.ResourceUtils.getEntityManager(ResourceUtils.java:68)
        at org.apache.airavata.persistance.registry.jpa.ResourceUtils.getConfigurations(ResourceUtils.java:201)
        at org.apache.airavata.persistance.registry.jpa.ResourceUtils.getConfiguration(ResourceUtils.java:223)
        at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.getConfiguration(AiravataJPARegistry.ja
va:226)
        at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.initialize(AiravataJPARegistry.java:159
)
        at org.apache.airavata.registry.api.AiravataRegistryFactory.getRegistry(AiravataRegistryFactory.java:81)
        at org.apache.airavata.client.AiravataClient.getRegistry(AiravataClient.java:216)
        at org.apache.airavata.client.AiravataClient.createConfig(AiravataClient.java:112)
        at org.apache.airavata.client.AiravataClient.initialize(AiravataClient.java:144)
        ... 4 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory
(Schema 'AIRAVATA' does n
ot exist)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110)
        at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87)
        at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91)
        ... 28 more
Caused by: java.sql.SQLSyntaxErrorException: Schema 'AIRAVATA' does not exist
        at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
        at org.apache.derby.client.am.Statement.executeQuery(Unknown Source)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 33 more
Caused by: org.apache.derby.client.am.SqlException: Schema 'AIRAVATA' does not exist
        at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
Source)
        at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
        at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
        at org.apache.derby.client.am.Statement.executeQueryX(Unknown Source)
        ... 38 more
[ERROR] Error while initializing the Airavata API
org.apache.airavata.client.api.exception.AiravataAPIInvocationException: Error while initializing
the Airavata API
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:64)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:43)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:39)
        at org.apache.airavata.wsmg.broker.BrokerServiceLifeCycle$1.run(BrokerServiceLifeCycle.java:156)
Caused by: org.apache.airavata.client.api.exception.AiravataAPIInvocationException: Error
while initializing the Airavat
a API
        at org.apache.airavata.client.AiravataClient.initialize(AiravataClient.java:163)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:61)
        ... 3 more
Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> org.apache.openjpa.persistence.PersistenceException:
Cann
ot create PoolableConnectionFactory (Schema 'AIRAVATA' does not exist)
        at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102)
        at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)
        at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1510)
        at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:518)
        at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:443)
        at org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:104)
        at org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68)
        at org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83)
        at org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:
968)
        at org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:
959)
        at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getMappingRepositoryInstance(JDBCConfigurationImpl.java:71
1)
        at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:140)
        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:227
)
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154
)
        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)

        at org.apache.airavata.persistance.registry.jpa.ResourceUtils.getEntityManager(ResourceUtils.java:68)
        at org.apache.airavata.persistance.registry.jpa.ResourceUtils.getConfigurations(ResourceUtils.java:201)
        at org.apache.airavata.persistance.registry.jpa.ResourceUtils.getConfiguration(ResourceUtils.java:223)
        at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.getConfiguration(AiravataJPARegistry.ja
va:226)
        at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.initialize(AiravataJPARegistry.java:159
)
        at org.apache.airavata.registry.api.AiravataRegistryFactory.getRegistry(AiravataRegistryFactory.java:81)
        at org.apache.airavata.client.AiravataClient.getRegistry(AiravataClient.java:216)
        at org.apache.airavata.client.AiravataClient.createConfig(AiravataClient.java:112)
        at org.apache.airavata.client.AiravataClient.initialize(AiravataClient.java:144)
        ... 4 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory
(Schema 'AIRAVATA' does n
ot exist)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110)
        at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87)
        at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91)
        ... 31 more
Caused by: java.sql.SQLSyntaxErrorException: Schema 'AIRAVATA' does not exist
        at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
        at org.apache.derby.client.am.Statement.executeQuery(Unknown Source)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 36 more
Caused by: org.apache.derby.client.am.SqlException: Schema 'AIRAVATA' does not exist
        at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
Source)
        at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
        at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
        at org.apache.derby.client.am.Statement.executeQueryX(Unknown Source)
        ... 41 more
[INFO] New Database created for Registry
59649  airavata_data  INFO   [Thread-3] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.DerbyDic
tionary" (Apache Derby 10.9.1.0 - (1344872) ,Apache Derby Network Client JDBC Driver 10.9.1.0
- (1344872)).
[INFO] Deploying Web service: airavata-registry-service-0.8.jar - file:/C:/Users/Viknes/DOWNLO~1/APACHE~1.8-B/APACHE~1.8
/bin/../repository/services/airavata-registry-service-0.8.jar
[INFO] Deploying Web service: airavata-xbaya-gui-0.8.jar - file:/C:/Users/Viknes/DOWNLO~1/APACHE~1.8-B/APACHE~1.8/bin/..
/repository/services/airavata-xbaya-gui-0.8.jar
[INFO] Deploying Web service: version-1.5.1.aar - file:/C:/Users/Viknes/DOWNLO~1/APACHE~1.8-B/APACHE~1.8/bin/../reposito
ry/services/version-1.5.1.aar
Jul 01, 2013 3:14:42 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
[ERROR] Unable to create Airavata API
org.apache.airavata.client.api.exception.AiravataAPIInvocationException: Error while initializing
the Airavata API
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:64)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:43)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:39)
        at org.apache.airavata.xbaya.interpretor.WorkflowInterpretorSkeleton.getAiravataAPI(WorkflowInterpretorSkeleton.
java:122)
        at org.apache.airavata.xbaya.interpretor.WorkflowInterpretorSkeleton.access$200(WorkflowInterpretorSkeleton.java
:78)
        at org.apache.airavata.xbaya.interpretor.WorkflowInterpretorSkeleton$1.run(WorkflowInterpretorSkeleton.java:158)

Caused by: org.apache.airavata.client.api.exception.AiravataAPIInvocationException: Error
while initializing the Airavat
a API
        at org.apache.airavata.client.AiravataClient.initialize(AiravataClient.java:163)
        at org.apache.airavata.client.AiravataAPIFactory.getAPI(AiravataAPIFactory.java:61)
        ... 5 more
Caused by: <openjpa-2.2.0-r422266:1244990 nonfatal user error> org.apache.openjpa.persistence.ArgumentException:
An erro
r occurred while parsing the query filter "SELECT p FROM Configuration p WHERE p.config_key
=:param0". Error message: Th
e name "Configuration" is not a recognized entity or identifier. Known entity names: []
        at org.apache.openjpa.kernel.exps.AbstractExpressionBuilder.parseException(AbstractExpressionBuilder.java:119)
        at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getClassMetaData(JPQLExpressionBuilder.java:197)
        at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMetaData(JPQLExpressionBuilder.java:167)
        at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMetaData(JPQLExpressionBuilder.java:242)
        at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMetaData(JPQLExpressionBuilder.java:212)
        at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateType(JPQLExpressionBuilder.java:205)
        at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.access$200(JPQLExpressionBuilder.java:80)
        at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.populate(JPQLExpressionBuilder.java:2417)
        at org.apache.openjpa.kernel.jpql.JPQLParser.populate(JPQLParser.java:61)
        at org.apache.openjpa.kernel.ExpressionStoreQuery.populateFromCompilation(ExpressionStoreQuery.java:162)
        at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:673)
        at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654)
        at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620)
        at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682)
        at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:589)
        at org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:997)
        at org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:979)
        at org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:102)
        at org.apache.airavata.persistance.registry.jpa.utils.QueryGenerator.generateQueryWithParameters(QueryGenerator.
java:95)
        at org.apache.airavata.persistance.registry.jpa.utils.QueryGenerator.selectQuery(QueryGenerator.java:64)
        at org.apache.airavata.persistance.registry.jpa.ResourceUtils.getConfigurations(ResourceUtils.java:205)
        at org.apache.airavata.persistance.registry.jpa.ResourceUtils.getConfiguration(ResourceUtils.java:223)
        at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.getConfiguration(AiravataJPARegistry.ja
va:226)
        at org.apache.airavata.persistance.registry.jpa.impl.AiravataJPARegistry.initialize(AiravataJPARegistry.java:159
)
        at org.apache.airavata.registry.api.AiravataRegistryFactory.getRegistry(AiravataRegistryFactory.java:81)
        at org.apache.airavata.client.AiravataClient.getRegistry(AiravataClient.java:216)
        at org.apache.airavata.client.AiravataClient.createConfig(AiravataClient.java:112)
        at org.apache.airavata.client.AiravataClient.initialize(AiravataClient.java:144)
        ... 6 more
Exception in thread "Thread-29" java.lang.NullPointerException
        at org.apache.airavata.xbaya.interpretor.WorkflowInterpretorSkeleton$1.run(WorkflowInterpretorSkeleton.java:159)


Steps to Reproduce,

1. Download the airavata server binary distribution and extract it. 
2. Start the server and you get the above error during startup.

--
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