Tortoise-orm 在高并发下引发 KeyError

Question

我在FastAPI中使用Tortoise-orm，Mysql连接池设置为{"minsize":8, "maxsize":16}。

# models.py
class Device(models.Model):
    id = fields.IntField(pk=True)
    model = fields.CharField(max_length=32)
    version = fields.CharField(max_length=32)
        port = fields.IntField(default=0)
    
class Channel(models.Model):
    id = fields.IntField(pk=True)
    Device = fields.ForeignKeyField("model.Device", related_name="channels")
    frequency = fields.IntField(default=0, index=True)


#routers.py
@app.get("channels/{port}", response_model=ChannelSchema)
async def get_channels(port:int)
        return await ChannelSchema.from_queryset(Channel.filter(Device__port=port))

我使用JMeter测试了这个API：

第一次是每秒100个接口请求：50%的请求是500错误，

查看服务日志：

  File "/root/TuffyProjects/simulator/venv/lib/python3.8/site-packages/tortoise/models.py", line 742, in _init_from_db

KeyError: 'model'

或者

File "/root/TuffyProjects/simulator/venv/lib/python3.8/site-packages/tortoise/models.py", line 742, in _init_from_db

KeyError: 'frequency'

第二次是每秒100个接口请求：20%的请求是500错误。

第三次是每秒100个接口请求：5%的请求是500个错误。

第四次是每秒100个接口请求：5%的请求是500个错误。

当我增加并发请求数时，错误数又回到了 50%。

我将重新启动服务并重新测试它。

第一次是每秒100个接口请求：50%的请求是500错误，看服务器日志发现KeyError提示不是model或者Frequency而是两个其他领域。

我把连接池设置改为minsize":100, "maxsize":100}，启动项目时Mysql日志提示：

2022-03-09T07:09:24.855819Z 116 [Note] Aborted connection 116 to db: 'Device' user: 'root' host: '127.0.0.1' (Got an error reading communication packets)
2022-03-09T07:09:24.855712Z 78 [Note] Aborted connection 78 to db: 'Device' user: 'root' host: '127.0.0.1' (Got an error reading communication packets)
2022-03-09T07:09:24.855140Z 124 [Note] Aborted connection 124 to db: 'Device' user: 'root' host: '127.0.0.1' (Got an error reading communication packets)
2022-03-09T07:09:24.856009Z 123 [Note] Aborted connection 123 to db: 'Device' user: 'root' host: '127.0.0.1' (Got an error reading communication packets)
2022-03-09T07:09:34.903747Z 108 [Note] Aborted connection 108 to db: 'Device' user: 'root' host: '127.0.0.1' (Got an error reading communication packets)
2022-03-09T07:09:34.903765Z 104 [Note] Aborted connection 104 to db: 'Device' user: 'root' host: '127.0.0.1' (Got an error reading communication packets)

但是服务运行正常，并发请求数减少，

错误是什么？这个BUG的原因有没有更好的解决办法呢？