Skip to content
Snippets Groups Projects

Bump tested pg versions in preparation of pg14

Merged Alex Ives requested to merge alexives/bump_tested_pg_versions into master
1 unresolved thread

What does this MR do and why?

Curious to see how hard it was to switch from pg12 to pg13 for testing defaults. Just changes the pipeline to use updated versions in preparation for the upgrade to gitlab.com and the omnibus updates in early 16.x

  • Adds pg14 nightly jobs
  • Moves pg12 to nightly
  • Makes pg13 default

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Leonardo da Rosa

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • mentioned in issue #398211 (closed)

  • assigned to @l.rosa

    • Author Maintainer
      Resolved by Leonardo da Rosa

      @l.rosa would you mind taking a look at the failures here to try and get this over the finish line? I kept thinking this would be quick and easy to do on the side, but it's not going as smoothly as that. I'd say we should feel free to err on the side of quick fixes to get specs passing and then we can address root causes in follow ups.

  • Leonardo da Rosa added 531 commits

    added 531 commits

    Compare with previous version

  • Contributor

    Database migrations (on the main database)

    Migrations included in this change have been executed on gitlab.com data for testing purposes. For details, please see the migration testing pipeline (limited access).

    Migration Type Total runtime Result DB size change

    No histogram available for visualization


    Background migrations


    Other migrations pending on GitLab.com
    Migration Type Total runtime Result DB size change
    20230303232426 - AddRoleApproversToScanResultPolicies Regular 2.2 s :white_check_mark: +0.00 B
    20230301020246 - EnsureMrUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom Post deploy 2.4 s :white_check_mark: +0.00 B
    20230301020356 - SwapMergeRequestUserMentionsNoteIdToBigint Post deploy 567.9 s :warning: -1.34 GiB
    20230309085547 - PrepareCiBuildsConstraintsForListPartitioning Post deploy 2.5 s :white_check_mark: +8.00 KiB
    20230310213308 - SyncSecurityPolicyRuleSchedulesThatMayHaveBeenDeletedByABug Post deploy 2.2 s :warning: +0.00 B
    20230315161408 - FinalizeSetNotificationsBigintConversionBackfill Post deploy 1.5 s :white_check_mark: +0.00 B
    20230316114426 - SwapCiRunnerMachineBuildsPrimaryKey Post deploy 2.1 s :warning: +0.00 B
    20230317195228 - PrepareAsyncSentNotificationsIndex Post deploy 1.9 s :white_check_mark: +0.00 B
    20230320155635 - AddIndexToNamespaceDetails Post deploy 255.3 s :white_check_mark: +1008.59 MiB
    20230321011529 - EnsureVumBigintBackfillIsFinishedForGlDotCom Post deploy 2.1 s :white_check_mark: +0.00 B
    20230321011903 - SwapVulnerabilityUserMentionsNoteIdToBigintForGitlabDotCom Post deploy 4.5 s :warning: +0.00 B
    20230321024333 - EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom Post deploy 1.5 s :white_check_mark: +0.00 B
    20230321024903 - SwapDesignUserMentionsNoteIdToBigintForGitlabDotCom Post deploy 65.9 s :warning: -1.50 MiB
    20230321124837 - RemoveCiBuildsPartitionIdDefault Post deploy 1.8 s :white_check_mark: +0.00 B

    Clone Details

    Clone ID Clone Created At Clone Data Timestamp Expected Removal Time
    database-testing-1809712-9569229-main 2023-03-22T17:07:22Z 2023-03-22T12:40:08Z 2023-03-23 05:27:33 +0000
    database-testing-1809712-9569229-ci 2023-03-22T17:07:22Z 2023-03-22T16:45:57Z 2023-03-23 05:27:33 +0000

    Artifacts


    Brought to you by gitlab-org/database-team/gitlab-com-database-testing. Epic

    Database migrations (on the ci database)

    Migrations included in this change have been executed on gitlab.com data for testing purposes. For details, please see the migration testing pipeline (limited access).

    Migration Type Total runtime Result DB size change

    No histogram available for visualization


    Background migrations


    Other migrations pending on GitLab.com
    Migration Type Total runtime Result DB size change
    20230303232426 - AddRoleApproversToScanResultPolicies Regular 2.8 s :white_check_mark: +0.00 B
    20230301020246 - EnsureMrUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom Post deploy 2.0 s :white_check_mark: +0.00 B
    20230301020356 - SwapMergeRequestUserMentionsNoteIdToBigint Post deploy 5.0 s :white_check_mark: -8.00 KiB
    20230309085547 - PrepareCiBuildsConstraintsForListPartitioning Post deploy 2.8 s :white_check_mark: +8.00 KiB
    20230310213308 - SyncSecurityPolicyRuleSchedulesThatMayHaveBeenDeletedByABug Post deploy 1.9 s :white_check_mark: +0.00 B
    20230315161408 - FinalizeSetNotificationsBigintConversionBackfill Post deploy 2.0 s :white_check_mark: +0.00 B
    20230316114426 - SwapCiRunnerMachineBuildsPrimaryKey Post deploy 2.4 s :white_check_mark: -1.01 GiB
    20230317195228 - PrepareAsyncSentNotificationsIndex Post deploy 2.3 s :white_check_mark: +0.00 B
    20230320155635 - AddIndexToNamespaceDetails Post deploy 2.4 s :white_check_mark: +8.00 KiB
    20230321011529 - EnsureVumBigintBackfillIsFinishedForGlDotCom Post deploy 1.9 s :white_check_mark: +0.00 B
    20230321011903 - SwapVulnerabilityUserMentionsNoteIdToBigintForGitlabDotCom Post deploy 5.4 s :warning: +0.00 B
    20230321024333 - EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom Post deploy 2.0 s :white_check_mark: +0.00 B
    20230321024903 - SwapDesignUserMentionsNoteIdToBigintForGitlabDotCom Post deploy 4.3 s :white_check_mark: +0.00 B
    20230321124837 - RemoveCiBuildsPartitionIdDefault Post deploy 2.2 s :white_check_mark: +0.00 B

    Clone Details

    Clone ID Clone Created At Clone Data Timestamp Expected Removal Time
    database-testing-1809712-9569229-main 2023-03-22T17:07:22Z 2023-03-22T12:40:08Z 2023-03-23 05:27:33 +0000
    database-testing-1809712-9569229-ci 2023-03-22T17:07:22Z 2023-03-22T16:45:57Z 2023-03-23 05:27:33 +0000

    Artifacts


    Brought to you by gitlab-org/database-team/gitlab-com-database-testing. Epic

  • added 1 commit

    • c14728d0 - Cast duration as double precision

    Compare with previous version

  • mentioned in issue #398772 (closed)

  • Leonardo da Rosa marked this merge request as ready

    marked this merge request as ready

  • Leonardo da Rosa requested review from @maddievn

    requested review from @maddievn

  • Leonardo da Rosa requested review from @axil

    requested review from @axil

  • removed frontend label

  • Leonardo da Rosa added 112 commits

    added 112 commits

    Compare with previous version

  • A deleted user added frontend label

    added frontend label

  • Madelein van Niekerk
  • Madelein van Niekerk
  • Achilleas Pipinellis approved this merge request

    approved this merge request

  • Achilleas Pipinellis removed review request for @axil

    removed review request for @axil

  • :wave: @axil, thanks for approving this merge request.

    This is the first time the merge request is approved. To ensure full test coverage, a new pipeline will be started shortly.

    For more info, please refer to the following links:

  • added 1 commit

    • ccd27afa - Check PG14 compatibility with ES8

    Compare with previous version

  • Leonardo da Rosa requested review from @a_luna

    requested review from @a_luna

  • It seems that this job is failing because the license key has expired or is invalid

    alt text
    Edited by Leonardo da Rosa
  • Stan Hu resolved all threads

    resolved all threads

  • Stan Hu approved this merge request

    approved this merge request

  • Amparo Luna approved this merge request

    approved this merge request

  • Amparo Luna requested review from @john-mason and removed review request for @a_luna

    requested review from @john-mason and removed review request for @a_luna

  • John Mason
  • John Mason removed review request for @john-mason

    removed review request for @john-mason

  • added 1 commit

    Compare with previous version

  • John Mason approved this merge request

    approved this merge request

  • John Mason resolved all threads

    resolved all threads

  • Leonardo da Rosa requested review from @jennli

    requested review from @jennli

  • Leonardo da Rosa added 312 commits

    added 312 commits

    Compare with previous version

  • Leonardo da Rosa marked the checklist item I have evaluated the MR acceptance checklist for this MR. as completed

    marked the checklist item I have evaluated the MR acceptance checklist for this MR. as completed

  • Leonardo da Rosa added 188 commits

    added 188 commits

    Compare with previous version

  • added 1 commit

    Compare with previous version

  • Jennifer Li approved this merge request

    approved this merge request

  • Jennifer Li resolved all threads

    resolved all threads

  • merged

  • @jennli, did you forget to run a pipeline before you merged this work? Based on our code review process, if the latest pipeline was created more than 6 hours ago OR finished more than 2 hours ago, you should:

    1. Ensure the merge request is not in Draft status.
    2. Start a pipeline (especially important for Community contribution merge requests).
    3. Set the merge request to merge when pipeline succeeds.

    This is a guideline, not a rule. Please consider replying to this comment for transparency.

    This message was generated automatically. You're welcome to improve it.

  • Jennifer Li mentioned in commit ce2fcceb

    mentioned in commit ce2fcceb

  • added workflowstaging label and removed workflowcanary label

  • mentioned in issue #402982 (closed)

  • Jennifer Li mentioned in merge request !123711 (merged)

    mentioned in merge request !123711 (merged)

  • Jennifer Li mentioned in merge request !123420 (merged)

    mentioned in merge request !123420 (merged)

  • Please register or sign in to reply
    Loading