Skip to content
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

[BUG] - Error in Log when creating a backup (alchemy_exporter.py:186: SAWarning: Cannot correctly sort tables; there are unresolvable cycles between tables "recipes, users"( #4834

Open
5 of 6 tasks
Christian-Me opened this issue Jan 5, 2025 · 0 comments
Labels
bug Something isn't working triage

Comments

@Christian-Me
Copy link

First Check

  • This is not a feature request.
  • I added a very descriptive title to this issue (title field is above this).
  • I used the GitHub search to find a similar issue and didn't find it.
  • I searched the Mealie documentation, with the integrated search.
  • I already read the docs and didn't find an answer.
  • This issue can be replicated on the demo site (https://demo.mealie.io/).

What is the issue you are experiencing?

When creating a backup i get this error message in the log. Don't know if this is relevant.

INFO     2025-01-05T14:58:09 - [172.17.0.1:51538] 200 OK "GET /api/admin/backups HTTP/1.1"
INFO     2025-01-05T14:58:12 - Checking for migration data fixes
/app/mealie/services/backups_v2/alchemy_exporter.py:186: SAWarning: Cannot correctly sort tables; there are unresolvable cycles between tables "recipes, users", which is usually caused by mutually dependent foreign key constraints.  Foreign key constraints involving these tables will not be considered; this warning may raise an error in a future release.
  for table in self.meta.sorted_tables

Steps to Reproduce

create a backup

Please provide relevant logs

INFO 2025-01-05T14:58:09 - [172.17.0.1:51538] 200 OK "GET /api/admin/backups HTTP/1.1"
INFO 2025-01-05T14:58:12 - Checking for migration data fixes
/app/mealie/services/backups_v2/alchemy_exporter.py:186: SAWarning: Cannot correctly sort tables; there are unresolvable cycles between tables "recipes, users", which is usually caused by mutually dependent foreign key constraints. Foreign key constraints involving these tables will not be considered; this warning may raise an error in a future release.
for table in self.meta.sorted_tables

Mealie Version

docker image 2.4.1

Deployment

Docker (Windows)

Additional Deployment Details

No response

@Christian-Me Christian-Me added bug Something isn't working triage labels Jan 5, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working triage
Projects
None yet
Development

No branches or pull requests

1 participant