程序没有用事务进行处理过SQL。都是很普通的SQL文。请问为什么会出现这个问题??MySql.Data.MySqlClient.MySqlException: Deadlock found when trying to get lock; try restarting transaction
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
解决方案 »
- 关于Linux系统下遇到的MySql问题,求指导
- mysql算法问题--大流量下找不同点
- 相匹配6位字母加2位数字怎么写正则表达式
- 插入数据 DELAYED INTO ON DUPLICATE KEY UPDATE
- 让我郁闷的mysql
- mysql root权限不小心被干掉了,已经访问不了权限数据库'mysql'了,请问如何恢复?
- mysql怎么给用户权限?
- 为什么mysql数据库里"卖"跟"买"字分辨不出来?
- [求助],MySQL本机启动,无法连接MySQL服务器问题
- innodb 与myisam能否混用?
- mysql, find_in_set 查询速度相当慢 ,in()又数据不全?有没有更合适的办法
- postgresql能否将bigint转换成date
需要访问并且进行操作的表,被别的事务锁住了,导致一直无法获得加锁的请求,而出现死锁建议检查下是不是有表被某事务操作了而忘记执行commit了,或者你服务器端进行执行某操作,加了表级别的锁 或锁住很大范围的数据#****************************************#
MySQL技术及运维自动化网:www.mysqlops.com新浪微博账号:http://weibo.com/mysqlops
#****************************************#