gorm-zero icon indicating copy to clipboard operation
gorm-zero copied to clipboard

windows上开发经常遇到查询mysql出现异常

Open xiucaiwu opened this issue 1 month ago • 2 comments

gorm-zero 版本:v1.2.1 go-zero 版本:v1.7.0

报错信息:

2025-11-17T14:18:46.072+08:00    info   127.0.0.1:61864 - /livesvc.live/GetLive - {"id":505}    span=95d849cb9703ba69 service=livesvc.rpc     duration=5.4ms  caller=serverinterceptors/statinterceptor.go:90       trace=b4c9f1b3dfb678181390e82df70123cd
2025-11-17T14:19:01.302+08:00    info   redis延时任务开始执行...        service=livesvc.rpc     caller=live/liveCreateLogic.go:683
[mysql] 2025/11/17 14:19:01 connection.go:49: read tcp 127.0.0.1:53979->127.0.0.1:3306: wsarecv: An established connection was aborted by the software in your host machine.
2025-11-17T14:19:01.302+08:00    error  E:/workspace/bwedu/service/livesvc/model/liveModel_gen.go:109 invalid connection
[0.000ms] [rows:0] SELECT * FROM `live` WHERE `id` = 505 AND `live`.`deleted_at` IS NULL LIMIT 1     service=livesvc.rpc      caller=logger/logger.go:86
2025-11-17T14:19:01.302+08:00    error  invalid connection      service=livesvc.rpc     caller=live/liveCreateLogic.go:693


2025-11-17T22:04:03.960+08:00    info   redis延时任务开始执行...        service=livesvc.rpc     caller=live/liveCreateLogic.go:859
[mysql] 2025/11/17 22:04:03 connection.go:49: bad connection
[mysql] 2025/11/17 22:04:03 connection.go:49: bad connection
2025-11-17T22:04:03.962+08:00    info   E:/workspace/bwedu/service/livesvc/model/liveModel_gen.go:109
[1.992ms] [rows:1] SELECT * FROM `live` WHERE `id` = 510 AND `live`.`deleted_at` IS NULL LIMIT 1     service=livesvc.rpc      caller=logger/logger.go:104
2025-11-17T22:04:03.962+08:00    info   直播结束时间已变更,忽略本次任务,[直播Id:510,本次任务记录的结束时间:1763388240,实际结束时间:1763382118].       service=livesvc.rpc     caller=live/liveCreateLogic.go:891
2025-11-17T22:04:03.962+08:00    info   redis延时任务执行结束...        service=livesvc.rpc     caller=live/liveCreateLogic.go:892

MySQL相关配置

Mysql:
    Path: 127.0.0.1
    Port: 3306
    Dbname: test
    Username: root
    Password: 123456
    MaxIdleConns: 50
    MaxOpenConns: 50
    LogMode: "dev"
    LogZap: false
    Config: charset=utf8mb4&parseTime=True&loc=Local

异常的频率非常高,如果在Linux下开发则几乎很少出现这个情况,还有其他配置能解决这个问题么?

xiucaiwu avatar Nov 18 '25 09:11 xiucaiwu