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 "Myrna van Lunteren (JIRA)" <de...@db.apache.org> on 2006/02/10 23:55:56 UTC
[jira] Commented: (DERBY-943) nightly test regression in sycat test
only on ibm142 jvm
[ 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.FilePermission E:\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
Re: [jira] Commented: (DERBY-943) nightly test regression in sycat test only on ibm142 jvm
Posted by Myrna van Lunteren <m....@gmail.com>.
On 2/11/06, Daniel John Debrunner <dj...@apache.org> wrote:
>
>
> >
> > Well, that was one of the things that first puzzled me - Mike reported
> > this with DerbyNet, and none of the DerbyNet tests actually run with
> > security manager.
> > However, the network server seems to *always* start with security
> > manager, even when the actual test has security manager switched off.
> > I'll have a look at that also.
>
> That's correct. The network server when started separately always runs
> under the security manager. The noSecurityManager flag only applies to
> the JVM running the test, the "client" jvm, as in "JDBC client",
> embedded or network. That was the original setup, when only the network
> server started separately was run under the security manager. Since all
> the tests passed in that mode it seemed to me like that model should
> continue.
>
> > (pf).
> > In the mean time, would it be acceptable to add the permissions so the
> > nightlies pass on?
>
> Yes, as long as it is commented with DERBY-616 bug number so that when
> the bug is fixed the policy file will get cleaned up. You will also need
> to comment DERBY-616 that the permissions you add will need be removed
> (I think) in order to see the issue. Currently just by removing the
> noSecurityManager=true property in the test's _app.properties file (eg.
> for access.sql) the tests will fail. Adding these properties will make
> the tests pass with a security manager and we just don't want someone to
> think that the bug was already fixed.
>
> Dan.
>
>
I put a comment in with DERBY-616, referring to this discussion.
I linked DERBY-943 to DERBY-616.
I modified derby_tests.policy and put a comment above the new permissions
indicating it is for DERBY-616/DERBY-943. I hope the comment is clear...
I added a patch with the modification to derby_tests.policy to DERBY-943,
but I couldn't find the 'patch available' checkbox...
Myrna
Re: [jira] Commented: (DERBY-943) nightly test regression in sycat
test only on ibm142 jvm
Posted by Daniel John Debrunner <dj...@apache.org>.
>
> Well, that was one of the things that first puzzled me - Mike reported
> this with DerbyNet, and none of the DerbyNet tests actually run with
> security manager.
> However, the network server seems to *always* start with security
> manager, even when the actual test has security manager switched off.
> I'll have a look at that also.
That's correct. The network server when started separately always runs
under the security manager. The noSecurityManager flag only applies to
the JVM running the test, the "client" jvm, as in "JDBC client",
embedded or network. That was the original setup, when only the network
server started separately was run under the security manager. Since all
the tests passed in that mode it seemed to me like that model should
continue.
> (pf).
> In the mean time, would it be acceptable to add the permissions so the
> nightlies pass on?
Yes, as long as it is commented with DERBY-616 bug number so that when
the bug is fixed the policy file will get cleaned up. You will also need
to comment DERBY-616 that the permissions you add will need be removed
(I think) in order to see the issue. Currently just by removing the
noSecurityManager=true property in the test's _app.properties file (eg.
for access.sql) the tests will fail. Adding these properties will make
the tests pass with a security manager and we just don't want someone to
think that the bug was already fixed.
Dan.
Re: [jira] Commented: (DERBY-943) nightly test regression in sycat test only on ibm142 jvm
Posted by Myrna van Lunteren <m....@gmail.com>.
On 2/11/06, Daniel John Debrunner <dj...@apache.org> wrote:
> Myrna van Lunteren wrote:
>
> > 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...
>
> I think you are correct here, it looks like 616. Since this is most
> likely an ORDER BY spilling to disk, it is environment dependent when
> that occurs. It's probably that this test is on the border line for
> spilling the sort to disk and only ibm142 crosses it.
>
> I would just disable this test from running with the security manager
> and mark it as due to DERBY-616.
>
> Dan.
>
>
>
Well, that was one of the things that first puzzled me - Mike reported this
with DerbyNet, and none of the DerbyNet tests actually run with security
manager.
However, the network server seems to *always* start with security manager,
even when the actual test has security manager switched off. I'll have a
look at that also.
(pf).
In the mean time, would it be acceptable to add the permissions so the
nightlies pass on?
Thx,
Myrna
Re: [jira] Commented: (DERBY-943) nightly test regression in sycat
test only on ibm142 jvm
Posted by Daniel John Debrunner <dj...@apache.org>.
Myrna van Lunteren wrote:
> 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...
I think you are correct here, it looks like 616. Since this is most
likely an ORDER BY spilling to disk, it is environment dependent when
that occurs. It's probably that this test is on the border line for
spilling the sort to disk and only ibm142 crosses it.
I would just disable this test from running with the security manager
and mark it as due to DERBY-616.
Dan.
Re: [jira] Commented: (DERBY-943) nightly test regression in sycat test only on ibm142 jvm
Posted by Myrna van Lunteren <m....@gmail.com>.
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) <de...@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
>
>