Trove - Timestamp Consistency Across All Bookkeeping Tables

Bug #1223217 reported by Auston McReynolds
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
Won't Fix
Undecided
Samuel Pilla

Bug Description

Filed as a result of https://review.openstack.org/#/c/45146/

In short, some tables have created_at+updated_at, some just have created_at, others have updated vs. updated_at, etc.

All tables should be assessed for altering to provide some level of consistency across the application. Also consider converting some single-row-updates to multi-row-inserts (RootHistory)

Changed in trove:
assignee: nobody → Auston McReynolds (amcrn)
Changed in trove:
milestone: none → ongoing
importance: Undecided → Medium
status: New → Confirmed
Revision history for this message
Ilya Sviridov (isviridov) wrote :
Changed in trove:
assignee: Auston McReynolds (amcrn) → nobody
Rohan (kanaderohan)
Changed in trove:
assignee: nobody → Rohan (kanaderohan)
Changed in trove:
importance: Medium → Low
Rohan (kanaderohan)
Changed in trove:
assignee: Rohan (kanaderohan) → nobody
Changed in trove:
assignee: nobody → Samuel Pilla (samuel.pilla)
status: Confirmed → In Progress
Amrith Kumar (amrith)
Changed in trove:
milestone: ongoing → none
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

Fix proposed to branch: master
Review: https://review.openstack.org/368867

Revision history for this message
OpenStack Infra (hudson-openstack) wrote :

Fix proposed to branch: master
Review: https://review.openstack.org/368990

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on trove (master)

Change abandoned by Samuel Pilla (<email address hidden>) on branch: master
Review: https://review.openstack.org/368867
Reason: Replaced with https://review.openstack.org/#/c/368990/

Revision history for this message
Amrith Kumar (amrith) wrote :

On the whole, I find this bug to be something that generates too much churn for the minimal (if any) benefit that it brings. I'm inclined to ignore any changes related to this bug; I intend to mark the bug as such.

Changed in trove:
status: In Progress → Won't Fix
Revision history for this message
Amrith Kumar (amrith) wrote :

Sorry Sam

Amrith Kumar (amrith)
Changed in trove:
importance: Low → Undecided
Revision history for this message
OpenStack Infra (hudson-openstack) wrote :

Change abandoned by amrith (<email address hidden>) on branch: master
Review: https://review.openstack.org/368990
Reason: per review comments

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.