When I use 'await session.commit()', the field content of my instance has become an error

[HaleTime]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

import uuid
from sqlalchemy.ext.asyncio import AsyncSession
from app.core.db import async_engine
from sqlmodel import SQLModel, Field


class Test(SQLModel, table=True):
    id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
    name: str = Field(max_length=255)


async def main():
    async with async_engine.begin() as conn:
        await conn.run_sync(SQLModel.metadata.create_all)

    async with AsyncSession(async_engine) as session:
        test = Test(name='test')
        session.add(test)
        await session.commit()
        await session.refresh(test)
        return test


if __name__ == '__main__':
    import asyncio

    asyncio.run(main())

Description

When I use 'await session.commit()', the field content of my instance has become an error, like
(sqlalchemy.exc.MissingGreenlet) greenlet_spawn has not been called; can't call await_only() here. Was IO attempted in an unexpected place?
[SQL: SELECT test.id AS test_id, test.name AS test_name
FROM test
WHERE test.id = %s]
[parameters: [{'pk_1': UUID('84f97a3a-107b-4ae6-81bb-f04295cf0d3f')}]]

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

3.10

Additional Context

No response

[monchin]

This is a sqlalchemy issue. Try this

[YuriiMotov]

Your code works well

SQLAlchemy marks object as expired after calling commit.
Next time you are attempting to use them it will try to refresh that object.
But it will fail since you are using async connection and all calls should be awaited.

So, after commit you should refresh objects to use them later