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.

HeidiSQL hangs / not responding creating triggers

LR's profile image LR posted 1 month ago in General Permalink

Hello.

I am using version 12.0.0.6468 trying to create a trigger against a MariaDB server. Every time I attempt to do so, HeidiSQL hangs and Windows reports NOT RESPONDING.

Right-click on a database and Create Trigger.

Fill in whatever we need in the Options section. All different kinds of settings seem to hang HeidiSQL.

The Statement defaults to

BEGIN

END

Start coding inside BEGIN and END and in a few characters HeidiSQL hangs.

I did like so

BEGIN
    INSERT
END

Pressing SPACE after INSERT hangs.

Thank you.

LR

jmstr8261@gmail.com's profile image jmstr8261@gmail.com posted 1 month ago Permalink

Yes, I'm getting the same issue with 12.0.0.6470

Select Version() query gives me 10.3.30-MariaDB-1:10.3.30+maria~stretch-log

I can type a few words into the Create Trigger, then get a spinning blue wheel and Heidi hangs. For example "UPDATE stock SET st" then it hangs until I force close.

mbabcock@mbsoftwaresolutions.com's profile image mbabcock@mbsoftwaresolutions.com posted 1 month ago Permalink

I'm getting the freeze/hang too every time HeidiSQL tries to use "intellisense" to show me the list of applicable values for the alias in question. This happens repeatedly today when I'm trying to write a new function.

ansgar's profile image ansgar posted 1 month ago Permalink

Got the same report from some other users, as well as issue #1568. Apart from myself yet - for some reasons I cannot reproduce that hanging/freezing. So please try to narrow it down, probably post a screen of the settings in Tools > Preferences > SQL.

LR's profile image LR posted 1 month ago Permalink

I'll try to narrow it down but in the meantime, my SQL settings are attached.

Thank you.

1 attachment(s):
  • SQL-Settings
ansgar's profile image ansgar posted 4 weeks ago Permalink

I could not yet reproduce the issue again. So, anyone encountering this issue more often, please testwise disable

  • the autocompletion
  • and the uppercase feature,

to test if one of these is the cause for the freeze.

Please disable only one of them at one time, then test. Do not disable both at the same time, otherwise you don't know which of these is the cause.

Description

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.