Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 38469 invoked from network); 4 Jun 2007 18:07:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Jun 2007 18:07:32 -0000 Received: (qmail 55074 invoked by uid 500); 4 Jun 2007 18:07:35 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 55045 invoked by uid 500); 4 Jun 2007 18:07:35 -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 55036 invoked by uid 99); 4 Jun 2007 18:07:35 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jun 2007 11:07:35 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [192.18.43.132] (HELO sca-es-mail-1.sun.com) (192.18.43.132) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jun 2007 11:07:28 -0700 Received: from fe-sfbay-09.sun.com ([192.18.43.129]) by sca-es-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id l54I78j6000289 for ; Mon, 4 Jun 2007 11:07:08 -0700 (PDT) Received: from conversion-daemon.fe-sfbay-09.sun.com by fe-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JJ400001I71V700@fe-sfbay-09.sun.com> (original mail from Richard.Hillegas@Sun.COM) for derby-dev@db.apache.org; Mon, 04 Jun 2007 11:07:08 -0700 (PDT) Received: from [192.9.61.197] by fe-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JJ4003QBIBSNV80@fe-sfbay-09.sun.com> for derby-dev@db.apache.org; Mon, 04 Jun 2007 11:07:04 -0700 (PDT) Date: Mon, 04 Jun 2007 11:08:50 -0700 From: Rick Hillegas Subject: errors in junit tests Sender: Richard.Hillegas@Sun.COM To: Derby Development Message-id: <46645532.7050500@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT User-Agent: Thunderbird 1.5.0.5 (X11/20060828) X-Virus-Checked: Checked by ClamAV on apache.org I synced my client to revision 544150 this morning. I see 70 failures and 21 errors when I run the junit tests. The errors are in the DatabaseClassLoadingTest and the upgrade tests: Errors: 1) testLoadJavaClassDirectly(org.apache.derbyTesting.functionTests.tests.lang.DatabaseClassLoadingTest)java.sql.SQLException: Jar file 'MY_JAVA' already exists in Schema 'EMC'. 2) testLoadJavaClassDirectly2(org.apache.derbyTesting.functionTests.tests.lang.DatabaseClassLoadingTest)java.sql.SQLException: Jar file 'MY_JAVA' already exists in Schema 'EMC'. 3) testLoadJavaClassDirectly3(org.apache.derbyTesting.functionTests.tests.lang.DatabaseClassLoadingTest)java.sql.SQLException: Jar file 'MY_JAVA' already exists in Schema 'EMC'. 4) testLoadDerbyClassIndirectly(org.apache.derbyTesting.functionTests.tests.lang.DatabaseClassLoadingTest)java.sql.SQLException: Jar file 'MY_JAVA' already exists in Schema 'EMC'. 5) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse29', see the next exception for details. 6) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse2a', see the next exception for details. 7) testProcedureSignature(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_1)java.sql.SQLException: PROCEDURE 'GC' already exists. 8) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse29', see the next exception for details. 9) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse2a', see the next exception for details. 10) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse2c', see the next exception for details. 11) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse2d', see the next exception for details. 12) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse2c', see the next exception for details. 13) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse2d', see the next exception for details. 14) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse2f', see the next exception for details. 15) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse30', see the next exception for details. 16) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse2f', see the next exception for details. 17) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse30', see the next exception for details. 18) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse32', see the next exception for details. 19) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse33', see the next exception for details. 20) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse32', see the next exception for details. 21) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)java.sql.SQLException: Failed to start database 'singleUse/oneuse33', see the next exception for details. There were 70 failures: 1) testLoadJavaClassIndirectly(org.apache.derbyTesting.functionTests.tests.lang.DatabaseClassLoadingTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[38000]> but was:<[XJ001]> 2) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<0> but was:<3> 3) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]> 4) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 5) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 6) testProcedureSignature(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_1)junit.framework.AssertionFailedError: Expected error 'XCL47' but no error was thrown. 7) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[XCL47]> but was:<[42Z60]> 8) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 9) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade 10) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade 11) testImportExportLobsProcedures(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Expected error '42Y03' but no error was thrown. 12) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 13) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<0> but was:<3> 14) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]> 15) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 16) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 17) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<1> but was:<3> 18) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]> 19) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 20) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 21) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[XCL47]> but was:<[42Z60]> 22) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 23) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade 24) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade 25) testImportExportLobsProcedures(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Expected error '42Y03' but no error was thrown. 26) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 27) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<1> but was:<3> 28) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]> 29) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 30) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 31) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<1> but was:<3> 32) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]> 33) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 34) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 35) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[XCL47]> but was:<[42Z60]> 36) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 37) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade 38) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade 39) testImportExportLobsProcedures(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Expected error '42Y03' but no error was thrown. 40) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 41) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<1> but was:<3> 42) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]> 43) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 44) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 45) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<1> but was:<3> 46) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]> 47) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 48) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 49) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<[XCL47]> but was:<[42Z60]> 50) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 51) changeEncryptionFromNone(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade 52) changeEncryptionFromEncryptedDatabase(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.AssertionFailedError: open re-encrypted connection in soft upgrade 53) testImportExportLobsProcedures(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Expected error '42Y03' but no error was thrown. 54) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 55) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<1> but was:<3> 56) testGrantRevokeStatements(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<42[X01]> but was:<42[Z60]> 57) testDatabaseOwnerChange(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_2)junit.framework.ComparisonFailure: AUTHORIZATIONID not valid for SYSIBM expected:<[DBA]> but was:<[APP]> 58) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 59) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<2> but was:<3> 60) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 61) testImportExportLobsProcedures(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Expected error '42Y03' but no error was thrown. 62) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 63) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<2> but was:<3> 64) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 65) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<2> but was:<3> 66) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 67) testImportExportLobsProcedures(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Expected error '42Y03' but no error was thrown. 68) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: 69) testOldVersion(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup)junit.framework.AssertionFailedError: Old minor (driver): expected:<2> but was:<3> 70) testPolicyReloadingProcedure(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3)junit.framework.AssertionFailedError: Reloading results. expected: but was: