This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 239884 - Using too much Memory and CPU usage
Summary: Using too much Memory and CPU usage
Status: RESOLVED FIXED
Alias: None
Product: javaee
Classification: Unclassified
Component: Persistence (show other bugs)
Version: 7.4
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Sergey Petrov
URL:
Keywords:
: 244886 (view as bug list)
Depends on:
Blocks:
 
Reported: 2013-12-31 05:02 UTC by darkzlayer
Modified: 2014-07-24 17:54 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Log file said from the failed upload error message (62.17 KB, application/octet-stream)
2013-12-31 05:02 UTC, darkzlayer 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description darkzlayer 2013-12-31 05:02:43 UTC 
Created attachment 143531 [details]
Log file said from the failed upload error message

I just added "OUTER JOIN" on my @NamedQuery and this problem occurs. I guess it was the IDE suggestion feature that caused the problem.
Comment 1 Tomas Hurka 2013-12-31 10:16:28 UTC 
Please upload zipped head dump here: <http://deadlock.netbeans.org/job/upload/build>.
The heap dump should be on your disk. The file is
C:\Users\Arth\AppData\Roaming\NetBeans\7.4\var\log\heapdump.hprof
or
C:\Users\Arth\AppData\Roaming\NetBeans\7.4\var\log\heapdump.hprof.old

Thanks.
Comment 2 darkzlayer 2013-12-31 19:24:14 UTC 
Thanks for the quick response. I used 239884 as Upload_Name. Happy new year!
Comment 3 Tomas Hurka 2014-01-02 09:55:00 UTC 
The heap dump contains 4,000,000 of org.eclipse.persistence.jpa.jpql.parser.IdentificationVariableDeclaration instances and 4,000,000 of org.eclipse.persistence.jpa.jpql.parser.AbstractExpression$Info instances. It looks like the problem is caused by parsing the following query:

SELECT r FROM Room r OUTER JOIN r.prioritizedCourses c WHERE c.major = :major AND c.name = :name AND r.lab = true

Reassigning to javaee/persistance for further evaluation.
Comment 4 darkzlayer 2014-01-02 17:03:54 UTC 
By the way, I am using SQLite 3.7.2 and EclipseLink 2.5.1. It might help you solve the problem. Thanks!
Comment 5 Sergey Petrov 2014-01-02 23:48:34 UTC 
what nb version do you use?
is ot patched? what eclipselink version you can see in libraries list?
Comment 6 Sergey Petrov 2014-01-02 23:49:53 UTC 
ok, I see 2.5.1 above but is it the one already provided by nb?
Comment 7 darkzlayer 2014-01-03 09:17:21 UTC 
Yes it is provided by NetBeans.

(In reply to Sergey Petrov from comment #6)
> ok, I see 2.5.1 above but is it the one already provided by nb?
Comment 8 PascalFilion 2014-01-03 22:10:03 UTC 
An EclipseLink bug was filed for the JPQL parser issue. The fix will be part of the 2.5.2 release.
https://bugs.eclipse.org/bugs/show_bug.cgi?id=424873
Comment 9 darkzlayer 2014-01-04 13:33:46 UTC 
Thanks for handling this bug. I guess I should be careful writing JPQL queries until I finish our thesis.
Comment 10 Sergey Petrov 2014-01-04 18:53:59 UTC 
let it be opened but with lower priority, I need to update bundelded version when new eclipselink will be available
Comment 11 Sergey Petrov 2014-07-09 11:14:53 UTC 
It's nice it was fixed in january and should be part of 2.5.2
http://hg.netbeans.org/web-main/rev/3816fb0ab1f5
Comment 12 Quality Engineering 2014-07-10 02:45:57 UTC 
Integrated into 'main-silver', will be available in build *201407100001* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)

Changeset: http://hg.netbeans.org/main-silver/rev/3816fb0ab1f5
User: Sergey B. Petrov <sj-nb@netbeans.org>
Log: #239884 el 2.5.2
Comment 13 Sergey Petrov 2014-07-24 17:54:42 UTC 
*** Bug 244886 has been marked as a duplicate of this bug. ***