Takuya Ono activity https://gitlab.com/takuya-o 2025-04-29T15:21:28Z tag:gitlab.com,2025-04-29:4225076317 Takuya Ono opened issue #3: Make `lint_commit` jobs executable at self-managed sites at GitLab components / Code Intelligence 2025-04-29T15:21:28Z takuya-o Takuya Ono tag:gitlab.com,2025-04-29:4225008420 Takuya Ono opened issue #2: Job Failed #9631147918 `code_navigation_golang` job requires go >= 1.24.0 (running go 1.23.8) at GitLab components / Code Intelli... 2025-04-29T15:03:44Z takuya-o Takuya Ono tag:gitlab.com,2023-09-27:2869862097 Takuya Ono commented on issue #8227 at GitLab.org / omnibus-gitlab 2023-09-27T17:12:20Z takuya-o Takuya Ono

I also met the same error. I started using GitLab 6.3 at 2013 by self-building from the source code, and at some point, I converted the backup from MySQL to Postgres, changed it to an omnibus package docker image, and have been updating the version every month. When I upgraded from 16.3.4 to 16.4, I got an error saying:

DETAIL: constraint fk_rails_d83a918cb1 on table system_note_metadata depends on index notes_pkey

That's how the tables were.

gitlabhq_production=# \d system_note_metadata
                                              Table "public.system_note_metadata
"
          Column           |           Type           | Collation | Nullable |  
                   Default                      
---------------------------+--------------------------+-----------+----------+--
------------------------------------------------
 id                        | integer                  |           | not null | n
extval('system_note_metadata_id_seq'::regclass)
 note_id_convert_to_bigint | integer                  |           | not null | 0
 commit_count              | integer                  |           |          | 
 action                    | character varying(510)   |           |          | N
ULL::character varying
 created_at                | timestamp with time zone |           |          | 
 updated_at                | timestamp with time zone |           |          | 
 description_version_id    | bigint                   |           |          | 
 note_id                   | bigint                   |           | not null | 
Indexes:
    "system_note_metadata_pkey" PRIMARY KEY, btree (id)
    "fk_rails_d83a918cb1" btree (note_id_convert_to_bigint)
    "index_system_note_metadata_on_description_version_id" UNIQUE, btree (descri
ption_version_id) WHERE description_version_id IS NOT NULL
    "index_system_note_metadata_on_note_id" UNIQUE, btree (note_id)
    "system_note_metadata_note_id_idx" btree (note_id_convert_to_bigint)
Foreign-key constraints:
    "fk_d83a918cb1" FOREIGN KEY (note_id) REFERENCES notes(id_convert_to_bigint)
 ON DELETE CASCADE
    "fk_fbd87415c9" FOREIGN KEY (description_version_id) REFERENCES description_
versions(id) ON DELETE SET NULL
    "fk_rails_d83a918cb1" FOREIGN KEY (note_id_convert_to_bigint) REFERENCES not
es(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Referenced by:
    TABLE "resource_link_events" CONSTRAINT "fk_2a039c40f4" FOREIGN KEY (system_
note_metadata_id) REFERENCES system_note_metadata(id) ON DELETE CASCADE
Triggers:
    trigger_482bac5ec48a BEFORE INSERT OR UPDATE ON system_note_metadata FOR EAC
H ROW EXECUTE FUNCTION trigger_482bac5ec48a()

After the following command upgrade for 16.4 was well, but I'm not sure if there are no side effects.

gitlabhq_production=# alter table system_note_metadata drop constraint fk_rails_d83a918cb1;
ALTER TABLE
gitlabhq_production=# exit
tag:gitlab.com,2023-08-05:2759960495 Takuya Ono commented on issue #363021 at GitLab.org / GitLab 2023-08-05T16:59:28Z takuya-o Takuya Ono

I met similar issue on GitLab 16.2 AutoDevOps. Other Build jobs etc. are succeeding, but only the CodeQuality job is failing.

$ docker run --rm \ # collapsed multi-line command
error: (CC::CLI::Analyze::EngineFailure) engine eslint failed with status 1 and stderr 
Module not supported: eslint-plugin-simple-import-sort
Module not supported: eslint-plugin-@typescript-eslint
Module not supported: @typescript-eslint/parser
Module not supported: @typescript-eslint/eslint-plugin

It would be fine if I removed .eslintrc.json, but I am in trouble because it is necessary at Build time.