RBlhaze
RBlhaze
PostsComments
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
It was the rate limit indeed. Consider this solved, many thanks for your time. Cheers
19 replies
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
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.
19 replies
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
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 👍
19 replies
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
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
19 replies
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
Which policy should i put in? It has non null constraint
19 replies
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
Do you mean reinserting the row? I'm not sure which values to use aside from id and workspace_id. Thanks for your patience
19 replies
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
I've manually delete one of them, but now the app table appears to be empty
19 replies
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
@rubenf i've done so, but now i get 
INFO Binary is in 'server' mode | timestamp=2024-04-12T16:11:43.197934Z target=windmill 
INFO Connecting to database... | timestamp=2024-04-12T16:11:43.202512Z target=windmill 
INFO Database connected | timestamp=2024-04-12T16:11:43.368182Z target=windmill 
INFO PostgreSQL version: PostgreSQL 16.1 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-6), 64-bit (windmill require PG >= 14) | timestamp=2024-04-12T16:11:43.377295Z target=windmill 
INFO Acquiring global PG lock for potential migration with pid: Some(23537) | timestamp=2024-04-12T16:11:43.379968Z target=windmill_api::db 
INFO Acquired global PG lock | timestamp=2024-04-12T16:11:43.381494Z target=windmill_api::db 
INFO Started applying migration 20240209103543: update app new | timestamp=2024-04-12T16:11:43.385891Z target=windmill_api::db 
INFO Finished applying migration 20240209103543 | timestamp=2024-04-12T16:11:43.388612Z target=windmill_api::db 
Error: Migrating database: while executing migrations: error returned from database: null value in column "app_id" of relation "app_version" violates not-null constraint
Caused by:
    0: while executing migrations: error returned from database: null value in column "app_id" of relation "app_version" violates not-null constraint
    1: error returned from database: null value in column "app_id" of relation "app_version" violates not-null constraint
    2: null value in column "app_id" of relation "app_version" violates not-null constraint
INFO Binary is in 'server' mode | timestamp=2024-04-12T16:11:43.197934Z target=windmill 
INFO Connecting to database... | timestamp=2024-04-12T16:11:43.202512Z target=windmill 
INFO Database connected | timestamp=2024-04-12T16:11:43.368182Z target=windmill 
INFO PostgreSQL version: PostgreSQL 16.1 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-6), 64-bit (windmill require PG >= 14) | timestamp=2024-04-12T16:11:43.377295Z target=windmill 
INFO Acquiring global PG lock for potential migration with pid: Some(23537) | timestamp=2024-04-12T16:11:43.379968Z target=windmill_api::db 
INFO Acquired global PG lock | timestamp=2024-04-12T16:11:43.381494Z target=windmill_api::db 
INFO Started applying migration 20240209103543: update app new | timestamp=2024-04-12T16:11:43.385891Z target=windmill_api::db 
INFO Finished applying migration 20240209103543 | timestamp=2024-04-12T16:11:43.388612Z target=windmill_api::db 
Error: Migrating database: while executing migrations: error returned from database: null value in column "app_id" of relation "app_version" violates not-null constraint
Caused by:
    0: while executing migrations: error returned from database: null value in column "app_id" of relation "app_version" violates not-null constraint
    1: error returned from database: null value in column "app_id" of relation "app_version" violates not-null constraint
    2: null value in column "app_id" of relation "app_version" violates not-null constraint
19 replies
WWindmill
Created by RBlhaze on 4/12/2024 in #help
Database migration error
|id| |--| |1| |1| Is this duplication the issue? What should i do then? Thanks for your support
19 replies
WWindmill
Created by RBlhaze on 11/23/2023 in #help
Self-hosted instance workspace bulk migration
This actually worked pretty well, i will give it a few days to test my scheduled flows an apps, but the environment went up smoothly and no data appear to be missing.Thanks a lot for now! If anything else comes up, I'll post in this thread. Hope everyone has a great weekend!
9 replies
WWindmill
Created by RBlhaze on 11/23/2023 in #help
Self-hosted instance workspace bulk migration
I hope i didn't got something wrong troubleshooting the deployment process, but the new version of windmill I was trying to install seemed being incompatible with potsgres 12 so the deployment process failed repeatedly. Hence the new installation.
9 replies
WWindmill
Created by RBlhaze on 11/23/2023 in #help
Self-hosted instance workspace bulk migration
I will give it a try, ty. Eventually i will get back here with some feedback.
9 replies