From nobody Fri Nov 11 18:22:59 2022 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4N86Wl3ZWtz4dYd0 for ; Fri, 11 Nov 2022 18:22:59 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4N86Wl2FHBz3qSM for ; Fri, 11 Nov 2022 18:22:59 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1668190979; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=tkB98cxsZDzqYzJ6zUx1jPXJRqUIZIJdAzNSIDElwKk=; b=L/R8UKpNHNbE4jauUZ+M1WOE50t39BkgZ44H27YfcCAA8nWG67OUmx915MsF4/0wGGWkU5 V3rR7anHZFy1fNHhEfvWTWipwB0oJqYCgii5rwdgAP79IaDE7Ek/RKmLA5hMvHAE8b31MI /vdR3/B1j7WwZdmmDvjHoNqcwW6Ra4pxShQ613+gWnfPsBTSk7hQFl9seF6kX3t7peUijo hL+3L65FTez9+9F8M+W4FO9q81sTU24FYX+WmUIT6RYboY+SoVbMMzhDSS0JgOra7W+MYB 822SlHVujDg7sVfHaUl+NGnFtoAbZYkwF8vSFdv4QD6r85FMVyaIP2imQqf/EA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1668190979; a=rsa-sha256; cv=none; b=s1z1EsiWy6sPRotA9OVp54TsyesZjcCvJWVtPa3dhM2nwgJBFZiqRxIVgE0JmnjIJp76k1 TFXWdA83abtLYio0uEQjbt4TvTCk67E/NEjuqYzGxJR77YlB5uLL/Cbrj4dsmVW4by9sj5 v+mZ6d5cYOJwsqcA7UkD3O4Penxl6cc6VX3NSJqb0o1rQVGC5uSyX014g0yq4o02qV6ipT qD3kQ1BxU10hGTeAcSfiN5Ksvg35zHwc0jCgVVKAIU+79oqrZBcAOBRxLNS3QcgE+5XnXB mGeTsvWtEwmTmAfmUFjTLKWc0pJedgKkpp9Pm1fIGytxYuoLmNBqfe8WHrhU5Q== ARC-Authentication-Results: i=1; mx1.freebsd.org; none Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4N86Wl1JT5zsLq for ; Fri, 11 Nov 2022 18:22:59 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 2ABIMxqq098042 for ; Fri, 11 Nov 2022 18:22:59 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 2ABIMxoG098041 for ports-bugs@FreeBSD.org; Fri, 11 Nov 2022 18:22:59 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 267716] www/gitlab-ce upgrade to 15.4.4 fails during database migration Date: Fri, 11 Nov 2022 18:22:59 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: gwright@antiope.com X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: mfechner@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D267716 Bug ID: 267716 Summary: www/gitlab-ce upgrade to 15.4.4 fails during database migration Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: mfechner@FreeBSD.org Reporter: gwright@antiope.com Assignee: mfechner@FreeBSD.org Flags: maintainer-feedback?(mfechner@FreeBSD.org) I upgraded from www/gitlab-ce 15.3.4 to 15.4.4. The upgrade failed in the database migration phase: root@gitlab:/usr/local/www/gitlab-ce # su -l git -c "cd /usr/local/www/gitlab-ce && rake db:migrate RAILS_ENV=3Dproduction" WARNING: Nokogiri was built against libxml version 2.10.2, but has dynamica= lly loaded 2.10.3 main: =3D=3D 20220902204048 MoveSecurityFindingsTableToGitlabPartitionsDynamicSchema: migrating main: -- transaction_open?() main: -> 0.0000s main: -- execute("LOCK TABLE vulnerability_scanners, security_scans, security_findings IN ACCESS EXCLUSIVE MODE\n") main: -> 0.0006s main: -- execute("SELECT\n=20 pg_get_constraintdef(pg_catalog.pg_constraint.oid)\nFROM\n=20 pg_catalog.pg_constraint\nINNER JOIN pg_class ON pg_class.oid =3D pg_catalog.pg_constr aint.conrelid\nWHERE\n conname =3D 'check_partition_number' AND\n=20 pg_class.relname =3D 'security_findings'\n") main: -> 0.0100s main: -- execute("ALTER TABLE security_findings RENAME TO security_findings_1;\n") main: -> 0.0006s main: -- execute("ALTER INDEX security_findings_pkey RENAME TO security_findings_1_pkey;\n") main: -> 0.0005s main: -- execute("CREATE TABLE security_findings (\n LIKE security_finding= s_1 INCLUDING ALL\n) PARTITION BY LIST (partition_number);\n") main: -> 0.0121s main: -- execute("ALTER SEQUENCE security_findings_id_seq OWNED BY public.security_findings.id;\n") rake aborted! StandardError: An error has occurred, all later migrations canceled: PG::ObjectNotInPrerequisiteState: ERROR: sequence must have same owner as table it is linked to /usr/local/www/gitlab-ce/db/post_migrate/20220902204048_move_security_findi= ngs_table_to_gitlab_partitions_dynamic_schema.rb:80:in `block in up' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:123:in `run_block' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:134:in `b= lock in run_block_with_lock_timeout' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:97:in `ru= n' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers.rb:452:in `with_lock_retries' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/v2.rb:117:in `with_lock_retries' /usr/local/www/gitlab-ce/db/post_migrate/20220902204048_move_security_findi= ngs_table_to_gitlab_partitions_dynamic_schema.rb:63:in `up' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/restrict_git= lab_schema.rb:33:in `block in exec_migration' /usr/local/www/gitlab-ce/lib/gitlab/database/query_analyzer.rb:37:in `withi= n' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/restrict_git= lab_schema.rb:30:in `exec_migration' /usr/local/www/gitlab-ce/lib/gitlab/database/migrations/lock_retry_mixin.rb= :36:in `ddl_transaction' Caused by: ActiveRecord::StatementInvalid: PG::ObjectNotInPrerequisiteState: ERROR:=20 sequence must have same owner as table it is linked to /usr/local/www/gitlab-ce/db/post_migrate/20220902204048_move_security_findi= ngs_table_to_gitlab_partitions_dynamic_schema.rb:80:in `block in up' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:123:in `run_block' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:134:in `b= lock in run_block_with_lock_timeout' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:97:in `ru= n' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers.rb:452:in `with_lock_retries' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/v2.rb:117:in `with_lock_retries' /usr/local/www/gitlab-ce/db/post_migrate/20220902204048_move_security_findi= ngs_table_to_gitlab_partitions_dynamic_schema.rb:63:in `up' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/restrict_git= lab_schema.rb:33:in `block in exec_migration' /usr/local/www/gitlab-ce/lib/gitlab/database/query_analyzer.rb:37:in `withi= n' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/restrict_git= lab_schema.rb:30:in `exec_migration' /usr/local/www/gitlab-ce/lib/gitlab/database/migrations/lock_retry_mixin.rb= :36:in `ddl_transaction' Caused by: PG::ObjectNotInPrerequisiteState: ERROR: sequence must have same owner as table it is linked to /usr/local/www/gitlab-ce/db/post_migrate/20220902204048_move_security_findi= ngs_table_to_gitlab_partitions_dynamic_schema.rb:80:in `block in up' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:123:in `run_block' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:134:in `b= lock in run_block_with_lock_timeout' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:129:in `run_block_with_lock_timeout' /usr/local/www/gitlab-ce/lib/gitlab/database/with_lock_retries.rb:97:in `ru= n' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers.rb:452:in `with_lock_retries' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/v2.rb:117:in `with_lock_retries' /usr/local/www/gitlab-ce/db/post_migrate/20220902204048_move_security_findi= ngs_table_to_gitlab_partitions_dynamic_schema.rb:63:in `up' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/restrict_git= lab_schema.rb:33:in `block in exec_migration' /usr/local/www/gitlab-ce/lib/gitlab/database/query_analyzer.rb:37:in `withi= n' /usr/local/www/gitlab-ce/lib/gitlab/database/migration_helpers/restrict_git= lab_schema.rb:30:in `exec_migration' /usr/local/www/gitlab-ce/lib/gitlab/database/migrations/lock_retry_mixin.rb= :36:in `ddl_transaction' Tasks: TOP =3D> db:migrate (See full trace by running task with --trace) root@gitlab:/usr/local/www/gitlab-ce # This seems to have something to do with this recent bug report: https://forum.gitlab.com/t/error-sequence-must-have-same-owner-as-table-it-= is-linked-to/77279 A similar report from last month: https://forum.gitlab.com/t/db-migration-error-when-upgrading-to-gitlab-v15-= 4/75828 This report give more hints on what to do: https://forum.gitlab.com/t/db-migration-fails-on-latest-update/47988/4 I will try to follow the procedure described in the last to see if the prob= lem can be worked around. --=20 You are receiving this mail because: You are the assignee for the bug.=