Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Error 38000 with a stack overflow on recordset.next()?
Date: Thu, 20 Oct 2005 11:54:21 -0400
Message-ID: <411004C89F48004A9B41C341A515E7BA01530B91@mail.oit.docfinity.com>
Thread-Topic: Error 38000 with a stack overflow on recordset.next()?
Thread-Index: AcXVEMp8Qj+8IsFkS8ind3PCphBrZQAfSw8w
From: "Daniel Skiles" <dskiles@docfinity.com>
To: "Derby Discussion" <derby-user@db.apache.org>

>>Lastly, if you were to perform one test with the logStatementText TRUE
>>   =20
>>
>
> =20
>
>>('derby.language.logStatementText=3Dtrue') then post the derby.log we
>>would know what SQL statement Derby was chewing on when this problem=20
>>happens (the derby.log will get large so I would unset it after the
>>   =20
>>
>test).

Thanks for the help with that bit.  Here is a snippet of that output.  I
can't include the whole thing, because the log is very large.  Let me
know if you need more before this.

2005-10-20 15:49:03.057 GMT Thread[main,5,main] (XID =3D 12392),
(SESSIONID =3D 0), (DATABASE =3D local), (DRDAID =3D null), Executing =
prepared
statement: INSERT INTO filesystemfiles (path) VALUES (?) :End prepared
statement with 1 parameters begin parameter #1:
u:\mss2k_incon\20050601.000\iefcimd-f1c\pdf_9\1799.pdf :end parameter=20
2005-10-20 15:49:03.057 GMT Thread[main,5,main] (XID =3D 12392),
(SESSIONID =3D 0), (DATABASE =3D local), (DRDAID =3D null), Committing
2005-10-20 15:49:03.057 GMT Thread[main,5,main] (XID =3D 12393),
(SESSIONID =3D 0), (DATABASE =3D local), (DRDAID =3D null), Begin =
compiling
prepared statement: SELECT path from filesystemfiles where path not in
(select path from existingfiles) :End prepared statement
2005-10-20 15:49:03.120 GMT Thread[main,5,main] (XID =3D 12393),
(SESSIONID =3D 0), (DATABASE =3D local), (DRDAID =3D null), End =
compiling
prepared statement: SELECT path from filesystemfiles where path not in
(select path from existingfiles) :End prepared statement
2005-10-20 15:49:03.135 GMT Thread[main,5,main] (XID =3D 12393),
(SESSIONID =3D 0), (DATABASE =3D local), (DRDAID =3D null), Executing =
prepared
statement: SELECT path from filesystemfiles where path not in (select
path from existingfiles) :End prepared statement
2005-10-20 15:49:03.448 GMT Thread[main,5,main] (XID =3D 12393),
(SESSIONID =3D 0), (DATABASE =3D local), (DRDAID =3D null), Cleanup =
action
starting
2005-10-20 15:49:03.448 GMT Thread[main,5,main] (XID =3D 12393),
(SESSIONID =3D 0), (DATABASE =3D local), (DRDAID =3D null), Failed =
Statement
is: SELECT path from filesystemfiles where path not in (select path from
existingfiles)
ERROR 38000: The exception 'java.lang.StackOverflowError' was thrown
while evaluating an expression.
	at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
	at
org.apache.derby.iapi.error.StandardException.unexpectedUserException(Un
known Source)
	at
org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
	at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCor
e(Unknown Source)
	at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unk
nown Source)
	at
org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown
Source)
	at
com.docfinity.orphantracker.CommandLineLocal.main(CommandLineLocal.java:
160)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin nested exception, level =
(1) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
java.lang.StackOverflowError
	at
org.apache.derby.impl.sql.execute.UnionResultSet.openCore(Unknown
Source)

etc...