Open Stack

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

On 10/07/14 08:09, Angus Lees wrote:
> On 10 July 2014 00:59, Roman Podoliaka <rpodolyaka at mirantis.com>
> wrote:
> 
>> Not sure what issues you are talking about, but I just replaced 
>> "mysql" with "mysql+mysqlconnector" in my db connection string
>> in neutron.conf and "neutron-db-manage upgrade head" worked like
>> a charm for an empty schema.
>> 
> 
> Yep, I don't think we're far away from it being that simple.  Most
> of the changes/work I've seen discussed is in shifting the test
> environments and suitably addressing everyone's
> performance/uncertainty concerns.
> 
> Ihar, could please elaborate on what changes to oslo.db are
> needed?

AFAIK we should:
- - set raise_on_warnings to False for sqlconnector (the current default
for sqlalchemy is True, which is wrong and to be fixed, but will need
to wait for the next release which is months away from us);
- - set encoding=utf8 until sqalchemy 1.0 is released and we require it.

Plus changes you already track (duplicate error detection and testing
parity - the latter is probably not a requirement).

>> (as an oslo.db developer I'm very interested in this part :) )
>> 
> 
> The changes I've been working on are (and most of these need
> oslo.db reviews):
> 
> https://review.openstack.org/#/c/104436/ Test that concurrent
> sqlalchemy transactions don't block (This test reproduces the core
> issue.  There's an open question where it belongs)
> 
> https://review.openstack.org/#/c/104425/ Add DBDuplicateEntry
> detection for mysqlconnector driver
> 
> https://review.openstack.org/#/c/104428/ Allow tox tests with
> complex OS_TEST_DBAPI_CONNECTION URLs
> 
> https://review.openstack.org/#/c/104447/ Support
> OS_TEST_DBAPI_ADMIN_CONNECTION override
> 
> https://review.openstack.org/#/c/104430/ Don't drop pre-existing
> database before tests
> 
> https://github.com/zzzeek/sqlalchemy/pull/102 sqlalchemy mysql
> unicode improvement, that has various workarounds available to us
> in the meantime
> 
> - Gus
> 
> 
> 
> _______________________________________________ OpenStack-dev
> mailing list OpenStack-dev at lists.openstack.org 
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBCgAGBQJTvlqyAAoJEC5aWaUY1u57mVkH/3rLbPfVFbgOjLsDTY+2pnEo
cm6gAhsGhSAIMgUcPiJrQdryD49muzQbqbSxszzL6JF4/4F6fAlm4lNNgjsCcmjn
E9lbFgwDNWz6ZGkHcFwcZ1w7I88qGZRPDJvKsPYfgLN7guWGDTfPPnmN56omxplx
gYnRedBGTErXJUxIiEopLf+n9cMFKK5vDFtqmcMvKaix/FMsHOiXXiuijSKwXtF2
R+2WBADhg6bP7Eu1am1LjnlkJbG9XtvBrdroPxAN4ZII3daJ8sEKfEFEIw+ZCeOy
d4YewzR9WJ9hdMhV68Dmc+0iUK/PyvE1en/0vJaF/5Q55jstocmhAhKr01P339Q=
=UrRc
-----END PGP SIGNATURE-----