【 使用环境 】生产环境
【 OB or 其他组件 】OMS
【 使用版本 】4.2.2_CE
OB 4.x
mysql 5.7.25
OB-> Mysql
OB同步到mysql，出现数据不一致问题，下游记录了所有表的SQL语句，
表schema
针对出错的这一行，当前OB中的数据是
24377:gifshow.pay_order_77 30190552 2415200092889077 2415200092889077 0 2415200092894077 40 999 CNY 0 1717129617277 1717129783017 1 OSP667940130167654577 2000 CSPiup625334654308715871 {“accountGroupKey”:null,“accountId”:“872484077”,“attach”:"{“1”:872484077,“2”:1,“3”:0}",“code”:null,“createTime”:null,“currencyType”:“CNY”,“data”:"{“GUIDE_INFO”:{“out_order_no”:“2415200092894077”,“sign_agreement”:{“sign_product”:“FAMILY_CARD”,“account_id”:“872484077”,“agreement_type”:“PASSWORD_FREE”,“provider”:“ALIPAY”,“merchant_id”:“GM712131691323525399”,“source”:“FROM_KUAISHOU_AFTER_PAY”,“account_group_key”:“BUYER_AGREEMENT”}},“PAY_AMOUNT_INFO”:{“kspay_promo_discount_amount”:0,“book_balance_pay_amount”:0,“actual_pay_amount”:8634,“provider_promo_discount_amount”:0},“CASHIER_SOURCE_TAG”:“INTEGRATE_IN_APP”,“GATEWAY_FUND_BILL”:"{\“provider\”:\“ALIPAY\”,\“amount\”:999,\“actual_pay_amount\”:999,\“payment_method\”:\“IN_APP\”,\“provider_trade_no\”:\“CSPiup625334654308715871\”,\“provider_pay_amount\”:8634,\“book_balance_pay_amount\”:0,\“provider_user_id\”:\“2088502451695511\”,\“provider_channel_type\”:\“NORMAL\”}",“MERGE_PAY_INFO”:"{}",“OUT_SETTLE_PARAM”:{“settle_params”:[{“amount”:2000,“receiver_params_post_position”:true,“seller_account_id”:“533844912”,“goods_infos”:[{“first_category_id”:“1164”,“goods_name”:“家会香生巧福团（全场满19.9包邮）”,“leaf_category_id”:“1165”,“goods_quantity”:20,“goods_category”:“其他零食/坚果/特产”,“goods_id”:“20257194906912”,“goods_type”:“PHY”,“goods_unit_price”:100,“has_buy_insurance”:false}],“account_group_key”:“MERCHANT_SELLER”,“out_sub_order_no”:“2415200092886077”},{“amount”:399,“receiver_params_post_position”:true,“seller_account_id”:“533844912”,“goods_infos”:[{“first_category_id”:“1164”,“goods_name”:“金币巧克力（全场满19.9包邮）”,“leaf_category_id”:“8311”,“goods_quantity”:1,“goods_category”:“DIY/手工巧克力”,“goods_id”:“15475706072912”,“goods_type”:“PHY”,“goods_unit_price”:399,“has_buy_insurance”:false}],“account_group_key”:“MERCHANT_SELLER”,“out_sub_order_no”:“2415200092888077”},{“amount”:1588,“receiver_params_post_position”:true,“seller_account_id”:“533844912”,“goods_infos”:[{“first_category_id”:“1164”,“goods_name”:“景旭鱿鱼仔半籽250克（全场满19.9包邮）”,“leaf_category_id”:“8300”,“goods_quantity”:1,“goods_category”:“其他即食水产/海味零食”,“goods_id”:“3781711965912”,“goods_type”:“PHY”,“goods_unit_price”:1588,“has_buy_insurance”:false}],“account_group_key”:“MERCHANT_SELLER”,“out_sub_order_no”:“2415200092890077”},{“amount”:1596,“receiver_params_post_position”:true,“seller_account_id”:“533844912”,“goods_infos”:[{“first_category_id”:“1346”,“goods_name”:“749同福记酸辣粉135克（全场满19.9包邮）”,“leaf_category_id”:“8186”,“goods_quantity”:4,“goods_category”:“冲泡方便面/拉面/面皮/面饼”,“goods_id”:“21910338805912”,“goods_type”:“PHY”,“goods_unit_price”:399,“has_buy_insurance”:false}],“account_group_key”:“MERCHANT_SELLER”,“out_sub_order_no”:“2415200092892077”},{“amount”:552,“receiver_params_post_position”:true,“seller_account_id”:“533844912”,“goods_infos”:[{“first_category_id”:“1164”,“goods_name”:“769小腿王鸭翅根（全场满19.9包邮）”,“leaf_category_id”:“8279”,“goods_quantity”:4,“goods_category”:“鸡肉制品”,“goods_id”:“21446373232912”,“goods_type”:“PHY”,“goods_unit_price”:138,“has_buy_insurance”:false}],“account_group_key”:“MERCHANT_SELLER”,“out_sub_order_no”:“2415200092887077”},{“amount”:999,“receiver_params_post_position”:true,“seller_account_id”:“533844912”,“goods_infos”:[{“first_category_id”:“1164”,“goods_name”:“591熊三岁巧克力脆筒328克（全场满19.9包邮）”,“leaf_category_id”:“8311”,“goods_quantity”:1,“goods_category”:“DIY/手工巧克力”,“goods_id”:“21186893597912”,“goods_type”:“PHY”,“goods_unit_price”:999,“has_buy_insurance”:false}],“account_group_key”:“MERCHANT_SELLER”,“out_sub_order_no”:“2415200092889077”},{“amount”:1500,“receiver_params_post_position”:true,“seller_account_id”:“533844912”,“goods_infos”:[{“first_category_id”:“1164”,“goods_name”:“百 吉福奶酪棒单支（全场满19.9包邮）”,“leaf_category_id”:“1165”,“goods_quantity”:10,“goods_category”:“其他零食/坚果/特产”,“goods_id”:“21076287502912”,“goods_type”:“PHY”,“goods_unit_price”:150,“has_buy_insurance”:false}],“account_group_key”:“MERCHANT_SELLER”,“out_sub_order_no”:“2415200092891077”}],“need_merge_pay”:true}}",“merchantId”:“GM712131691323525399”,“msg”:null,“notifyTime”:1717129617286,“oppositeAccount”:null,“oppositeAccountName”:null,“orderAmount”:999,“orderPayNo”:“OSP667940130167654577”,“orderState”:“SUCCESS”,“orderStateDesc”:“支付成功”,“outOrderNo”:“2415200092894077”,“paymentTime”:1717129617277,“settleChannel”:“KSPAY_GATEWAY”,“sign”:null,“version”:“1.0”} KWAISHOP 533844912 533844912 872484077 {“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21186893597912,“skuNum”:1,“skuPrice”:999},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:999,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“refunds”:[{“refundFee”:999,“refundOutBizNo”:“2415200161516077_FEO1619023515”,“refundPrepaidCardAmount”:0}],“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false} 0 2 1717129603185 1717129689004 1 {“agreementType”:“PASSWORD_FREE”,“payChannelCode”:“ALIPAY”,“paymentMethod”:“IN_APP”,“provider”:“ALIPAY”,“providerChannelType”:“NORMAL”,“providerProductCode”:“PINGAN_JZB”,“settleChannel”:“KSPAY_GATEWAY”} 0 999 0 2024-05-31 12:28:09
但是在下游MySQL中显示是
24377:gifshow.pay_order_77 | 30190552 | 2415200092889077 | 2415200092889077 | 0 | 2415200092894077 | 40 | 999 | CNY | 0 | | 1717129617277 | 1717129783017 | 1 | OSP667940130167654577 | 2000 | CSPiup625334654308715871 | | KWAISHOP | 533844912 | 533844912 | 872484077 | {“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21186893597912,“skuNum”:1,“skuPrice”:999},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:999,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“refunds”:[{“refundFee”:999,“refundOutBizNo”:“2415200161516077_FEO1619023515”,“refundPrepaidCardAmount”:0}],“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false} | 0 | | 2 | 1717129603185 | 1717129689004 | 1 | {“agreementType”:“PASSWORD_FREE”,“payChannelCode”:“ALIPAY”,“paymentMethod”:“IN_APP”,“provider”:“ALIPAY”,“providerChannelType”:“NORMAL”,“providerProductCode”:“PINGAN_JZB”,“settleChannel”:“KSPAY_GATEWAY”} | 0 | | 999 | 0 | | 2024-05-31 12:28:09 |
下面是对这一行的所有更新语句，最后一次UPDATE操作将pay_gate_notify_info设置成了NULL，其它的值更新能够对应上，这样的错误不止出现这一行，在OB中是有对应的值的，上下游的数据不一致
INSERT INTO kwaishoppaycenterpayorder.pay_order (_hd_shard,id,pay_order_id,order_id,sub_order_id,cart_id,status,pay_fee,currency_type,discount_amount,discount_detail,pay_time,pay_timeout,pay_gate,pay_gate_oid,pay_channel,pay_channel_oid,pay_gate_notify_info,business_line,shop_id,seller_id,buyer_id,attributes,attributes_cc,return_data,version,create_time,update_time,pay_biz_type,pay_channel_detail,sub_status,pay_scene,actual_pay_fee,pay_balance,pay_balance_detail,ob_modify_time) VALUES (‘24377:gifshow.pay_order_77’,‘30190546’,‘2415200092894077’,‘2415200092894077’,‘0’,‘2415200092894077’,‘10’,‘8634’,‘CNY’,‘0’,null,‘0’,‘1717129783017’,‘1’,’’,‘0’,’’,null,‘KWAISHOP’,‘0’,‘0’,‘872484077’,’{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:2,“grayType”:1,“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:8634,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’,‘0’,’’,‘0’,‘1717129603185’,‘1717129603185’,‘1’,null,‘0’,’’,‘0’,‘0’,null,‘2024-05-31 12:26:43’),(‘24377:gifshow.pay_order_77’,‘30190549’,‘2415200092890077’,‘2415200092890077’,‘0’,‘2415200092894077’,‘10’,‘1588’,‘CNY’,‘0’,null,‘0’,‘1717129783017’,‘1’,’’,‘0’,’’,null,‘KWAISHOP’,‘533844912’,‘533844912’,‘872484077’,’{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:3781711965912,“skuNum”:1,“skuPrice”:1588},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:1588,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’,‘0’,’’,‘0’,‘1717129603185’,‘1717129603185’,‘1’,null,‘0’,’’,‘0’,‘0’,null,‘2024-05-31 12:26:43’),(‘24377:gifshow.pay_order_77’,‘30190548’,‘2415200092888077’,‘2415200092888077’,‘0’,‘2415200092894077’,‘10’,‘399’,‘CNY’,‘0’,null,‘0’,‘1717129783017’,‘1’,’’,‘0’,’’,null,‘KWAISHOP’,‘533844912’,‘533844912’,‘872484077’,’{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:15475706072912,“skuNum”:1,“skuPrice”:399},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:399,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’,‘0’,’’,‘0’,‘1717129603185’,‘1717129603185’,‘1’,null,‘0’,’’,‘0’,‘0’,null,‘2024-05-31 12:26:43’),(‘24377:gifshow.pay_order_77’,‘30190553’,‘2415200092891077’,‘2415200092891077’,‘0’,‘2415200092894077’,‘10’,‘1500’,‘CNY’,‘0’,null,‘0’,‘1717129783017’,‘1’,’’,‘0’,’’,null,‘KWAISHOP’,‘533844912’,‘533844912’,‘872484077’,’{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21076287502912,“skuNum”:10,“skuPrice”:150},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:1500,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’,‘0’,’’,‘0’,‘1717129603185’,‘1717129603185’,‘1’,null,‘0’,’’,‘0’,‘0’,null,‘2024-05-31 12:26:43’),(‘24377:gifshow.pay_order_77’,‘30190550’,‘2415200092892077’,‘2415200092892077’,‘0’,‘2415200092894077’,‘10’,‘1596’,‘CNY’,‘0’,null,‘0’,‘1717129783017’,‘1’,’’,‘0’,’’,null,‘KWAISHOP’,‘533844912’,‘533844912’,‘872484077’,’{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21910338805912,“skuNum”:4,“skuPrice”:399},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:1596,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’,‘0’,’’,‘0’,‘1717129603185’,‘1717129603185’,‘1’,null,‘0’,’’,‘0’,‘0’,null,‘2024-05-31 12:26:43’),(‘24377:gifshow.pay_order_77’,‘30190547’,‘2415200092886077’,‘2415200092886077’,‘0’,‘2415200092894077’,‘10’,‘2000’,‘CNY’,‘0’,null,‘0’,‘1717129783017’,‘1’,’’,‘0’,’’,null,‘KWAISHOP’,‘533844912’,‘533844912’,‘872484077’,’{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:20257194906912,“skuNum”:20,“skuPrice”:100},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:2000,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’,‘0’,’’,‘0’,‘1717129603185’,‘1717129603185’,‘1’,null,‘0’,’’,‘0’,‘0’,null,‘2024-05-31 12:26:43’),(‘24377:gifshow.pay_order_77’,‘30190551’,‘2415200092887077’,‘2415200092887077’,‘0’,‘2415200092894077’,‘10’,‘552’,‘CNY’,‘0’,null,‘0’,‘1717129783017’,‘1’,’’,‘0’,’’,null,‘KWAISHOP’,‘533844912’,‘533844912’,‘872484077’,’{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21446373232912,“skuNum”:4,“skuPrice”:138},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:552,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’,‘0’,’’,‘0’,‘1717129603185’,‘1717129603185’,‘1’,null,‘0’,’’,‘0’,‘0’,null,‘2024-05-31 12:26:43’),(‘24377:gifshow.pay_order_77’,‘30190552’,‘2415200092889077’,‘2415200092889077’,‘0’,‘2415200092894077’,‘10’,‘999’,‘CNY’,‘0’,null,‘0’,‘1717129783017’,‘1’,’’,‘0’,’’,null,‘KWAISHOP’,‘533844912’,‘533844912’,‘872484077’,’{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21186893597912,“skuNum”:1,“skuPrice”:999},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:999,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’,‘0’,’’,‘0’,‘1717129603185’,‘1717129603185’,‘1’,null,‘0’,’’,‘0’,‘0’,null,‘2024-05-31 12:26:43’)
PDATE kwaishoppaycenterpayorder.pay_order SET _hd_shard = ‘24377:gifshow.pay_order_77’, id = ‘30190552’, pay_order_id = ‘24152 00092889077’, order_id = ‘2415200092889077’, sub_order_id = ‘0’, cart_id = ‘2415200092894077’, status = ‘20’, pay_fee = ‘999’, currency_type = ‘CNY’, discount_amount = ‘0’, discount_detail = null, pay_time = ‘1717129617277’, pay_timeout = ‘1717129783017’, pay_gate = ‘1’, pay_gate_oid = ‘OSP667940130167654577’, pay_channel = ‘2000’, pay_channel_oid = ‘CSPiup625334654308715871’, pay_gate_notify_info = ‘{“accountGroupKey” :null,“accountId”:“872484077”,“attach”:"{\“1\”:872484077,\“2\”:1,\“3\”:0}",“code”:null,“createTime”:null,“currencyType”:“CNY”,“data”:"{\“GUIDE_INFO\”:{\“out_order_no\”:\“2415200092894077\”,\“sign_agreement\”:{\" sign_product\":\“FAMILY_CARD\”,\“account_id\”:\“872484077\”,\“agreement_type\”:\“PASSWORD_FREE\”,\“provider\”:\“ALIPAY\”,\“merchant_id\”:\“GM712131691323525399\”,\“source\”:\“FROM_KUAISHOU_AFTER_PAY\”,\ “account_group_key\”:\“BUYER_AGREEMENT\”}},\“PAY_AMOUNT_INFO\”:{\“kspay_promo_discount_amount\”:0,\“book_balance_pay_amount\”:0,\“actual_pay_amount\”:8634,\“provider_promo_discount_amount\”:0},\“CASHIER_SOURCE_TA G\”:\“INTEGRATE_IN_APP\”,\“GATEWAY_FUND_BILL\”:\"{\\\“provider\\\”:\\\“ALIPAY\\\”,\\\“amount\\\”:999,\\\“actual_pay_amount\\\”:999,\\\“payment_method\\\”:\\\“IN_APP\\\”,\\\“provider _trade_no\\\”:\\\“CSPiup625334654308715871\\\”,\\\“provider_pay_amount\\\”:8634,\\\“book_balance_pay_amount\\\”:0,\\\“provider_user_id\\\”:\\\“2088502451695511\\\”,\\\“provider_channel_type\ \\”:\\\“NORMAL\\\”}\",\“MERGE_PAY_INFO\”:\"{}\",\“OUT_SETTLE_PARAM\”:{\“settle_params\”:[{\“amount\”:2000,\“receiver_params_post_position\”:true,\“seller_account_id\”:\“533844912\”,\“goods_infos\”:[ {\“first_category_id\”:\“1164\”,\“goods_name\”:\“家会香生巧福团（全场满19.9包邮）\”,\“leaf_category_id\”:\“1165\”,\“goods_quantity\”:20,\“goods_category\”:\“其他零食/坚果/特产\”,\“goods_id\”:\“202571949069 12\”,\“goods_type\”:\“PHY\”,\“goods_unit_price\”:100,\“has_buy_insurance\”:false}],\“account_group_key\”:\“MERCHANT_SELLER\”,\“out_sub_order_no\”:\“2415200092886077\”},{\“amount\”:399,\“receiver_params_post _position\”:true,\“seller_account_id\”:\“533844912\”,\“goods_infos\”:[{\“first_category_id\”:\“1164\”,\“goods_name\”:\“金币巧克力（全场满19.9包邮）\”,\“leaf_category_id\”:\“8311\”,\“goods_quantity\”:1,\“g oods_category\”:\“DIY/手工巧克力\”,\“goods_id\”:\“15475706072912\”,\“goods_type\”:\“PHY\”,\“goods_unit_price\”:399,\“has_buy_insurance\”:false}],\“account_group_key\”:\“MERCHANT_SELLER\”,\"out_sub_order_no\ “:\“2415200092888077\”},{\“amount\”:1588,\“receiver_params_post_position\”:true,\“seller_account_id\”:\“533844912\”,\“goods_infos\”:[{\“first_category_id\”:\“1164\”,\“goods_name\”:\“景旭鱿鱼仔半籽250克（全> 场满19.9包邮）\”,\“leaf_category_id\”:\“8300\”,\“goods_quantity\”:1,\“goods_category\”:\“其他即食水产/海味零食\”,\“goods_id\”:\“3781711965912\”,\“goods_type\”:\“PHY\”,\“goods_unit_price\”:1588,\“has_buy_i nsurance\”:false}],\“account_group_key\”:\“MERCHANT_SELLER\”,\“out_sub_order_no\”:\“2415200092890077\”},{\“amount\”:1596,\“receiver_params_post_position\”:true,\“seller_account_id\”:\“533844912\”,\“goods_info s\”:[{\“first_category_id\”:\“1346\”,\“goods_name\”:\“749同福记酸辣粉135克（全场满19.9包邮）\”,\“leaf_category_id\”:\“8186\”,\“goods_quantity\”:4,\“goods_category\”:\“冲泡方便面/拉面/面皮/面饼\”,\“goods_id\ “:\“21910338805912\”,\“goods_type\”:\“PHY\”,\“goods_unit_price\”:399,\“has_buy_insurance\”:false}],\“account_group_key\”:\“MERCHANT_SELLER\”,\“out_sub_order_no\”:\“2415200092892077\”},{\“amount\”:552,\“re ceiver_params_post_position\”:true,\“seller_account_id\”:\“533844912\”,\“goods_infos\”:[{\“first_category_id\”:\“1164\”,\“goods_name\”:\“769小腿王鸭翅根（全场满19.9包邮）\”,\“leaf_category_id\”:\“8279\”,\“g oods_quantity\”:4,\“goods_category\”:\“鸡肉制品\”,\“goods_id\”:\“21446373232912\”,\“goods_type\”:\“PHY\”,\“goods_unit_price\”:138,\“has_buy_insurance\”:false}],\“account_group_key\”:\“MERCHANT_SELLER\”,\” out_sub_order_no\”:\“2415200092887077\”},{\“amount\”:999,\“receiver_params_post_position\”:true,\“seller_account_id\”:\“533844912\”,\“goods_infos\”:[{\“first_category_id\”:\“1164\”,\“goods_name\”:\“591熊三> 岁巧克力脆筒328克（全场满19.9包邮）\”,\“leaf_category_id\”:\“8311\”,\“goods_quantity\”:1,\“goods_category\”:\“DIY/手工巧克力\”,\“goods_id\”:\“21186893597912\”,\“goods_type\”:\“PHY\”,\“goods_unit_price\”:99 9,\“has_buy_insurance\”:false}],\“account_group_key\”:\“MERCHANT_SELLER\”,\“out_sub_order_no\”:\“2415200092889077\”},{\“amount\”:1500,\“receiver_params_post_position\”:true,\“seller_account_id\”:\“533844912\” ,\“goods_infos\”:[{\“first_category_id\”:\“1164\”,\“goods_name\”:\“百 吉福奶酪棒单支（全场满19.9包邮）\”,\“leaf_category_id\”:\“1165\”,\“goods_quantity\”:10,\“goods_category\”:\“其他零食/坚果/特产\”,\“good s_id\”:\“21076287502912\”,\“goods_type\”:\“PHY\”,\“goods_unit_price\”:150,\“has_buy_insurance\”:false}],\“account_group_key\”:\“MERCHANT_SELLER\”,\“out_sub_order_no\”:\“2415200092891077\”}],\“need_merge_pay \”:true}}”,“merchantId”:“GM712131691323525399”,“msg”:null,“notifyTime”:1717129617286,“oppositeAccount”:null,“oppositeAccountName”:null,“orderAmount”:999,“orderPayNo”:“OSP667940130167654577”,“orderState”:“SUCCESS”,“orderStateD esc”:“支付成功”,“outOrderNo”:“2415200092894077”,“paymentTime”:1717129617277,“settleChannel”:“KSPAY_GATEWAY”,“sign”:null,“version”:“1.0”}’, business_line = ‘KWAISHOP’, shop_id = ‘533844912’, seller_id = ‘533844912’, buye r_id = ‘872484077’, attributes = ‘{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“ca rrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21186893597912,“skuNum”:1,“skuPrice”:999},“orderType”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:999,“orderTo talPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45 c8-8287-4f2015440ab2”,“zeroOrder”:false}’, attributes_cc = ‘0’, return_data = ‘’, version = ‘1’, create_time = ‘1717129603185’, update_time = ‘1717129617341’, pay_biz_type = ‘1’, pay_channel_detail = ‘{“agreement Type”:“PASSWORD_FREE”,“payChannelCode”:“ALIPAY”,“paymentMethod”:“IN_APP”,“provider”:“ALIPAY”,“providerChannelType”:“NORMAL”,“providerProductCode”:“PINGAN_JZB”,“settleChannel”:“KSPAY_GATEWAY”}’, sub_status = ‘0’, pay_scene = ‘’, actual_pay_fee = ‘999’, pay_balance = ‘0’, pay_balance_detail = null, ob_modify_time = ‘2024-05-31 12:26:57’ WHERE _hd_shard = ‘24377:gifshow.pay_order_77’ and id = ‘30190552’ and pay_order_id = ‘2415200092 889077’ and order_id = ‘2415200092889077’ and sub_order_id = ‘0’ and cart_id = ‘2415200092894077’ and status = ‘10’ and pay_fee = ‘999’ and currency_type = ‘CNY’ and discount_amount = ‘0’ and discount_detail is null and pay_time = ‘0’ and pay_timeout = ‘1717129783017’ and pay_gate = ‘1’ and pay_gate_oid = ‘’ and pay_channel = ‘0’ and pay_channel_oid = ‘’ and pay_gate_notify_info is null and business_line = ‘KWAISHOP’ and shop_id = ‘533844912’ and seller_id = ‘533844912’ and buyer_id = ‘872484077’ and attributes = ‘{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077,24 15200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21186893597912,“skuNum”:1,“skuPrice”:999},“orderType”:0,“payLoca tionType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:999,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSelect PaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’ and attributes_cc = ‘0’ and return_data = ‘’ and version = ‘0’ and create_time = ‘1717129603185’ and upd ate_time = ‘1717129603185’ and pay_biz_type = ‘1’ and pay_channel_detail is null and sub_status = ‘0’ and pay_scene = ‘’ and actual_pay_fee = ‘0’ and pay_balance = ‘0’ and pay_balance_detail is null and ob_modi fy_time = ‘2024-05-31 12:26:43’ LIMIT 1
UPDATE kwaishoppaycenterpayorder.pay_order SET _hd_shard = ‘24377:gifshow.pay_order_77’, id = ‘30190552’, pay_order_id = ‘24152 00092889077’, order_id = ‘2415200092889077’, sub_order_id = ‘0’, cart_id = ‘2415200092894077’, status = ‘40’, pay_fee = ‘999’, currency_type = ‘CNY’, discount_amount = ‘0’, discount_detail = null, pay_time = ‘1717129617277’, pay_timeout = ‘1717129783017’, pay_gate = ‘1’, pay_gate_oid = ‘OSP667940130167654577’, pay_channel = ‘2000’, pay_channel_oid = ‘CSPiup625334654308715871’, pay_gate_notify_info = null, business_lin e = ‘KWAISHOP’, shop_id = ‘533844912’, seller_id = ‘533844912’, buyer_id = ‘872484077’, attributes = ‘{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,2415200092887077 ,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21186893597912,“skuNum”:1,“skuPrice”:999},“orderType”:0,“payL ocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:999,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“ALIPAY”,“preSel ectPaymentMethod”:“IN_APP”,“refunds”:[{“refundFee”:999,“refundOutBizNo”:“2415200161516077_FEO1619023515”,“refundPrepaidCardAmount”:0}],“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’, attributes_cc = ‘0’, return_data = ‘’, version = ‘2’, create_time = ‘1717129603185’, update_time = ‘1717129689004’, pay_biz_type = ‘1’, pay_channel_detail = ‘{“agreementType”:“PASSWORD_FREE”,“payChannelCode”:“ALIP AY”,“paymentMethod”:“IN_APP”,“provider”:“ALIPAY”,“providerChannelType”:“NORMAL”,“providerProductCode”:“PINGAN_JZB”,“settleChannel”:“KSPAY_GATEWAY”}’, sub_status = ‘0’, pay_scene = ‘’, actual_pay_fee = ‘999’, pay_balance = ‘0’, pay_balance_detail = null, ob_modify_time = ‘2024-05-31 12:28:09’ WHERE _hd_shard = ‘24377:gifshow.pay_order_77’ and id = ‘30190552’ and pay_order_id = ‘2415200092889077’ and order_id = ‘2415200092889077’ and sub_order_id = ‘0’ and cart_id = ‘2415200092894077’ and status = ‘20’ and pay_fee = ‘999’ and currency_type = ‘CNY’ and discount_amount = ‘0’ and discount_detail is null and pay_time = ‘1717129617277’ and pay_timeout = ‘1717129783017’ and pay_gate = ‘1’ and pay_gate_oid = ‘OSP667940130167654577’ and pay_channel = ‘2000’ and pay_channel_oid = ‘CSPiup625334654308715871’ and pay_gate_notify_info is null and business_li ne = ‘KWAISHOP’ and shop_id = ‘533844912’ and seller_id = ‘533844912’ and buyer_id = ‘872484077’ and attributes = ‘{“bathRelationSubPayOrderIds”:[2415200092886077,2415200092888077,2415200092890077,2415200092892077,241 5200092887077,2415200092889077,2415200092891077],“budgetReduceTag”:0,“carrierInfo”:{“carrierId”:0,“carrierType”:0},“cpsInfo”:{“distributorId”:0},“grayType”:1,“itemDTO”:{“itemId”:21186893597912,“skuNum”:1,“skuPrice”:999},“order Type”:0,“payLocationType”:2000,“payOrderFeeDTO”:{“expressFee”:0,“goodsFee”:999,“orderTotalPaymentFee”:0},“payServiceAbility”:0,“payServiceScene”:0,“payTag”:“00000001”,“pinganB2bLargeAmountOrder”:false,“preSelectPayChannel”:“AL IPAY”,“preSelectPaymentMethod”:“IN_APP”,“relateOrderId”:0,“sessionId”:“69bf1fbb-94f1-45c8-8287-4f2015440ab2”,“zeroOrder”:false}’ and attributes_cc = ‘0’ and return_data = ‘’ and version = ‘1’ and create_time = ‘1717129 603185’ and update_time = ‘1717129617341’ and pay_biz_type = ‘1’ and pay_channel_detail = ‘{“agreementType”:“PASSWORD_FREE”,“payChannelCode”:“ALIPAY”,“paymentMethod”:“IN_APP”,“provider”:“ALIPAY”,“providerChannelType”:“NO RMAL”,“providerProductCode”:“PINGAN_JZB”,“settleChannel”:“KSPAY_GATEWAY”}’ and sub_status = ‘0’ and pay_scene = ‘’ and actual_pay_fee = ‘999’ and pay_balance = ‘0’ and pay_balance_detail is null and ob_modify_time = ‘2024-05-31 12:26:57’ LIMIT 1
【问题描述】