Crash on lost connection

drull posted 8 months ago in General

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):
drull posted 8 months ago

Very annoying bug.

charlieo posted 8 months ago

Same thing I get when my computer wakes from sleep.

xmedeko posted 3 months ago

Happens to me several times during a day.

xmedeko posted 3 months ago

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.

gretkief posted 3 months ago

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 posted 3 months ago

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

lucasoman posted 2 months ago

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):
drull posted 2 months ago

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.

denis posted 2 months ago

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

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

lucasoman posted 2 months ago

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

lemon_juice posted 2 months ago

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 posted 2 months ago

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 posted 2 months ago

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.

xmedeko posted 2 months ago

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 posted 2 months ago

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

xmedeko posted 1 month ago

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

denis posted 1 month ago

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 posted 3 weeks ago

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

denis posted 3 weeks ago

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

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