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 262158 - OutOfMemoryError: GC overhead limit exceeded
Summary: OutOfMemoryError: GC overhead limit exceeded
Status: RESOLVED INCOMPLETE
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 8.1
Hardware: All All
: P3 normal (vote)
Assignee: matthias42
URL:
Keywords:
: 258278 (view as bug list)
Depends on:
Blocks:
 
Reported: 2016-05-20 07:00 UTC by kRk
Modified: 2016-06-13 20:08 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 56711


Attachments
stacktrace (2.05 KB, text/plain)
2016-05-20 07:00 UTC, kRk
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kRk 2016-05-20 07:00:53 UTC
Build: NetBeans IDE 8.1 (Build 201510222201)
VM: OpenJDK 64-Bit Server VM, 24.85-b03, OpenJDK Runtime Environment, 1.7.0_85-b01
OS: Linux

User Comments:
GUEST: seems to be memory problem, appears after system booting

GUEST: Just worked. Switching windows. Writing code.

kRk: Not remember

GUEST: I was starting netbeans. Last time (last week friday) i checked a database table with many entries.

GUEST: Ruuning a MySQL query on a remote database

GUEST: restarted netbeans after updating from 7.4 to 7.4.1

GUEST: loading a IBM DB2 iseries logical view

tlemus: i was making a query on the Mysql Tool with more of 92 000 000 records with select and order by ....
Regards!
Marco Antonio Trejo Lemus

GUEST: Color formatting

GUEST: Executing query to mysql server

GUEST: nothing special

GUEST: Laggy situation due to perpetual project scanning

GUEST: <Forne
Comment 1 kRk 2016-05-20 07:00:57 UTC
Created attachment 159818 [details]
stacktrace
Comment 2 matthias42 2016-06-13 20:07:15 UTC
Closing this - if the user asks the system to fetch to many rows netbeans can't react correctly. JDBC drivers buffering to many rows are another problem.

In netbeans 8.0 for a short time scrollable cursors were enabled by default for certain databases. It turned out, that many db vendors only simulated scrollable cursors by buffering the resultset.

For 8.1 and 8.2 changes introduced:

- scrollable cursors are disabled by default again
- "View data" limits the resultset already in the query
- Queries are only run once
- Paging is disabled

Closing as incomplete, as a real cause is not determinable by the present data.
Comment 3 matthias42 2016-06-13 20:08:46 UTC
*** Bug 258278 has been marked as a duplicate of this bug. ***