1069ad3999
fix: improve v2 migration finalizer to avoid deadlocks
2025-02-18 13:17:10 +01:00
9234701f05
ensure index creation of root_job_by_path
2025-02-17 23:57:38 +01:00
85c56e9450
fix: improve que job indices for faster performances
2025-02-17 19:17:30 +01:00
5e22690bd9
fix: improve que job indices for faster performances
2025-02-17 17:56:28 +01:00
266f82046a
fix: improve runs page load time
2025-02-14 13:30:07 +01:00
586044e077
v2 list jobs
2025-02-13 23:53:00 +01:00
86d45c61c9
fix extra_perms for schedule light
2025-02-13 21:34:53 +01:00
a814024440
re-enable RLS on v2_job
2025-02-13 21:04:17 +01:00
1e45903d78
re-do the migration finalization but now with BYPASSRLS for v2_job_queue and v2_job_completed
2025-02-13 20:03:48 +01:00
fad6dc4400
Revert "revert last commit"
...
This reverts commit b6a57207a2
2025-02-13 19:45:52 +01:00
b6a57207a2
revert last commit
2025-02-13 19:38:58 +01:00
9a5fe90bdd
Revert "migration to remove unecessary triggers and fields after job v2"
...
This reverts commit 029e2c7537
2025-02-13 19:37:45 +01:00
029e2c7537
migration to remove unecessary triggers and fields after job v2
2025-02-13 19:18:32 +01:00
4fa897fbb6
remove v5 migration
2025-02-13 17:51:03 +01:00
b1f358d4a2
backend: finalize v2 migration (v2 phase 4 - final) ( #5155 )
...
* backend: finalize v2 migration (v2 phase 4 - final)
* update migration
---------
Co-authored-by: Ruben Fiszel <ruben@windmill.dev >
2025-02-13 17:10:30 +01:00
bf206515e8
fix(backend): improve schedule queries plan to leverage indices better for performance ( #5273 )
...
* backend: fix schedule queries plan
* rework
* fix skipped as non success
* update sqlx
* update
* all
* fix npm run check
---------
Co-authored-by: Ruben Fiszel <ruben@windmill.dev >
2025-02-12 16:34:03 +01:00
4849af04de
backend: fix workflow as code ( #5239 )
...
* backend: improve `/get_job_update` after v2
* backend: insert missing `workflow_as_code_status` on completion
also insert `flow_status` from so we can remove the query when `_duration` is above 500
* backend: fix workflow_as_code after v2
* backend: add `workflow_as_code` worker test
2025-02-07 12:27:43 +01:00
f12d6e5d20
clarify migration lock message
2025-02-07 09:02:38 +01:00
2478df52a5
backend: un-queue zombies left by missing row in v2_job_runtime ( #5232 )
2025-02-06 16:46:32 +01:00
3e8e0c653e
backend: migrate job tables to v2 schema (v2 phase 1) ( #5084 )
2025-02-06 12:37:11 +01:00
99b3308c56
Fix otel migration error ( #5189 )
...
* Fix otel migration error
1: error returned from database: duplicate key value violates unique constraint "global_settings_pkey"
0: while executing migration 20250131115248: error returned from database: duplicate key value violates unique constraint "global_settings_pkey"
* delete migration
* add .sqlx cache + move otel_global_settings to new location
* Fix compilation error
* Move before migrating
* Add error handler
* warn -> info
---------
Co-authored-by: Ruben Fiszel <ruben@windmill.dev >
2025-01-31 19:34:23 +01:00
ab38215c86
fix(backend): in flows, workspace scripts should use their set tags instead of the default one
2024-10-29 07:29:39 +01:00
8841180b5f
BYPASSRLS admin policy falllback ( #4493 )
...
* BYPASSRLS admin policy falllback
* use fixed list instead
---------
Co-authored-by: Ruben Fiszel <ruben@windmill.dev >
2024-10-08 20:08:29 +02:00
16692d5ff6
fix: fix new instance db setup
2024-10-01 16:03:58 +02:00
f438d1adbe
fix: skip one migration to avoid using md5 for azure support
2024-09-30 14:02:31 +02:00
41ff40f777
send stats when renewing key if last >24h ( #4430 )
...
* feat: send stats when renewing key if last >24h
* nits
* fix: sqlx
* nit
* renewal reason
* stats reason
* update ee ref
* Update ee-repo-ref.txt
---------
Co-authored-by: Ruben Fiszel <ruben@windmill.dev >
2024-09-30 12:23:07 +02:00
84e18c73c0
fix: improve wm_labels indices + UX nits
2024-09-04 11:40:23 +02:00
ccc86ca88b
refactor windmill concurrent index migrations using a macro ( #4275 )
...
* Add macro to run migrations
* Factor windmill migrations into the new macro
* Run formatter
2024-08-21 17:15:08 +02:00
25434168d8
add global created_at index
2024-08-05 13:12:15 +02:00
c956ecd1a8
feat: improve indices of completed_runs for faster load
2024-08-05 12:46:07 +02:00
69e400563c
feat: variables created by password fields expire after 7 days
2024-08-01 16:05:03 +02:00
78c115c68c
fix: improve index usage and runs page performance
2024-07-31 13:08:28 +02:00
135f57eb5a
fix: improve runs page performance through pg indices
2024-07-27 12:16:13 +02:00
be7e7ba05c
fix: fix migration for instances starting from scratch
2024-07-11 02:12:51 +02:00
9e27ee8b57
improve try migration lock
2024-07-11 01:15:12 +02:00
33ca9bd101
fix: improve completed_job index
2024-07-10 23:43:02 +02:00
bbcaec9769
fix: improve flow version fix migration ( #4050 )
2024-07-09 11:02:53 +02:00
ff8d51a8db
fix: always run flow versioning edge case fix migration ( #4047 )
2024-07-08 22:52:04 +02:00
0a613b76c8
fix: flow versioning edge case ( #4037 )
2024-07-07 20:04:42 +02:00
6a332bc30f
fix: make all error strings more verbose
2024-05-25 22:15:15 +02:00
126459f972
feat: improve permissioned audit logs ( #3799 )
...
* fix: increase token label size in db
* Revert "Revert "feat: improve premissioned audit logs (#3793 )" (#3798 )"
This reverts commit afae33f5f8
2024-05-23 17:23:50 +02:00
afae33f5f8
Revert "feat: improve premissioned audit logs ( #3793 )" ( #3798 )
...
This reverts commit 35f8eecf2d
2024-05-23 11:12:51 +02:00
35f8eecf2d
feat: improve premissioned audit logs ( #3793 )
...
* feat: improve premissioned audit logs
* chore: update ee ref
* fix: build
* fix: sqlx
2024-05-23 08:55:48 +02:00
c5de8365ec
feat: support multiple labels for jobs (wm_label -> wm_labels)
2024-04-24 11:32:25 +02:00
ba4efb7b7e
feat: add label and schedule filters to runs page
2024-04-23 22:48:21 +02:00
9502a5b811
fix: improve locking
2024-04-04 01:10:38 +02:00
8d51cfcadc
fix: use webhook id as username
2024-03-26 10:06:01 +01:00
6320cc9ce5
fix: use try_lock instead of lock to wait for global pg lock
2024-03-14 14:28:13 +01:00
c2e743bb67
fix: show current pid before acquiring lock
2024-03-14 01:02:55 +01:00
1571ab2339
fix: clarify pg migration logs
2024-02-26 20:43:23 +01:00
Ruben Fiszel
Lucas Abel
pyranota
Ruben Fiszel
HugoCasa
wendrul