db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1058) derby fails supporting holdable scrollable resultset: ERROR XSCB8: The btree conglomerate 1,141,037,436,752 is closed.
Date Mon, 20 Mar 2006 04:33:00 GMT
    [ 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:
> ak136785@khepri35:/<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)
> ak136785@khepri35:/<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


Mime
View raw message