Bug 1634215

Summary: "Lost connection to MySQL server during query" when creating two cinder backups at the same time
Product: Red Hat OpenStack Reporter: Chen <cchen>
Component: openstack-cinderAssignee: Eric Harney <eharney>
Status: ASSIGNED --- QA Contact: Avi Avraham <aavraham>
Severity: medium Docs Contact: Kim Nylander <knylande>
Priority: medium    
Version: 13.0 (Queens)CC: cchen, eharney, geguileo, jschluet, ltoscano, mvalsecc, scohen, tkajinam
Target Milestone: ---Keywords: Triaged, ZStream
Target Release: ---Flags: tshefi: automate_bug-
cchen: needinfo? (eharney)
mvalsecc: needinfo? (eharney)
ifrangs: needinfo? (eharney)
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Chen 2018-09-29 02:12:25 UTC 
Description of problem:

2018-08-28 09:36:58.965 1 ERROR oslo_messaging.rpc.server [req-b37988b3-0551-497b-a7f5-5090620cae07 bef8166ac2c245cfae0098b70683b3fe 400a14fe2f3e4c53a439a84d12f3593a - default default] Exception during message handling: DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') (Background on this error at: http://sqlalche.me/e/e3q8)

Version-Release number of selected component (if applicable):

OSP13

How reproducible:

50% at customer's site

Steps to Reproduce:

$ openstack volume backup create <vol01>
$ openstack volume backup create <vol02> 

$ openstack volume backup list
+--------------------------------------+------+-------------+-----------+------+
| ID                                   | Name | Description | Status    | Size |
+--------------------------------------+------+-------------+-----------+------+
| c70bdb42-6f4b-42a6-8777-bc49971fb9c8 | None | None        | available |   50 |
| 15bb7efd-8461-4d8c-af8c-5e5af6310b55 | None | None        | error     |   50 |
| b8f70d5e-7371-41ea-96c8-ffabc37a2541 | None | None        | available |   10 |
+--------------------------------------+------+-------------+-----------+------+

Actual results:


Expected results:


Additional info:

The customer tested 1GB volume and this issue didn't happen