好的,附件太大,网盘地址见私信(网盘文件有效期24小时) ,感谢
tidb中丢失的数据为 :
select pid,id,buyer_id,create_at,update_at from mt_order where id = 1389564502787260468 and buyer_id=127194221;
+-----------+---------------------+-----------+---------------------+---------------------+
| pid | id | buyer_id | create_at | update_at |
+-----------+---------------------+-----------+---------------------+---------------------+
| 285563777 | 1389564502787260468 | 127194221 | 2020-06-16 14:48:18 | 2020-06-16 15:41:04 |
+-----------+---------------------+-----------+---------------------+---------------------+
下游tidb中表结构为:
CREATE TABLE `mt_order` (
`pid` bigint(20) unsigned NOT NULL ,
`id` bigint(20) unsigned NOT NULL ,
`union_order` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`flag` tinyint(4) NOT NULL DEFAULT '0' ,
`buyer_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`recv_mobile` varchar(20) NOT NULL DEFAULT '' ,
`mall_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`goods_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`goods_icon` varchar(200) NOT NULL DEFAULT '' ,
`goods_sku_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`goods_spec_desc` varchar(128) NOT NULL DEFAULT '' ,
`goods_snap_id` char(128) NOT NULL DEFAULT '' ,
`goods_group_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`goods_group_size` int(10) unsigned NOT NULL DEFAULT '1' ,
`out_sku_sn` varchar(100) DEFAULT '' ,
`goods_unit_price` int(10) unsigned NOT NULL DEFAULT '1' ,
`goods_quantity` int(11) unsigned NOT NULL DEFAULT '1' ,
`goods_ship_limit_seconds` int(10) unsigned NOT NULL DEFAULT '24' ,
`goods_cat_id` int(11) NOT NULL DEFAULT '0' ,
`success_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`pay_success_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`process_status` int(11) unsigned NOT NULL DEFAULT '0' ,
`finished_status` int(11) unsigned NOT NULL DEFAULT '0' ,
`finish_on_refund_end` tinyint(4) NOT NULL DEFAULT '0' ,
`refund_status` int(11) unsigned NOT NULL DEFAULT '0' ,
`lock_status` int(11) unsigned NOT NULL DEFAULT '0' ,
`lucky_draw_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`lucky_deadline` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`group_order_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`group_deadline` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`ship_deadline` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`buyer_remark` varchar(512) NOT NULL DEFAULT '' ,
`recv_type` tinyint(4) NOT NULL DEFAULT '0' ,
`auto_sign` tinyint(4) NOT NULL DEFAULT '0' ,
`forbid_refund` tinyint(4) NOT NULL DEFAULT '0' ,
`address_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`address_snap_id` char(128) NOT NULL DEFAULT '' ,
`custom_addr_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`mall_confirm_deadline` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`mall_confirm_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`buyer_confirm_deadline` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`buyer_confirm_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`buyer_confirm_delay_count` tinyint(4) NOT NULL DEFAULT '0' ,
`review_deadline` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`buyer_review_count` tinyint(4) NOT NULL DEFAULT '0' ,
`payment_deadline` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`payment_money_type` tinyint(4) NOT NULL DEFAULT '0' ,
`payment_total` int(10) unsigned NOT NULL DEFAULT '0' ,
`payment_express` int(10) unsigned NOT NULL DEFAULT '0' ,
`payment_system_discount` int(10) unsigned NOT NULL DEFAULT '0' ,
`payment_activity_discount` int(10) unsigned NOT NULL DEFAULT '0' ,
`payment_mall_discount` int(10) unsigned NOT NULL DEFAULT '0' ,
`mall_coins_discount` int(10) unsigned NOT NULL DEFAULT '0' ,
`system_coins_discount` int(10) unsigned NOT NULL DEFAULT '0' ,
`payment_cash_card` int(11) unsigned NOT NULL DEFAULT '0' ,
`payment_method` tinyint(4) NOT NULL DEFAULT '0' ,
`payment_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`coupon_desc` varchar(128) NOT NULL DEFAULT '' ,
`activity_desc` varchar(128) NOT NULL DEFAULT '' ,
`logistic_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`aftersale_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`activity_type` int(11) NOT NULL DEFAULT '0' ,
`activity_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`activity_snap_id` char(128) NOT NULL DEFAULT '' ,
`invite_from_attender_id` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`is_hide` tinyint(4) NOT NULL DEFAULT '0' ,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' ,
`is_bot` tinyint(4) NOT NULL DEFAULT '0' ,
`platform` tinyint(3) unsigned NOT NULL DEFAULT '0' ,
`subsidy` int(10) unsigned NOT NULL DEFAULT '0' ,
`mod_subsidy` int(10) unsigned NOT NULL DEFAULT '0' ,
`ext_goods_id` varchar(50) NOT NULL DEFAULT '' ,
`seq` bigint(20) unsigned NOT NULL DEFAULT '0' ,
`client_ip` varchar(64) NOT NULL DEFAULT '' ,
`device` varchar(200) NOT NULL DEFAULT '' ,
`sign_reward_coin` int(10) unsigned NOT NULL DEFAULT '0' ,
`create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`payment_fee` int(10) unsigned NOT NULL DEFAULT '0' ,
`service_fee` int(10) unsigned NOT NULL DEFAULT '0' ,
`td` bigint(20) NOT NULL DEFAULT '0' ,
UNIQUE KEY `uk_pid` (`pid`),
KEY `idx_id` (`id`),
KEY `sd_status` (`ship_deadline`,`process_status`),
KEY `ucd_status` (`buyer_confirm_deadline`,`process_status`),
KEY `pd_status` (`payment_deadline`,`process_status`),
KEY `create_at` (`create_at`),
KEY `goods_recv_mobile_status` (`goods_id`,`recv_mobile`,`process_status`),
KEY `seq` (`seq`),
KEY `activity` (`activity_id`),
KEY `buyer_id` (`buyer_id`),
KEY `mall_id` (`mall_id`,`success_time`),
KEY `group_order_id` (`group_order_id`),
KEY `ext_goods_id` (`ext_goods_id`),
KEY `recv_mobile` (`recv_mobile`),
KEY `mall_status_success` (`mall_id`,`process_status`,`success_time`,`is_bot`),
KEY `union_order` (`union_order`),
KEY `mallid_update_at` (`mall_id`,`update_at`),
KEY `update_at` (`update_at`),
KEY `order_rds_mid_create_at` (`mall_id`,`is_bot`,`is_deleted`,`create_at`),
KEY `order_rds_mid_success_time` (`mall_id`,`is_bot`,`is_deleted`,`success_time`),
KEY `order_rds_mid_ship_deadline` (`mall_id`,`is_bot`,`is_deleted`,`ship_deadline`),
KEY `order_rds_mid_confirm_time` (`mall_id`,`is_bot`,`is_deleted`,`buyer_confirm_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin/*!90000 SHARD_ROW_ID_BITS=4 */ COMMENT=''