Message-ID: <560ADB34.6050700@yandex.ru>
Date: Tue, 29 Sep 2015 21:40:52 +0300
From: Nikolai Zhubr <n-a-zhubr@yandex.ru>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ru;
 rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
To: pgadmin-support@postgresql.org, pgadmin-hackers@postgresql.org
Subject: Re: [pgadmin-support] SQL-panel causes 100% CPU and lockup on windows
 (Was Stability and compatability issues on windows xp)
References: <r8vwwstv0bdjlhprr0tg4nva.1443292908241@email.android.com>
 <5606F2C8.9010001@yandex.ru> <56070F5A.3070102@yandex.ru>
 <1674144739.20150927082019@mail.ru> <5607CF32.7030707@yandex.ru>
 <5609BC61.8030503@yandex.ru>
In-Reply-To: <5609BC61.8030503@yandex.ru>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

Hi,
29.09.2015 1:17, I wrote:
[...]
> Here is how to reproduce. (Procedure valid at least for win xp and 7)
> In under 1 minute!

Some more observations. Same problem happens also in function properties 
window, in the 'Code' tab:

- choose some simple (lets say empty) function, open its properties;
- click on the 'Code' tab;
- place this properties window so that its righthand margin is somewhat 
beyond the right margin of the monitor, making some part of SQL editor 
invisible (out of the real screen space);
- click to place cursor into the function body and type 'select now()';
- watch the CPU load.

So it looks like ctlSQLBox instances are affected, although ctlSQLBox 
itself seems quite harmless (looking at the code), except for maybe 
ctlSQLBox::OnPositionStc() about which I've just no idea. And since 
ctlSQLBox is a direct descendant of a wx class, it looks like maybe it 
is actually wxwin to blame.
So my theory is:
-- either ctlSQLBox::OnPositionStc() itself,
-- or the underlying wx class (classes).

I haven't arranged a development environment yet, but am going to.


Thank you,
Nikolai

> - Aero have to be disabled (on versions that have it). If you can not or
> do not want to disable aero for some reason, you might try connecting
> via remote desktop instead, it should basically behave very similar,
> I've tested it as well.
> - start windows task manager and minimize it so it just shows CPU load
> within a tray icon. (taskmgr.exe)
> - start pgamin as usual, connect to some server, then click on some
> database, so that SQL-panel button becomes available.
> - open SQL-panel (click the above mentioned button), then move SQL-panel
> window in the righthand direction till some part of SQL-editor window
> rectangle goes beyond the right border of the screen. Let is stay like
> that (partly invisible). Note that I mean exactly SQL-editor window
> itself, not additional notepad window that might happen to be located to
> the right of SQL-editor. (Or you can just close this notepad to be sure)
> - now click into SQL-editor so that you can start typing.
> - type just exactly this: 'select now()' then stop, do not touch
> anything and watch the CPU load. it should go 100% (50% on dual core,
> 25% on quad core) and stick there.
> - note: it is critical to put brackets there, otherwise bug is not
> triggered, so I'd guess this is related to code highlighting.
> - now go to SQL-panel's main menu - select file - select exit. instead
> of closing, SQL-panel goes completely unresponsive here.
>
> I'd be glad to hear some feedback (from windows users) :)
>
>
> Thank you,
> Nikolai
>
>>
>>
>> Thank you,
>> Nikolai
>
>
>


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers