Skip to content

Rang a Bell

I collect links to things that rang a bell for me. These are things that may not be useful everyday but may be super useful on the day that they are needed.

Run touch /etc/gitlab/skip-auto-backup to get GitLab to skip taking a backup during upgrade.

Issues

GitLab Pages

Docs: Migrate legacy storage to ZIP storage

GitLab tries to automatically migrate the old storage format to the new ZIP-based one when you upgrade to GitLab 13.11 or further.

GitLab Runner

curl -s http://localhost:9402/debug/jobs/list

source

Authentication

See supported user attributes. Those attributes take effect for users created after the attribute is set. In other words: the value is not toggled retroactively. It's queried when the user is created.

can_create_group and projects_limit

SAML

See the docs.

- Each provider has a unique name set that matches a name set in args. At least one provider must have the name saml to mitigate a known issue in GitLab 14.6 and newer.

Unauthenticated connection first

When performing git over HTTP operations, the git client will attempt an unauthenticated connection first. Enable GIT_TRACE to see this on the client side.

GIT_TRACE=true git whatever

In the logs, you'llsee:

10.10.1-.84 - - [26/Aug/2022:03:30:30 +0000] "GET /cats/whatever.git/info/refs?service=git-receive-pack HTTP/2.0" 401 26 "" "git/2.36.1" -
10.10.10.84 - cats [26/Aug/2022:03:30:42 +0000] "GET /cats/whatever.git/info/refs?service=git-receive-pack HTTP/2.0" 401 26 "" "git/2.36.1" -

Docs: Debugging with Git embedded traces

Check the Debugging section of the linked page from the official git documentation.

PostgreSQL

\d is DESCRIBE

I'm used to doing DESCRIBE uploads; in order to get the layout of a table. Unfortunately, postgres doesn't know what I want when I ask for this. The thing I am looking for is \d (and not \dt).

gitlabhq_production=# DESCRIBE uploads;
ERROR:  syntax error at or near "DESCRIBE"
LINE 1: DESCRIBE uploads;

lolwut

gitlabhq_production=# \d uploads
                                         Table "public.uploads"
   Column    |            Type             | Collation | Nullable |               Default
-------------+-----------------------------+-----------+----------+-------------------------------------
 id          | integer                     |           | not null | nextval('uploads_id_seq'::regclass)
 size        | bigint                      |           | not null |
 path        | character varying(511)      |           | not null |
 checksum    | character varying(64)       |           |          |
 model_id    | integer                     |           |          |
 model_type  | character varying           |           |          |
 uploader    | character varying           |           | not null |
 created_at  | timestamp without time zone |           | not null |
 store       | integer                     |           |          | 1
 mount_point | character varying           |           |          |
 secret      | character varying           |           |          |
Indexes:
    "uploads_pkey" PRIMARY KEY, btree (id)
    "index_uploads_on_checksum" btree (checksum)
    "index_uploads_on_model_id_and_model_type" btree (model_id, model_type)
    "index_uploads_on_store" btree (store)
    "index_uploads_on_uploader_and_path" btree (uploader, path)
Check constraints:
    "check_5e9547379c" CHECK (store IS NOT NULL)
Referenced by:
    TABLE "upload_states" CONSTRAINT "fk_rails_d00f153613" FOREIGN KEY (upload_id) REFERENCES uploads(id) ON DELETE CASCADE