mirror of
https://github.com/zitadel/zitadel.git
synced 2025-08-12 12:07:37 +00:00
c877add363
# Which Problems Are Solved
The execution handler projection handles all events to check if an
execution has to be provided to the worker to execute.
In this logic all events would be processed from the beginning which is
not necessary.
# How the Problems Are Solved
Add the current state to the execution handler projection, to avoid
processing all existing events.
# Additional Changes
Add custom configuration to the default, so that the transactions are
limited to some events.
# Additional Context
None
(cherry picked from commit 21167a4bba)
22 lines
1.1 KiB
SQL
22 lines
1.1 KiB
SQL
INSERT INTO projections.current_states AS cs ( instance_id
|
|
, projection_name
|
|
, last_updated
|
|
, sequence
|
|
, event_date
|
|
, position
|
|
, filter_offset)
|
|
SELECT instance_id
|
|
, 'projections.execution_handler'
|
|
, now()
|
|
, $1
|
|
, $2
|
|
, $3
|
|
, 0
|
|
FROM eventstore.events2 AS e
|
|
WHERE aggregate_type = 'instance'
|
|
AND event_type = 'instance.added'
|
|
ON CONFLICT (instance_id, projection_name) DO UPDATE SET last_updated = EXCLUDED.last_updated,
|
|
sequence = EXCLUDED.sequence,
|
|
event_date = EXCLUDED.event_date,
|
|
position = EXCLUDED.position,
|
|
filter_offset = EXCLUDED.filter_offset; |