[
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
