java.sql.SQLSyntaxErrorException: ORA-02049: 超时: 分布式事务处理等待锁处理

最新推荐文章于 2024-02-29 22:18:16 发布

孙海龙_1982

最新推荐文章于 2024-02-29 22:18:16 发布

阅读量2.1k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/card_2005/article/details/8108922

ORACLE TROUBLESHOOTING 专栏收录该内容

8 篇文章

订阅专栏

应用发版后部分服务器重启导致应用服务器启动时出现ORA-02049错误，提示超时等待分布式事务处理锁。此问题通常由并发操作引起，建议等待分布式_lock_timeout秒后再尝试，一般情况下会自动恢复。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

**** Error 星期四十月 25 01:23:36 CST 2012 1351099416103 /atg/dynamo/messaging/SqlJmsProvider --- java.sql.SQLSyntaxErrorException: ORA-02049: 超时: 分布式事务处理等待锁
**** Error 星期四十月 25 01:23:36 CST 2012 1351099416103 /atg/dynamo/messaging/SqlJmsProvider

**** Error 星期四十月 25 01:23:36 CST 2012 1351099416103 /atg/dynamo/messaging/SqlJmsProvider

.....

应用发版部分服务器重启，应用服务器启动报错“超时: 分布式事务处理等待锁”，根据ORACLE官方的说法这是避免死锁的一种机制

遇到这种问题时等一会（至少等distributed_lock_timeout那么久吧，所以这个值设置过大会导致一些不可知的风险），再次尝试会自动恢复。

Error:  ORA 2049
Text:   timeout: distributed transaction waiting for lock
-------------------------------------------------------------------------------
Cause:  Exceeded <Parameter:DISTRIBUTED_LOCK_TIMEOUT> seconds waiting for lock.
Action: treat as a deadlock
 

*** Important: The notes below are for experienced users - See Note:22080.1

Explanation:
	Ignore the "Action" above - this is non-sense.

	Basically ORA 2049 is signalled if:

        a) you are waiting on another sessions TX enqueue
           (Eg: usually you are waiting for a row lock)

   AND  b) you are performing a distributed operation.
           Eg: You are using a DB link for something, even if it is only a
                select

   AND  c) You wait for longer than 'distributed_lock_timeout'

    The use of a DB Link opens you up to distributed rules of operation 
    even if you only READ from it.
 
    You can either increase the timeout OR handle the ORA 2049 as a 'try again' 
    exception that is not fatal. This mechanism exists to prevent deadlock 
    so any handling of 'TRY AGAIN' should include an escape clause to prevent 
    deadlock. 


Example:
    Session 1                                Session 2
    ~~~~~~~~~				     ~~~~~~~~~
    update t2@LINK set b=4 where b=3;                                          
                                             select * from dual@LINK;          
                                             update t2 set b=4 where b=3;      
                                             ^^ ORA 2049                       
  OR EVEN 
    update t2 set b=4 where b=3;                                               
                                             select * from dual@LINK;          
                                             update t2 set b=4 where b=3;      
                                             ^^ ORA 2049