From derby-dev-return-95606-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Fri May 11 05:25:17 2012 Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 02CA496AF for ; Fri, 11 May 2012 05:25:17 +0000 (UTC) Received: (qmail 12244 invoked by uid 500); 11 May 2012 05:25:16 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 12021 invoked by uid 500); 11 May 2012 05:25:15 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 11978 invoked by uid 99); 11 May 2012 05:25:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 May 2012 05:25:14 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 May 2012 05:25:08 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 475BE490A79 for ; Fri, 11 May 2012 05:24:46 +0000 (UTC) Date: Fri, 11 May 2012 05:24:46 +0000 (UTC) From: "Kristian Waagan (JIRA)" To: derby-dev@db.apache.org Message-ID: <127908582.53263.1336713886311.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <1356818816.24940.1333738764803.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (DERBY-5686) multiple intermittent errors in nightly tests during DriverMgrAuthenticationTest test. reason: An SQL data change is not permitted for a read-only connection, user or database. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273054#comment-13273054 ] Kristian Waagan commented on DERBY-5686: ---------------------------------------- Thanks for updating the environment field, Myrna. Is patch 6 temporary, or is it intended as a permanent addition? Especially if the latter, I have a few questions and comments: o Are there cases where the lock files won't be removed for some reason? If yes, then there should be a timeout function, i.e. don't wait for more than X minutes. o You can avoid the boolean by using break, but with a timeout the loop will probably be rewritten anyway. o This patch masks an issue. I'd like it to print something if it has to wait, similar to what assertDirectoryDeleted does, as an incentive/reminder for fixing the real issue. I expect that with patch 6 committed, you shouldn't see any more output from assertDirectoryDeleted, except for in cases where there's a real bug with not closing file handles. The theory about the database shutdown now being complete is pretty much confirmed, since the file deletion logic has failed deleting db.lock and tmp. Both of these are supposed to be removed by Derby when it has shut down properly. I don't know if this is the reason for the read-only connections, but it will be good to rule that out. Do we know if the database goes read-only on boot, or if it turns read-only after being booted? > multiple intermittent errors in nightly tests during DriverMgrAuthenticationTest test. reason: An SQL data change is not permitted for a read-only connection, user or database. > ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-5686 > URL: https://issues.apache.org/jira/browse/DERBY-5686 > Project: Derby > Issue Type: Bug > Components: Test > Environment: Most often seen with trunk, on: Windows XP (Professional Version 2002, SP3) Intel(R) Xeon(TM) CPU 2.40 GHz 2.39 GHz, 3.87 GB of RAM. Hyperthreading on or off. JVM version seems not to matter (seen with ibm 1.5, 1.6, 1.7, weme6.2). Machine runs 4 jvm suites.All runs concurrently, so heavily loaded. Similar load on a windows XP on VMWare similuated with Xeon(TM) MP CPU 3.33GHz, 3.34GHz machine does not display this behavior. > Once a variation was seen (see DERBY-5735) on another machine (Windows 2008, 4 CPU) with 10.8. > Reporter: Mike Matrigali > Attachments: DERBY-5686-3a-add_missing_return.diff, DERBY-5686_1.diff, DERBY-5686_2.diff, DERBY-5686_3.diff, DERBY-5686_4.diff, DERBY-5686_5.diff, DERBY-5686_6.diff > > > 8 errors in nightly test runs on 4/4/2012 against trunk, windows, ibm16, build 1310147 . Tests passed against same build, same machine on ibm15 and ibm17 > http://people.apache.org/~myrnavl/derby_test_results/main/windows/testlog/ibm16/1310147-suites.All_diff.txt > There were 8 errors: > 1) testNotFullAccessUsers(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)java.sql.SQLException: An SQL data change 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.PreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setProperties(DatabasePropertyTestSetup.java:352) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setUp(DatabasePropertyTestSetup.java:268) > at junit.extensions.TestSetup$1.protect(TestSetup.java:20) > 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) > 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) > 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) > 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: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database. > at org.apache.derby.client.am.Statement.completeExecute(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source) > at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source) > ... 47 more > 2) testNotFullAccessUsers(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)java.sql.SQLException: An SQL data change 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.PreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.tearDown(DatabasePropertyTestSetup.java:294) > at junit.extensions.TestSetup$1.protect(TestSetup.java:22) > 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) > 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) > 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: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database. > at org.apache.derby.client.am.Statement.completeExecute(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source) > at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source) > ... 41 more > 3) testChangePasswordAndDatabasePropertiesOnly(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)java.sql.SQLException: An SQL data change 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.PreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setProperties(DatabasePropertyTestSetup.java:352) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setUp(DatabasePropertyTestSetup.java:268) > at junit.extensions.TestSetup$1.protect(TestSetup.java:20) > 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) > 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) > 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) > 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: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database. > at org.apache.derby.client.am.Statement.completeExecute(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source) > at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source) > ... 47 more > 4) testChangePasswordAndDatabasePropertiesOnly(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)java.sql.SQLException: An SQL data change 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.PreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.tearDown(DatabasePropertyTestSetup.java:294) > at junit.extensions.TestSetup$1.protect(TestSetup.java:22) > 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) > 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) > 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: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database. > at org.apache.derby.client.am.Statement.completeExecute(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source) > at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source) > ... 41 more > 5) testGreekCharacters(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)java.sql.SQLException: An SQL data change 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.PreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setProperties(DatabasePropertyTestSetup.java:352) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setUp(DatabasePropertyTestSetup.java:268) > at junit.extensions.TestSetup$1.protect(TestSetup.java:20) > 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) > 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) > 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) > 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: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database. > at org.apache.derby.client.am.Statement.completeExecute(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source) > at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source) > ... 47 more > 6) testGreekCharacters(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)java.sql.SQLException: An SQL data change 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.PreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.tearDown(DatabasePropertyTestSetup.java:294) > at junit.extensions.TestSetup$1.protect(TestSetup.java:22) > 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) > 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) > 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: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database. > at org.apache.derby.client.am.Statement.completeExecute(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source) > at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source) > ... 41 more > 7) testSystemShutdown(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)java.sql.SQLException: An SQL data change 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.PreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setProperties(DatabasePropertyTestSetup.java:352) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setUp(DatabasePropertyTestSetup.java:268) > at junit.extensions.TestSetup$1.protect(TestSetup.java:20) > 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) > 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) > 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) > 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: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database. > at org.apache.derby.client.am.Statement.completeExecute(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source) > at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source) > ... 47 more > 8) testSystemShutdown(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)java.sql.SQLException: An SQL data change 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.PreparedStatement.executeUpdate(Unknown Source) > at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.tearDown(DatabasePropertyTestSetup.java:294) > at junit.extensions.TestSetup$1.protect(TestSetup.java:22) > 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) > 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) > 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: org.apache.derby.client.am.SqlException: An SQL data change is not permitted for a read-only connection, user or database. > at org.apache.derby.client.am.Statement.completeExecute(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source) > at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source) > at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown Source) > ... 41 more > FAILURES!!! > Tests run: 15467, Failures: 0, Errors: 8 -- 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