Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Frequent CRASHES running long queries or loading SQL files with no default THEME #654

Open
robman70 opened this issue May 22, 2019 · 8 comments

Comments

@robman70
Copy link

commented May 22, 2019

Steps to reproduce this issue

  1. Run a long query (maybe only loading SQL files but I'm not sure about this);

Current behavior

Frequent crashes occur using a non default theme (e.g. Windows 10 Dark)

Expected behavior

No crashes... :-)

Possible solution

Environment

  • HeidiSQL version:
    HeidiSQL 10.1
  • Database system and version:
    MariaDB 10.1
  • Operating system:
    Windows 10 Pro
@DizzyC

This comment has been minimized.

Copy link

commented Jun 22, 2019

I can confirm this issue.
And it happens with the Material Theme that is now selectable from the install screen.

Happens every time I 'Run SQL script'. Consistently reproduces with bigger scripts. A script over ~150MB will crash every time.
I don't get the crash popup dialog, it seems the gui just breaks down.
First indicator is the progress bar that disappears and is replaced by a weird pulsating dark shadow :)
Annotation 2019-06-22 204924

But the process continues, the SQL script is executed to the end.
After it finishes and the progress dialog disappears the whole interface breaks down (various surfaces become blank white).
The app seems to partially continue to work, I can select dbs, tables etc. but It's not really usable and I can't close the app anymore. Need to kill it and restart.
Annotation 2019-06-22 205046
Annotation 2019-06-22 205742

@robman70

This comment has been minimized.

Copy link
Author

commented Jun 24, 2019

At the beginning I also thought the same thing but then some scripts crashed even using the default theme ... :-(

@jjasoncool

This comment has been minimized.

Copy link

commented Jul 5, 2019

I have the same problem, this will happen after executing the mysql dump file.
And the delete button sometimes fails, you can only use the backspace key to delete the string in the editor (it is normal in video).
Video_2019-07-05_165640.zip

@aruldd

This comment has been minimized.

Copy link

commented Jul 19, 2019

Experiencing the same issue with the same theme. It crashes consistently.

@WesleyM77

This comment has been minimized.

Copy link

commented Sep 4, 2019

Can confirm this issue. I've experienced it multiple times with the Material theme.

ansgarbecker added a commit that referenced this issue Sep 8, 2019
Issue #654: reduce very frequent calls to Application.ProcessMessages…
… while import dialog shows, down from 1 call per command to 1 call per second
@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

commented Sep 8, 2019

I found the myriad of refreshes after each query can confuse the application, so my just pushed change reduces that from one call per SQL command down to one call per second. It helps at least here, in case of one bigger file with many short queries.
Please update to the latest build and report back if that already helped.

@DizzyC

This comment has been minimized.

Copy link

commented Sep 10, 2019

@ansgarbecker I'm sorry to report the last build has not fixed the problem. (running 10.2.0.5684 (64 Bit))

I'm having the exact same issues. Noticed that at about 1 mil, 1.2 mil imported rows the UI breaks.
(I encounter this issue when importing bigger dumps, 200MB plus, dumps generated also by heidisql)

Thanks for the effort!

@WesleyM77

This comment has been minimized.

Copy link

commented Sep 10, 2019

Still an issue. Seems to break the UI before it actually finishes running the file.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
6 participants
You can’t perform that action at this time.