Freezing/Hang when enter 'Space'

Hi.

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

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

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.

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.

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.

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')

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

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?

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.

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?

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

MariaDB 10.6.x on windows 11 64bit

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

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

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

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.

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.

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

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?

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

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.

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.

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)

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

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.

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

Not that much.

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

and increasing it.

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.

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.

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.

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.

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

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

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

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.

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?

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)

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

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?

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?

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

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.