nova-manage always show extra debug message

[taget]

nova-manage always show DEUBG message in nova.openstack.common.db.sqlalchemy.session

2014-07-18 09:00:03.481 DEBUG nova.openstack.common.db.sqlalchemy.session [req-be5e1211-deba-4247-96c6-9d5ba400eb06 None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION from (pid=12522) _mysql_check_effective_sql_mode /opt/stack/nova/nova/openstack/common/db/sqlalchemy/session.py:562
m1.medium: Memory: 4096MB, VCPUS: 2, Root: 40GB, Ephemeral: 0Gb, FlavorID: 3, Swap: 0MB, RXTX Factor: 1.0, public, ExtraSpecs {}
m1.tiny: Memory: 512MB, VCPUS: 1, Root: 1GB, Ephemeral: 0Gb, FlavorID: 1, Swap: 0MB, RXTX Factor: 1.0, public, ExtraSpecs {}
m1.large: Memory: 8192MB, VCPUS: 4, Root: 80GB, Ephemeral: 0Gb, FlavorID: 4, Swap: 0MB, RXTX Factor: 1.0, public, ExtraSpecs {}
m1.xlarge: Memory: 16384MB, VCPUS: 8, Root: 160GB, Ephemeral: 0Gb, FlavorID: 5, Swap: 0MB, RXTX Factor: 1.0, public, ExtraSpecs {}
m1.small: Memory: 2048MB, VCPUS: 1, Root: 20GB, Ephemeral: 0Gb, FlavorID: 2, Swap: 0MB, RXTX Factor: 1.0, public, ExtraSpecs {}
m1.nano: Memory: 64MB, VCPUS: 1, Root: 0GB, Ephemeral: 0Gb, FlavorID: 42, Swap: 0MB, RXTX Factor: 1.0, public, ExtraSpecs {}
m1.micro: Memory: 128MB, VCPUS: 1, Root: 0GB, Ephemeral: 0Gb, FlavorID: 84, Swap: 0MB, RXTX Factor: 1.0, public, ExtraSpecs {}
m1.heat: Memory: 512MB, VCPUS: 1, Root: 0GB, Ephemeral: 0Gb, FlavorID: 451, Swap: 0MB, RXTX Factor: 1.0, public, ExtraSpecs {}

[tagett@stack-01 devstack]$ nova-manage vm list
instance node type state launched image kernel ramdisk project user zone index
2014-07-18 09:15:01.978 DEBUG nova.openstack.common.db.sqlalchemy.session [req-d836b1a5-95d3-4c16-ba13-c57d4de62b04 None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION from (pid=15815) _mysql_check_effective_sql_mode /opt/stack/nova/nova/openstack/common/db/sqlalchemy/session.py:562
vm1 stack-01 m1.tiny active 2014-07-16 14:22:53 44c37b90-0ec3-460a-bdf2-bd8bb98c9fdf 6445cccf-b7c9-435b-b51f-fd88dc62a88e cc6dc752-4d45-4d08-bf62-e70a73d4c105 d7beb7f28e0b4f41901215000339361d fba8a67b69004320b2ace0b35aeebb18 nova 0
f1 stack-01 m1.small active 2014-07-17 02:35:45 dbdb65e4-d303-47a2-8f53-9d0ffe1363dc d7beb7f28e0b4f41901215000339361d fba8a67b69004320b2ace0b35aeebb18 nova 0

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Change abandoned by Eli Qiao (<email address hidden>) on branch: master
Review: https://review.openstack.org/109934

[Davanum Srinivas (DIMS) (dims-v)]

previous attempt was abandoned, resetting "In Progress" to "Confirmed"

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/240271
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=ecc4952ada4f5fcbcfae0fcd2441f665b43ea2ab
Submitter: Jenkins
Branch: master

commit ecc4952ada4f5fcbcfae0fcd2441f665b43ea2ab
Author: Stephen Finucane <email address hidden>
Date: Thu Oct 29 15:28:18 2015 +0000

    Change logging level for 'oslo_db'

    Currently, running a command such as 'nova-manage' produces a lot of
    irrelevant debug messages from the 'oslo_db' module. For example:

      $ nova-manage vm list
      instance node type state launched ...
      2015-10-29 15:20:32.624 DEBUG oslo_db.api [req-0fc5d653-a78f-44...
      ...
      test1 nova-dev m1.tiny active 2015-10-29 ...

    Change the default logging level for this module to ensure this output
    is not shown.

    Change-Id: I85d4f18b7d32d9e2cbac22e075c435b7c84e7020
    Closes-bug: #1343697