Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Freezing/Hang when enter 'Space'

Mitchell Lee's profile image Mitchell Lee posted 5 months ago in General Permalink

Hi.

MariaDB, in a 'view' editor mode, when type a select query, when enter a 'space' keep hang. Especially when right after 'AS'(alias)

ansgar's profile image ansgar posted 4 months ago Permalink

Isn't that the same issue which you posted here?

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

by the surface symtom, i do not think so. It seem that occur(assume) when heidiSQL do something for smart search(auto column listing). and un/comment working fine after u patch.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

and... there is another freezing symptom that when I edit a 'View' which column changed > 'Save' then crash sometime. It sent by the crash report many times.

all above two are occuring in these days.

ansgar's profile image ansgar posted 4 months ago Permalink

Then please watch out for the internal queries executed and shown in the log panel at the bottom. I suspect there is some slow query causing that hanging.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

Let me correct a word. It make CRASH. not hag/freezing. the auto CRACH report handler called.

so not the slow matter what Im talking about for above all. (Sorry for the 'title or this post')

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

FYI, You can find crash logs from me. I have sent above matters multiple times.

ansgar's profile image ansgar posted 4 months ago Permalink

I am trying to reproduce that issue, without luck yet. I see you updated to the latest build which still crashes in QuotedDatabase. Can you describe exactly what you did when that happened, and whether your connection was probably broken at that time?

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

Erm, I do not know what you 'QuotedDatabase' mention. there is some of different types of crashs which Im keep sending it. So..i do not know which one is which.

btw, I have put a reproduce steps in one of latest crash report. Please check the one of latest one.

There was no connection broken.

ansgar's profile image ansgar posted 4 months ago Permalink

I guess you mean this one?

Right after 'Save' a edited view
 > goto [DATA] tab to check.
it occur.
really frequent.

I did exactly that (edited a view and clicked the data tab), but I get no crash. So this probably depends on the view or the underlying table. Could you post the create definition of the view and the table(s) behind the view?

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

Erm....the view combination of views and each views also reference another view as hierarchy. if look at the very bottom of the view, there is tables which multiple join. which means, I assume, each columns use implicit type internally. (And....the contents bit sensitive.. so cannot show you the contents.)

Column counts are seem that over 90? 80? 100? or so. And the last view contain math fuctions multiple(exp, log, if, ifnull that are calc purpose on some nested sub queries).

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

MariaDB 10.6.x on windows 11 64bit

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

and connection use SSL with key. on the same PC.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

and the 'With' function for table resue that the query consist of view and table, and nested sub queries.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

not 100% reproducible, but about 1 time out of 3? maybe?

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

not 100% reproducible, but about 1 time out of 3? maybe?

plus, this is not the only view make crash, but also others. similar ratio.

ansgar's profile image ansgar posted 4 months ago Permalink

There must be some reproduction recipe. I cannot find the cause if I cannot reproduce here.

By the way, please update to build 6456, I already fixed a few related crashes.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

As I sent you a crash report. same problem on the new patch.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

If install RAD studio 10.4 community version. and download source code. Can I easily dump infomation what you want? I have zero knowledge about delphi. (But, I have deep knowledge of Visual Studio C++ 2022, Visualbasic, java. over 26 years.)

Can you simply lead me?

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

What I meant is that debug run mode. not compile.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

FYI, the status log at the screen below. When the crash occur(mean that after edit view and save until click [Data] tab) the '/ Ping server ... /' not displayed but right after CRASH multiple '/ Ping server ... /' log appear suddenly.

when click [save] something affect to the connection since the [save] calls lots of information load from the server (column information and so on.)

Just talking.

Code modification/commit 3d90ce2 from Ansgar Becker <anse@heidisql.com>, 4 months ago, revision 6457
Silence two crashes in QuotedDatabase and IsSameAs. See https://www.heidisql.com/forum.php?t=39040
ansgar's profile image ansgar posted 4 months ago Permalink

As said the only helpful thing would be a reproduction recipe, probably with the right tables/views. Anyway, I just silenced two crashes which were reported several times, new build will appear in a few minutes. The one crash you reported the last times is one of them. I cannot reproduce both of them, but in the end these are harmless issues, so silencing should not create new problems.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

Ive got the patch, and good for me. Lets keep in touch. (if you make log file into the bottom log window, I can copy and send you. consider that later)

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

