You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2012/04/30 19:15:48 UTC
[jira] [Created] (DERBY-5735) 2 failures in Derby2017LayerATest on
trunk(revision 1332036) with ibm17
Mamta A. Satoor created DERBY-5735:
--------------------------------------
Summary: 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
[jira] [Commented] (DERBY-5735) 2 failures in Derby2017LayerATest
on trunk(revision 1332036) with ibm17
Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13267683#comment-13267683 ]
Kristian Waagan commented on DERBY-5735:
----------------------------------------
In the case of the <assertDirectoryDeleted> messages I saw, the test framework waited for 0 + 2 + 4 + 6 = 12 seconds, plus any overhead of the deletion logic itself, before it could delete all the files. The files may have been deleted after 6+ seconds, as the wait logic is based on #attempt * 2seconds. #attempt is one less then the number printed in the test output, and the last attempt succeeded and generated no output. Had the last attempt failed, the test would have failed too.
This may be caused by the issue we have with getConnection("...;shutdown=true") returns before Derby has actually shut down, but I haven't checked which database was being deleted and if the test that created it generates a lot of data or not.
> 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
[jira] [Closed] (DERBY-5735) 2 failures in Derby2017LayerATest on
trunk(revision 1332036) with ibm17
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren closed DERBY-5735.
-------------------------------------
Resolution: Duplicate
> 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.1.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
[jira] [Commented] (DERBY-5735) 2 failures in Derby2017LayerATest
on trunk(revision 1332036) with ibm17
Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Commented] (DERBY-5735) 2 failures in Derby2017LayerATest
on trunk(revision 1332036) with ibm17
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13265422#comment-13265422 ]
Myrna van Lunteren commented on DERBY-5735:
-------------------------------------------
You're right, we're hitting these messages re read-only databases regularly in various tests and with various jvms, I think it's all on the same machine, and this is indeed during (very) heavy load.
I've linked most of these to DERBY-5686.
> 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
[jira] [Commented] (DERBY-5735) 2 failures in Derby2017LayerATest
on trunk(revision 1332036) with ibm17
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13267620#comment-13267620 ]
Myrna van Lunteren commented on DERBY-5735:
-------------------------------------------
I was incorrect in saying that this is the same machine as the failure(s) of DERBY-5686 - this was on 10.8 (windows XP), all other occurrences so far have been with trunk (10.9) windows (XP)
The trunk tests run on a 2 CPU machine, the 10.8 on 4 CPU, if this is likely to occur on a heavily loaded machine, then that may be why we've not (?) seen this on 10.8 before.
> 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