airavata-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raminderjeet Singh (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (AIRAVATA-930) Airavata Security Implementation failing because of existing database
Date Wed, 16 Oct 2013 15:53:43 GMT

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

Raminderjeet Singh updated AIRAVATA-930:
----------------------------------------

    Description: 
Test fails with following error.

Running org.apache.airavata.security.userstore.SessionDBUserStoreTest
[main] ERROR org.apache.airavata.common.utils.DBUtil - An error occurred while closing database
connections
java.sql.SQLException: Cannot close a connection while a transaction is still active.
	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.Connection.closeResourcesX(Unknown Source)
	at org.apache.derby.client.am.Connection.closeX(Unknown Source)
	at org.apache.derby.client.net.NetConnection.closeX(Unknown Source)
	at org.apache.derby.client.am.Connection.close(Unknown Source)
	at org.apache.derby.client.net.NetConnection.close(Unknown Source)
	at org.apache.derby.client.net.NetConnection40.close(Unknown Source)
	at org.apache.airavata.common.utils.DBUtil.executeSQL(DBUtil.java:174)
	at org.apache.airavata.common.utils.DatabaseTestCases.executeSQL(DatabaseTestCases.java:106)
	at org.apache.airavata.security.userstore.SessionDBUserStoreTest.setUpDatabase(SessionDBUserStoreTest.java:51)
Caused by: org.apache.derby.client.am.SqlException: Cannot close a connection while a transaction
is still active.
	at org.apache.derby.client.am.Connection.checkForTransactionInProgress(Unknown Source)
	... 31 more
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.131 sec <<< FAILURE!

Results :

Tests in error:
  org.apache.airavata.security.userstore.JDBCUserStoreTest: Table/View 'AIRAVATA_USER' already
exists in Schema 'ADMIN'.
  org.apache.airavata.security.userstore.SessionDBUserStoreTest: Table/View 'PERSONS' already
exists in Schema 'ADMIN'.


  was:
Test fails with following error.

Running org.apache.airavata.security.userstore.SessionDBUserStoreTest
[main] ERROR org.apache.airavata.common.utils.DBUtil - An error occurred while closing database
connections
java.sql.SQLException: Cannot close a connection while a transaction is still active.
	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.Connection.closeResourcesX(Unknown Source)
	at org.apache.derby.client.am.Connection.closeX(Unknown Source)
	at org.apache.derby.client.net.NetConnection.closeX(Unknown Source)
	at org.apache.derby.client.am.Connection.close(Unknown Source)
	at org.apache.derby.client.net.NetConnection.close(Unknown Source)
	at org.apache.derby.client.net.NetConnection40.close(Unknown Source)
	at org.apache.airavata.common.utils.DBUtil.executeSQL(DBUtil.java:174)
	at org.apache.airavata.common.utils.DatabaseTestCases.executeSQL(DatabaseTestCases.java:106)
	at org.apache.airavata.security.userstore.SessionDBUserStoreTest.setUpDatabase(SessionDBUserStoreTest.java:51)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:236)
	at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:134)
	at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:113)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189)
	at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165)
	at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85)
	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:103)
	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:74)
Caused by: org.apache.derby.client.am.SqlException: Cannot close a connection while a transaction
is still active.
	at org.apache.derby.client.am.Connection.checkForTransactionInProgress(Unknown Source)
	... 31 more
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.131 sec <<< FAILURE!

Results :

Tests in error:
  org.apache.airavata.security.userstore.JDBCUserStoreTest: Table/View 'AIRAVATA_USER' already
exists in Schema 'ADMIN'.
  org.apache.airavata.security.userstore.SessionDBUserStoreTest: Table/View 'PERSONS' already
exists in Schema 'ADMIN'.



> Airavata Security Implementation failing because of existing database
> ---------------------------------------------------------------------
>
>                 Key: AIRAVATA-930
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-930
>             Project: Airavata
>          Issue Type: Bug
>          Components: Security
>    Affects Versions: 0.9
>            Reporter: Raminderjeet Singh
>
> Test fails with following error.
> Running org.apache.airavata.security.userstore.SessionDBUserStoreTest
> [main] ERROR org.apache.airavata.common.utils.DBUtil - An error occurred while closing
database connections
> java.sql.SQLException: Cannot close a connection while a transaction is still active.
> 	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.Connection.closeResourcesX(Unknown Source)
> 	at org.apache.derby.client.am.Connection.closeX(Unknown Source)
> 	at org.apache.derby.client.net.NetConnection.closeX(Unknown Source)
> 	at org.apache.derby.client.am.Connection.close(Unknown Source)
> 	at org.apache.derby.client.net.NetConnection.close(Unknown Source)
> 	at org.apache.derby.client.net.NetConnection40.close(Unknown Source)
> 	at org.apache.airavata.common.utils.DBUtil.executeSQL(DBUtil.java:174)
> 	at org.apache.airavata.common.utils.DatabaseTestCases.executeSQL(DatabaseTestCases.java:106)
> 	at org.apache.airavata.security.userstore.SessionDBUserStoreTest.setUpDatabase(SessionDBUserStoreTest.java:51)
> Caused by: org.apache.derby.client.am.SqlException: Cannot close a connection while a
transaction is still active.
> 	at org.apache.derby.client.am.Connection.checkForTransactionInProgress(Unknown Source)
> 	... 31 more
> Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.131 sec <<<
FAILURE!
> Results :
> Tests in error:
>   org.apache.airavata.security.userstore.JDBCUserStoreTest: Table/View 'AIRAVATA_USER'
already exists in Schema 'ADMIN'.
>   org.apache.airavata.security.userstore.SessionDBUserStoreTest: Table/View 'PERSONS'
already exists in Schema 'ADMIN'.



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message