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 in...@oracle.com on 2016/05/03 08:40:43 UTC

[Java DB - testing] Failure continuous trunk (rev 1742057)

Java DB testing and reporting infrastructure.

Failure continuous trunk (rev 1742057)

There were 2 failures.


Re: [Java DB - testing] Failure continuous trunk (rev 1742057)

Posted by Knut Anders Hatlen <kn...@oracle.com>.
ingemar.aberg@oracle.com writes:

> Java DB testing and reporting infrastructure.
>
> Failure continuous trunk (rev 1742057)
>
> There were 2 failures.

The two failures were in derbyall. The test report is included below.
Both tests failed when attempting to rename a file. Looks very similar
to a failure that was previously reported as DERBY-1418 (closed as not
reproducible), so probably not a new problem with the latest commits.

Generating report for RunSuite derbyall  null null null true 
------------------ Java Information ------------------
Java Version:    1.8.0_92
Java Vendor:     Oracle Corporation
Java home:       c:\tendril4\work\install\sun-jdk-8u92-promoted-latest\jdk\jdk1.8.0_92\jre
Java classpath:  c:\tendril4\work\run\28718531\jars\sane\derbyTesting.jar;c:\tendril4\work\run\28718531\jars\sane\derbyrun.jar;c:\tendril4\work\run\28718531\tools\java\junit.jar;c:\tendril4\work\install\jakarta-oro-2.0.8\jakarta-oro-2.0.8.jar
OS name:         Windows 8.1
OS architecture: amd64
OS version:      6.3
Java user name:  jrockitqa
Java user home:  C:\Users\jrockitqa
Java user dir:   c:\tendril4\work\run\28718531\output
java.specification.name: Java Platform API Specification
java.specification.version: 1.8
java.runtime.version: 1.8.0_92-b14
--------- Derby Information --------
[C:\tendril4\work\run\28718531\jars\sane\derby.jar] 10.13.0.0 alpha - (1742057)
[C:\tendril4\work\run\28718531\jars\sane\derbytools.jar] 10.13.0.0 alpha - (1742057)
[C:\tendril4\work\run\28718531\jars\sane\derbynet.jar] 10.13.0.0 alpha - (1742057)
[C:\tendril4\work\run\28718531\jars\sane\derbyclient.jar] 10.13.0.0 alpha - (1742057)
[C:\tendril4\work\run\28718531\jars\sane\derbyoptionaltools.jar] 10.13.0.0 alpha - (1742057)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale :  [English/United States [en_US]]
Found support for locale: [cs]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [de_DE]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [es]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [fr]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [hu]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [it]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [ja_JP]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [ko_KR]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [pl]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [pt_BR]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [ru]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [zh_CN]
	 version: 10.13.0.0 alpha - (1742057)
Found support for locale: [zh_TW]
	 version: 10.13.0.0 alpha - (1742057)
------------------------------------------------------
org.apache.derbyTesting.*:
	 [C:\tendril4\work\run\28718531\jars\sane\derbyTesting.jar]
	 version: 10.13.0.0 alpha - (1742057)
------------------------------------------------------
Test environment information:
COMMAND LINE STYLE: jdk13
TEST CANONS: master
------------------------------------------------------
------------------------------------------------------
Summary results:

Test Run Started: 2016-05-03 05:26:08.0
Test Run Duration: 00:26:32

115 Tests Run
98% Pass (113 tests passed)
 2% Fail (2 tests failed)
