Red Hat Bugzilla – Bug 1278979
Seeing recurring mySQL: database messages in nova.api.log
Last modified: 2016-06-20 18:07:12 EDT
Description of problem: The following message repeats over & over in the nova.api.log: 2015-11-06 08:58:36.991 28340 DEBUG oslo.db.sqlalchemy.session [req-79601268-b888-439f-a3c8-c0cb2702ab7d ] 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 _check_effective_sql_mode /usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py:482 Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. install openstack 6.0 2. see messages over and over 3. Actual results: Expected results: Additional info: esterday we logged the message more than 275 times
this is a normal message emitted by the driver each time a new database connection is established against the database; oslo.db sets up the SQL server mode on new connections (I need to review the code to re-examine the specific methodology). as far as if it is suddenly emitting to the logs where it was not before, has this just started occurring where it did not previously, and if so what changed? leaning towards no bug here but will examine to see if the messaging is inappropriate or unexpected.
per the customer they had DEBUG logging set up in nova.conf that would be causing this.