Crash when many windows open

Marcel Hoefs · Jul 16, 2014

I am using PLSQL Dev 10.0.5.1710 on Windows 7 64bit. When I am working with many windows open, let's say 15, then after some time PLSQL Dev crashes. Well actually PLSQL Dev tries to "paint" over and over all windows and becomes unresponsive while the MDI window is filled with partially repainted windows. Finally I have to kill PLSQL Dev.

When I look in the Debug.txt file around the time this starts happening I see the following:

16-7-2014 15:28:25 SQLForm 0 rows selected in 1,014 seconds /* 28/1 selected symbols */
16-7-2014 15:28:27 CheckFileDate WindowFileDate = 17:24:42
16-7-2014 15:28:27 FileAge: M:\MVS\ddl\Oxxigen\ML-WP5\tst_expand_sql_text.tst = 17:24:42
16-7-2014 15:28:27 CheckFileDate WindowFileDate = 20:06:26
16-7-2014 15:28:27 FileAge: M:\MVS\ddl\Oxxigen\VPD\vpd_analyse_queries_1.sql = 20:06:26
16-7-2014 15:28:27 CheckFileDate WindowFileDate = 8:45:04
16-7-2014 15:28:27 FileAge: M:\MVS\ddl\Oxxigen\ML-WP5\tst_set_aut_context.tst = 8:45:04
16-7-2014 15:28:27 CheckFileDate WindowFileDate = 15:00:54
16-7-2014 15:28:27 FileAge: M:\MVS\ddl\Oxxigen\ML-WP5\tst_add_grouped_policy.tst = 15:00:54
16-7-2014 15:28:27 CheckFileDate WindowFileDate = 10:34:38
16-7-2014 15:28:27 FileAge: M:\MVS\ddl\Oxxigen\ML-WP5\patch11682b\BOUW\VPD_labelling_view_query.sql = 10:34:38
16-7-2014 15:28:27 CheckFileDate WindowFileDate = 10:35:12
16-7-2014 15:28:27 FileAge: M:\MVS\ddl\Oxxigen\ML-WP5\patch11682b\BOUW\TEST\test_data_vpd.sql = 10:35:12
16-7-2014 15:28:27 NavigationBookmarks.EnableButtons(Rebuild)
16-7-2014 15:28:27 NavigationBookmarks: Backward=10, Forward=0
16-7-2014 15:28:30 EurekaLogExceptionNotify
16-7-2014 15:28:30 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
16-7-2014 15:28:30 TOracleQuery Query End (5 records processed)
Duration = 0,016
16-7-2014 15:28:30 TOracleQuery $0DECB880 Start Query.Execute
SQL = select * from nls_database_parameters where parameter like 'NLS%CHARACTERSET'
16-7-2014 15:28:30 TOracleQuery $0DECB880 End (2 records processed)
Duration = 0,062
16-7-2014 15:28:30 EurekaLog: The parameter is incorrect.
16-7-2014 15:28:30 EurekaLog: The parameter is incorrect.
16-7-2014 15:28:30 Exception: The parameter is incorrect.
16-7-2014 15:28:30 Exception: Canvas does not allow drawing
16-7-2014 15:28:30 Exception: Canvas does not allow drawing
16-7-2014 15:28:30 Exception: Canvas does not allow drawing
16-7-2014 15:28:30 Exception: Canvas does not allow drawing
16-7-2014 15:28:30 Exception: Canvas does not allow drawing
16-7-2014 15:28:30 Exception: Canvas does not allow drawing
16-7-2014 15:28:31 Exception: Invalid window handle.
16-7-2014 15:28:31 Exception: RestoreDC fails
16-7-2014 15:28:31 Exception: RestoreDC fails
16-7-2014 15:28:31 Exception: RestoreDC fails
16-7-2014 15:28:31 Exception: Canvas does not allow drawing
16-7-2014 15:28:31 Exception: Canvas does not allow drawing
16-7-2014 15:28:31 Exception: Canvas does not allow drawing
16-7-2014 15:28:31 Exception: Canvas does not allow drawing
16-7-2014 15:28:31 Exception: Canvas does not allow drawing
16-7-2014 15:28:46 Exception: Canvas does not allow drawing
16-7-2014 15:28:46 CheckFileDate WindowFileDate = 17:24:42
16-7-2014 15:28:46 FileAge: **************************************************** = 17:24:42
16-7-2014 15:28:46 CheckFileDate WindowFileDate = 20:06:26
16-7-2014 15:28:46 FileAge: **************************************************** = 20:06:26
16-7-2014 15:28:46 CheckFileDate WindowFileDate = 8:45:04
16-7-2014 15:28:46 FileAge: **************************************************** = 8:45:04
16-7-2014 15:28:46 CheckFileDate WindowFileDate = 15:00:54
16-7-2014 15:28:46 FileAge: **************************************************** = 15:00:54
16-7-2014 15:28:46 CheckFileDate WindowFileDate = 10:34:38
16-7-2014 15:28:47 FileAge: **************************************************** = 10:34:38
16-7-2014 15:28:47 CheckFileDate WindowFileDate = 10:35:12
16-7-2014 15:28:47 FileAge: **************************************************** = 10:35:12
16-7-2014 15:28:47 NavigationBookmarks.EnableButtons(Rebuild)
16-7-2014 15:28:47 NavigationBookmarks: Backward=10, Forward=0
16-7-2014 15:28:47 Exception: RestoreDC fails
16-7-2014 15:28:47 Exception: Invalid window handle.
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Invalid window handle.
16-7-2014 15:28:47 Exception: RestoreDC fails
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:47 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: RestoreDC fails
16-7-2014 15:28:48 Exception: Canvas does not allow drawing
16-7-2014 15:28:49 Exception: Canvas does not allow drawing
16-7-2014 15:28:49 Exception: Canvas does not allow drawing
16-7-2014 15:28:49 Exception: Canvas does not allow drawing
16-7-2014 15:28:49 Exception: Canvas does not allow drawing
16-7-2014 15:28:58 Exception: RestoreDC fails
16-7-2014 15:28:59 Exception: Out of system resources
16-7-2014 15:28:59 Exception: Canvas does not allow drawing
16-7-2014 15:28:59 Exception: Canvas does not allow drawing
16-7-2014 15:28:59 Exception: Canvas does not allow drawing
16-7-2014 15:28:59 Exception: RestoreDC fails
16-7-2014 15:28:59 Exception: RestoreDC fails
16-7-2014 15:28:59 Exception: RestoreDC fails
16-7-2014 15:28:59 Exception: RestoreDC fails
16-7-2014 15:28:59 Exception: RestoreDC fails
16-7-2014 15:28:59 Exception: Canvas does not allow drawing
16-7-2014 15:28:59 Exception: Canvas does not allow drawing
16-7-2014 15:28:59 Exception: Canvas does not allow drawing
16-7-2014 15:28:59 Exception: Canvas does not allow drawing
16-7-2014 15:28:59 Exception: Canvas does not allow drawing
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: RestoreDC fails
16-7-2014 15:29:13 Exception: Canvas does not allow drawing
16-7-2014 15:29:13 Exception: Canvas does not allow drawing
16-7-2014 15:29:13 Exception: Canvas does not allow drawing
16-7-2014 15:29:13 Exception: Canvas does not allow drawing
16-7-2014 15:29:13 Exception: Canvas does not allow drawing
16-7-2014 15:29:53 Exception: RestoreDC fails
16-7-2014 15:29:53 Exception: RestoreDC fails
16-7-2014 15:29:53 Exception: RestoreDC fails
16-7-2014 15:29:53 Exception: Canvas does not allow drawing
16-7-2014 15:29:53 Exception: Canvas does not allow drawing
16-7-2014 15:29:53 Exception: Canvas does not allow drawing
16-7-2014 15:29:53 Exception: RestoreDC fails
16-7-2014 15:29:53 Exception: RestoreDC fails
16-7-2014 15:29:53 Exception: RestoreDC fails
16-7-2014 15:29:53 Exception: RestoreDC fails
16-7-2014 15:29:54 Exception: Canvas does not allow drawing
16-7-2014 15:29:54 Exception: Canvas does not allow drawing
16-7-2014 15:29:54 Exception: Canvas does not allow drawing
16-7-2014 15:29:54 Exception: Canvas does not allow drawing
16-7-2014 15:29:54 Exception: Canvas does not allow drawing

