Hi
I was running the derbyall tests on an AIX machine with ibm142 jvm and
found the blobclob4BLOB.java still failing with JCC 2.6 (90). The diff
I got is different from the one described in DERBY-1691. But from the
derby.log I could sense some similarity. Can anyone please have a look
into it and let me know whether I have to re-open DERBY-1691.
Diff:
*** Start: blobclob4BLOB jdk1.4.2 DerbyNet derbynetmats:jdbcapi
2006-09-27 17:23
:53 ***
475a476,478
> at java.lang.String.substring(String.java(Compiled Code))
> at com.ibm.db2.jcc.a.ec.a(ec.java(Compiled Code))
> at com.ibm.db2.jcc.a.ec.getSubString(ec.java(Compiled Code))
783a787,788
> at com.ibm.db2.jcc.a.dc.a(dc.java(Compiled Code))
> at com.ibm.db2.jcc.a.dc.getBytes(dc.java(Compiled Code))
789a795,804
> at com.ibm.db2.jcc.a.jd.e(jd.java(Compiled Code))
> at com.ibm.db2.jcc.a.jd.b(jd.java(Compiled Code))
> at com.ibm.db2.jcc.b.fb.i(fb.java(Compiled Code))
> at com.ibm.db2.jcc.b.fb.b(fb.java(Compiled Code))
> at com.ibm.db2.jcc.b.s.b(s.java(Inlined Compiled Code))
> at com.ibm.db2.jcc.b.wb.f(wb.java(Compiled Code))
> at com.ibm.db2.jcc.a.jd.m(jd.java(Inlined Compiled Code))
> at com.ibm.db2.jcc.a.jd.a(jd.java(Compiled Code))
> at com.ibm.db2.jcc.a.jd.c(jd.java(Compiled Code))
> at com.ibm.db2.jcc.a.jd.executeUpdate(jd.java(Compiled Code))
Test Failed.
*** End: blobclob4BLOB jdk1.4.2 DerbyNet derbynetmats:jdbcapi
2006-09-27 17:27
Sysinfo:
$ java org.apache.derby.tools.sysinfo
------------------ Java Information ------------------
Java Version: 1.4.2
Java Vendor: IBM Corporation
Java home: /local1/mkutty/ibm142/jre
Java classpath:
/local1/mkutty/10.2/pantry/db2jcc.jar:/local1/mkutty/10.2/pantr
y/db2jcc_license_c.jar:/local1/mkutty/10.2/pantry/derby.jar:/local1/mkutty/10.2/
pantry/derbyclient.jar:/local1/mkutty/10.2/pantry/derbyLocale_de_DE.jar:/local1/
mkutty/10.2/pantry/derbyLocale_es.jar:/local1/mkutty/10.2/pantry/derbyLocale_fr.
jar:/local1/mkutty/10.2/pantry/derbyLocale_it.jar:/local1/mkutty/10.2/pantry/der
byLocale_ja_JP.jar:/local1/mkutty/10.2/pantry/derbyLocale_ko_KR.jar:/local1/mkut
ty/10.2/pantry/derbyLocale_pt_BR.jar:/local1/mkutty/10.2/pantry/derbyLocale_zh_C
N.jar:/local1/mkutty/10.2/pantry/derbyLocale_zh_TW.jar:/local1/mkutty/10.2/pantr
y/derbynet.jar:/local1/mkutty/10.2/pantry/derbyTesting.jar:/local1/mkutty/10.2/p
antry/derbytools.jar:/local1/mkutty/10.2/pantry/functionTests.jar:/local1/mkutty
/10.2/pantry/maps.jar:/local1/mkutty/10.2/pantry/tours.jar:.:/local1/mkutty/10.2
/pantry/junit.jar:/local1/mkutty/10.2/pantry/jakarta-oro-2.0.8.jar
OS name: AIX
OS architecture: ppc
OS version: 5.2
Java user name: mkutty
Java user home: /u/mkutty
Java user dir: /local1/mkutty/10.2/ibm142_beta5/rerun
java.specification.name: Java Platform API Specification
java.specification.version: 1.4
--------- Derby Information --------
JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
[/local1/mkutty/10.2/pantry/derby.jar] 10.2.1.5 - (449431)
[/local1/mkutty/10.2/pantry/derbytools.jar] 10.2.1.5 - (449431)
[/local1/mkutty/10.2/pantry/derbynet.jar] 10.2.1.5 - (449431)
[/local1/mkutty/10.2/pantry/derbyclient.jar] 10.2.1.5 - (449431)
[/local1/mkutty/10.2/pantry/db2jcc.jar] 2.6 - (90)
[/local1/mkutty/10.2/pantry/db2jcc_license_c.jar] 2.6 - (90)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [de_DE]
version: 10.2.1.5 - (449431)
Found support for locale: [es]
version: 10.2.1.5 - (449431)
Found support for locale: [fr]
version: 10.2.1.5 - (449431)
Found support for locale: [it]
version: 10.2.1.5 - (449431)
Found support for locale: [ja_JP]
version: 10.2.1.5 - (449431)
Found support for locale: [ko_KR]
version: 10.2.1.5 - (449431)
Found support for locale: [pt_BR]
version: 10.2.1.5 - (449431)
Found support for locale: [zh_CN]
version: 10.2.1.5 - (449431)
Found support for locale: [zh_TW]
version: 10.2.1.5 - (449431)
------------------------------------------------------
Apache Derby Network Server - 10.2.1.5 - (449431) started and ready to accept co
nnections on port 1527 at 2006-09-28 00:24:26.615 GMT
----------------------------------------------------------------
2006-09-28 00:24:37.606 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.2.1.5
- (449431): instance c013800d-010d-f1ce-d1c9-ffffd36a6fd4
on database directory /local1/mkutty/10.2/ibm142_beta5/derbyall/derbynetmats/Der
byNet/jdbcapi/blobclob4BLOB/wombat
Database Class Loader started - derby.database.classpath=''
2006-09-28 00:26:32.640 GMT Thread[DRDAConnThread_4,5,main] (XID = 2362), (SESSI
ONID = 1), (DATABASE = wombat), (DRDAID = NF000001.A346-795447124781126847{3}),
Cleanup action starting
2006-09-28 00:26:32.661 GMT Thread[DRDAConnThread_4,5,main] (XID = 2362), (SESSI
ONID = 1), (DATABASE = wombat), (DRDAID = NF000001.A346-795447124781126847{3}),
Failed Statement is: update testCLOB_MAIN set b = b + 1 where b = 10000
ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(Unknown So
urce)
at org.apache.derby.impl.services.locks.LockSet.lockObject(Unknown Sourc
e)
at org.apache.derby.impl.services.locks.SinglePool.lockAnObject(Unknown
Source)
at org.apache.derby.impl.services.locks.SinglePool.lockObject(Unknown So
urce)
at org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(U
nknown Source)
at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lock
PositionForWrite(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateCo
ntroller.replace(Unknown Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown So
urce)
at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows
(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source
)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown So
urce)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown So
urce)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Sourc
e)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(Unknown Sour
ce)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
rce)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Cleanup action completed
2006-09-28 00:27:05.722 GMT Thread[DRDAConnThread_6,5,main] (XID = 2697), (SESSI
ONID = 3), (DATABASE = wombat), (DRDAID = NF000001.A34A-810365298546781843{5}),
Cleanup action starting
2006-09-28 00:27:05.722 GMT Thread[DRDAConnThread_6,5,main] (XID = 2697), (SESSI
ONID = 3), (DATABASE = wombat), (DRDAID = NF000001.A34A-810365298546781843{5}),
Failed Statement is: create trigger T8A after update on testBlob referencing new
as n old as o for each row mode db2sql insert into blobTest8TriggerA(a, b, crc3
2) values (n.a, n.b, n.crc32)
ERROR X0X95: Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB'
because there is an open ResultSet dependent on that object.
at org.apache.derby.iapi.error.StandardException.newException(Unknown So
urce)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.verif
yNoOpenResultSets(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.prepareToInvalidat
e(Unknown Source)
at org.apache.derby.impl.sql.depend.BasicDependencyManager.coreInvalidat
eFor(Unknown Source)
at org.apache.derby.impl.sql.depend.BasicDependencyManager.invalidateFor
(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateTriggerConstantAction.execute
ConstantAction(Unknown Source)
at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown So
urce)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown So
urce)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Sourc
e)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(Unknown Sour
ce)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
rce)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Cleanup action completed
2006-09-28 00:27:15.480 GMT Thread[DRDAConnThread_3,5,main] (XID = 2971), (SESSI
ONID = 7), (DATABASE = wombat), (DRDAID = NF000001.A355-723671005719864254{9}),
Cleanup action starting
2006-09-28 00:27:15.480 GMT Thread[DRDAConnThread_3,5,main] (XID = 2971), (SESSI
ONID = 7), (DATABASE = wombat), (DRDAID = NF000001.A355-723671005719864254{9}),
Failed Statement is: null
ERROR XJ073: The data in this BLOB or CLOB is no longer available. The BLOB/CLO
B's transaction may be committed, or its connection is closed.
at org.apache.derby.iapi.error.StandardException.newException(Unknown So
urce)
at org.apache.derby.impl.jdbc.EmbedClob.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getClob(Unknown Source)
at org.apache.derby.impl.drda.EXTDTAInputStream.initInputStream(Unknown
Source)
at org.apache.derby.impl.drda.EXTDTAInputStream.<init>(Unknown Source)
at org.apache.derby.impl.drda.EXTDTAInputStream.getEXTDTAStream(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
rce)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Cleanup action completed
2006-09-28 00:27:16.676 GMT Thread[DRDAConnThread_3,5,main] (XID = 3207), (SESSI
ONID = 7), (DATABASE = wombat), (DRDAID = NF000001.A355-723671005719864254{9}),
Cleanup action starting
2006-09-28 00:27:16.676 GMT Thread[DRDAConnThread_3,5,main] (XID = 3207), (SESSI
ONID = 7), (DATABASE = wombat), (DRDAID = NF000001.A355-723671005719864254{9}),
Failed Statement is: null
ERROR XJ073: The data in this BLOB or CLOB is no longer available. The BLOB/CLO
B's transaction may be committed, or its connection is closed.
at org.apache.derby.iapi.error.StandardException.newException(Unknown So
urce)
at org.apache.derby.impl.jdbc.EmbedBlob.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getBlob(Unknown Source)
at org.apache.derby.impl.drda.EXTDTAInputStream.initInputStream(Unknown
Source)
at org.apache.derby.impl.drda.EXTDTAInputStream.<init>(Unknown Source)
at org.apache.derby.impl.drda.EXTDTAInputStream.getEXTDTAStream(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
rce)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Cleanup action completed
2006-09-28 00:27:34.114 GMT:
Shutting down instance c013800d-010d-f1ce-d1c9-ffffd36a6fd4
----------------------------------------------------------------
