Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Wed, 5 Sep 2012 03:36:08 +1100 (NCT)
From: "Mamta A. Satoor (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <195574852.33322.1346776568171.JavaMail.jiratomcat@arcas>
In-Reply-To: 
 <1682317684.7692.1308159827092.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Resolved] (DERBY-5279)
 test5DeleteBeforeTriggerNoReferencingClause fails in nightly testing
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/DERBY-5279?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mamta A. Satoor resolved DERBY-5279.
------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.3.3.1

The test has not failed in over a year. I will close it for now. If it repr=
oduces, we can reopen the issue.
               =20
> test5DeleteBeforeTriggerNoReferencingClause fails in nightly testing
> --------------------------------------------------------------------
>
>                 Key: DERBY-5279
>                 URL: https://issues.apache.org/jira/browse/DERBY-5279
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.3.3.1
>         Environment: failing in posted 10.3 tinderbox on sun jvm:
> org.apache.derbyTesting.functionTests.suites.All diff -------------------=
------------------------------------------
> ------------------ Java Information ------------------
> Java Version:    1.6.0_18
> Java Vendor:     Sun Microsystems Inc.
> Java home:       /usr/local/java/jdk1.6.0_18/jre
> Java classpath:  /home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/de=
rby.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyclient.j=
ar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbytools.jar:/ho=
me/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbynet.jar:/home/os136=
789/Apache/TinderBox-10.3/db2jcc/lib/db2jcc.jar:/home/os136789/Apache/Tinde=
rBox-10.3/db2jcc/lib/db2jcc_license_c.jar:/home/os136789/Apache/TinderBox-1=
0.3/10.3/jars/insane/derbyTesting.jar:/home/os136789/Apache/TinderBox-10.3/=
10.3/jars/insane/derbyrun.jar:/home/os136789/Apache/TinderBox-10.3/10.3/too=
ls/java/jakarta-oro-2.0.8.jar:/home/os136789/Apache/TinderBox-10.3/10.3/too=
ls/java/junit.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/der=
byLocale_de_DE.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/de=
rbyLocale_es.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derb=
yLocale_fr.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyL=
ocale_it.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLoc=
ale_ja_JP.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLo=
cale_ko_KR.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyL=
ocale_pt_BR.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derby=
Locale_zh_CN.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derb=
yLocale_zh_TW.jar:/usr/local/share/java/xalan/serializer.jar:/usr/local/sha=
re/java/xalan/xalan.jar:/usr/local/share/java/xalan/xercesImpl.jar:/usr/loc=
al/share/java/xalan/xml-apis.jar:/usr/local/share/java/xalan/xsltc.jar
> OS name:         SunOS
> OS architecture: x86
> OS version:      5.10
> Java user name:  os136789
> Java user home:  /home/os136789
> Java user dir:   /export/home/tmp/os136789/testingDerbyTinderBox-10.3/Sun=
OS-5.10_i86pc-i386/org.apache.derbyTesting.functionTests.suites.All
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.6
> --------- Derby Information --------
> JRE - JDBC: Java SE 6 - JDBC 4.0
> [/export/home/tmp/os136789/10.3/jars/insane/derby.jar] 10.3.3.1 - (105589=
0)
> [/export/home/tmp/os136789/10.3/jars/insane/derbytools.jar] 10.3.3.1 - (1=
055890)
> [/export/home/tmp/os136789/10.3/jars/insane/derbynet.jar] 10.3.3.1 - (105=
5890)
> [/export/home/tmp/os136789/10.3/jars/insane/derbyclient.jar] 10.3.3.1 - (=
1055890)
> [/home/os136789/Apache/TinderBox_Derby/db2jcc/lib/db2jcc.jar] 2.4 - (17)
> [/home/os136789/Apache/TinderBox_Derby/db2jcc/lib/db2jcc_license_c.jar] 2=
.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> Current Locale :  [English/United States [en_US]]
> Found support for locale: [cs]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [de_DE]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [es]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [fr]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [hu]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [it]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [ja_JP]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [ko_KR]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [pl]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [pt_BR]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [ru]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [zh_CN]
> =09 version: 10.3.3.1 - (1055890)
> Found support for locale: [zh_TW]
> =09 version: 10.3.3.1 - (1055890)
> ------------------------------------------------------
>            Reporter: Mike Matrigali
>            Assignee: Mamta A. Satoor
>             Fix For: 10.3.3.1
>
>
> The following has failed in a number of tinderbox runs, but not always.  =
For example it has failed as reported in:
> http://dbtg.foundry.sun.com/derby/test/tinderbox_10.3_16/jvm1.6/testing/t=
estlog/SunOS-5.10_i86pc-i386/1055890-org.apache.derbyTesting.functionTests.=
suites.All_diff.txt
> But not fail in the subsequent run:
> http://dbtg.foundry.sun.com/derby/test/tinderbox_10.3_16/jvm1.6/testing/t=
estlog/SunOS-5.10_i86pc-i386/1056412-derbyall_diff.txt
> But then fails again in the most recent run:
> http://dbtg.foundry.sun.com/derby/test/tinderbox_10.3_16/jvm1.6/testing/t=
estlog/SunOS-5.10_i86pc-i386/1135825-org.apache.derbyTesting.functionTests.=
suites.All_diff.txt
> There was 1 error:
> 1) test5DeleteBeforeTriggerNoReferencingClause(org.apache.derbyTesting.fu=
nctionTests.tests.memory.TriggerTests)java.sql.SQLException: Table/View 'TA=
BLE1' already exists in Schema 'APP'.
> =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQ=
LExceptionFactory40.java:95)
> =09at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:20=
2)
> =09at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLExcepti=
on(TransactionResourceImpl.java:391)
> =09at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(=
TransactionResourceImpl.java:346)
> =09at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedCon=
nection.java:1593)
> =09at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Connecti=
onChild.java:81)
> =09at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedSta=
tement.java:1294)
> =09at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.ja=
va:596)
> =09at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.ja=
va:528)
> =09at org.apache.derbyTesting.functionTests.tests.memory.TriggerTests.bas=
icSetup(TriggerTests.java:267)
> =09at org.apache.derbyTesting.functionTests.tests.memory.TriggerTests.tes=
t5DeleteBeforeTriggerNoReferencingClause(TriggerTests.java:1221)
> =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp=
l.java:39)
> =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc=
essorImpl.java:25)
> =09at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.jav=
a:99)
> =09at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> =09at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> =09at junit.extensions.TestSetup.run(TestSetup.java:25)
> =09at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:=
57)
> =09at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> =09at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> =09at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: java.sql.SQLException: Table/View 'TABLE1' already exists in S=
chema 'APP'.
> =09at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLE=
xceptionFactory.java:45)
> =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTranspo=
rtAcrossDRDA(SQLExceptionFactory40.java:135)
> =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQ=
LExceptionFactory40.java:70)
> =09... 41 more
> Caused by: ERROR X0Y32: Table/View 'TABLE1' already exists in Schema 'APP=
'.
> =09at org.apache.derby.iapi.error.StandardException.newException(Standard=
Exception.java:371)
> =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescr=
iptorException(DataDictionaryImpl.java:1683)
> =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(=
DataDictionaryImpl.java:1674)
> =09at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(=
DataDictionaryImpl.java:1653)
> =09at org.apache.derby.impl.sql.execute.CreateTableConstantAction.execute=
ConstantAction(CreateTableConstantAction.java:238)
> =09at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.=
java:64)
> =09at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericP=
reparedStatement.java:370)
> =09at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedSta=
tement.java:1203)
> =09... 35 more

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs
For more information on JIRA, see: http://www.atlassian.com/software/jira