Differences

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

--- gitlab [2025/09/11 09:44] – baumi
+++ gitlab [2026/10/03 11:33] (current) – [Check Pipelines] baumi
@@ Line 1: / Line 1: @@
 ====== Gitlab ======
-===== Check Background Migrations from CLI =====
+===== Query Gitlab Database =====
-<code>
+<code bash>
-gitlab-psql -c "SELECT job_class_name, table_name, column_name, job_arguments FROM batched_background_migrations WHERE status NOT IN(3, 6);"
+# 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>