重现步骤
反馈人：袁慧斌
严重级别：严重
所属项目：hwy-zh-gz-lfw-datax
问题原因：同步数据SQL 没有加 nolock 同步主库 造成阻塞
select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID],[OtherAdvertisingFee],[OtherPlatformFee],[OtherYunCangFee],[OtherReturnFee],[DeliveryType],[DeliveryTypeDsec],[BreakageFee],[ExpenseSubCategory],[CustomStorageFee],[AffiliatePartnerCommissionFee],[FirstLegBreakageFee],'' as [OrderDescription] from RB_Report_OrderSettlement where (CustomerID = 1 and UpdateTime >= DATEADD(DAY, -30, GETDATE()))
解决方案：添加 nolock
历史记录  
  1. 2025-07-22 16:47:48, 由 陈莉珍 创建。
  2. 2025-07-22 17:06:22, 由 张明磊 解决，方案为 配置问题 。
    修改了 解决方案，旧值为 ""，新值为 "deploy"。
    修改了 解决日期，旧值为 ""，新值为 "2025-07-22 17:06:16"。
    修改了 指派给 ，旧值为 "zhangminglei"，新值为 "chenlizhen"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "zhangminglei"。
  3. 2025-07-22 17:53:48, 由 陈莉珍 编辑。
    修改了 所属模块 ，旧值为 "0"，新值为 "1929"。
    修改了 业务部门 ，旧值为 "0"，新值为 "2"。
    修改了 开发责任人，旧值为 ""，新值为 "songyu"。
    修改了 测试责任人，旧值为 ""，新值为 "songyu"。
    修改了 解决时效 ，旧值为 "0"，新值为 "0.31"。
    修改了 重现步骤 ，区别为：
    001- 反馈人：袁慧斌
    001+ 反馈人：袁慧斌 严重级别：严重 所属项目：hwy-zh-gz-lfw-datax 问题原因：同步数据SQL 没有加 nolock 同步主库 造成阻塞 select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID],[OtherAdvertisingFee],[OtherPlatformFee],[OtherYunCangFee],[OtherReturnFee],[DeliveryType],[DeliveryTypeDsec],[BreakageFee],[ExpenseSubCategory],[CustomStorageFee],[AffiliatePartnerCommissionFee],[FirstLegBreakageFee],'' as [OrderDescription] from RB_Report_OrderSettlement where (CustomerID = 1 and UpdateTime >= DATEADD(DAY, -30, GETDATE())) 解决方案：添加 nolock
    002- 严重级别：严重
    003- 所属项目：hwy-zh-gz-lfw-datax
    004- 问题原因：同步数据SQL 没有加 nolock 同步主库 造成阻塞
    005- select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID],[OtherAdvertisingFee],[OtherPlatformFee],[OtherYunCangFee],[OtherReturnFee],[DeliveryType],[DeliveryTypeDsec],[BreakageFee],[ExpenseSubCategory],[CustomStorageFee],[AffiliatePartnerCommissionFee],[FirstLegBreakageFee],'' as [OrderDescription] from RB_Report_OrderSettlement where (CustomerID = 1 and UpdateTime >= DATEADD(DAY, -30, GETDATE()))
    006- 解决方案：添加 nolock
    001- 反馈人：袁慧斌<br />
    001+ 反馈人：袁慧斌<br /> 严重级别：严重<br /> 所属项目：hwy-zh-gz-lfw-datax<br /> 问题原因：同步数据SQL 没有加 nolock 同步主库 造成阻塞<br /> select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID],[OtherAdvertisingFee],[OtherPlatformFee],[OtherYunCangFee],[OtherReturnFee],[DeliveryType],[DeliveryTypeDsec],[BreakageFee],[ExpenseSubCategory],[CustomStorageFee],[AffiliatePartnerCommissionFee],[FirstLegBreakageFee],'' as [OrderDescription] from RB_Report_OrderSettlement where (CustomerID = 1 and UpdateTime &gt;= DATEADD(DAY, -30, GETDATE()))<br /> 解决方案：添加 nolock
    002- 严重级别：严重<br />
    003- 所属项目：hwy-zh-gz-lfw-datax<br />
    004- 问题原因：同步数据SQL 没有加 nolock 同步主库 造成阻塞<br />
    005- select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID],[OtherAdvertisingFee],[OtherPlatformFee],[OtherYunCangFee],[OtherReturnFee],[DeliveryType],[DeliveryTypeDsec],[BreakageFee],[ExpenseSubCategory],[CustomStorageFee],[AffiliatePartnerCommissionFee],[FirstLegBreakageFee],'' as [OrderDescription] from RB_Report_OrderSettlement where (CustomerID = 1 and UpdateTime &gt;= DATEADD(DAY, -30, GETDATE()))<br />
    006- 解决方案：添加 nolock
  4. 2025-07-22 17:53:52, 由 陈莉珍 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-07-22 17:53:52"。
返回
所属项目 技术中心-需求池
所属模块 财务   客户订单
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 宋宇
测试责任人 宋宇
解决时效 0.31
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-07-22 17:53:52
截止日期 0000-00-00
上线时间 2025-07-22 17:05:00
上线时效 0.29
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-07-22 16:47:48
影响环境 生产环境-业务反馈
由谁解决 张明磊 于 2025-07-22 17:06:16
解决版本
解决方案 配置问题
由谁关闭 陈莉珍 于 2025-07-22 17:53:52
最后修改 陈莉珍 于 2025-07-22 17:53:52
相关Bug