开发者社区> 问答> 正文

DRDS 使用GTS事务之后,多条update同时执行报错 ErrorCode:4603

2018_01_19_15_28_47_

执行预处理:
Preparing: update erp_store_stock SET storehouse_id=?, product_id=?, stock_amount=?, stock_active=?, stock_lock=?, status=?, status_time=?, deposit_amount=?, stock_type=? where store_stock_id = ? and company_id=? ; update erp_store_stock SET storehouse_id=?, product_id=?, stock_amount=?, stock_active=?, stock_lock=?, status=?, status_time=?, deposit_amount=?, stock_type=? where store_stock_id = ? and company_id=? ; update erp_store_stock SET storehouse_id=?, product_id=?, stock_amount=?, stock_active=?, stock_lock=?, status=?, status_time=?, deposit_amount=?, stock_type=? where store_stock_id = ? and company_id=?

Parameters: 986(Integer), 1964509(Integer), 95(Integer), 95(Integer), 0(Integer), 00A(String), 2018-01-12 17:07:03.0(Timestamp), 77(Integer), null, 8802427(Integer), 287(Integer), 979(Integer), 1964511(Integer), 15(Integer), 15(Integer), 0(Integer), 00A(String), 2018-01-05 02:31:37.0(Timestamp), 20(Integer), null, 8870517(Integer), 287(Integer), 979(Integer), 1965967(Integer), 0(Integer), 0(Integer), 0(Integer), 00A(String), 2018-01-05 02:31:37.0(Timestamp), 2(Integer), null, 8871973(Integer), 287(Integer)

错误信息:
Cause: java.sql.SQLException: c5cfc2f23001000-8[erp]ERR-CODE: TDDL-4603 Transaction accross db is not supported in current transaction policy, transaction node is: ERP_1515085279201HUAUERP_TPXY_0000_RDS, but this sql execute on: ERP_1515085279201HUAUERP_TPXY_0003_RDS. More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4603]
5427 ; uncategorized SQLException for SQL []; SQL state [HY000]; error code [4603]; c5cfc2f23001000-8[erp]ERR-CODE: TDDL-4603 Transaction accross db is not supported in current transaction policy, transaction node is: ERP_1515085279201HUAUERP_TPXY_0000_RDS, but this sql execute on: ERP_1515085279201HUAUERP_TPXY_0003_RDS. More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4603]; nested exception is java.sql.SQLException: c5cfc2f23001000-8[erp]ERR-CODE: TDDL-4603 Transaction accross db is not supported in current transaction policy, transaction node is: ERP_1515085279201HUAUERP_TPXY_0000_RDS, but this sql execute on: ERP_1515085279201HUAUERP_TPXY_0003_RDS. More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4603]

具体情况是目前部分用了RDS,部分大表使用了DRDS,有多个数据源,代码为多个数据源配置了多个事务,全局使用GTS做事务的一致性,然后报出该异常。
看到的情况是有三个事务在一次操作中。
有请大神了~~~

展开
收起
一年庄铭南 2018-01-19 15:33:49 6703 0
1 条回答
写回答
取消 提交回答
  • 你已经是大神了

    2019-07-17 21:55:36
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
PolarDB-X分布式数据库解决方案 立即下载
PolarDB-X 2.0 全局 Binlog 与备份恢复能 立即下载
分布式数据库DRDS全新升级 立即下载