[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-30 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12431510 ] Knut Anders Hatlen commented on DERBY-418: -- Derbyall ran cleanly. However, when running the repro for DERBY-1142 (without rs.close()), I noticed that

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-29 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12431148 ] Knut Anders Hatlen commented on DERBY-418: -- Thanks Mayuresh. I think the patch looks good. If there are no more comments, I will run some tests and commit

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-25 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12430512 ] Daniel John Debrunner commented on DERBY-418: - I think your loop that closes activations needs to include similar logic to htis, from cleanupOnError

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-25 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12430517 ] Knut Anders Hatlen commented on DERBY-418: -- Thank you for addressing my comments, Mayuresh! I think you misunderstood what I meant with the indentation

Re: [jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-23 Thread Knut Anders Hatlen
Mayuresh Nirhali [EMAIL PROTECTED] writes: Hi Knut, Thanks for the review and trying out my changes. Could you tell me with what memory size did you run the repros ?? I see the OOME for -Xmx16m and do not see it for 64m. You're right. I used 64 MB, and it did fail eventually. However, I

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-23 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12430028 ] Daniel John Debrunner commented on DERBY-418: - The change ignores the exception: +} catch(StandardException e) { +

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-22 Thread Mayuresh Nirhali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429668 ] Mayuresh Nirhali commented on DERBY-418: I tried the approach suggested by Dan in DERBY-1142, and my version of change looks like as below, In

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-22 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429674 ] Knut Anders Hatlen commented on DERBY-418: -- Hi Mayuresh, I'm afraid your fix has some unwanted consequences. First of all, the OutOfMemoryError is still

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-22 Thread Mayuresh Nirhali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429709 ] Mayuresh Nirhali commented on DERBY-418: Thanks Knut for pointing that out. I did not mean to provide a patch for this JIRA, but just wanted to try out a

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-22 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429712 ] Knut Anders Hatlen commented on DERBY-418: -- Did you try to declare BaseActivation.inUse as volatile? outofmemory error when running large query in

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-22 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429721 ] Daniel John Debrunner commented on DERBY-418: - Any change must not ignore exceptions thrrown during an activation.close(). }

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-22 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429725 ] Knut Anders Hatlen commented on DERBY-418: -- Mayuresh, with your latest changes, I don't see the memory leak any more (neither DERBY-418 nor DERBY-1142).

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429361 ] Andreas Korneliussen commented on DERBY-418: I think that the lack of synchronization when calling singleUseActivation.markUnused() may cause that

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429386 ] Andreas Korneliussen commented on DERBY-418: The finalizer thread is as pr javadoc guaranteed to not hold any user-visible synchronization locks when

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429430 ] Daniel John Debrunner commented on DERBY-418: - I don't think there is any guarantee about the order of finalization, therefore it is impossible to

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429438 ] Andreas Korneliussen commented on DERBY-418: I am not sure what you mean. Could you give an example ? I agree that it is possible to get a deadlock

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429442 ] Daniel John Debrunner commented on DERBY-418: - The alternate way to phrase it is: Can you guarantee no deadlocks from using synchronization in the

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429473 ] Andreas Korneliussen commented on DERBY-418: Assuming the Derby embedded JDBC driver is thread-safe, it should be safe for a result set to call its own

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429483 ] Daniel John Debrunner commented on DERBY-418: - I'd assumed that you were going to go in at a lower level than ResultSet.close(). ResultSet.close() is

Re: [jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Knut Anders Hatlen
Andreas Korneliussen (JIRA) derby-dev@db.apache.org writes: Assuming the Derby embedded JDBC driver is thread-safe, it should be safe for a result set to call its own close() method in its finalizer. If you get a dead-lock in the finalizer, it proves that it is also possible to write a

Re: [jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Andreas Korneliussen
Knut Anders Hatlen wrote: Andreas Korneliussen (JIRA) derby-dev@db.apache.org writes: Assuming the Derby embedded JDBC driver is thread-safe, it should be safe for a result set to call its own close() method in its finalizer. If you get a dead-lock in the finalizer, it proves that it is

Re: [jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-21 Thread Andreas Korneliussen
Not sure of the guarantee of the unsynchronized field being set. Are you saying that field will never be seen as set, or that the setting may not be seen for some time? It may be seen, however it may also never be seen. Andreas

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-20 Thread Mayuresh Nirhali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429259 ] Mayuresh Nirhali commented on DERBY-418: I tried modifying the finalize method of embedResultSet to close singleuseActivation and that seems to have worked

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-20 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12429264 ] Daniel John Debrunner commented on DERBY-418: - Closing the activation directly in the finalize method will lead to problems. The close of the

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-14 Thread Mayuresh Nirhali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12427891 ] Mayuresh Nirhali commented on DERBY-418: Thanks to Andreas and Oystein for pointing out another possibilty that when the statement objects are GC'd, the

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-14 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12427899 ] Daniel John Debrunner commented on DERBY-418: - I think this is the same case as described in DERBY-1142, comment towards end has a couple of possible

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-11 Thread Mayuresh Nirhali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12427480 ] Mayuresh Nirhali commented on DERBY-418: I used the JHAT (jdk1.6) to dump the java heap and observed that large number of generated objects of type

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-07-20 Thread Mayuresh Nirhali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12422407 ] Mayuresh Nirhali commented on DERBY-418: I was able to reproduce this issue on my Sol10 x86 jdk1.5 platform. I ran with following option, -verbosegc (java