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

Summary:	OutOfMemoryError: GC overhead limit exceeded
Product:	db	Reporter:	kRk
Component:	Show Data	Assignee:	matthias42
Status:	RESOLVED INCOMPLETE
Severity:	normal	CC:	minoleg, tlemus
Priority:	P3
Version:	8.1
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:	56711
Attachments:	stacktrace

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. ***