SQL running on task manager only

brunolopes's profile image brunolopes posted 4 years ago in General Permalink

Hello guys, how is everyone? I m using HeidiSQL for a while now as i learn how to work with SQL and this is an amazing app for SURE, but now i came across a problem, afther running a BIG SQL file into my database with heidisql when i start heidisql.exe it shows me the session manager and afther i chose my session and put my log in info heidisql is runing on task manager but wont show up so i canĀ“t work with it... i hope have explained my self right, hope to hear some feedback from you guys soon! cheers!

girtsgr's profile image girtsgr posted 4 years ago Permalink

The same here, although I did not run any big files. The problem started overnight after installation of latest Windows 10 updates yesterday (KB4552931 Cumulative Update for .NET Framework 3.5 and 4.8, KB4556799 OS Builds 18362.836 and 18363.836, KB2267602 Security intelligence updates for Windows Defender Antivirus, KB890830 Windows Malicious Software Removal Tool). Cannot connect to the following DB's any more: MariaDB 10.1.41 and 10.3.22 on Debian, MariaDB 10.4 on Windows 10. Server logs show the following errors: [Warning] Aborted connection 351306 to db: 'XXX' user: 'XXX' host: 'localhost' (Got an error reading communication packets)

girtsgr's profile image girtsgr posted 4 years ago Permalink

P.S. I reinstalled the latest nightly build and specifically allowed Heidi in Windows Firewall, but to no avail.

ansgar's profile image ansgar posted 4 years ago Permalink

@brunolopes: your problem could be you had some additional monitor previously, and now the default window placement is outside your screen. In that case my solution in this thread may help you.

@girtsgr: your problem is totally different, as you get some error message while connecting. You should try out the other library dlls in the session manager, to see if one works.

girtsgr's profile image girtsgr posted 4 years ago Permalink

@ansgar Thank you for your work and for getting back to this. None of the other libraries worked yesterday (besides libmariadb.dll I have libmysql.dll and libmysql-6.1.dll), however, it resumed working with the default libmariadb.dll today :0 Nothing did change either on the client (no restarts, no changes in preferences) or servers (no machine or service restarts); as the Windows server is on the same machine as the client, it was not a network issue either. I can only point my finger at the inner workings of Windows 10, which are becoming more and more mysterious with each update, and hope this will not repeat :) Thank you again!

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