yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1774544] Re: Upgrade pike to queens get `xxx DBConnectionError SELECT 1`

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: oyym <oyym.mv@xxxxxxxxx>
Date: Mon, 09 Jul 2018 08:21:55 -0000
Reply-to: Bug 1774544 <1774544@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Also affects: nova
   Importance: Undecided
       Status: New

** No longer affects: nova

-- 
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/1774544

Title:
  Upgrade pike to queens get `xxx DBConnectionError  SELECT 1`

Status in oslo.db:
  New

Bug description:
  Exception:
  Database connection was found disconnected; reconnecting: DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: u'SELECT 1']

  Log:
  http://paste.openstack.org/show/722333/

  Env:
  centos7
  kernel uname -r
  3.10.0-514.26.2.el7.x86_64

  Description:
  Upgrading OpenStack from pike to queens almost all openstack components, such as nova-api, nova-conductor, glance-api, neutron-server, cinder-api, get such ERROR in log:
  Database connection was found disconnected; reconnecting: DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: u'SELECT 1']

  Checing oslo.db version, it was upgraded from 4.25 to 4.33.

  Force downgrade the version from 4.33 to 4.25, the exception
  disappear.

To manage notifications about this bug go to:
https://bugs.launchpad.net/oslo.db/+bug/1774544/+subscriptions