ORA-01591: lock held by in-doubt distributed transaction string

ORA-01591: lock held by in-doubt distributed transaction string
Cause: Trying to access resource that is locked by a dead two-phase commit transaction that is in prepared state.
Action: DBA should query the pending_trans$ and related tables, and attempt to repair network connection(s) to coordinator and commit point. If timely repair is not possible, DBA should contact DBA at commit point if known or end user for correct outcome, or use heuristic default if given to issue a heuristic commit or abort command to finalize the local portion of the distributed transaction.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01591：由不确定的分布式事务字符串保持的锁,
.原因：尝试访问由处于准备状态的死的两阶段提交事务锁定的资源。,
.操作： DBA应查询pending_trans $和相关表，并尝试修复与协调器和落实点的网络连接。如果不能及时修复，DBA应在提交点（如果已知或最终用户获得正确结果）与DBA联系，或者如果给定发出启发式提交或中止命令以完成分布式事务的本地部分，则使用启发式默认值。,
.

aiaiDBA

13718043309

010-86462881

ORA-01591: lock held by in-doubt distributed transaction string

1 个回答

相似问题