Does anybody have any idea what could be the problem?

Thank you for your help.

Regards, Marcel.

Marco Kalter · Jul 17, 2014

Is there also an error message that refers to a plsqldev.elf file? If so, can you send it to support@allroundautomations.com?

Marcel Hoefs · Jul 18, 2014

No, I had to kill PLSQL Dev manually so nothing appeared in the plsqldev.elf file. When this problem occurs PLSQL Dev does not crash spontaneously but keeps on redrawing all windows. The program then responds to nothing anymore so manually killing it is the only option.

Just to be certain I have looked into this file and no exceptions were logged around the time that was logged in Debug.txt.

Marcel Hoefs · Jul 18, 2014

Today when I had to kill PLSQLDev again when it started redrawing all my open windows over and over again I saw something new. An dialog box appeared with the following message: "InternalGetDIB fails". I could not click the OK button in this dialog. So finally I had to kill PLSQLDev again.

Maybe this provides a clue in identifying the cause of this problem.

Worker · Jul 18, 2014

When this happens, does the problem stay contained within PLSQLDev, or do you also get errors starting other programs?

Marcel Hoefs · Jul 21, 2014

The problem stays contained within PLSQLDev. Other Windows programs remain unaffected.

mike · Jul 22, 2014

Quite likely not it, but just in case...One thing that I do when I have issues is to temporarily disable all of my plug-ins and restart PL/SQL Developer so that I can rule them out.

