Database logging required

Bug #964844 reported by justinsb
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Fix Released
Wishlist
justinsb

Bug Description

We need a way to enable SQL logging in the field so that when someone reports "OMG the DB is so slow, Y U not using MongoDB - it is web scale" then we will be able to analyze the problem intelligently. See Bug #964824 for the sort of issues this can show.

(I proposed an initial patch here https://review.openstack.org/#change,5783 , but apparently the correct procedure is to file a bug and get it merged into master and then essex.)

tags: added: essex-rc-potential
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (master)

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

Changed in nova:
assignee: nobody → justinsb (justin-fathomdb)
status: New → In Progress
Thierry Carrez (ttx)
Changed in nova:
importance: Undecided → Wishlist
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (master)

Reviewed: https://review.openstack.org/5816
Committed: http://github.com/openstack/nova/commit/6432997f672f5b20b3d5b6b961fc3b9bf1117022
Submitter: Jenkins
Branch: master

commit 6432997f672f5b20b3d5b6b961fc3b9bf1117022
Author: Justin Santa Barbara <email address hidden>
Date: Mon Mar 26 09:32:43 2012 -0700

    Support sql_connection_debug to get SQL diagnostic information

    We've had a few reports of SQL issues; it'll be very helpful to be able to get SQL information
    into our log.

    Bug #964844

    Change-Id: I9d08991a3677bc6cbed45a930ede9271d685cac1

Changed in nova:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (milestone-proposed)

Fix proposed to branch: milestone-proposed
Review: https://review.openstack.org/6031

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (milestone-proposed)

Reviewed: https://review.openstack.org/6031
Committed: http://github.com/openstack/nova/commit/ed26fb38263d9aa3df52005f304921ffd51f8d4a
Submitter: Jenkins
Branch: milestone-proposed

commit ed26fb38263d9aa3df52005f304921ffd51f8d4a
Author: Justin Santa Barbara <email address hidden>
Date: Mon Mar 26 09:32:43 2012 -0700

    Support sql_connection_debug to get SQL diagnostic information

    We've had a few reports of SQL issues; it'll be very helpful to be able to get SQL information
    into our log.

    Bug #964844

    Change-Id: I9d08991a3677bc6cbed45a930ede9271d685cac1

Changed in nova:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in nova:
milestone: none → 2012.1
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.