Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Mike Bayer
per IRC deliberation, I'll do a patch in oslo.db: * detect incoming URL that is like "mysql://" with no driver (I can set this up for all DBs, though excluding sqlite:// since that one is used by tests) * log warning referring to the issue, rather than a hard-cut over ("the big issue we'll

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Mike Bayer
On 05/23/2017 04:17 PM, Doug Hellmann wrote: On May 23, 2017, at 4:01 PM, Doug Hellmann > wrote: Excerpts from Sean McGinnis's message of 2017-05-23 11:38:34 -0500: This sounds like something we could fix completely by dropping the use of the offending librar

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Doug Hellmann
> On May 23, 2017, at 4:01 PM, Doug Hellmann wrote: > > Excerpts from Sean McGinnis's message of 2017-05-23 11:38:34 -0500: >>> >>> This sounds like something we could fix completely by dropping the >>> use of the offending library. I know there was a lot of work done >>> to get pymysql suppor

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Doug Hellmann
Excerpts from Sean McGinnis's message of 2017-05-23 11:38:34 -0500: > > > > This sounds like something we could fix completely by dropping the > > use of the offending library. I know there was a lot of work done > > to get pymysql support in place. It seems like we can finish that by > > removing

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Tim Bell
One scenario would be to change the default and allow the exceptions to opt out (e.g. mysql-pymysql ( Tim On 23.05.17, 19:08, "Matt Riedemann" wrote: On 5/23/2017 11:38 AM, Sean McGinnis wrote: >> >> This sounds like something we could fix completely by dropping the >> use of t

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Matt Riedemann
On 5/23/2017 11:38 AM, Sean McGinnis wrote: This sounds like something we could fix completely by dropping the use of the offending library. I know there was a lot of work done to get pymysql support in place. It seems like we can finish that by removing support for the old library and redirecti

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Sean McGinnis
> > This sounds like something we could fix completely by dropping the > use of the offending library. I know there was a lot of work done > to get pymysql support in place. It seems like we can finish that by > removing support for the old library and redirecting mysql:// > connections to use pym

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Tim Bell
Would an automatic transform of mysql:// to mysql+pymysql:// be possible? Is there any reason to not have pymysql? Tim From: Arne Wiebalck Date: Tuesday, 23 May 2017 at 17:50 To: Sean McGinnis Cc: openstack-operators Subject: Re: [Openstack-operators] DB deadlocks due to connection string

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Doug Hellmann
Excerpts from Arne Wiebalck's message of 2017-05-23 15:50:43 +: > As discussed on the Cinder channel, I’ve opened > > https://bugs.launchpad.net/oslo.db/+bug/1692956 > > to see if oslo.db would be a good place to produce a warning when it detects > this potential misconfiguration. This sound

Re: [Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Arne Wiebalck
As discussed on the Cinder channel, I’ve opened https://bugs.launchpad.net/oslo.db/+bug/1692956 to see if oslo.db would be a good place to produce a warning when it detects this potential misconfiguration. Cheers, Arne On 23 May 2017, at 17:25, Sean McGinnis mailto:sean.mcgin...@gmx.com>> wro

[Openstack-operators] DB deadlocks due to connection string

2017-05-23 Thread Sean McGinnis
Just wanted to put this out there to hopefully spread awareness and prevent it from happening more. We had a bug reported in Cinder of hitting a deadlock when attempting to deelte multiple volumes simultaneously: https://bugs.launchpad.net/cinder/+bug/1685818 Some were seeing it, but others were