"Freezing/Hang when enter 'Space'" still occur. I do not have specific reprostep, but type fast table/view name and space and 'as' and space. totally freeze. keep loosing what I had enter/type.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

one reprostep from myside is,

  1. there is long query

  2. in the middle of query that sub query as below. select

    • from table_a, table_b AS bTT WHERE key_col = bTT.match_key
  3. at the end of the word 'match_key' of above query(means middle of the entire query)

    press enter > press back space > type 'order' > and press space then hang.

ansgar's profile image ansgar posted 4 months ago Permalink

Are there probably many tables in your database? I mean really many, several thousands or so?

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

Not that much.

6 events 88 functions 196 SPs 76 tables 16 triggers 107 views

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

and increasing it.

ansgar's profile image ansgar posted 4 months ago Permalink

That's indeed not too much. I thought the hanging could be due to loading details about the tables for the completion proposal.

I have no more ideas what to check then. Unless you have a crash window.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

Just talk that I'm keep watching the symptom whether possible to reproduce, and will keep you post it.

BTW, it must be memory overrun or equivalent error that 200% sure. In this morning Ive got the error under quite controlled situation only with 3 lines(about..less 100 chars) but I only produce the hang error only twice, but now any more... Please look at the Highlight editor in detail.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

due to wrong pointer connection when after edit text. For example(as an example), remove some words at the line 10 middle of the line move the cursor to line 9 by pressin up-arrow and press ctrl+z then you can see that line 9 disappered.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

when delete text, use 'ctrl + shift + arrow left or right until selected enough + delete/ or backspace' + move to other place by pressing arrow and crrl + v/c/z, ctrl+shift + z whatever one.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

Oh.FYI, I'm using Korean comments a lot in the editor. which 2bytes base unicode.

ansgar's profile image ansgar posted 4 months ago Permalink

Well Unicode characters could easily cause such issues. You could remove these testwise.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

FYI, it keeps hang when traveling between tabs. That is why no crash report to you.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

What today verified is the symptom is that

it occur when the editor try to change lower case to upper case for keywords. For example, middle of 400~500 lines of query, editing subqeury, and type 'where' (small case) and enter 'Space' to expect be upper case. In that case hang. I think 'order' also same situation as report above.

And.. why don't you try to write queries yourself to fix the sypmtom. We cannot help you to pick a 100% reproducible steps. since these are not specific error. only way is, you do write long query, and edit, adjust middle or random as you want.

ansgar's profile image ansgar posted 4 months ago Permalink

Hey, that was what I did all the time. Only it did not hang here as on your side. That's why I was asking for a reproduction recipe.

Just did that again, with a 600 line query tab, writing keywords which are uppercase'd after a space. Again I get no issue here.

Did you remove Unicode/Korean characters testwise?

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

If I remember correctly, some of error happened on pure query. (reason why I told you that multibyte charactor is some of old source handle string as MBCS, not unicode which make memory crash, that was why to give a hint. Now a days, most of source must not handle string as MBCS.)

... and...another idea you give it a try is that, would check the error POSSIBLY occur well in the VIEW edit mode,(not any query edit mode but the VIEW edit mode, you know what im saying. that loaded from the db directly and save) which connected to the buttons UI handling when typing and status change of edit widget. it possibly UI error may not editor error. Hope that u understand what I meant. (one of hang symptom I saw today was, crash detector poped up, and I press report, but hang forever. so didn't send you the report)

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

(plus) whether the VIEW editor referencing wrong button pointer(or possibility by garbage collector) when text changes or change a keyword into upper case.

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

on 12.x same. one weird symptom is that when I press space middle of long view query, right after 'select' a blank list box appeared once.(that usually shows when press '.(period)' after table name) isn't that cause of problem?

ansgar's profile image ansgar posted 4 months ago Permalink

That's the completion proposal of the editor. When it pops up, that normally fires some internal queries you see in the log panel at the bottom. Is there some query taking longer?

Mitchell Lee's profile image Mitchell Lee posted 4 months ago Permalink

none. (why the list pops up when after press space after a keyword 'select'? it is first time.)

Mitchell Lee's profile image Mitchell Lee posted 3 months ago Permalink

Hi. any progress on this?

Now only can use turning off auto-completion as you requested. No intellisense and any support feature at all. (it dramatically reduce hang and errors. but still unknown quiting withut any of notice. just disappearing.)

Seem that there are some of untrackerable errors vary. You should fix the this editor crash matter that windows hooking mechanism, then you will get free from the big errors.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.