[Expired for OpenStack Identity (keystone) because there has been no
activity for 60 days.]
** Changed in: keystone
Status: Incomplete => Expired
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
db_sync doesn't work with sql_mode = 'TRADITIONAL'
Status in OpenStack Identity (keystone):
The keystone-manage db_sync command fails with the following error :
2016-07-14 16:13:17.670 19170 ERROR keystone DBError:
(_mysql_exceptions.ProgrammingError) (1064, 'You have an error in your
SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near \'"keystone"\' at line 1')
[SQL: 'SHOW FULL TABLES FROM "keystone"']
OS: Debian 8.5
Keystone ver : 2:9.0.0-2~bpo8+1
Mysql: Server version: 5.5.44-MariaDB-log MariaDB Server
The problem seems to be related with :
It seems that on MariaDB if you set:
set session sql_mode = 'TRADITIONAL';
the query :
show full tables from "keystone"
I've solve the problem by adding ANSI to default sql mode:
To manage notifications about this bug go to:
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : email@example.com
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp