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 199533 - OutOfMemoryError with an idle Database Connection
Summary: OutOfMemoryError with an idle Database Connection
Status: RESOLVED WONTFIX
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 7.1
Hardware: PC Windows Vista
: P4 normal with 1 vote (vote)
Assignee: matthias42
URL:
Keywords: PERFORMANCE
Depends on:
Blocks:
 
Reported: 2011-06-20 06:59 UTC by bht
Modified: 2015-03-11 11:54 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
log files zipped (71.38 KB, application/octet-stream)
2011-06-20 06:59 UTC, bht 		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 bht 2011-06-20 06:59:52 UTC 
Created attachment 108981 [details]
log files zipped

Ran a few queries against a Sybase connection. The IDE was somewhat slow after a while.
Left it unattended, worked with other programs for a while.

Then the IDE popped an error and I had to kill the IDE process.

Log files are attached.

Have 128MBytes compressed heapdump.hprof but don't know how to upload it.

It does not concern me much - just wanted to report it in case it is useful.
Comment 1 Jiri Rechtacek 2011-10-14 07:38:41 UTC 
Thanks for your report. It seems a infinitive look while reading metadata of procedures. Can you confirm you are browsing Sysbase procedures? Could you attach a snippet of your queries? Your heapdump.hprof might be important. You can use something like http://upload.megashare.com/ for uploading. Thanks
Comment 2 bht 2011-10-14 08:48:59 UTC 
Thanks for your questions.

Unfortunately I am no longer working at the site where this happened.

One can freely download a Sybase server at

http://download.sybase.com/eval/155/ase155esd2_winx86.zip

which would allow us to play with this. Not sure whether this will be easier to reproduce at my end than at your end.

I should add that at the site where this happened, with the same NetBeans configuration, the DBAs called me multiple times because I was "locking" the database. I didn't know that NetBeans was involved at all because I had other things running which is what always happens before I use the NetBeans DB explorer.

See issue 200098

I cannot upload large files even to upload.megashare.com - I have tried this before and meanwhile I have deleted the heap dump.

So from my perspective, while I would love to help pinpoint this one, I would recommend you look at installing the Sybase server and play with it, based on my experience that there are possibly more than 1 issue and based on your analysis that pinpoints stored procedures, and based on the fact that I no longer have access to the original environment.

Strictly speaking, I shouldn't even try this at another site, because normally Sybase customers use other tools like SQl Advantage, ASE Isql.
Comment 3 matthias42 2015-03-11 11:54:17 UTC 
Looks like Sybase was shut down. Closing this, as most probably the root cause is one of the other OOM problems in DB.