You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/05/26 01:20:37 UTC
[GitHub] [shardingsphere] bobogreentea commented on issue #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
bobogreentea commented on issue #17925:
URL: https://github.com/apache/shardingsphere/issues/17925#issuecomment-1138040326
error：org.ssssssss.script.exception.MagicScriptException: PreparedStatementCallback; SQL [update car_camera set camera_online = 1 where camera_id = ?]; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction at Row:3~3,Col:11~89
return db.update('update car_camera set camera_online = 1 where camera_id = #{serialno}');
"update car_camera set camera_online = 1 where camera_id = ?"?????
camera_online and camera_id They all have certain values
The concurrency is small, not large, but does the occurrence of this problem cause the above error? This is a very simple SQL statement ah!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org