0 Suites skipped
------------------------------------------------------
Failed tests in: derbyall_fail.txt
------------------------------------------------------
Passed tests in: derbyall_pass.txt
------------------------------------------------------
System properties in: derbyall_prop.txt
------------------------------------------------------
------------------------------------------------------
Failure Details:
********* Diff file derbyall/derbynetclientmats/DerbyNetClient/encodingTests/TestEnc.diff
*** Start: TestEnc jdk1.8.0_92 DerbyNetClient derbynetclientmats:encodingTests 2016-05-03 05:37:19 ***
derbyTesting.encoding can only be used with jdk15, skipping test
*** End:   TestEnc jdk1.8.0_92 DerbyNetClient derbynetclientmats:encodingTests 2016-05-03 05:37:19 ***
********* Diff file derbyall/encryptionAll/encryptionAll/encryptDatabaseTest3.diff
*** Start: encryptDatabaseTest3 jdk1.8.0_92 encryptionAll:encryptionAll 2016-05-03 05:38:38 ***
245 del
< 0 rows inserted/updated/deleted
245a245
> ERROR XSRS4: Error renaming file (during backup) from extinout\mybackup2\wombat to extinout\mybackup2\wombat.OLD.
255a256,274
> ij> -- reboot the db and disable the log archive mode
> connect 'jdbc:derby:wombat;encryptionKey=6162636465666768';
> ij(CONNECTION1)> select * from t1;
> A          
> -----------
> 1          
> 2          
> 3          
> 3 rows selected
> ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(1);
> 0 rows inserted/updated/deleted
> ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE('extinout/mybackup1');
> 0 rows inserted/updated/deleted
> ij(CONNECTION1)> disconnect;
> ij> connect 'jdbc:derby:wombat;shutdown=true';
> ERROR 08006: Database 'wombat' shutdown.
> ij> -- now re-encrypt the database, with the log archive mode disbaled.
> -- it should pass. 
> connect 'jdbc:derby:wombat;encryptionKey=6162636465666768;newEncryptionKey=5666768616263646';
257 del
< ERROR XBCXS: Cannot encrypt, re-encrypt or decrypt a database when it is in the log archive mode.
258 del
< ij> -- reboot the db and disable the log archive mode
259 del
< connect 'jdbc:derby:wombat;encryptionKey=6162636465666768';
259a276
> ERROR XBCXK: The given encryption key does not match the encryption key used when creating the database. Please ensure that you are using the correct encryption key and try again. 
260a278,288
> IJ ERROR: Unable to establish connection
> ij> select count(*) from emp;
> IJ ERROR: Unable to establish connection
> ij> disconnect;
> IJ ERROR: Unable to establish connection
> ij> connect 'jdbc:derby:wombat;shutdown=true';
> ERROR XJ004: Database 'wombat' not found.
> ij> -- Finally, decrypt the database with log archive mode disabled.
> -- It should pass.
> connect 'jdbc:derby:wombat;encryptionKey=5666768616263646;decryptDatabase=true';
> ij(CONNECTION1)> select * from t1;
267 del
< ij> call SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(1);
268 del
< 0 rows inserted/updated/deleted
269 del
< ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE('extinout/mybackup1');
270 del
< 0 rows inserted/updated/deleted
271 del
< ij> disconnect;
271a295,300
> ij(CONNECTION1)> select count(*) from emp;
> 1          
> -----------
> 3          
> 1 row selected
> ij(CONNECTION1)> disconnect;
274 del
< ij> -- now re-encrypt the database, with the log archive mode disbaled.
275 del
< -- it should pass. 
276 del
< connect 'jdbc:derby:wombat;encryptionKey=6162636465666768;newEncryptionKey=5666768616263646';
277 del
< ij> select * from t1;
278 del
< A          
279 del
< -----------
280 del
< 1          
281 del
< 2          
282 del
< 3          
283 del
< 3 rows selected
283a303,319
> ij> -- restore from backup and attempt to configure database for encryption.
> -- it shoud fail.
> connect 'jdbc:derby:wombat;restoreFrom=extinout/mybackup/wombat;dataEncryption=true;bootPassword=xyz1234abc';
> ERROR XJ081: Conflicting create/restore/recovery attributes specified.
> ij> -- creating database from backup and attempting to configure database for encryption.
> -- it shoud fail.
> connect 'jdbc:derby:wombat_new;createFrom=extinout/mybackup/wombat;dataEncryption=true;bootPassword=xyz1234abc';
> ERROR XJ081: Conflicting create/restore/recovery attributes specified.
> ij> -- restore from backup and attempt to reEncrypt
> -- it should fail.
> connect 'jdbc:derby:wombat;restoreFrom=extinout/mybackup1/wombat;encryptionKey=6162636465666768;newEncryptionKey=5666768616263646';
> ERROR XJ081: Conflicting create/restore/recovery attributes specified.
> ij> -- restore from backup without re-encryption
> -- it shoud boot. 
> connect 'jdbc:derby:wombat;restoreFrom=extinout/mybackup1/wombat;encryptionKey=6162636465666768';
> ERROR XJ040: Failed to start database 'wombat' with class loader XXXX,  see the next exception for details.
> ERROR XBCXK: The given encryption key does not match the encryption key used when creating the database. Please ensure that you are using the correct encryption key and try again. 
285 del
< 1          
286 del
< -----------
287 del
< 3          
288 del
< 1 row selected
288a321
> IJ ERROR: Unable to establish connection
289a323
> IJ ERROR: Unable to establish connection
291 del
< ERROR 08006: Database 'wombat' shutdown.
292 del
< ij> -- Finally, decrypt the database with log archive mode disabled.
293 del
< -- It should pass.
294 del
< connect 'jdbc:derby:wombat;encryptionKey=5666768616263646;decryptDatabase=true';
295 del
< ij> select * from t1;
296 del
< A          
297 del
< -----------
298 del
< 1          
299 del
< 2          
300 del
< 3          
301 del
< 3 rows selected
302 del
< ij> select count(*) from emp;
303 del
< 1          
304 del
< -----------
305 del
< 3          
306 del
< 1 row selected
307 del
< ij> disconnect;
308 del
< ij> connect 'jdbc:derby:wombat;shutdown=true';
309 del
< ERROR 08006: Database 'wombat' shutdown.
310 del
< ij> -- restore from backup and attempt to configure database for encryption.
311 del
< -- it shoud fail.
312 del
< connect 'jdbc:derby:wombat;restoreFrom=extinout/mybackup/wombat;dataEncryption=true;bootPassword=xyz1234abc';
313 del
< ERROR XJ081: Conflicting create/restore/recovery attributes specified.
314 del
< ij> -- creating database from backup and attempting to configure database for encryption.
315 del
< -- it shoud fail.
316 del
< connect 'jdbc:derby:wombat_new;createFrom=extinout/mybackup/wombat;dataEncryption=true;bootPassword=xyz1234abc';
317 del
< ERROR XJ081: Conflicting create/restore/recovery attributes specified.
318 del
< ij> -- restore from backup and attempt to reEncrypt
319 del
< -- it should fail.
320 del
< connect 'jdbc:derby:wombat;restoreFrom=extinout/mybackup1/wombat;encryptionKey=6162636465666768;newEncryptionKey=5666768616263646';
321 del
< ERROR XJ081: Conflicting create/restore/recovery attributes specified.
322 del
< ij> -- restore from backup without re-encryption
323 del
< -- it shoud boot. 
324 del
< connect 'jdbc:derby:wombat;restoreFrom=extinout/mybackup1/wombat;encryptionKey=6162636465666768';
325 del
< ij> select count(*) from emp;
326 del
< 1          
327 del
< -----------
328 del
< 3          
329 del
< 1 row selected
330 del
< ij> disconnect;
331 del
< ij> connect 'jdbc:derby:wombat;shutdown=true';
332 del
< ERROR 08006: Database 'wombat' shutdown.
332a325
> ERROR XJ004: Database 'wombat' not found.
Test Failed.
*** End:   encryptDatabaseTest3 jdk1.8.0_92 encryptionAll:encryptionAll 2016-05-03 05:38:51 ***
********* Diff file derbyall/storeall/storemore/rollForwardBackup.diff
*** Start: rollForwardBackup jdk1.8.0_92 storeall:storemore 2016-05-03 05:29:27 ***
683 del
< 0 rows inserted/updated/deleted
683a683
> ERROR XSRS4: Error renaming file (during backup) from extinout\mybackup\wombat to extinout\mybackup\wombat.OLD.
732,734d731
< 42         
< 43         
< 44         
783,785d779
< 42         
< 43         
< 44         
Test Failed.
*** End:   rollForwardBackup jdk1.8.0_92 storeall:storemore 2016-05-03 05:29:43 ***
------------------------------------------------------