db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5735) 2 failures in Derby2017LayerATest on trunk(revision 1332036) with ibm17
Date Mon, 30 Apr 2012 20:55:50 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13265209#comment-13265209
] 

Kristian Waagan commented on DERBY-5735:
----------------------------------------

Haven't we seen several other tests failing with similar error messages lately?
If I remember correctly, the test shouldn't do anything to make the database read-only. The
errors, as opposed to the two failures, seem to happen in decorators.
I see the errors are clustered together after AuthenticationTest and DriverTest. The former
tests read-only users. The latter has code to remove databases, where one of them is "'wombat'"
([1]). The next test to succeed after the group of errors is DriverMgrAuthenticationTest,
which uses a single-use database.

A quick look at some code *indicates* (I have not debugged this properly) that either BaseDataFileFactory.privGetJBMSLockOnDB
fails, or the user/connection is configured as read-only. In the former case the IOException
seems to be discarded without emitting any traces. The comment says "// probably a read only
db, don't do anything more".

I also found some traces of <assertDirectoryDeleted> at work in another test run, but
it succeeded before it decided to give up. That's an indication of concurrent disk IO, possibly
dual-boot, or that the machine running the tests is heavily loaded / slow. In this case the
test run recovered sooner, and there were only 8 errors.


[1] The single quotes within the double quotes are part of the name.
                
> 2 failures in Derby2017LayerATest on trunk(revision 1332036) with ibm17
> -----------------------------------------------------------------------
>
>                 Key: DERBY-5735
>                 URL: https://issues.apache.org/jira/browse/DERBY-5735
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.9.0.0
>         Environment: Windows machine with ibm17
>            Reporter: Mamta A. Satoor
>
> Not sure if anyone is aware of following 2 failures. suites.All.out shows following
> 1) cs_FailedStreamInsertCharBufferBoundaries(org.apache.derbyTesting.functionTests.tests.jdbcapi.Derby2017LayerATest)junit.framework.ComparisonFailure:
Unexpected SQL state. expected:<[X0Y32]> but was:<[25503]>
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:811)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:854)
> 	at org.apache.derbyTesting.functionTests.tests.jdbcapi.Derby2017LayerATest.doInsertTest(Derby2017LayerATest.java:492)
> 	at org.apache.derbyTesting.functionTests.tests.jdbcapi.Derby2017LayerATest.cs_FailedStreamInsertCharBufferBoundaries(Derby2017LayerATest.java:166)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: java.sql.SQLException: DDL is not permitted for a read-only connection, user
or database.
> 	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.executeUpdate(Unknown Source)
> 	at org.apache.derbyTesting.functionTests.tests.jdbcapi.Derby2017LayerATest.doInsertTest(Derby2017LayerATest.java:490)
> 	... 34 more
> Caused by: org.apache.derby.client.am.SqlException: DDL is not permitted for a read-only
connection, user or database.
> 	at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
> 	at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
> 	at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source)
> 	at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source)
> 	at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source)
> 	at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
> 	at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source)
> 	at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
> 	at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
> 	... 36 more
> 2) cs_StreamInsertCharBufferBoundary(org.apache.derbyTesting.functionTests.tests.jdbcapi.Derby2017LayerATest)junit.framework.ComparisonFailure:
Unexpected SQL state. expected:<[X0Y32]> but was:<[25503]>
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:811)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:854)
> 	at org.apache.derbyTesting.functionTests.tests.jdbcapi.Derby2017LayerATest.cs_StreamInsertCharBufferBoundary(Derby2017LayerATest.java:100)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: java.sql.SQLException: DDL is not permitted for a read-only connection, user
or database.
> 	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.executeUpdate(Unknown Source)
> 	at org.apache.derbyTesting.functionTests.tests.jdbcapi.Derby2017LayerATest.cs_StreamInsertCharBufferBoundary(Derby2017LayerATest.java:98)
> 	... 33 more
> Caused by: org.apache.derby.client.am.SqlException: DDL is not permitted for a read-only
connection, user or database.
> 	at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
> 	at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
> 	at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source)
> 	at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source)
> 	at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source)
> 	at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
> 	at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source)
> 	at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
> 	at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
> 	... 35 more

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message