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.

After build 11.3.0.6314 can't export csv data

ckleuser's profile image ckleuser posted 1 month ago in Import/Export Permalink

After updated to build 11.3.0.6315 and beyond, the export registry functionality are crashing to me. Trying to export to clipboard using delimited text option. Using on Win10 x64. Connected db: Postgres.

Description

ansgar's profile image ansgar posted 1 month ago Permalink

I get no crash here with the latest build and the same settings on a local PG server. Could you attach the callstack/bugreport textfile here?

ckleuser's profile image ckleuser posted 1 month ago Permalink

I get no crash here with the latest build and the same settings on a local PG server. Could you attach the callstack/bugreport textfile here?

Sure, here it is:

date/time : 2021-06-21, 10:34:03, 435ms computer name : CRISTIAN-I7 user name : ckleu <admin> operating system : Windows 10 x64 build 19043 system language : Portuguese system up time : 3 days 21 hours program up time : 5 minutes 51 seconds processors : 12x Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz physical memory : 8813/16323 MB (free/total) free disk space : (C:) 118,75 GB display mode : 1920x1080, 32 bit process id : $2148 allocated memory : 103,47 MB largest free block : 131025,95 GB executable : heidisql.exe exec. date/time : 2021-06-21 10:28 version : 11.3.0.6321 compiled with : Delphi 10.4 Sydney madExcept version : 5.1.1 callstack crc : $f31ee59a, $2f3f29e4, $2f3f29e4 contact name : Cristian Kleuser contact email : kleuser@gmail.com exception number : 1 exception class : EAccessViolation exception message : Access violation at address 0000000000411D7C in module 'heidisql.exe'. Read of address FFFFFFFFFFFFFFFF.

main thread ($36e8): 00411d7c heidisql.exe System @UStrAddRef 004122c8 heidisql.exe System @UStrLAsg 00a298b3 heidisql.exe apphelpers 4018 +2 TAppSettings.Write 00a29d67 heidisql.exe apphelpers 4062 +1 TAppSettings.WriteInt 00faa93a heidisql.exe exportgrid 161 +3 TfrmExportGrid.FormDestroy 0087c763 heidisql.exe Vcl.Forms TCustomForm.DoDestroy 0087c401 heidisql.exe Vcl.Forms TCustomForm.BeforeDestruction 00a0a17a heidisql.exe gnugettext 4093 +14 THookedObjects.BeforeDestructionHook 0040f3b2 heidisql.exe System @BeforeDestruction 0087c43c heidisql.exe Vcl.Forms TCustomForm.Destroy 0040e935 heidisql.exe System TObject.Free 0056609a heidisql.exe System.Classes TComponent.DestroyComponents 0056588a heidisql.exe System.Classes TComponent.Destroy 006c9cd7 heidisql.exe Vcl.Controls TControl.Destroy 006d0f36 heidisql.exe Vcl.Controls TWinControl.Destroy 0087a89e heidisql.exe Vcl.Forms TScrollingWinControl.Destroy 0087c631 heidisql.exe Vcl.Forms TCustomForm.Destroy 0040e935 heidisql.exe System TObject.Free 008851f4 heidisql.exe Vcl.Forms TCustomForm.CMRelease 0040f082 heidisql.exe System TObject.Dispatch 006cdead heidisql.exe Vcl.Controls TControl.WndProc 006d510b heidisql.exe Vcl.Controls TWinControl.WndProc 0087e6a9 heidisql.exe Vcl.Forms TCustomForm.WndProc 006d428a heidisql.exe Vcl.Controls TWinControl.MainWndProc 00569673 heidisql.exe System.Classes StdWndProc 7ff943f5 USER32.dll DispatchMessageW 0088ce0e heidisql.exe Vcl.Forms TApplication.ProcessMessage 0088ce83 heidisql.exe Vcl.Forms TApplication.HandleMessage 0088d2d1 heidisql.exe Vcl.Forms TApplication.Run 010687e8 heidisql.exe heidisql 104 +41 initialization 7ff94411 KERNEL32.DLL BaseThreadInitThunk 7ff944dc ntdll.dll RtlUserThreadStart

