CI pipelines not triggered on push, but work flawlessly if manually triggered

Hi all, I'm having the issue, that for about 3 weeks(~15.02.24), gitlab pipelines are not triggered automatically anymore on push events or merge events. Manually triggered pipelines still work as expected and run. the only hint I have is some warning that happens on this event from sidekiq:

{"severity":"WARN","time":"2024-03-12T13:15:07.236Z","retry":3,"queue":"default","version":0,"args":["project-146","key-266","1d0b46ea4ff345f34d71dc63ce3844d98133862e b6168f6a10d1ecad4fffe97c6d4dbe51292238eb refs/heads/master\n","{}"],"class":"PostReceive","jid":"d6ca5b9a6a3e9ae96e992fb3","created_at":"2024-03-12T13:14:08.031Z","correlation_id":"d478849759fb725acf4ce6927013fed0","meta.caller_id":"POST /api/:version/internal/post_receive","meta.remote_ip":"127.0.0.1","meta.feature_category":"source_code_management","meta.user":"fgoth","meta.user_id":45,"meta.project":"fgoth/zeta","meta.root_namespace":"fgoth","meta.client_id":"user/45","meta.root_caller_id":"POST /api/:version/internal/post_receive","worker_data_consistency":"always","size_limiter":"validated","enqueued_at":"2024-03-12T13:15:06.455Z","retry_count":1,"retried_at":"2024-03-12T13:14:29.238Z","job_size_bytes":132,"pid":14680,"message":"PostReceive JID-d6ca5b9a6a3e9ae96e992fb3: fail: 0.777912 sec","job_status":"fail","scheduling_latency_s":0.002138,"gitaly_calls":12,"gitaly_duration_s":0.054834,"redis_calls":80,"redis_allowed_cross_slot_calls":4,"redis_duration_s":0.021326,"redis_read_bytes":742,"redis_write_bytes":5886,"redis_cache_calls":13,"redis_cache_duration_s":0.003133,"redis_cache_read_bytes":146,"redis_cache_write_bytes":907,"redis_queues_calls":4,"redis_queues_duration_s":0.002961,"redis_queues_read_bytes":4,"redis_queues_write_bytes":1556,"redis_queues_metadata_calls":2,"redis_queues_metadata_duration_s":0.001971,"redis_queues_metadata_read_bytes":4,"redis_queues_metadata_write_bytes":416,"redis_repository_cache_calls":49,"redis_repository_cache_allowed_cross_slot_calls":4,"redis_repository_cache_duration_s":0.01216,"redis_repository_cache_read_bytes":540,"redis_repository_cache_write_bytes":2608,"redis_shared_state_calls":12,"redis_shared_state_duration_s":0.001101,"redis_shared_state_read_bytes":48,"redis_shared_state_write_bytes":399,"db_count":118,"db_write_count":82,"db_cached_count":0,"db_replica_count":0,"db_primary_count":118,"db_main_count":36,"db_ci_count":82,"db_main_replica_count":0,"db_ci_replica_count":0,"db_replica_cached_count":0,"db_primary_cached_count":0,"db_main_cached_count":0,"db_ci_cached_count":0,"db_main_replica_cached_count":0,"db_ci_replica_cached_count":0,"db_replica_wal_count":0,"db_primary_wal_count":0,"db_main_wal_count":0,"db_ci_wal_count":0,"db_main_replica_wal_count":0,"db_ci_replica_wal_count":0,"db_replica_wal_cached_count":0,"db_primary_wal_cached_count":0,"db_main_wal_cached_count":0,"db_ci_wal_cached_count":0,"db_main_replica_wal_cached_count":0,"db_ci_replica_wal_cached_count":0,"db_replica_duration_s":0.0,"db_primary_duration_s":0.158,"db_main_duration_s":0.082,"db_ci_duration_s":0.076,"db_main_replica_duration_s":0.0,"db_ci_replica_duration_s":0.0,"cpu_s":0.575651,"mem_objects":361349,"mem_bytes":12116654,"mem_mallocs":69320,"mem_total_bytes":26570614,"worker_id":"sidekiq_0","rate_limiting_gates":["pipelines_create"],"duration_s":0.777912,"completed_at":"2024-03-12T13:15:07.235Z","load_balancing_strategy":"primary","exception.class":"ActiveRecord::NotNullViolation","exception.message":"PG::NotNullViolation: ERROR: null value in column "partition_id" of relation "ci_pipelines_config" violates not-null constraint\nDETAIL: Failing row contains (22369, ---\ninclude:\n- local: ".gitlab-ci.yml"\n, null).\n","exception.backtrace":["lib/gitlab/database/load_balancing/connection_proxy.rb:127:in public_send'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in block in write_using_load_balancer'","lib/gitlab/database/load_balancing/load_balancer.rb:141:in block in read_write'","lib/gitlab/database/load_balancing/load_balancer.rb:228:in retry_with_backoff'","lib/gitlab/database/load_balancing/load_balancer.rb:130:in read_write'","lib/gitlab/database/load_balancing/connection_proxy.rb:126:in write_using_load_balancer'","lib/gitlab/database/load_balancing/connection_proxy.rb:61:in block (2 levels) in \u003cclass:ConnectionProxy\u003e'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in public_send'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in block in write_using_load_balancer'","lib/gitlab/database/load_balancing/load_balancer.rb:141:in block in read_write'","lib/gitlab/database/load_balancing/load_balancer.rb:228:in retry_with_backoff'","lib/gitlab/database/load_balancing/load_balancer.rb:130:in read_write'","lib/gitlab/database/load_balancing/connection_proxy.rb:126:in write_using_load_balancer'","lib/gitlab/database/load_balancing/connection_proxy.rb:78:in transaction'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in public_send'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in block in write_using_load_balancer'","lib/gitlab/database/load_balancing/load_balancer.rb:141:in block in read_write'","lib/gitlab/database/load_balancing/load_balancer.rb:228:in retry_with_backoff'","lib/gitlab/database/load_balancing/load_balancer.rb:130:in read_write'","lib/gitlab/database/load_balancing/connection_proxy.rb:126:in write_using_load_balancer'","lib/gitlab/database/load_balancing/connection_proxy.rb:78:in transaction'","lib/gitlab/ci/pipeline/chain/create.rb:16:in block (4 levels) in perform!'","app/models/concerns/cross_database_modification.rb:92:in block in transaction'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in public_send'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in block in write_using_load_balancer'","lib/gitlab/database/load_balancing/load_balancer.rb:141:in block in read_write'","lib/gitlab/database/load_balancing/load_balancer.rb:228:in retry_with_backoff'","lib/gitlab/database/load_balancing/load_balancer.rb:130:in read_write'","lib/gitlab/database/load_balancing/connection_proxy.rb:126:in write_using_load_balancer'","lib/gitlab/database/load_balancing/connection_proxy.rb:78:in transaction'","lib/gitlab/database.rb:359:in block in transaction'","lib/gitlab/database.rb:358:in transaction'","app/models/concerns/cross_database_modification.rb:83:in transaction'","lib/gitlab/ci/pipeline/chain/create.rb:15:in block (3 levels) in perform!'","app/models/concerns/ci/bulk_insertable_tags.rb:13:in with_bulk_insert_tags'","lib/gitlab/ci/pipeline/chain/create.rb:14:in block (2 levels) in perform!'","app/models/concerns/bulk_insertable_associations.rb:54:in with_bulk_insert'","lib/gitlab/ci/pipeline/chain/create.rb:13:in block in perform!'","lib/gitlab/ci/pipeline/logger.rb:27:in instrument'","lib/gitlab/ci/pipeline/logger.rb:43:in instrument_once_with_sql'","lib/gitlab/ci/pipeline/chain/create.rb:12:in perform!'","lib/gitlab/ci/pipeline/chain/sequence.rb:20:in block in build!'","lib/gitlab/ci/pipeline/chain/sequence.rb:16:in each'","lib/gitlab/ci/pipeline/chain/sequence.rb:16:in build!'","app/services/ci/create_pipeline_service.rb:93:in execute'","app/services/git/base_hooks_service.rb:59:in create_pipelines'","app/services/git/base_hooks_service.rb:13:in execute'","app/services/git/branch_hooks_service.rb:13:in execute'","app/services/git/branch_push_service.rb:78:in execute_related_hooks'","app/services/git/branch_push_service.rb:29:in execute'","app/services/git/process_ref_changes_service.rb:59:in block in process_changes'","app/services/git/process_ref_changes_service.rb:49:in each'","app/services/git/process_ref_changes_service.rb:49:in process_changes'","app/services/git/process_ref_changes_service.rb:22:in block in process_changes_by_action'","app/services/git/process_ref_changes_service.rb:21:in each'","app/services/git/process_ref_changes_service.rb:21:in process_changes_by_action'","app/services/git/process_ref_changes_service.rb:10:in execute'","app/workers/post_receive.rb:134:in process_ref_changes'","app/workers/post_receive.rb:66:in process_project_changes'","app/workers/post_receive.rb:36:in perform'","lib/gitlab/sidekiq_middleware/skip_jobs.rb:49:in call'","lib/gitlab/database/load_balancing/sidekiq_server_middleware.rb:29:in call'","lib/gitlab/sidekiq_middleware/duplicate_jobs/strategies/none.rb:14:in perform'","lib/gitlab/sidekiq_middleware/duplicate_jobs/duplicate_job.rb:44:in perform'","lib/gitlab/sidekiq_middleware/duplicate_jobs/server.rb:8:in call'","lib/click_house/migration_support/sidekiq_middleware.rb:7:in call'","lib/gitlab/sidekiq_middleware/pause_control/strategies/base.rb:31:in perform'","lib/gitlab/sidekiq_middleware/pause_control/strategy_handler.rb:22:in perform'","lib/gitlab/sidekiq_middleware/pause_control/server.rb:8:in call'","lib/gitlab/sidekiq_middleware/worker_context.rb:9:in wrap_in_optional_context'","lib/gitlab/sidekiq_middleware/worker_context/server.rb:19:in block in call'","lib/gitlab/application_context.rb:130:in block in use'","lib/gitlab/application_context.rb:130:in use'","lib/gitlab/application_context.rb:64:in with_context'","lib/gitlab/sidekiq_middleware/worker_context/server.rb:17:in call'","lib/gitlab/sidekiq_status/server_middleware.rb:7:in call'","lib/gitlab/sidekiq_versioning/middleware.rb:9:in call'","lib/gitlab/sidekiq_middleware/query_analyzer.rb:7:in block in call'","lib/gitlab/database/query_analyzer.rb:37:in within'","lib/gitlab/sidekiq_middleware/query_analyzer.rb:7:in call'","lib/gitlab/sidekiq_middleware/admin_mode/server.rb:14:in call'","lib/gitlab/sidekiq_middleware/instrumentation_logger.rb:9:in call'","lib/gitlab/sidekiq_middleware/batch_loader.rb:7:in call'","lib/gitlab/sidekiq_middleware/extra_done_log_metadata.rb:7:in call'","lib/gitlab/sidekiq_middleware/request_store_middleware.rb:8:in block in call'","lib/gitlab/sidekiq_middleware/request_store_middleware.rb:7:in call'","lib/gitlab/sidekiq_middleware/server_metrics.rb:105:in block in call'","lib/gitlab/sidekiq_middleware/server_metrics.rb:133:in block in instrument'","lib/gitlab/metrics/background_transaction.rb:33:in run'","lib/gitlab/sidekiq_middleware/server_metrics.rb:133:in instrument'","lib/gitlab/sidekiq_middleware/server_metrics.rb:104:in call'","lib/gitlab/sidekiq_middleware/monitor.rb:10:in block in call'","lib/gitlab/sidekiq_daemon/monitor.rb:46:in within_job'","lib/gitlab/sidekiq_middleware/monitor.rb:9:in call'","lib/gitlab/sidekiq_middleware/size_limiter/server.rb:13:in call'","lib/gitlab/sidekiq_logging/structured_logger.rb:21:in call'"],"exception.cause_class":"PG::NotNullViolation","exception.sql":"/application:sidekiq,correlation_id:d478849759fb725acf4ce6927013fed0,jid:d6ca5b9a6a3e9ae96e992fb3,endpoint_id:PostReceive,db_config_name:ci/ INSERT INTO "ci_pipelines_config" ("pipeline_id", "content") VALUES ($1, $2) RETURNING "pipeline_id"","db_duration_s":0.155297,"urgency":"high","target_duration_s":10,"target_scheduling_latency_s":10}

The gist of it seems to be this:

"ActiveRecord::NotNullViolation","exception.message":"PG::NotNullViolation: ERROR: null value in column \"partition_id\" of relation \"ci_pipelines_config\" violates not-null constraint\nDETAIL: Failing row contains (22369, ---\ninclude:\n- local: \".gitlab-ci.yml\"\n, null).\n","exception.backtrace":

Any help appreciated, since I'm running out of ideas....