重现步骤

【测试环境】测试环境,产品资料库,从正式环境迁移这四份sku数据相关联表数据时,发现产生了三份一模一样的数据,即使删除对应sku测试环境相关表数据,查询页面时仍然发现这些sku数据仍存在于页面,仍然是三份一模一样数据。


产生问题的系统sku:

16511633
16510975
16510429
16509854
数据库迁移-产品资料库相关表:(测试环境数据表均无这四个sku表相关数据)



select * from p_product where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');

select * from p_product_image where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');

select * from p_market_product where CustomerId=1 and MarketId = 2 and Sku in ('16511633','16510975','16510429','16509854');

select * from p_market_product_review where CustomerId =1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');

select * from p_market_product_attribute where CustomerId=1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');

select * from p_market_product_variant where CustomerId=1 and MarketId=2 and Sku in ('16511633','16510975','16510429','16509854');

select * from p_product_inventory where Sku in ('16511633','16510975','16510429','16509854');

select * from p_product_groupsku where CustomerId =1 and GroupSku in ('16511633','16510975','16510429','16509854');

select * from P_Product_Inventory where Sku in ('16511633','16510975','16510429','16509854');


测试环境产品资料库:

正式环境查询这四个系统sku:(迁移后的数据测试环境数据,理应按照以下正式环境展示如下)

[步骤]


[结果]


[期望]


