Hi,
while running the largeData suite I found that the test largeCodeGen is
failing with derbyclient. The same test passed with Embedded. Any info
regarding this is greately appreciated.
FAILED QUERY: SELECT with 10000 unions.
Exception in thread "main" java.sql.SQLException: An internal error was
identified by RawStore module.
Caused by: org.apache.derby.client.am.SqlException: An internal error
was identified by RawStore module.
The derby.log says
2006-02-18 02:18:21.015 GMT Thread[DRDAConnThread_3,5,main] (XID = 120),
(SESSIONID = 0), (DATABASE = wombat), (DRDAID =
NF000001.H26A-666250129645088143{2}), Failed Statement is: select * from
t0 UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM
v0) UNION ALL (SELECT * FROM v0) UNION ALL (SELECT * FROM v0) UNION ALL
(SELECT * FROM v0) UNION ALL (SELECT * FROM v0)
java.lang.OutOfMemoryError: Java heap space
Is it the same as DERBY-216? and just need a master update?
The test ran on a windows 2000 machine(1.5GB) with jdk15
Thanks
Manjula