error details: Trying to export data to csv -> clipboard

ckleuser's profile image ckleuser posted 1 month ago Permalink

I get no crash here with the latest build and the same settings on a local PG server. Could you attach the callstack/bugreport textfile here?

File attached!!

1 attachment(s):
ansgar's profile image ansgar posted 1 month ago Permalink

Thanks.

This crash is apparently caused indirectly by the themes. Try to use the default "Windows" theme, instead of Material (click Tools > Preferences > General > Style theme), and see if that runs without crash.

ckleuser's profile image ckleuser posted 1 month ago Permalink

I've tried as instructed, but still crashes. Attached the crash report using Windows 10 default theme.

1 attachment(s):
ansgar's profile image ansgar posted 1 month ago Permalink

Not "Windows 10" - just "Windows" is the default one. "Windows 10" is a styled theme, looking not so different than the default one.

Apart from testing that, I probably found the cause of the crash in the approach I am using for closing most dialogs, and I am just testing a different one. Crossing fingers that helps fixing various crashes with themes.

Code modification/commit c634dcf from Ansgar Becker <anse@heidisql.com>, 1 month ago, revision 6322
Attempt to fix theme related crashes through OnClose event of dialogs with caFree. See https://www.heidisql.com/forum.php?t=38043
ansgar's profile image ansgar posted 1 month ago Permalink

I just pushed my mentioned fix for the next nightly build - would be nice if you update to 11.3.0.6322 and test the same again, this time with the Material theme (or any other non-"Windows" theme).

ckleuser's profile image ckleuser posted 1 month ago Permalink

I can confirm that version 11.3.0.6322 fixed the problem. Many Thanks!!

I just pushed my mentioned fix for the next nightly build - would be nice if you update to 11.3.0.6322 and test the same again, this time with the Material theme (or any other non-"Windows" theme).

ansgar's profile image ansgar posted 1 month ago Permalink

Thanks for the feedback!

Will modify the same logic for the remaining dialogs now.

ansgar's profile image ansgar posted 1 month ago Permalink

Learned a bit today about caFree: https://stackoverflow.com/questions/2075405/how-to-close-non-modal-form-in-delphi

Code modification/commit cb1024b from Ansgar Becker <anse@heidisql.com>, 1 month ago, revision 6324
Fix more potential theme related EAccessViolation's, due to Action:=caFree in OnClose event of modal forms. Their caller now frees these modal forms. In non-modal forms, keep caFree in OnClose but remove existing OnDestroy events, moving code to OnClose instead.
https://www.heidisql.com/forum.php?t=38043
https://stackoverflow.com/questions/2075405/how-to-close-non-modal-form-in-delphi
ckleuser's profile image ckleuser posted 1 month ago Permalink

Hi, still using build 11.3.0.6323 cause other new builds breaks alot of UI elements using Material theme. Nevertheless, I'm attaching a row of exceptions ocurred in this version cause logging into one database, and then logging into another. The second time, it gives me 3 (three) exceptions in a row just for connecting to that database.

If you need more tests and information, please contact me. Thank's

3 attachment(s):
ckleuser's profile image ckleuser posted 1 month ago Permalink

Just adding the 4th file of the bug report limit. Same subject as above.

1 attachment(s):
ansgar's profile image ansgar posted 1 month ago Permalink

Do these crashes happen with the latest build as well?

And which UI elements are broken with Material?

ckleuser's profile image ckleuser posted 1 month ago Permalink

Yes, updated now to version 6333 and same thing happens:

  • Using Material theme.
  • Aparrently NO UI elements are broken, just the crash report
  • The error do not occur when I connect to a database, but only when I close that session without closing Heidi, and connecting to another database. At this point, if I select a different table, 2 or 3 crashes happens, and no longer in that session, even changing and navigating between tables.

If the logs and description above are not good enough to help, I could make a video and upload, to see the step by step clicks and system response.

Thank's

3 attachment(s):

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.