In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
What if the mysql update fails? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!
The solution to the failure of mysql update is to open the command window first, and then solve it by executing the "select * from information_schema.innodb_trx kill 15758" statement.
Mysql update error
Today, when I was at work, I found that a field in a update table timed out. I thought about it for a long time. The first thing I thought of was to extend the operation time:
Mysql > set innodb_lock_wait_timeout=100mysql > show variables like 'innodb_lock_wait_timeout'
However, although the time has been extended, the problem has not been solved. I looked around on the Internet and found that it may be that the mysql transaction was not committed, resulting in locking the table. the solution is as follows:
Select * from information_schema.innodb_trxkill 15758
Of which 15758 is the id of thread
Thank you for reading! After reading the above, do you have a general idea of what to do if the mysql update fails? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.