Connection will broke after reopen the laptop

[Sccotliu]

Preconditions

• HeidiSQL version: 11.3.0.6295
• Database type and version: postgresql 13.3
• OS: windows 10

Describe the bug

The HeidiSql is a perfect DB client for me, I use it many years, and I found a tiny problem, I install HeidiSql on my laptop and it run without any problem, but if I just covered my laptop, after few hours, I open my laptop, then Heidi window still on my screen, but connection was broke, I can not find any way to reconnect it, if I manul disconnect it, then Heidi window will exit, I must reopen it and resume my working.
To Reproduce

1. Open Heidi client and connect to DB(pg) on laptop with windows 10
2. Just cover but does not shutdown the laptop
3. After few hours open the laptop
4. Will found the Heidi client connection was broke
   Screenshots or Crash reports

[ansgarbecker]

Did you try to click at some object in the database tree? HeidiSQL should in most cases be able to reconnect on demand. But I know this is prone to errors.

Apart from that, I highly recommend to activate this setting:
Tools > Preferences > Files > "Reopen previously used SQL files and unsaved contents in tab"
This should minimize the annoyance factor due to reopening files.

[Sccotliu]

Thanks for your reply, I'll try your suggestion later.

[boryn]

I have the same issue (after awaking the laptop from sleep or hibernation). I see in the grid just "nodes":

and when I click any item to the left, the program tries to reconnect, it takes quite long ~25 seconds, it connects and shows the table contents but soon later I get the window "can't connect twice".

And later when I click anything again, it connects and again window "can't connect twice". So in this case this app instance gets "unusable", I need to close it and connect again.

Windows10, HeidiSQL 11.3.0.6295 (but I had this problem for many previous versions as well). Probably what may be important, I connect through SSH Tunnel, library is libmariadb.dll

Privately I could send you video with the behaviour of the app.

[boryn]

I have just sent a bug report (my email starts with bo...) after trying to reconnect, the same database, but now using the libmysql.dll

[boryn]

With the database on the local computer, I have the same empty nodes and this window:

The bug report:

date/time          : 2021-07-19, 09:09:53, 913ms
computer name      : XMG
user name          : michal
registered owner   : michal
operating system   : Windows 10 x64 build 19043
system language    : Polish
system up time     : 3 days 12 hours
program up time    : 1 day 23 hours
processors         : 12x Intel(R) Core(TM) i7-8700K CPU @ 3.70GHz
physical memory    : 10250/65483 MB (free/total)
free disk space    : (C:) 95,05 GB
display mode       : 2560x1440, 32 bit
process id         : $7d34
allocated memory   : 178,52 MB
largest free block : 131021,95 GB
command line       : "C:\Program Files\HeidiSQL\heidisql.exe" -d="LOCAL"
executable         : heidisql.exe
exec. date/time    : 2021-05-30 07:40
version            : 11.3.0.6295
compiled with      : Delphi 10.4 Sydney
madExcept version  : 5.1.0
callstack crc      : $6a267d27, $c25e51b5, $c25e51b5
exception number   : 2
exception class    : EListError
exception message  : Duplicates not allowed.

thread $39a8:
00bfd9de heidisql.exe dbconnection      57   +0 {System.Generics.Collections}TDictionary<System.string,dbconnection.TTableColumnList>.Add
00bf5108 heidisql.exe dbconnection    9085   +4 TDBObject.GetTableColumns
01042dcd heidisql.exe Main            9271  +59 TMainForm.DBtreeFocusChanged
0096f8c4 heidisql.exe VirtualTrees   20073   +2 TBaseVirtualTree.DoFocusChange
00976acb heidisql.exe VirtualTrees   22839 +274 TBaseVirtualTree.HandleMouseDown
009696b5 heidisql.exe VirtualTrees   17469   +6 TBaseVirtualTree.WMLButtonDown
0040f072 heidisql.exe System                    TObject.Dispatch
0097e132 heidisql.exe VirtualTrees   25795  +19 TBaseVirtualTree.WndProc
006d3cea heidisql.exe Vcl.Controls              TWinControl.MainWndProc
00569013 heidisql.exe System.Classes            StdWndProc
7ffd7c3e USER32.dll                             DispatchMessageW
0088c44e heidisql.exe Vcl.Forms                 TApplication.ProcessMessage
0088c4c3 heidisql.exe Vcl.Forms                 TApplication.HandleMessage
0088c911 heidisql.exe Vcl.Forms                 TApplication.Run
01066588 heidisql.exe heidisql         104  +41 initialization
7ffd7cec KERNEL32.DLL                           BaseThreadInitThunk
7ffd7e04 ntdll.dll                              RtlUserThreadStart