Marcel Hoefs · Jul 23, 2014

Hi Mike,

Thank you for your suggestion. I will try this out.

Regards, Marcel.

Marcel Hoefs · Jul 23, 2014

Hi Marco,

Today when the windowing problem occurred I did get an PLSQLDev unexpected exception. I mailed the plsqldev.elf exception to support@allroundautomations.com.

Regard, Marcel.

Marcel Hoefs · Aug 11, 2014

Hi Marco,

Is there any news on my problem? PL/SQL Dev crashes usually several times a day and since I started this discussion a lot of my colleagues are reporting the same behavior.

I can also rule out the influence of plugins as many of my colleagues who are experiencing this problem do not use plugins.

Regards, Marcel

Marco Kalter · Aug 11, 2014

Can you download this version and try again?

Marcel Hoefs · Aug 12, 2014

Thank you. I will try this version today and let you know the results.

Regards, Marcel Hoefs

Marcel Hoefs · Aug 12, 2014

Hi Marco,

Sadly after less than 2 hours of programming PL/SQL Dev crashed again showing the same behavior as before. I have mailed you the plsqldev.elf file containing the exception that occurred this time.

Regards, Marcel.

Hilarion · Aug 13, 2014

As far as I can see, it's just the official 10.0.5 version, which Marcel is apparently already using.

Marcel Hoefs · Aug 21, 2014

A bit more info that may help in finding the cause and a solution.

This morning when PL/SQL Dev crashed I saw the following sequence of error messages:

- Invalid Window Handle
- Canvas does not allow drawing
- InternalGetDIB Fails
- The parameter is incorrect
- Access violation at address 77C7B489 in module 'ntdll.dll'. Write of address 00000014
- Error drawing UpdateWatchesBtn.Glyph.Data: Canvas does no allow drawing
- Unexpected error...
- crash

Kind Regards,

Marcel

Worker · Aug 21, 2014

I've had similar problems in the past and they were related to Windows running out of space in the "desktop heap". Basically Windows has a limit to how many windows, buttons, scrollbars, etc. it can handle, and having a large number of PL/SQL Developer instances open can burn through that.

However, I experienced that on Windows XP. The Windows 7 limit is higher, so it's less likely you're really hitting that.

If the desktop heap is the cause, then at the moment you experience the PL/SQL Developer problem, you should get similar problems trying to open a bunch of Firefox, Office, or other complex windows. If you get errors in PL/SQL Developer (but before it crashes completely) but you can open dozens of new non-PL/SQL Developer windows, then it's probably not the desktop heap.

Marcel Hoefs · Aug 21, 2014

Yes I know of the desktop heap problems in Windows XP. But I don't think this is the case this time. I only have 1 instance of PL/SQL Dev open and about 20 windows open in this instance. When PLSQL Dev crashes all other program's remain unaffected and behave normally.

But still sometimes I see an "Out of resources" error just before PLSQL Dev crashes...

Crash when many windows open

Marcel Hoefs

Member³

Marco Kalter

Administrator

Marcel Hoefs

Member³

Marcel Hoefs

Member³

Worker

Member³

Marcel Hoefs

Member³

mike

Member³

Marcel Hoefs

Member³

Marcel Hoefs

Member³

Marcel Hoefs

Member³

Marco Kalter

Administrator

Marcel Hoefs

Member³

Marcel Hoefs

Member³

Hilarion

Member³

Marcel Hoefs

Member³

Worker

Member³

Marcel Hoefs

Member³

Similar threads