Differences

This shows you the differences between two versions of the page.

--- gitlab [2025/09/11 09:42] – created baumi
+++ gitlab [2026/10/03 11:33] (current) – [Check Pipelines] baumi
@@ Line 1: / Line 1: @@
 ====== Gitlab ======
-===== Multiplattform Build =====
+===== Query Gitlab Database =====
+<code bash>
+# Interactivly
+gitlab-sql
+# Query on Command line
+gitlab-sql -c "<sql>"
+</code>
+==== Check Background Migrations from CLI ====
+<code sql>
+SELECT job_class_name
+     , table_name
+     , column_name
+     , job_arguments
+FROM batched_background_migrations
+WHERE status NOT IN(3, 6);
+</code>
+==== Check Pipelines ====
+<code sql>
+SELECT
+    p.id as pipeline_id,
+    pr.name as project_name,
+    pr.path as project_path,
+    p.ref,
+    p.status,
+    p.started_at
+FROM
+    p_ci_pipelines p
+JOIN
+    projects pr ON p.project_id = pr.id
+-- WHERE p.status IN ('pending', 'running')
+ORDER BY
+    p.started_at DESC;
+</code>
+===== Garbage Collection Container Registry =====
+<code>
+gitlab-ctl registry-garbage-collect -m
+</code>
+===== CI/CD Multiplattform Build =====
 ==== Enable Binary Formats ====
 <code bash>
@@ Line 26: / Line 68: @@
 </code>
-===== Switch to buildx in .gitlab-ci.yml =====
+==== Switch to buildx in .gitlab-ci.yml ====
 Define CI_PLATFORMS variable in Settings / CI/CD:
@@ Line 46: / Line 88: @@
+{{tag>kb git}}