Crash on lost connection

[expired user #10698]'s profile image [expired user #10698] posted 7 years ago in General Permalink

Steps to reproduce:

  1. Connect to server
  2. Type in query window: select * from db.my_table limit 1
  3. Simulate network problems, for example just disable networking
  4. Execute query

Sometimes it crashes with bugreport window, sometimes without any information.

2 attachment(s):
[expired user #10698]'s profile image [expired user #10698] posted 7 years ago Permalink

Very annoying bug.

charlieo's profile image charlieo posted 7 years ago Permalink

Same thing I get when my computer wakes from sleep.

[expired user #10980]'s profile image [expired user #10980] posted 7 years ago Permalink

Happens to me several times during a day.

[expired user #10980]'s profile image [expired user #10980] posted 7 years ago Permalink

I have stumbled upon the HeidiSQL two years ago and was excited about it. I've recommended it in my company and convinced my boss to send a donation. However, frequent exception and crashed repelled my colleagues from the HeidiSQL.

I've searched the MySQL GUI tools recently and still find the HeidiSQL as the best. Hover these exception and crashes makes it sometimes almost unusable. It's a big pitty. Pls, HeidiSQL developers, fix it and I convince my boss to send a donation again or I will send something by myself :-) Thanks very much.

[expired user #10719]'s profile image [expired user #10719] posted 7 years ago Permalink

I think this is the same problem that I've been having that I posted yesterday Sept 14: "Access violation at address / Windows 10 64-bit". I agree that it makes an excellent software program unusable. Please help!

charlieo's profile image charlieo posted 7 years ago Permalink

Agree this is still a big issue. And allow me to explain why: When I use HeidiSQL I often create queries in many tabs. Some tabs are different small projects. Other tabs are subqueries of more complex queries that I'm working on.

The problem is that I don't want to have to save the contents of every tab. But if I don't, I can easily lose all my work due to a loss of connectivity or my computer goes to sleep leading to a Heidi crash. And when that happens and I lose my work I get really mad.

As a minimum backup, if Heidi saved state and restored it on a restart then at least I wouldn't lose all my work.

Currently I have to relentlessly save everything which is really inconvenient especially for things that I'm not planning to reuse.

Thanks for reading, Charlie

[expired user #11021]'s profile image [expired user #11021] posted 6 years ago Permalink

Still an issue for me, as well. Sometimes I get several errors in a row, which allow the application to continue running. Other times, I'm forced to restart the application completely. See attached bug report.

Please fix this soon, as it is getting to the point that I will have to look for another client to use; dealing with this multiple times a day and losing work is, as you can imagine, extremely frustrating.

1 attachment(s):
[expired user #10698]'s profile image [expired user #10698] posted 6 years ago Permalink

I had to stop using HeidiSQL because of this bug :( dbForge is slower and consumes much more memory, but at least it is not crashing.

[expired user #9976]'s profile image [expired user #9976] posted 6 years ago Permalink

Same as heidisql . com/forum.php?t=21789#p21789

Please fix it, it's been a year now.

[expired user #11021]'s profile image [expired user #11021] posted 6 years ago Permalink

This just happened to me again, in the middle of my work, with an irrecoverable error. This bug is critical.

lemon_juice's profile image lemon_juice posted 6 years ago Permalink

Guys, I wouldn't expect this to become fixed. I've reported this problem several times here and the problem is the author himself doesn't know how to fix those crashes even if he got many donations. The crashes are mostly random, hard to reproduce and I suppose are a result of the framework or compiler that is used - whatever it is it's outside of his control. It's a real pity because otherwise Heidi is really fantastic.

The only partial workaround I've come up with is to never use the TAB key for navigation in result cells or table column cells - TAB often causes crashes. Apart from that there are random crashes in other circumstances, too.

I think it would be best if someone wrote a new program from scratch based on the design of HeidiSQL - in a different language and platform that wouldn't have these inherent crash problems.

charlieo's profile image charlieo posted 6 years ago Permalink

In my experience, the problems are easy to reproduce. Run a query. Put computer to sleep. Wake computer. Run a query. Crash.

The only part that's a bit variable is that sometimes you can click continue after the crash and it will work. Other times the only choice is restart application. Even when 'continue' works you're on borrowed time. The next query execution or the one after that will be a hard crash meaning 'restart application' only.

lemon_juice's profile image lemon_juice posted 6 years ago Permalink

So you have one case that can be reproduced, that's good, but in my experience there are also crashes which do not happen after sleep and they appear totally random. Anyway, I don't think even a reproducible crash would help the author since he doesn't know how to stop them. Or maybe he could find out but it would require a huge amount of time to dedicate to debugging all the platform that is used there.

[expired user #10980]'s profile image [expired user #10980] posted 6 years ago Permalink

The crashes are on the lost connection. E.g. the computer woke up after the sleep (as charlieo said), or when using ssh tunnel, just close the ssh and start it again, etc. So, it's easy to simulate - just interrupt the TCP connection to the server. You may also just edit SQL query and the errors occur.

It's all just about clean reconnect to the server, when the previous connection is lost. For me, a good workaround would be to save the tabs state, restart the HeidiSQL with all tabs content restored.

charlieo's profile image charlieo posted 6 years ago Permalink

Completely agree on saved tab state. In that case the crash would go from 'lost work' (terrible) to 'time inconvenience (tolerable)

[expired user #10980]'s profile image [expired user #10980] posted 6 years ago Permalink

I have rev. 5185 and it seems much better, now.

[expired user #9976]'s profile image [expired user #9976] posted 6 years ago Permalink

Rev 5186, there's now a log and a popup "/ connection pointer is NULL /" Heidi doesn't seem to crash anymore. A few days of usage to have confirmation, but it seems better.

charlieo's profile image charlieo posted 6 years ago Permalink

I wish I could say that I've seen improvement but it seems the same to me. build 5186

[expired user #9976]'s profile image [expired user #9976] posted 6 years ago Permalink

After a few days, still lots of crashes with 5186. Still unresolved.

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