-
Notifications
You must be signed in to change notification settings - Fork 4k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Postgres migration error #1607
Comments
Hey there, @tejeshbhalla! 🚀 Great to see you diving into Langflow. Looks like you've hit a bit of a snag, but no worries, we're here to help you sort it out. Let's tackle this together! Based on the error message you provided, it seems like the username "superuser" is already present in your database, which is causing the violation of the unique constraint "ix_user_username". To resolve this issue, you can change the
DEFAULT_SUPERUSER = "unique_langflow_superuser"
DEFAULT_SUPERUSER_PASSWORD = "langflow"
This change will attempt to create a superuser with a new, unique username, thus avoiding the violation of the unique constraint "ix_user_username". You can refer to the If you're still encountering issues, it might be helpful to check out these similar threads on the Langflow repository:
These threads discuss similar issues and might provide additional insights or solutions. If you continue to experience problems, please provide more details about your setup process and any additional error messages you're receiving. This will help me better understand your situation and provide more accurate assistance. Sources
|
Hello, |
We hope you're doing well. Just a friendly reminder that if we do not hear back from you within the next 3 days, we will close this issue. If you need more time or further assistance, please let us know. Thank you for your understanding! |
Thank you for your contribution! This issue will be closed. If you have any questions or encounter another problem, please open a new issue and we will be ready to assist you. |
Describe the bug
While setting up langflow locally on postgres i get error
postgres-1 | 2024-04-04 17:09:20.050 UTC [69] ERROR: duplicate key value violates unique constraint "ix_user_username" postgres-1 | 2024-04-04 17:09:20.050 UTC [69] DETAIL: Key (username)=(superuser) already exists. postgres-1 | 2024-04-04 17:09:20.050 UTC [69] STATEMENT: INSERT INTO "user" (id, username, password, profile_image, is_active, is_superuser, create_at, updated_at, last_login_at, store_api_key) VALUES ('d81401a3-4798-4f99-a30e-a01f678e7e75'::UUID, 'superuser', '$2b$12$0FNtcrd.0c70wZPXWu3Bdux1Tk82k07.gRd2Yfbq8zZcLIqYrZm92', NULL, true, true, '2024-04-04T17:09:20.048501'::timestamp, '2024-04-04T17:09:20.048504'::timestamp, NULL, NULL) langflow-1 | No new upgrade operations detected. langflow-1 | No new upgrade operations detected. langflow-1 | [04/04/24 17:09:20] INFO 2024-04-04 17:09:20 - INFO - utils utils.py:84 langflow-1 | - LLM caching setup with SQLiteCache postgres-1 | 2024-04-04 17:09:20.076 UTC [70] ERROR: duplicate key value violates unique constraint "ix_user_username" postgres-1 | 2024-04-04 17:09:20.076 UTC [70] DETAIL: Key (username)=(superuser) already exists. postgres-1 | 2024-04-04 17:09:20.076 UTC [70] STATEMENT: INSERT INTO "user" (id, username, password, profile_image, is_active, is_superuser, create_at, updated_at, last_login_at, store_api_key) VALUES ('7060f313-41da-4342-8149-b1b74bd5898a'::UUID, 'superuser', '$2b$12$CT1Bov9kd3MF/W6V55EbBeY.oDYyt8UxSIKmG8GCOvFkcUBAB7UP2', NULL, true, true, '2024-04-04T17:09:20.074609'::timestamp, '2024-04-04T17:09:20.074612'::timestamp, NULL, NULL) langflow-1 | No new upgrade operations detected.
Screenshots
If applicable, add screenshots to help explain your problem.
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered: