问题描述

gateway-worker 并发场景下,查询数据库的结果返回混乱.

程序代码

在gateway-worker中实际执行的laravel代码,使用了orm 的with关联, 查询用户A,B的信息:

$selfUser = User::query()->with('userInfo')->where(['uuid' => $selfUuid])->first();
info('$selfUuid='.$selfUuid);   //查询用户A $UUID= 956498 的用户信息
info($selfUser);

$targetUser = User::query()->with('userInfo')->where(['uuid' => $targetUuid])->first();
info('$targetUuid='.$targetUuid);   //查询用户B $UUID= 724129的用户信息
info($targetUser);

返回的结果却是用户C的信息:

[2023-12-12 14:17:11] prod.INFO: $selfUuid=956498
[2023-12-12 14:17:11] prod.INFO: {"id":3,"uuid":371006,"register_device_type":0,"register_device_imei":"E0B993E56CC","register_ip":"221.234.178.221","created_at":"2023-12-07 16:18:35","updated_at":"2023-12-12 12:18:36","deleted_at":null,"user_info":null}

[2023-12-12 14:17:11] prod.INFO: $targetUuid=724129
[2023-12-12 14:17:11] prod.INFO: {"id":3,"uuid":371006,"register_device_type":0,"register_device_imei":"E0B993E56CC","register_ip":"221.234.178.221","created_at":"2023-12-07 16:18:35","updated_at":"2023-12-12 12:18:36","deleted_at":null,"user_info":null}

框架执行时候输出的sql:

   [2023-12-12 14:17:11] time: 0.08 ms; sql: select * from `user` where (`uuid` = "956498") and `user`.`deleted_at` is null limit 1;    //查询956498的用户信息
    [2023-12-12 14:17:11] time: 2.27 ms; sql: select * from `user_info` where `user_info`.`uuid` in ("371006") and `user_info`.`deleted_at` is null;    //with查询956498用户的扩展信息, 但是框架执行的时候,变成了用户C的UUID 371006

    [2023-12-12 14:17:11] time: 0.05 ms; sql: select * from `user` where (`uuid` = "724129") and `user`.`deleted_at` is null limit 1;   //查询 724129 的用户信息
    [2023-12-12 14:17:11] time: 2.2 ms; sql: select * from `user_info` where `user_info`.`uuid` in ("371006") and `user_info`.`deleted_at` is null; //with查询 724129 用户的扩展信息, 但是框架执行的时候,变成了用户C的UUID 371006

重现问题的步骤

此bug不是必现,多数时候框架是正常运行 , 但是一旦触发这种混乱查询 ,就会大面积的使线上其他用户的查询, 全部返回这条异常ID的结果.必须通过重启gateway-worker,才能使其它人的查询结果再次正常.

看了gateway-worker的运行日志,没有报错信息.
请教下版主,这种情况是gateway-worker的变量污染吗?应该怎么处理呢?

操作系统环境及workerman/webman等具体版本

php: 8.1.19
gateway-worker: 3.1.4