这是indexloc提供的服务,不要输入任何密码
Skip to content

添加密钥数量较大时,保存配置失败: HTTP error! status: 400 附日志 #243

@6uu1

Description

@6uu1

部署平台:render+avien数据库

render报错日志:

    err.raise_mysql_exception(self._data)
  File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.DataError: (1406, "Data too long for column 'value' at row 1")
2025-07-24 11:28:22,438 | ERROR    | [exceptions.py:99]             | HTTP Exception: (1406, "Data too long for column 'value' at row 1") (Status: 400)
2025-07-24 11:29:08,862 | ERROR    | [config_service.py:112]        | Failed to bulk update/insert settings: (1406, "Data too long for column 'value' at row 1")
2025-07-24 11:29:08,862 | ERROR    | [config_routes.py:42]          | Error updating config or log levels: (1406, "Data too long for column 'value' at row 1")
Traceback (most recent call last):
  File "/app/app/router/config_routes.py", line 36, in update_config
    result = await ConfigService.update_config(config_data)
  File "/app/app/service/config/config_service.py", line 109, in update_config
    await database.execute(query=query_update)
  File "/usr/local/lib/python3.10/site-packages/databases/core.py", line 199, in execute
    return await connection.execute(query, values)
  File "/usr/local/lib/python3.10/site-packages/databases/core.py", line 318, in execute
    return await self._connection.execute(built_query)
  File "/usr/local/lib/python3.10/site-packages/databases/backends/mysql.py", line 161, in execute
    await cursor.execute(query_str, args)
  File "/usr/local/lib/python3.10/site-packages/aiomysql/cursors.py", line 239, in execute
    await self._query(query)
  File "/usr/local/lib/python3.10/site-packages/aiomysql/cursors.py", line 457, in _query
    await conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/aiomysql/connection.py", line 469, in query
    await self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/aiomysql/connection.py", line 683, in _read_query_result
    await result.read()
  File "/usr/local/lib/python3.10/site-packages/aiomysql/connection.py", line 1164, in read
    first_packet = await self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/aiomysql/connection.py", line 652, in _read_packet
    packet.raise_for_error()
  File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.DataError: (1406, "Data too long for column 'value' at row 1")
2025-07-24 11:29:08,863 | ERROR    | [exceptions.py:99]             | HTTP Exception: (1406, "Data too long for column 'value' at row 1") (Status: 400)
2025-07-24 11:29:59,176 | ERROR    | [config_service.py:112]        | Failed to bulk update/insert settings: (1406, "Data too long for column 'value' at row 1")
2025-07-24 11:29:59,176 | ERROR    | [config_routes.py:42]          | Error updating config or log levels: (1406, "Data too long for column 'value' at row 1")
Traceback (most recent call last):
  File "/app/app/router/config_routes.py", line 36, in update_config
    result = await ConfigService.update_config(config_data)
  File "/app/app/service/config/config_service.py", line 109, in update_config
    await database.execute(query=query_update)
  File "/usr/local/lib/python3.10/site-packages/databases/core.py", line 199, in execute
    return await connection.execute(query, values)
  File "/usr/local/lib/python3.10/site-packages/databases/core.py", line 318, in execute
    return await self._connection.execute(built_query)
  File "/usr/local/lib/python3.10/site-packages/databases/backends/mysql.py", line 161, in execute
    await cursor.execute(query_str, args)
  File "/usr/local/lib/python3.10/site-packages/aiomysql/cursors.py", line 239, in execute
    await self._query(query)
  File "/usr/local/lib/python3.10/site-packages/aiomysql/cursors.py", line 457, in _query
    await conn.query(q)
  File "/usr/local/lib/python3.10/site-packages/aiomysql/connection.py", line 469, in query
    await self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.10/site-packages/aiomysql/connection.py", line 683, in _read_query_result
    await result.read()
  File "/usr/local/lib/python3.10/site-packages/aiomysql/connection.py", line 1164, in read
    first_packet = await self.connection._read_packet()
  File "/usr/local/lib/python3.10/site-packages/aiomysql/connection.py", line 652, in _read_packet
    packet.raise_for_error()
  File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.DataError: (1406, "Data too long for column 'value' at row 1")
2025-07-24 11:29:59,177 | ERROR    | [exceptions.py:99]             | HTTP Exception: (1406, "Data too long for column 'value' at row 1") (Status: 400)
Need better ways to work with logs? Try theRender CLIor 

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions