ob-ce-4.0.0
ob [test]>set session ob_trx_timeout = 12000000;
ob [test]>begin;
Query OK, 0 rows affected (0.00 sec)
<--- 停顿超过12秒
ob [test]>insert into t1 select rand()*1024;
ERROR 4012 (25000): Transaction timeout occurred, please rollback the transaction, set the variable ob_trx_timeout to a larger value and then restart the transaction
ob [test]>select * from t1;
ERROR 4012 (25000): Transaction timeout occurred, please rollback the transaction, set the variable ob_trx_timeout to a larger value and then restart the transaction
ob [test]>commit; <--手动执行commit,被强制当做rollback处理了,而不是继续报错
ERROR 6002 (40000): Transaction rollbacked
ob [test]>select * from t1;
Empty set (0.00 sec)