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/25 02:26:18 UTC
[GitHub] [shardingsphere] xeoro opened a new issue, #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
xeoro opened a new issue, #17925:
URL: https://github.com/apache/shardingsphere/issues/17925
## Bug Report.
### Which version of ShardingSphere did you use?
5.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
rules:
- !SHARDING
tables:
car_info:
actualDataNodes: ds_0.car_info_${1..8}
tableStrategy:
standard:
shardingColumn: city_id
shardingAlgorithmName: car_info_inline
keyGenerateStrategy:
column: id
keyGeneratorName: carauto
bindingTables:
- car_info
defaultTableStrategy:
none:
shardingAlgorithms:
car_info_inline:
type: INLINE
props:
algorithm-expression: car_info_${city_id}
keyGenerators:
carauto:
type: CarautoKeyGen
scalingName: default_scaling
scaling:
default_scaling:
input:
workerThread: 40
batchSize: 1000
output:
workerThread: 40
batchSize: 1000
streamChannel:
type: MEMORY
props:
block-queue-size: 10000
completionDetector:
type: IDLE
props:
incremental-task-idle-minute-threshold: 30
dataConsistencyChecker:
type: DATA_MATCH
props:
chunk-size: 1000
[ERROR] 2022-05-25 10:09:15.639 [Connection-2-ThreadExecutor] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
Accumulated 100K+ files are all the same error
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
URL: https://github.com/apache/shardingsphere/issues/17925
--
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
[GitHub] [shardingsphere] terrymanu commented on issue #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #17925:
URL: https://github.com/apache/shardingsphere/issues/17925#issuecomment-1159481455
Closed because of no feedback for long time
--
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
[GitHub] [shardingsphere] bobogreentea commented on issue #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
Posted by GitBox <gi...@apache.org>.
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
[GitHub] [shardingsphere] TeslaCN commented on issue #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #17925:
URL: https://github.com/apache/shardingsphere/issues/17925#issuecomment-1136663227
Could you show us your SQL?
--
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
[GitHub] [shardingsphere] jingshanglu commented on issue #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #17925:
URL: https://github.com/apache/shardingsphere/issues/17925#issuecomment-1139221096
@bobogreentea Is it the same to #16894?
--
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
[GitHub] [shardingsphere] bobogreentea commented on issue #17925: About ShardingHere-Proxy Lock Wait Time Out Exceeded; try restarting transaction
Posted by GitBox <gi...@apache.org>.
bobogreentea commented on issue #17925:
URL: https://github.com/apache/shardingsphere/issues/17925#issuecomment-1138041363
--
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