| Bug #105803 | mysql.exe Application Error The exception unknown software exception... | ||
|---|---|---|---|
| Submitted: | 6 Dec 2021 5:16 | Modified: | 6 Dec 2021 13:26 |
| Reporter: | Christopher Penalver | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Command-line Clients | Severity: | S3 (Non-critical) |
| Version: | OS: | Windows | |
| Assigned to: | CPU Architecture: | x86 | |
[6 Dec 2021 13:26]
MySQL Verification Team
Hi Mr. Penalver, Thank you for your bug report. However, we can not accept your report , since we are not able to repeat the behaviour. We have run MySQL CLI several times per second with some command and it worked just fine. We used Windows client and macOS server. Hence, what we require is a fully repeatable test case, so that we can try to reproduce it and continue with the processing of this report. Also, running any executable 20 times per second is not recommended administration practice, since Windows shell is not exactly fast, so you might be getting an OS error since the cleanup from the previous run is not over. It is far better to run it once per several seconds with many commands at once ......
Description: I wanted to report that when using the mysql-cli to update a remote sql database, a window popped up noting: mysql.exe Application Error The exception unknown software exception (0xe0434352) occurred in the application at location 0x00007FFF29354F69. The client has AV and firewall turned off, latest updates, BIOS, and drivers applied. The server has av turned off during the update attempt. It was noticed that version 8.0.27 is available. However, while I'm not a mysql dev, I checked the release notes and didn't see anything glaringly obvious to me that would indicate there is a fix for this issue. Hence, I wanted to report as a heads up in case after I try 8.0.27 it happens again. Environment: ***CLIENT*** mysql -V C:\ProgramData\chocolatey\lib\mysql-cli\tools\mysql.exe Ver 8.0.26 for Win64 on x86_64 (MySQL Community Server - GPL) $PSVersionTable Name Value ---- ----- PSVersion 7.2.0 PSEdition Core GitCommitId 7.2.0 OS Microsoft Windows 10.0.19044 Platform Win32NT PSCompatibleVersions {1.0, 2.0, 3.0, 4.0…} PSRemotingProtocolVersion 2.3 SerializationVersion 1.1.0.1 WSManStackVersion 3.0 *** SERVER *** uname -a Linux ds 3.10.108 #42218 SMP Mon Oct 18 19:16:10 CST 2021 x86_64 GNU/Linux synology_avoton_1517+ mysql --version mysql Ver 15.1 Distrib 10.3.29-MariaDB, for Linux (x64) using readline 5.1 How to repeat: This foreach-boject -parallel calls invokes mysql.exe about 20 times per second to update a remote sql server. ***PSUEDOCODE START*** $DATATOPROCESS | foreach-object -parallel { ... STRING MANIPULATION OF $COL1DATA & $COL2DATA ... $COMMAND="UPDATE $DBNAME.$TABLE SET col1='$COL1DATA' WHERE id='$ID';UPDATE $DBNAME.$TABLE SET col2='$COL2DATA' WHERE id='$ID';" mysql -A -u $USERNAME --password=$PASSWORD -h $IPADDRESS -e $COMMAND } -throttlelimit 4 -asjob ***PSUEDOCODE END***