[
http://issues.apache.org/jira/browse/DERBY-1058?page=comments#action_12371029 ]
Myrna van Lunteren commented on DERBY-1058:
-------------------------------------------
In re DERBY-993 I ran this test, and it failed for me, so I applied the patch.
And indeed, now the test passes with netclientmats and embedded. However,
(after fixing up TestUtil.getConnection to pass in the user name 'APP') I now
got the following for derbynet:
...E.E.E.E.........
Time: 41.59
There were 4 errors:
1)
testHeldForwardOnlyUpdatableResultSetScanInit(org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest)com.ibm.db2.jcc.c.SqlException:
Encountered "(" at line 1, column 19 <snip unreadable character> 42X01
at com.ibm.db2.jcc.c.zc.e(zc.java:1606)
at com.ibm.db2.jcc.a.eb.p(eb.java:634)
at com.ibm.db2.jcc.a.eb.h(eb.java:152)
at com.ibm.db2.jcc.a.eb.a(eb.java:43)
at com.ibm.db2.jcc.a.r.a(r.java:30)
at com.ibm.db2.jcc.a.tb.g(tb.java:152)
at com.ibm.db2.jcc.c.zc.n(zc.java:1186)
at com.ibm.db2.jcc.c.ad.db(ad.java:1761)
at com.ibm.db2.jcc.c.ad.ib(ad.java:1880)
at com.ibm.db2.jcc.c.o.a(o.java:888)
at com.ibm.db2.jcc.c.rc.ib(rc.java:3335)
at com.ibm.db2.jcc.c.rc.B(rc.java:2469)
at com.ibm.db2.jcc.c.rc.updateRow(rc.java:2446)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.SURBaseTest.updateTuple(SURBaseTest.java:119)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest.testHeldForwardOnlyUpdatableResultSetScanInit(HoldabilityTest.java:121)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2)
testCompressOnHeldForwardOnlyUpdatableResultSetScanInProgress(org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest)com.ibm.db2.jcc.c.SqlException:
Encountered "(" at line 1, column 19 <snip> 42X01
....(ditto jcc stack)...
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.SURBaseTest.updateTuple(SURBaseTest.java:119)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest.testCompressOnHeldForwardOnlyUpdatableResultSetScanInProgress(HoldabilityTest.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
3)
testCompressOnHeldForwardOnlyUpdatableResultSetScanInit(org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest)com.ibm.db2.jcc.c.SqlException:
Encountered "(" at line 1, column 19 <snip...> 42X01
<ditto jcc stack>
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.SURBaseTest.updateTuple(SURBaseTest.java:119)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest.verifyResultSetUpdatableAfterCompress(HoldabilityTest.java:424)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest.testCompressOnHeldForwardOnlyUpdatableResultSetScanInit(HoldabilityTest.java:164)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
4)
testHeldForwardOnlyUpdatableResultSetScanInProgress(org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest)com.ibm.db2.jcc.c.SqlException:
Encountered "(" at line 1, column 19 <snip> 42X01
..<ditto jcc stack>...
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.SURBaseTest.updateTuple(SURBaseTest.java:119)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest.testHeldForwardOnlyUpdatableResultSetScanInProgress(HoldabilityTest.java:182)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
FAILURES!!!
Tests run: 15, Failures: 0, Errors: 4
-------------------------------------
and from derby.log:
-------------------------------------
2006-03-20 02:59:27.666 GMT Thread[DRDAConnThread_4,5,main] (XID = 394),
(SESSIONID = 6), (DATABASE = wombat), (DRDAID =
NF000001.GC01-1085084892396012877{8}), Failed Statement is: UPDATE APP.T1 SET
(ID,A,B,C) = (?,?,?,?) WHERE CURRENT OF SQL_CURSH300C2
ERROR 42X01: Syntax error: Encountered "(" at line 1, column 19.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:311)
at
org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.java:154)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:310)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:725)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:122)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:62)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:92)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:710)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:607)
at
org.apache.derby.impl.drda.DRDAStatement.prepareStatementJDBC3(DRDAStatement.java:1557)
at
org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:525)
at
org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:487)
at
org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3196)
at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:695)
at
org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:236)
----------------------------------
> derby fails supporting holdable scrollable resultset: ERROR XSCB8: The btree
> conglomerate 1,141,037,436,752 is closed.
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1058
> URL: http://issues.apache.org/jira/browse/DERBY-1058
> Project: Derby
> Type: Bug
> Components: SQL, Store
> Versions: 10.1.2.1
> Environment: All
> Reporter: Andreas Korneliussen
> Assignee: Andreas Korneliussen
> Attachments: DERBY-1058.diff, DERBY-1058.stat, DERBY-1058v2.diff,
> DERBY-1058v2.stat, HoldabilityIssue.java, derbyall_report.txt
>
> If the ResultSet is so big that the scrollable resultset needs to back the
> hashtable to disk, and the resultset is not fully populated before a commit(),
> a call to next() will fail with:
> [EMAIL PROTECTED]:/<3>db-derby-10.1.2.1-bin/lib> java -cp
> /home/ak136785/devel/derbytesting/derbytest/build/classes/:./derby.jar
> derbytest.HoldabilityIssue
> ERROR XSCB8: The btree conglomerate 1,141,037,436,752 is closed.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown
> Source)
> at org.apache.derby.iapi.store.access.DiskHashtable.put(Unknown
> Source)
> at
> org.apache.derby.iapi.store.access.BackingStoreHashtable.spillToDisk(Unknown
> Source)
> at
> org.apache.derby.iapi.store.access.BackingStoreHashtable.add_row_to_hash_table(Unknown
> Source)
> at
> org.apache.derby.iapi.store.access.BackingStoreHashtable.put(Unknown Source)
> at
> org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.addRowToHashTable(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.getNextRowFromSource(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.getNextRowCore(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> at derbytest.HoldabilityIssue.runTest1(HoldabilityIssue.java:72)
> at derbytest.HoldabilityIssue.main(HoldabilityIssue.java:91)
> [EMAIL PROTECTED]:/<3>db-derby-10.1.2.1-bin/lib>
> The BtreeController is always initialized as non-holdable, and if this is
> changed, Derby has the following assert in closeForEndTransaction(..):
> SanityManager.THROWASSERT("There is currently no requirement for a held
> btree conglomerate controller.");
> A simple test program is attached which reproduces this failure. It fails in
> the trunk and on the 10.1.2.1 release
--
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
