Database Group Triage for week ending 2023-08-11
About
This issue is used by groupdatabase to triage issues and make sure they get properly assigned and prioritized. Each week, a bot will look up the old issue, pick the next assignee in the list, and submit a new issue with a list of any issues that may need attention from the team.
Process
-
Review any issues identified for triage -
Review any issues with undefined types -
Post any questions or pressing issues to the database group meeting doc -
Post a comment on the database group status issue For triage this week there were 2 issues in need of triage, 2 issues without throughput labels, and 7 other database issues reviewed.
<link to this issue>
databasetriage)
Issues needing triage (LabeledFor each issue below:
- If the issue needs further investigation, spend up to 1 hour of investigating or fixing the issue.
- If the issue is a typebug, assign it one of severity1, severity2, severity3, or severity4
- Document any findings you make in a comment on the issue, and if the issue still needs additional work or refinement, consider looping in
@alexives
and@rogerwoo
to help with scheduling and priority. - If the issue is incomplete, labeled ~"workflow::scheduled", and will take more than an hour to fix, remove databasetriage
-
Prevent name clash between database and search migrations -
Batched background migrations marked as finished but finished_at is not populated
Bugs needing Severity
For each issue below:
- For each typebug, spend up to 1 hour investigating or fixing the issue.
- Assign it one of severity1, severity2, severity3, or severity4
- Document any findings you make in a comment on the issue, and if the issue still needs additional work or refinement, consider looping in
@alexives
and@rogerwoo
to help with scheduling and priority.
Issues with Undefined Type
For each issue below:
- Assess if the issue is appropriately assigned to groupdatabase, if not add the correct group label.
- Add the proper work type label, or if the issue is a request for support, redirect the user to our support resources with the following message:
Hey @author. Based on the information given, this request for support is out of the scope of the issue tracker (which is for new bug reports and feature proposals). Unfortunately, I won't be able to help get it resolved. However, for support requests we have several resources that you can use to find help and support from the Community, including: * [Technical Support for Paid Tiers](https://about.gitlab.com/support/) * [Community Forum](https://forum.gitlab.com/) * [Reference Documents and Videos](https://about.gitlab.com/get-help/#references) Please refer to our [Support page](https://about.gitlab.com/support/) for more information. If you believe this was closed in error, please feel free to re-open the issue. /label ~"support request" /close
- If the issue needs further investigation, add databasetriage and spend up to 1 hour of investigating the issue.
- Document any findings you make in a comment on the issue, and if the issue still needs additional work or refinement, consider looping in
@alexives
and@rogerwoo
to help with scheduling and priority.
-
column "id_convert_to_bigint" of relation "ci_build_needs" Error after upgrading to gitlab-ce=16.2.0-ce.0 -
Column application_settings.encrypted_tofa_credentials does not exist, GitLab 16.1
database
Recent issues labeledFor each issue below:
- If the issue has no
group
label, consider if it should be addressed by groupdatabase and if so label it. - If the issue has a group, and you think they may need assistance from us:
- If the issue needs further investigation, add databasetriage and spend up to 1 hour of investigating the issue.
- Document any findings you make in a comment on the issue, and if the issue still needs additional work or refinement, consider looping in
@alexives
and/or@rogerwoo
-
groupcomposition analysis [Feature flag] Cleanup compressed_package_metadata_query -
~"group::authentication and authorization" [Database cleanup] Remove Twitter identity records -
groupcontainer registry Requesting support for falco artifacts -
groupthreat insights Database: Add hasRemediations filter to Vulnerability Report -
groupthreat insights Database: Add hasMergeRequest filter to VulnerabilityReport -
~"group::authentication and authorization" Analyse Query Performance for Listing Personal Access Tokens -
grouppipeline execution Convert shared_runners_duration to bigint for project and namespace monthly usage tables
@gitlab-org/database-team
Recent mentions of For each mention below:
- If the item already has an adequate response, move on to the next
- If the mention is from someone looking to provide feedback on database review, and nobody has responded yet, set up a coffee chat with them and make a note in the thread that you did. Record feedback in the feedback issue.
- If you know how to respond to the comment, post a response
- If you don't know how, redirect with a specific mention to someone who may be able to respond
-
@jon_jenkins
mentioned the team on Migrations should run in milestone, not version order
Customer Issue Hand-offs
@l.rosa please add a comment providing any hand-off details to @mattkasa about the following issues. If an issue won't be handed off, make a comment on this issue.
- Patroni failover breaks cluster and requires a manual restart on PgBouncer hosts~"Help group::Database"
- Questions regarding fine tuning PgBouncer connection pooling and PSQL max connections~"Help group::Database"
@alexives if @mattkasa isn't available this week, please reassign to @praba.m7n
cc @rogerwoo