yahoo-eng-team team mailing list archive

[taget <taget@xxxxxxx>]

Public bug reported:

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

** Affects: nova
     Importance: Undecided
         Status: New


** Tags: nova-api

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1343697

Title:
  nova-manage always show extra debug message

Status in OpenStack Compute (Nova):
  New

Bug description:
  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

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1343697/+subscriptions