Database migration error
Hi all,
my self-hosted Windmill stopped working and shows this error before failing.
Di you have any suggestion on how tò solve this?
Many thanks for your support.
12 Replies
What does:
return ?
|id|
|--|
|1|
|1|
Is this duplication the issue? What should i do then? Thanks for your support
I don't know how you arrived to that state
but you need to delete one of them
@rubenf i've done so, but now i get
did you delete both of them ?
I've manually delete one of them, but now the app table appears to be empty
try to recreate one at the right path
Do you mean reinserting the row? I'm not sure which values to use aside from id and workspace_id.
Thanks for your patience
put blank where you can, just have it be right workspace id and path
Which policy should i put in? It has non null constraint
Update
I've managed to retrieve data from a dump of the db, and recreated the rows in app table.
Server Is now stuck with a 500 error
that's likely not coming from windmill
but you will have to share more than that
what are the logs of the servers saying
I got a load of 429 errors from the Page in fetching resources. As i'm not seeing errors in the server logs, i'm assuming this has something to do with my rev proxy rate limit. I'll keep you posted while i figure this out, many thanks 👍
Same error even disabling the rate limit, so i'm not quite understandg the 429s.
I will try a few things an post a new update.
Many thanks, your support Is really appreciated.
It was the rate limit indeed. Consider this solved, many thanks for your time. Cheers