(fastapi_env) D:\Agent_learning\Fastapi_Code>aerich init-db
Traceback (most recent call last):
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\backends\mysql\client.py", line 50, in translate_exceptions_
return await func(self, *args)
^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\backends\mysql\client.py", line 223, in execute_script
await cursor.execute(query)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\cursors.py", line 239, in execute
await self._query(query)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\cursors.py", line 457, in _query
await conn.query(q)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\connection.py", line 469, in query
await self._read_query_result(unbuffered=unbuffered)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\connection.py", line 683, in _read_query_result
await result.read()
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\connection.py", line 1164, in read
first_packet = await self.connection._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\connection.py", line 652, in _read_packet
packet.raise_for_error()
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\pymysql\err.py", line 154, in raise_mysql_exception
raise errorclass(errno, errval, sqlstate=sqlstate)
pymysql.err.OperationalError: (1071, 'Specified key was too long; max key length is 1000 bytes')
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<frozen runpy>", line 198, in _run_module_as_main
File "<frozen runpy>", line 88, in _run_code
File "D:\Anaconda\envs\fastapi_env\Scripts\aerich.exe\__main__.py", line 5, in <module>
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aerich\cli.py", line 300, in main
cli()
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 1656, in __call__
return anyio.run(self._main, main, args, kwargs, **opts)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\anyio\_core\_eventloop.py", line 83, in run
return async_backend.run(func, args, {}, backend_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\anyio\_backends\_asyncio.py", line 2481, in run
return runner.run(wrapper())
^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\asyncio\runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\asyncio\base_events.py", line 691, in run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\anyio\_backends\_asyncio.py", line 2464, in wrapper
return await func(*args)
^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 1674, in _main
return await main(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 1549, in main
rv = await self.invoke(ctx)
^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 2075, in invoke
return await _process_result(await sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 1412, in invoke
return await ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 965, in invoke
rv = await rv
^^^^^^^^
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aerich\cli.py", line 275, in init_db
await command.init_db(safe)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aerich\__init__.py", line 284, in init_db
await generate_schema_for_client(connection, safe)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\utils.py", line 46, in generate_schema_for_client
await generator.generate_from_string(schema)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\backends\base\schema_generator.py", line 504, in generate_from_string
await self.client.execute_script(creation_string)
File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\backends\mysql\client.py", line 58, in translate_exceptions_
raise OperationalError(exc)
tortoise.exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 1000 bytes')
当执行
aerich init-db
出现了这个问题