db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Myrna van Lunteren <m.v.lunte...@gmail.com>
Subject Re: [jira] Commented: (DERBY-943) nightly test regression in sycat test only on ibm142 jvm
Date Sat, 11 Feb 2006 10:00:01 GMT
I could use some help on this one.
The problem does *not* occur with jdk14, ibm15, jdk15.
The problem only occurs with jars - I've been using insane jars.

 The reason I changed the database name was to enable this test to be run in
the remote host configuration. In that setup, the test would be run after
several other tests, and there were too many things left behind to get a
clear result.

I got past the java.security.AccessControlException by granting to
derbynet.jar:
  permission java.io.FilePermission
"${derby.system.home}${/}syscatdb${/}tmp${/}-",
"read, write, delete";

So, is this a jvm bug or another privileged block needed somewhere in
derby code only accessed with ibm142?

If privileged block, how does one find out where? (this may seem obvious to
other people, or even to me at some other time. it's late, or, rather,
early).

Or is this the same issue as DERBY-616? That one doesn't say it's only with
ibm142...

How shall we go about 'hiding' this problem from the nightly test output
1. disable the test with ibm142
2. reset to use wombat (which already uses this) and disable for remote
server testing
3. add the above mentioned privilege for derbynet.jar to derby_tests.policy.

Input please?

Myrna