Is there anything more I can provide to trace this inconvenience?

[Hr0bar]

This is the worst bug in HeidiSQL imho, I get it multiple times a day, not only after laptop gets back from sleep. Even having HeidiSQL idle for 4+ hours on a running laptop triggers this. Sent the crash report already maybe a year ago.

[karsten-eger]

I'm running into this several times a day as well.

Exactly the same error and call stack as @boryn

It is MariaDB in my case though. And it happens even while only using heidi normally out of a blue

[hoggatt]

I'm getting this as well. I agree that it is the most frustrating bug in Heidi. I have to constantly restart the program. I close my laptop lid to carry my laptop when I go between meetings and I'm constantly having to restart the program since it doesn't auto-reconnect like other SQL managers.

Apart from that, I highly recommend to activate this setting: Tools > Preferences > Files > "Reopen previously used SQL files and unsaved contents in tab" This should minimize the annoyance factor due to reopening files.

Unfortunately, this does not fix the issue.

[hoggatt]

Here is my bug report:

date/time          : 2022-09-16, 13:18:30, 5ms
operating system   : Windows 10 Tablet PC x64 build 19042
system language    : English
system up time     : 12 days 3 hours
program up time    : 4 hours 7 minutes
processors         : 16x 11th Gen Intel(R) Core(TM) i7-11850H @ 2.50GHz
physical memory    : 9404/32488 MB (free/total)
free disk space    : (C:) 603.24 GB
display mode       : 1707x1067, 32 bit
process id         : $e9a4
allocated memory   : 155.20 MB
largest free block : 131025.96 GB
executable         : heidisql.exe
exec. date/time    : 2019-12-11 12:26
version            : 10.3.0.5771
compiled with      : Delphi 10.3 Rio
madExcept version  : 5.0.0
callstack crc      : $a97ad4d7, $b36fc8c8, $b36fc8c8
exception number   : 1
exception class    : EDbError
exception message  : Column #0 not available. Query returned 117 columns and 1000 rows.

main thread ($be04):
00b07003 heidisql.exe dbconnection    6398  +35 TMySQLQuery.Col
00de9086 heidisql.exe Main            9199  +31 TMainForm.AnyGridGetText
0094e216 heidisql.exe VirtualTrees   33939   +8 TCustomVirtualStringTree.DoGetText
0094e43e heidisql.exe VirtualTrees   33996  +12 TCustomVirtualStringTree.DoPaintNode
00945667 heidisql.exe VirtualTrees   30626 +355 TBaseVirtualTree.PaintTree
009358c7 heidisql.exe VirtualTrees   23761  +23 TBaseVirtualTree.Paint
006b5ed6 heidisql.exe Vcl.Controls              TCustomControl.PaintWindow
006accb3 heidisql.exe Vcl.Controls              TWinControl.PaintHandler
006ad9cf heidisql.exe Vcl.Controls              TWinControl.WMPaint
006b5e68 heidisql.exe Vcl.Controls              TCustomControl.WMPaint
009268cd heidisql.exe VirtualTrees   17509   +8 TBaseVirtualTree.WMPaint
0040e9d2 heidisql.exe System                    TObject.Dispatch
006a5d6d heidisql.exe Vcl.Controls              TControl.WndProc
006aca2a heidisql.exe Vcl.Controls              TWinControl.WndProc
0093a4f8 heidisql.exe VirtualTrees   25582  +32 TBaseVirtualTree.WndProc
006abc5a heidisql.exe Vcl.Controls              TWinControl.MainWndProc
0055e643 heidisql.exe System.Classes            StdWndProc
7ffeded3 ntdll.dll                              KiUserCallbackDispatcher
7ffedeab USER32.dll                             DispatchMessageW
00851fae heidisql.exe Vcl.Forms                 TApplication.ProcessMessage
00852023 heidisql.exe Vcl.Forms                 TApplication.HandleMessage
00852471 heidisql.exe Vcl.Forms                 TApplication.Run
00e08f41 heidisql.exe heidisql          93  +32 initialization
7ffedd16 KERNEL32.DLL                           BaseThreadInitThunk
7ffedece ntdll.dll                              RtlUserThreadStart