[Yahoo-eng-team] [Bug 1655610] [NEW] alembic_version table has no primary key

2017-01-11 Thread Proskurin Kirill 
Public bug reported:

Currently alembic_version table in the neutron db has no primary key.

Which is a bad thing, if you consider to use Galera as a database, since
it requires primary keys in all tables.

For example, during the "INFO  [alembic.runtime.migration] Running
upgrade  -> kilo, kilo_initial" migration you will get the:

oslo_db.exception.DBError: (pymysql.err.InternalError) (1105, u'Percona-
XtraDB-Cluster prohibits use of DML command on a table
(neutron.alembic_version) without an explicit primary key with
pxc_strict_mode = ENFORCING or MASTER') [SQL: u"INSERT INTO
alembic_version (version_num) VALUES ('kilo')"]

** Affects: neutron
 Importance: Undecided
 Assignee: Ann Taraday (akamyshnikova)
 Status: New


** Tags: db

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1655610

Title:
  alembic_version table has no primary key

Status in neutron:
  New

Bug description:
  Currently alembic_version table in the neutron db has no primary key.

  Which is a bad thing, if you consider to use Galera as a database,
  since it requires primary keys in all tables.

  For example, during the "INFO  [alembic.runtime.migration] Running
  upgrade  -> kilo, kilo_initial" migration you will get the:

  oslo_db.exception.DBError: (pymysql.err.InternalError) (1105, u
  'Percona-XtraDB-Cluster prohibits use of DML command on a table
  (neutron.alembic_version) without an explicit primary key with
  pxc_strict_mode = ENFORCING or MASTER') [SQL: u"INSERT INTO
  alembic_version (version_num) VALUES ('kilo')"]

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1655610/+subscriptions

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

[Yahoo-eng-team] [Bug 1637012] [NEW] newton docs not consistent about [assignment] driver option

2016-10-26 Thread Proskurin Kirill 
Public bug reported:

It's not clear what I should put into the:

[assignment]
driver = ???

in newton.

If I leave it undefined, I have deprecation warning, but docs tell me to leave 
it be:
http://docs.openstack.org/newton/config-reference/identity/samples/keystone.conf.html

and this one tells me to define it, since auto detection is deprecated. 
http://docs.openstack.org/newton/config-reference/identity/config-options.html

** Affects: keystone
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1637012

Title:
  newton docs not consistent about [assignment] driver option

Status in OpenStack Identity (keystone):
  New

Bug description:
  It's not clear what I should put into the:

  [assignment]
  driver = ???

  in newton.

  If I leave it undefined, I have deprecation warning, but docs tell me to 
leave it be:
  
http://docs.openstack.org/newton/config-reference/identity/samples/keystone.conf.html

  and this one tells me to define it, since auto detection is deprecated. 
  http://docs.openstack.org/newton/config-reference/identity/config-options.html

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1637012/+subscriptions

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp