[#DERBY-1693] Out of Memory Error with derby.language.logStatementText=true

Derby

Out of Memory Error with derby.language.logStatementText=true

Created: 14/Aug/06 11:27 PM Updated: 19/Oct/07 04:11 PM

Return to search

Component/s:

SQL

Affects Version/s:

10.2.1.6, 10.3.1.4

Fix Version/s:

10.1.3.2, 10.2.2.0, 10.3.1.4

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
derby-1693-1a.diff	2006-10-31 11:54 AM	Kristian Waagan	4 kB
derby-1693-1a.stat	2006-10-24 01:08 PM	Kristian Waagan	0.6 kB
ReproDerby1693.class	2006-10-24 01:08 PM	Kristian Waagan	2 kB
ReproDerby1693.java	2006-10-24 09:53 AM	Kristian Waagan	2 kB

Environment:

« Hide

JVM INFO :
java version "1.5.0_02"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_02-b09)
Java HotSpot(TM) Client VM (build 1.5.0_02-b09, mixed mode)

OS : Windows XP Professional

Issue Links:

Duplicate

This issue duplicates:

~~DERBY-598~~ Ensure that with derby.language.logStatementText.true, values set by streams are not materialized

Urgency:	Normal
Resolution Date:	16/Nov/06 05:08 PM

Description

« Hide

While running a test with blobs and clobs of random size but not exceeding more than 5MB , with derby.language.logStatementText=true , The inserts are faling with out of memory error. Once that error occurs then the test loses all connections to the database. If I take off the derby.language.logStatementText=true property from derby.properties, the test runs fine. Here is the stack Trace

java.lang.OutOfMemoryError: Java heap space

---SQLException Caught---

SQLState: XJ001
Severity: 0
Message: Java exception: 'Java heap space: java.lang.OutOfMemoryError'.
java.lang.OutOfMemoryError: Java heap space
java.sql.SQLException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExc
eptionFactory.java:45)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:89)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:105)
        at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Util.java:209)
        at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(EmbedConnect
ion.java:1351)
        at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(EmbedCon
nection.java:1529)
        at org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.j
ava:946)
        at com.ibm.db2j.tests.scenario.utils.DbTasks.insertMail(DbTasks.java:400
)
        at com.ibm.db2j.tests.scenario.tasks.Refresh.insertMail(Refresh.java:62)
        at com.ibm.db2j.tests.scenario.tasks.Refresh.doWork(Refresh.java:43)
        at com.ibm.db2j.tests.scenario.tasks.Refresh.run(Refresh.java:21)

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Repository	Revision	Date	User	Message
ASF	#475817	Thu Nov 16 17:06:34 UTC 2006	kristwaa	~~DERBY-1693~~: Log a token in derby.log for LOBs instead of the actual content when derby.language.logStatementText=true (token: "NULL\|[BC]LOB(<length>\|<stream class>)")
				Files Changed
				MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLBlob.java MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataType.java MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLClob.java MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/DataValueDescriptor.java MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/GenericParameter.java

Repository	Revision	Date	User	Message
ASF	#477699	Tue Nov 21 15:39:31 UTC 2006	kristwaa	~~DERBY-1693~~: Merged changes by '~~DERBY-1693~~-1a.diff' from trunk (r475817).
				Files Changed
				MODIFY /db/derby/code/branches/10.2/java/engine/org/apache/derby/iapi/types/SQLBlob.java MODIFY /db/derby/code/branches/10.2/java/engine/org/apache/derby/iapi/types/SQLClob.java MODIFY /db/derby/code/branches/10.2/java/engine/org/apache/derby/impl/sql/GenericParameter.java MODIFY /db/derby/code/branches/10.2/java/engine/org/apache/derby/iapi/types/DataValueDescriptor.java MODIFY /db/derby/code/branches/10.2/java/engine/org/apache/derby/iapi/types/DataType.java

Repository	Revision	Date	User	Message
ASF	#586506	Fri Oct 19 15:43:14 UTC 2007	kmarsden	~~DERBY-1693~~ Out of Memory Error with derby.language.logStatementText=true merge from trunk
				Files Changed
				MODIFY /db/derby/code/branches/10.1/java/engine/org/apache/derby/iapi/types/SQLBlob.java MODIFY /db/derby/code/branches/10.1/java/engine/org/apache/derby/iapi/types/SQLClob.java MODIFY /db/derby/code/branches/10.1/java/engine/org/apache/derby/iapi/types/DataValueDescriptor.java MODIFY /db/derby/code/branches/10.1/java/engine/org/apache/derby/iapi/types/DataType.java