[DERBY-943] nightly test regression in sycat test only on ibm142 jvm

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 10.0.2.0
• Fix Version/s: 10.2.1.6
• Component/s: Test

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)

• Bug behavior facts: Regression Test Failure
• Assignee: Myrna van Lunteren
• Reporter: Mike Matrigali
• Created: 11/Feb/06 05:51
• Updated: 29/Jun/09 22:58
• Resolved: 14/Feb/06 10:09

Description

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 ***

Issue Links

• is related to: DERBY-616 create index can fail under the SecurityManager when trying to access files in the tmp folder of a database