执行预处理:
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做事务的一致性,然后报出该异常。
看到的情况是有三个事务在一次操作中。
有请大神了~~~
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。