On 2/10/06, Myrna van Lunteren (JIRA) <derby-dev@db.apache.org> wrote:
>
>    [ http://issues.apache.org/jira/browse/DERBY-943?page=comments#action_12365997
> ]
>
> Myrna van Lunteren commented on DERBY-943:
> ------------------------------------------
>
> I changed this test to use a different database than 'wombat'.
> I am very surprised by this behavior under ibm142. I'll have a look.
>
> > nightly test regression in sycat test only on ibm142 jvm
> > --------------------------------------------------------
> >
> >          Key: DERBY-943
> >          URL: http://issues.apache.org/jira/browse/DERBY-943
> >      Project: Derby
> >         Type: Bug
> >   Components: Regression Test Failure
> >     Versions: 10.0.2.0
> >  Environment: Generating report for RunSuite derbyall  null null null
> true
> > ------------------ Java Information ------------------
> > Java Version:    1.4.2
> > Java Vendor:     IBM Corporation
> > Java home:       e:\classtest\ibm142\jre
> > Java
> classpath:  e:/classtest/classes/derby.jar;e:/classtest/classes/derbyLocale_zh_TW.jar;e:/classtest/classes/derbyLocale_zh_CN.jar;e:/classtest/classes/derbyLocale_pt_BR.jar;e:/classtest/classes/derbyLocale_ko_KR.jar;e:/classtest/classes/derbyLocale_ja_JP.jar;e:/classtest/classes/derbyLocale_it.jar;e:/classtest/classes/derbyLocale_fr.jar;e:/classtest/classes/derbyLocale_es.jar;e:/classtest/classes/derbyLocale_de_DE.jar;e:/classtest/classes/derbytools.jar;e:/classtest/classes/derbynet.jar;e:/classtest/classes/derbyclient.jar;;e:/classtest/classes/derbyTesting.jar;e:/classtest/classes/maps.jar;e:/classtest/classes/functionTests.jar;e:/classtest/tools/java/junit.jar;e:/classtest/tools/java/jndi/fscontext.jar;e:/classtest/tools/java/RmiJdbc.jar;e:/classtest/drda/jcc/2.4/db2jcc.jar;e:/classtest/drda/jcc/2.4/db2jcc_license_c.jar
>
> > OS name:         Windows 2000
> > OS architecture: x86
> > OS version:      5.0
> > Java user name:  cloudtst
> > Java user home:  C:\WINNT40\Profiles\cloudtst
> > Java user dir:   E:\classtest\JarResults.2006-02-09\ibm142_derbyall
> > java.specification.name: Java Platform API Specification
> > java.specification.version: 1.4
> > --------- Derby Information --------
> > JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
> > [E:\classtest\classes\derby.jar] 10.2.0.0 alpha - (376537)
> > [E:\classtest\classes\derbytools.jar] 10.2.0.0 alpha - (376537)
> > [E:\classtest\classes\derbynet.jar] 10.2.0.0 alpha - (376537)
> > [E:\classtest\classes\derbyclient.jar] 10.2.0.0 alpha - (376537)
> > [E:\classtest\drda\jcc\2.4\db2jcc.jar] 2.4 - (17)
> > [E:\classtest\drda\jcc\2.4\db2jcc_license_c.jar] 2.4 - (17)
> >     Reporter: Mike Matrigali
> >     Priority: Critical
>
> >
> > The following test has failed only under the ibm142 jvm for the last 2
> nights:
> > *** Start: syscat jdk1.4.2 DerbyNet derbynetmats:derbynetmats 2006-02-10
> 01:35:43 ***
> > 77 del
> > < CONGLOMERATENAME |2
> > 77a77,79
> > > ERROR XSDF1: Exception during creation of file
> E:\classtest\JarResults.2006-02-09\ibm142_derbyall\derbyall\derbynetmats\DerbyNet\derbynetmats\syscat\syscatdb\tmp\T1139564150757.tmp
> for container SQLSTATE: XJ001: Java exception: 'access denied (
> java.io.FilePermissionE:\classtest\JarResults.2006-02-09\ibm142_derbyall\derbyall\derbynetmats\DerbyNet\derbynetmats\syscat\syscatdb\tmp\T1139564150757.tmp
> read): java.security.AccessControlException'.
> > > ij> select TABLENAME, TABLETYPE from sys.systables order by tablename;
> > > TABLENAME |&
> > 79 del
> > < SYSALIASES_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096 , derby.storage.reusableRecordId=true }
> > 80 del
> > < SYSALIASES_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 81 del
> > < SYSALIASES_INDEX3 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 82 del
> > < SYSCHECKS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 83 del
> > < SYSCOLPERMS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 84 del
> > < SYSCOLUMNS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 85 del
> > < SYSCOLUMNS_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 86 del
> > < SYSCONGLOMERATES_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 87 del
> > < SYSCONGLOMERATES_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 88 del
> > < SYSCONGLOMERATES_INDEX3 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 89 del
> > < SYSCONSTRAINTS_INDEX1 |{ derby.storage.initialPages=1 ,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 90 del
> > < SYSCONSTRAINTS_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 91 del
> > < SYSCONSTRAINTS_INDEX3 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1 , derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 92 del
> > < SYSDEPENDS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0 ,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 93 del
> > < SYSDEPENDS_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096 , derby.storage.reusableRecordId=true }
> > 94 del
> > < SYSFILES_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 95 del
> > < SYSFILES_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 96 del
> > < SYSFOREIGNKEYS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > 97,115d80
> > < SYSFOREIGNKEYS_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSKEYS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSREQUIREDPERM_INDEX1 |{ derby.storage.initialPages=1 ,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSROUTINEPERMS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1 , derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSSCHEMAS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0 ,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSSCHEMAS_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096 , derby.storage.reusableRecordId=true }
> > < SYSSTATEMENTS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSSTATEMENTS_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSSTATISTICS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSTABLEPERMS_INDEX1 |{ derby.storage.initialPages=1 ,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSTABLES_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1 , derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSTABLES_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0 ,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSTRIGGERS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096 , derby.storage.reusableRecordId=true }
> > < SYSTRIGGERS_INDEX2 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSTRIGGERS_INDEX3 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < SYSVIEWS_INDEX1 |{ derby.storage.initialPages=1,
> derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0,
> derby.storage.pageSize=4096, derby.storage.reusableRecordId=true }
> > < ij> select TABLENAME, TABLETYPE from sys.systables order by tablename;
> > < TABLENAME |&
> > < -----
> > Test Failed.
> > *** End:   syscat jdk1.4.2 DerbyNet derbynetmats:derbynetmats 2006-02-10
> 01:38:36 ***
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
>   http://issues.apache.org/jira/secure/Administrators.jspa
> -
> For more information on JIRA, see:
>   http://www.atlassian.com/software/jira
>
>

Mime
View raw message