dosubot[bot]
commented
3 weeks ago Hey @shengxiagit! I'm a bot designed to help you with bugs, questions, and becoming a contributor. I'm here to assist you while you wait for a human maintainer.
To resolve the "Instance <Provider at 0x7d21b5a12f80> has a NULL identity key" error when adding a model voucher in a self-hosted Dify v0.7.1 setup, ensure that the Provider instance has a valid identity key before it is added to the database. This typically involves setting the primary key or ensuring that the necessary fields are populated correctly.
Here is a snippet of code that shows how to ensure the Provider instance has a valid identity key:
from models.provider import Provider
from extensions.ext_database import db
class ProviderManager:
# Other methods...
def add_provider(self, tenant_id: str, provider_data: dict) -> Provider:
"""
Add a new provider to the database.
:param tenant_id: The tenant ID.
:param provider_data: A dictionary containing provider data.
:return: The created Provider instance.
"""
# Create a new Provider instance
new_provider = Provider(**provider_data)
# Ensure the identity key is set (e.g., primary key)
if not new_provider.id:
new_provider.id = self.generate_unique_id()
# Add the provider to the session and commit
db.session.add(new_provider)
try:
db.session.commit()
except IntegrityError:
db.session.rollback()
raise
return new_provider
def generate_unique_id(self) -> str:
"""
Generate a unique ID for the provider.
:return: A unique ID string.
"""
# Implement your unique ID generation logic here
return str(uuid.uuid4())In this example, the add_provider method ensures that the Provider instance has a valid id before it is added to the database. The generate_unique_id method is a placeholder for your unique ID generation logic, which could be based on UUIDs or any other scheme suitable for your application [1].
Additionally, ensure that the Provider class's primary key is correctly defined and managed in the database schema. The id column should be defined as follows:
id = db.Column(StringUUID, server_default=db.text('uuid_generate_v4()'))This column uses the StringUUID type and has a default value generated by the uuid_generate_v4() function, ensuring that each Provider instance has a unique identifier [2].
To continue talking to Dosu, mention @dosu.
Self Checks
Dify version
v0.7.1
Cloud or Self Hosted
Self Hosted (Source)
Steps to reproduce
When I add a model voucher, an error message appears, like this:
·· sqlalchemy.orm.exc.FlushError: Instance <Provider at 0x7d21b5a12f80> has a NULL identity key. If this is an auto-generated value, check that the database table allows generation of new primary key values, and that the mapped Column object is configured to expect these generated values. Ensure also that this flush() is not occurring at an inappropriate time, such as within a load() event.
✔️ Expected Behavior
model provider add success
❌ Actual Behavior