New version migration SQL exception

[chenhuan89]

Having gotten used to Aerich, the configuration before migrating to the new version is much more troublesome than before.

use_tz=False

tortoise migrate
Connection: default
APPLY models.0001_initial
Plan: 1 to apply, 0 to roll back
Applying models.0001_initial... OK
Traceback (most recent call last):
File ".venv\Lib\site-packages\tortoise\backends\mysql\client.py", line 50, in translate_exceptions_
return await func(self, *args)
^^^^^^^^^^^^^^^^^^^^^^^
File ".venv\Lib\site-packages\tortoise\backends\mysql\client.py", line 232, in execute_script
await cursor.execute(query)
File ".venv\Lib\site-packages\aiomysql\cursors.py", line 239, in execute
await self._query(query)
File ".venv\Lib\site-packages\aiomysql\cursors.py", line 457, in _query
await conn.query(q)
File ".venv\Lib\site-packages\aiomysql\connection.py", line 469, in query
await self._read_query_result(unbuffered=unbuffered)
File ".venv\Lib\site-packages\aiomysql\connection.py", line 683, in _read_query_result
await result.read()
File ".venv\Lib\site-packages\aiomysql\connection.py", line 1164, in read
first_packet = await self.connection._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File ".venv\Lib\site-packages\aiomysql\connection.py", line 652, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File ".venv\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File ".venv\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1292, "Incorrect datetime value: '2026-03-09T13:03:32.267109+00:00' for column test_sql.tortoise_migrations.applied_at at row 1")

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "", line 198, in run_module_as_main
File "", line 88, in run_code
File ".venv\Scripts\tortoise.exe_main.py", line 10, in
sys.exit(main())
~~~~^^
File ".venv\Lib\site-packages\tortoise\cli_init.py", line 9, in main
cli_main()
~~~~~~~~^^
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 872, in main
raise SystemExit(asyncio.run(run_cli_async()))
~~~~~~~~~~~^^^^^^^^^^^^^^^^^
File "C:\Users\Chen\AppData\Roaming\uv\python\cpython-3.13.3-windows-x86_64-none\Lib\asyncio\runners.py", line 195, in run
return runner.run(main)
~~~~~~~~~~^^^^^^
File "C:\Users\Chen\AppData\Roaming\uv\python\cpython-3.13.3-windows-x86_64-none\Lib\asyncio\runners.py", line 118, in run
return self._loop.run_until_complete(task)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
File "C:\Users\Chen\AppData\Roaming\uv\python\cpython-3.13.3-windows-x86_64-none\Lib\asyncio\base_events.py", line 719, in run_until_complete
return future.result()
~~~~~~~~~~~~~^^
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 859, in run_cli_async
await args.func(ctx, args)
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 827, in _run_migrate_cmd
await migrate(ctx, args.app_label, args.migration, args.fake, args.dry_run)
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 554, in migrate
await _run_migrate(ctx, app_label, migration, fake=fake, dry_run=dry_run)
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 535, in run_migrate
await migrate_api(
...<8 lines>...
)
File ".venv\Lib\site-packages\tortoise\migrations\api\migrate.py", line 57, in migrate
await executor.migrate(
...<5 lines>...
)
File ".venv\Lib\site-packages\tortoise\migrations\executor.py", line 120, in migrate
await self.recorder.record_applied(key.app_label, key.name)
File ".venv\Lib\site-packages\tortoise\migrations\recorder.py", line 83, in record_applied
await self.connection.execute_script(query)
File ".venv\Lib\site-packages\tortoise\backends\mysql\client.py", line 58, in translate_exceptions
raise OperationalError(exc)
tortoise.exceptions.OperationalError: (1292, "Incorrect datetime value: '2026-03-09T13:03:32.267109+00:00' for column test_sql.tortoise_migrations.applied_at at row 1")
(rbac-backend) PS C:\Users\Chen\Desktop\code\sys-demo\rbac_backend> tortoise makemigrations
Created models.0002_auto_20260309_2108
migrations\0002_auto_20260309_2108.py
(rbac-backend) PS C:\Users\Chen\Desktop\code\sys-demo\rbac_backend> tortoise migrate
Connection: default
APPLY models.0002_auto_20260309_2108
Plan: 1 to apply, 0 to roll back
.venv\Lib\site-packages\aiomysql\cursors.py:239: Warning: Table 'tortoise_migrations' already exists
await self.query(query)
Applying models.0002_auto_20260309_2108... OK
Traceback (most recent call last):
File ".venv\Lib\site-packages\tortoise\backends\mysql\client.py", line 50, in translate_exceptions
return await func(self, *args)
^^^^^^^^^^^^^^^^^^^^^^^
File ".venv\Lib\site-packages\tortoise\backends\mysql\client.py", line 232, in execute_script
await cursor.execute(query)
File ".venv\Lib\site-packages\aiomysql\cursors.py", line 239, in execute
await self._query(query)
File ".venv\Lib\site-packages\aiomysql\cursors.py", line 457, in _query
await conn.query(q)
File ".venv\Lib\site-packages\aiomysql\connection.py", line 469, in query
await self._read_query_result(unbuffered=unbuffered)
File ".venv\Lib\site-packages\aiomysql\connection.py", line 683, in _read_query_result
await result.read()
File ".venv\Lib\site-packages\aiomysql\connection.py", line 1164, in read
first_packet = await self.connection._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File ".venv\Lib\site-packages\aiomysql\connection.py", line 652, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File ".venv\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File ".venv\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1292, "Incorrect datetime value: '2026-03-09T13:08:23.145734+00:00' for column test_sql.tortoise_migrations.applied_at at row 1")

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "", line 198, in run_module_as_main
File "", line 88, in run_code
File ".venv\Scripts\tortoise.exe_main.py", line 10, in
sys.exit(main())
~~~~^^
File ".venv\Lib\site-packages\tortoise\cli_init.py", line 9, in main
cli_main()
~~~~~~~~^^
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 872, in main
raise SystemExit(asyncio.run(run_cli_async()))
~~~~~~~~~~~^^^^^^^^^^^^^^^^^
File "C:\Users\Chen\AppData\Roaming\uv\python\cpython-3.13.3-windows-x86_64-none\Lib\asyncio\runners.py", line 195, in run
return runner.run(main)
~~~~~~~~~~^^^^^^
File "C:\Users\Chen\AppData\Roaming\uv\python\cpython-3.13.3-windows-x86_64-none\Lib\asyncio\runners.py", line 118, in run
return self._loop.run_until_complete(task)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
File "C:\Users\Chen\AppData\Roaming\uv\python\cpython-3.13.3-windows-x86_64-none\Lib\asyncio\base_events.py", line 719, in run_until_complete
return future.result()
~~~~~~~~~~~~~^^
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 859, in run_cli_async
await args.func(ctx, args)
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 827, in _run_migrate_cmd
await migrate(ctx, args.app_label, args.migration, args.fake, args.dry_run)
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 554, in migrate
await _run_migrate(ctx, app_label, migration, fake=fake, dry_run=dry_run)
File ".venv\Lib\site-packages\tortoise\cli\cli.py", line 535, in run_migrate
await migrate_api(
...<8 lines>...
)
File ".venv\Lib\site-packages\tortoise\migrations\api\migrate.py", line 57, in migrate
await executor.migrate(
...<5 lines>...
)
File ".venv\Lib\site-packages\tortoise\migrations\executor.py", line 120, in migrate
await self.recorder.record_applied(key.app_label, key.name)
File ".venv\Lib\site-packages\tortoise\migrations\recorder.py", line 83, in record_applied
await self.connection.execute_script(query)
File ".venv\Lib\site-packages\tortoise\backends\mysql\client.py", line 58, in translate_exceptions
raise OperationalError(exc)
tortoise.exceptions.OperationalError: (1292, "Incorrect datetime value: '2026-03-09T13:08:23.145734+00:00' for column test_sql.tortoise_migrations.applied_at at row 1")

Migration successful, but it will report an error

[panla]

tortoise/migrations/recorder.py

async def record_applied(self, app: str, name: str) -> None:
    applied_at = datetime.now(timezone.utc).isoformat()
    query = (
        f"INSERT INTO {self._quote(self.table_name)} "  # nosec B608
        f"({self._quote('app')}, {self._quote('name')}, {self._quote('applied_at')}) "
        f"VALUES ('{self._escape(app)}', '{self._escape(name)}', '{applied_at}')"
    )
    await self.connection.execute_script(query)

// The format is specified here
applied_at = datetime.now(timezone.utc).isoformat()

[panla]

from tortoise.migrations.recorder import MigrationRecorder

async def patched_record_applied(self, app: str, name: str) -> None:
     # modify this col
    applied_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")

    query = (
        f"INSERT INTO {self._quote(self.table_name)} "
        f"({self._quote('app')}, {self._quote('name')}, {self._quote('applied_at')}) "
        f"VALUES ('{self._escape(app)}', '{self._escape(name)}', '{applied_at}')"
    )
    await self.connection.execute_script(query)


MigrationRecorder.record_applied = patched_record_applied

This is a temporary solution, which is neither user-friendly nor elegant.
hope the official team can introduce a better method to address this issue