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
