Problems with MySQL server auto-disconnection

Source: Internet
Author: User
Tags mysql command line

A problem with MySQL today, when running the UPDATE statement, the MySQL service will automatically break off, whether with phpMyAdmin, Navicat, MySQL Workbench even with the MySQL command line effect.

My environment is: Windows Server R2 + Mysql5.7.18-win64.

The MySQL log shows:

06:36:18 Utc-mysqld got exception 0xc000001d; This could is because a bug. It's also possible that's binaryor one of the libraries it was linked against are corrupt, improperly built,or misconfi Gured. This error can also is caused by malfunctioning hardware. Attempting to collect some information, could help diagnose the problem. As this was a crash and something is definitely wrong, the informationcollection process might fail.key_buffer_size=8388608 Read_buffer_size=8192max_used_connections=2max_threads=151thread_count=2connection_count=2it is possible that Mysqld could use up to Key_buffer_size + (read_buffer_size + sort_buffer_size) *max_threads = 49892 K bytes of Memoryhope That ' s OK; If not, decrease some variables in the equation. Thread pointer:0xa066480attempting BackTrace. You can use the following information to find Outwhere Mysqld died. If you see no messages after this, something wentterribly wrong ... 7FEF5755C01 Msvcr120.dll!pow () 13F8A62AA [email pRotected]@[email protected]@[email protected]@@z () 13fe68107 [email protected][email  Protected][email protected]@[email protected][email protected]@[email protected][email  protected]@@@@[email protected]@[email protected]@@@[email protected] () 13fe5e059 [email  protected][email protected] @QEAAXXZ () 13fe6a3f5 [Email protected]@[email protected]@[email  protected][email protected]@@[email protected][email protected]@[email protected]@[ Email protected]@[email protected][email protected]@@z () 13fb18ce7 [Email protected]@[email  protected]@[email protected]@@@@[email protected]@[email protected] () 13fb1afb0 [email  protected][email protected]@[email protected]@[email protected] () 13fb172ea [email  Protected][email protected]@[email protected]@@z () 13f8d72d5 [email protected]@[email  Protected]@[eMail protected] () 13f8d9bf3 [Email protected]@[email protected]@[email protected]@@z () 13f8d2c93 [Email protected]@[email protected]@[email protected]@[email protected]@@z () 13F8D3CDA [Email protected]@[email protected]@@z () 13f87a80c mysqld.exe!handle_connection () 1402d5932 [em Ail protected][email protected][email protected]@[email protected]@@[email protected] @[email protected] () 13ffe7e6c mysqld.exe!my_thread_once () 7fef56e4f7f Msvcr120.dll!_beginthreadex () 7fef56e5126 Msvcr120.dll!_endthreadex () 7703f34d kernel32.dll! Basethreadinitthunk () 77172cc1 ntdll.dll! Rtluserthreadstart () Trying to get some variables. Some pointers may is invalid and cause the dump to abort. Query (E881F30): UPDATE ' system_lane_type ' SET ' lane_type ' = ' Lane8 ' WHERE (' lane_type_id ' = ' 3 ') Connection ID (thread ID): 3 Status:not_killedthe manual page at http://dev.mysql.com/doc/mysql/en/crashing.html containsinformationThat's should help you find out what's causing the crash. 

In the middle after a variety of attempts, finally after Google Google Google find a solution, install SP1 patch on it, Microsoft official download: Windows6.1-kb976932-x64.exe

Here are the 2 articles found:

https://bugs.mysql.com/bug.php?id=81538

http://www.talkwithtrend.com/Question/405405

Problems with MySQL server auto-disconnection

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.