polardbx-sql
polardbx-sql copied to clipboard
Error: Lock wait timeout exceeded; try restarting transaction.
The error message is as follows:
ERR-CODE: [TDDL-4614][ERR_EXECUTE_ON_MYSQL] Error occurs when execute on GROUP 'SNOWBERG_PRE_000004_GROUP' ATOM 'dskey_snowberg_pre_000004_group#pxc-xdb-s-pxchzr468jpnxhjv48be8#11.61.195.2-3315#snowberg_pre_000004': Lock wait timeout exceeded; try restarting transaction.
看起来是行锁等待超时了,可能是其他事务占用了行锁,并且长期没有commit。show trans 看一下有没有长事务
没有发现任何相关的事务呀,只有获取 TSO 的事务。