历史记录  
  1. 2023-03-26 15:23:30, 由 王小勤 创建。
  2. 2023-03-27 09:39:11, 由 周楷鹏 指派给 胡笑锋。
    修改了 指派给,旧值为 "zhoukaipeng",新值为 "huxiaofeng"。

    这是请求参数,剩下的我没看出什么问题


    {

      "input": {
        "SearchType": "1",
        "SearchTimeKeys": [
          "1",
          []
        ],
        "BatchSearchType": "1",
        "BatchSearchValue": [
          "13551708"
        ]
      },
      "current": 1,
      "language": "zh_cn"
    }
  3. 2023-03-27 09:47:33, 由 胡笑锋 解决,方案为 非BUG-纯属误判 。
    修改了 解决方案,旧值为 "",新值为 "feiBUG"。
    修改了 解决版本,旧值为 "",新值为 "trunk"。
    修改了 解决日期,旧值为 "",新值为 "2023-03-27 09:47:14"。
    修改了 指派给 ,旧值为 "huxiaofeng",新值为 "wangxiaoqin"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "huxiaofeng"。
    无此数据
  4. 2023-03-27 09:50:38, 由 王小勤 编辑。
    修改了 重现步骤,区别为:
    006-
    006+
    007-
    007+
    008-
    008+
    009- select * from p_product where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');
    009+ select * from p_product where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');
    010- select * from p_product_image where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');
    010+ select * from p_product_image where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');
    011- select * from p_market_product where CustomerId=1 and MarketId = 2 and Sku in ('16511633','16510975','16510429','16509854');
    011+ select * from p_market_product where CustomerId=1 and MarketId = 2 and Sku in ('16511633','16510975','16510429','16509854');
    012- select * from p_market_product_review where CustomerId =1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');
    012+ select * from p_market_product_review where CustomerId =1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');
    013- select * from p_market_product_attribute where CustomerId=1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');
    013+ select * from p_market_product_attribute where CustomerId=1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');
    014- select * from p_market_product_variant where CustomerId=1 and MarketId=2 and Sku in ('16511633','16510975','16510429','16509854');
    014+ select * from p_market_product_variant where CustomerId=1 and MarketId=2 and Sku in ('16511633','16510975','16510429','16509854');
    015- select * from p_product_inventory where Sku in ('16511633','16510975','16510429','16509854');
    015+ select * from p_product_inventory where Sku in ('16511633','16510975','16510429','16509854');
    016- select * from p_product_groupsku where CustomerId =1 and GroupSku in ('16511633','16510975','16510429','16509854');
    016+ select * from p_product_groupsku where CustomerId =1 and GroupSku in ('16511633','16510975','16510429','16509854');
    017- select * from P_Product_Inventory where Sku in ('16511633','16510975','16510429','16509854');
    017+ select * from P_Product_Inventory where Sku in ('16511633','16510975','16510429','16509854');
    018-
    018+
    019-
    019+
    020-
    020+
    021-
    021+ 测试环境产品资料库:
    022- 测试环境产品资料库:
    022+
    023-
    023+ 正式环境查询这四个系统sku:(迁移后的数据测试环境数据,理应按照以下正式环境展示如下)
    024- 正式环境查询这四个系统sku:(迁移后的数据测试环境数据,理应按照以下正式环境展示如下)
    024+
    025-
    025+ [步骤]
    026- [步骤]
    026+ [结果]
    027- [结果]
    027+ [期望]
    028- [期望]
    028+
    029-
    006- <p>
    006+ <p><br /></p>
    007- </p><div style="background-color:#ffffff;">
    007+ <div style="background-color:#ffffff;">
    008- <div style="color:#000000;background-color:#ffffff;">
    008+ <div style="color:#000000;background-color:#ffffff;">
    009- <p>select * from p_product where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');</p>
    009+ <p>select * from p_product where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');</p>
    010- <p>select * from p_product_image where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');</p>
    010+ <p>select * from p_product_image where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');</p>
    011- <p>select * from p_market_product where CustomerId=1 and MarketId = 2 and Sku in ('16511633','16510975','16510429','16509854');</p>
    011+ <p>select * from p_market_product where CustomerId=1 and MarketId = 2 and Sku in ('16511633','16510975','16510429','16509854');</p>
    012- <p>select * from p_market_product_review where CustomerId =1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');</p>
    012+ <p>select * from p_market_product_review where CustomerId =1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');</p>
    013- <p>select * from p_market_product_attribute where CustomerId=1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');</p>
    013+ <p>select * from p_market_product_attribute where CustomerId=1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');</p>
    014- <p>select * from p_market_product_variant where CustomerId=1 and MarketId=2 and Sku in ('16511633','16510975','16510429','16509854');</p>
    014+ <p>select * from p_market_product_variant where CustomerId=1 and MarketId=2 and Sku in ('16511633','16510975','16510429','16509854');</p>
    015- <p>select * from p_product_inventory where Sku in ('16511633','16510975','16510429','16509854');</p>
    015+ <p>select * from p_product_inventory where Sku in ('16511633','16510975','16510429','16509854');</p>
    016- <p>select * from p_product_groupsku where CustomerId =1 and GroupSku in ('16511633','16510975','16510429','16509854');</p>
    016+ <p>select * from p_product_groupsku where CustomerId =1 and GroupSku in ('16511633','16510975','16510429','16509854');</p>
    017- <p>select * from P_Product_Inventory where Sku in ('16511633','16510975','16510429','16509854');</p>
    017+ <p>select * from P_Product_Inventory where Sku in ('16511633','16510975','16510429','16509854');</p>
    018- </div>
    018+ </div>
    019- </div>
    019+ </div>
    020-
    020+ <p><br /></p>
    021- <p><br /></p>
    021+ <p>测试环境产品资料库:</p>
    022- <p>测试环境产品资料库:</p>
    022+ <p><img src="{251149.png}" alt="" /></p>
    023- <p><img src="{251149.png}" alt="" /></p>
    023+ <p>正式环境查询这四个系统sku:(<span>迁移后的数据</span>测试环境数据,理应按照以下正式环境展示如下)</p>
    024- <p>正式环境查询这四个系统sku:(<span>迁移后的数据</span>测试环境数据,理应按照以下正式环境展示如下)</p>
    024+ <p><img src="{251150.png}" alt="" /></p>
    025- <p><img src="{251150.png}" alt="" /></p>
    025+ <p>[步骤]</p>
    026- <p>[步骤]</p>
    026+ <br /><p>[结果]</p>
    027- <br /><p>[结果]</p>
    027+ <br /><p>[期望]</p>
    028- <br /><p>[期望]</p>
    028+ <br />
    029- <br />
    再次搜索,问题的sku已经不存在,无法复现。暂时关闭问题单
  5. 2023-03-27 09:50:46, 由 王小勤 编辑。
    修改了 指派给,旧值为 "wangxiaoqin",新值为 "closed"。
  6. 2025-04-16 11:40:46, 由 李亚婷 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "liyating"。
    修改了 关闭日期,旧值为 "",新值为 "2025-04-16 11:40:46"。
所属项目 智能中心-需求池
所属模块 /
所属计划
所属迭代 智能中心-EBAY直发迭代
Bug类型
严重程度 提示
优先级 P2
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-04-16 11:40:46
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
由谁创建 王小勤 于 2023-03-26 15:23:30
影响环境 测试环境-测试反馈
由谁解决 胡笑锋 于 2023-03-27 09:47:14
解决版本 主干
解决方案 非BUG-纯属误判
由谁关闭 李亚婷 于 2025-04-16 11:40:46
最后修改 李亚婷 于 2025-04-16 11:40:46
相关Bug