Public bug reported:
If there were user with null password existes, keystone-manage db_sync
will fail when migrate the DB to
091_migrate_data_to_local_user_and_password_tables.py.
This is beacuse the `password` doesn't allow the the `password` to be
null.
The stacktrace is,
2016-02-25 16:48:02.187 16248 TRACE keystone _check_mysql_exception(errinfo)
2016-02-25 16:48:02.187 16248 TRACE keystone File
"/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in
_check_mysql_exception
2016-02-25 16:48:02.187 16248 TRACE keystone raise errorclass(errno,
errorvalue)
2016-02-25 16:48:02.187 16248 TRACE keystone DBError:
(pymysql.err.IntegrityError) (1048, u"Column 'password' cannot be null") [SQL:
u'INSERT INTO password (local_user_id, password) VALUES (%(local_user_id_0)s,
%(password_0)s), (%(local_user_id_1)s, %(password_1)s), (%(local_user_id_2)s,
%(password_2)s), (%(local_user_id_3)s, %(password_3)s), (%(local_user_id_4)s,
%(password_4)s), (%(local_user_id_5)s, %(password_5)s), (%(local_user_id_6)s,
%(password_6)s)'] [parameters: {u'local_user_id_5': 6, u'local_user_id_2': 3,
u'password_0':
u'$6$rounds=10000$9MsHCDa99KIsGgyl$ElIyqo1w.SvcmM2cg3Lml6snJ.5txHxlq63Pmu19bxpnAkvqndenOV9t0Nu0qTCoxawGCpj2pUjfxuV0fDBz4.',
u'password_1':
u'$6$rounds=10000$VBqe3vSR7zxy10GE$jRIqQtJQkfkRJWmzKVViChVn7NHstzcC5mJANnl7bpzQaluqz.33Q6BG5MGHyFu.hWRRz3jxoLjsgTvv2GOpa0',
u'password_2':
u'$6$rounds=10000$LtmUoF9GZAdPfLDo$pQ313zPsbtjB7NM7bR73Jg8V7bO2oM5LysJsi2wkjCk7nwSwoos9QJdvbVL.9rV8u/3MdcDgRY1Eu28EtahQ41',
u'password_3': u'$6$rounds=10000$rjTuGfpVeLXm608/$VjjU8ShY
DZT6PFKjqZvf0zUvg5P7IUlW1K1ZN6NfH2a/0hGbVkcaDqky/z7fujdRfMifKjtthpLnLCN0cPPnp1',
u'password_4':
u'$6$rounds=10000$KYR89pU.OwWJ9MdD$cMwW970ccn44gTISz2P9vZ3lD14zvQC6R4O7q0yLunNVcqH09RMV4o7Vr47MnkejpWKvnxYKntxrmYSmlm/yg/',
u'password_5':
u'$6$rounds=10000$i6WcGIGqDtNML2lX$7jSzlulHQXW2mbvYfniYvlJ.EmRjM2JxYqCaldhLVgKrULImg2Gj0ZqAmoq2xs9CgXcu5jJH1L9pCMxF4gMfM.',
u'password_6': None, u'local_user_id_4': 5, u'local_user_id_1': 2,
u'local_user_id_0': 1, u'local_user_id_6': 7, u'local_user_id_3': 4}]
** Affects: keystone
Importance: Undecided
Assignee: Dave Chen (wei-d-chen)
Status: New
** Description changed:
If there were user with null password existes, keystone-manage db_sync
will fail when migrate the DB to
091_migrate_data_to_local_user_and_password_tables.py.
- This is beacuse the `password` not allow the the `password` to be null.
-
+ This is beacuse the `password` doesn't allow the the `password` to be
+ null.
The stacktrace is,
2016-02-25 16:48:02.187 16248 TRACE keystone
_check_mysql_exception(errinfo)
2016-02-25 16:48:02.187 16248 TRACE keystone File
"/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in
_check_mysql_exception
2016-02-25 16:48:02.187 16248 TRACE keystone raise errorclass(errno,
errorvalue)
2016-02-25 16:48:02.187 16248 TRACE keystone DBError:
(pymysql.err.IntegrityError) (1048, u"Column 'password' cannot be null") [SQL:
u'INSERT INTO password (local_user_id, password) VALUES (%(local_user_id_0)s,
%(password_0)s), (%(local_user_id_1)s, %(password_1)s), (%(local_user_id_2)s,
%(password_2)s), (%(local_user_id_3)s, %(password_3)s), (%(local_user_id_4)s,
%(password_4)s), (%(local_user_id_5)s, %(password_5)s), (%(local_user_id_6)s,
%(password_6)s)'] [parameters: {u'local_user_id_5': 6, u'local_user_id_2': 3,
u'password_0':
u'$6$rounds=10000$9MsHCDa99KIsGgyl$ElIyqo1w.SvcmM2cg3Lml6snJ.5txHxlq63Pmu19bxpnAkvqndenOV9t0Nu0qTCoxawGCpj2pUjfxuV0fDBz4.',
u'password_1':
u'$6$rounds=10000$VBqe3vSR7zxy10GE$jRIqQtJQkfkRJWmzKVViChVn7NHstzcC5mJANnl7bpzQaluqz.33Q6BG5MGHyFu.hWRRz3jxoLjsgTvv2GOpa0',
u'password_2':
u'$6$rounds=10000$LtmUoF9GZAdPfLDo$pQ313zPsbtjB7NM7bR73Jg8V7bO2oM5LysJsi2wkjCk7nwSwoos9QJdvbVL.9rV8u/3MdcDgRY1Eu28EtahQ41',
u'password_3': u'$6$rounds=10000$rjTuGfpVeLXm608/$VjjU8S
hYDZT6PFKjqZvf0zUvg5P7IUlW1K1ZN6NfH2a/0hGbVkcaDqky/z7fujdRfMifKjtthpLnLCN0cPPnp1',
u'password_4':
u'$6$rounds=10000$KYR89pU.OwWJ9MdD$cMwW970ccn44gTISz2P9vZ3lD14zvQC6R4O7q0yLunNVcqH09RMV4o7Vr47MnkejpWKvnxYKntxrmYSmlm/yg/',
u'password_5':
u'$6$rounds=10000$i6WcGIGqDtNML2lX$7jSzlulHQXW2mbvYfniYvlJ.EmRjM2JxYqCaldhLVgKrULImg2Gj0ZqAmoq2xs9CgXcu5jJH1L9pCMxF4gMfM.',
u'password_6': None, u'local_user_id_4': 5, u'local_user_id_1': 2,
u'local_user_id_0': 1, u'local_user_id_6': 7, u'local_user_id_3': 4}]
** Changed in: keystone
Assignee: (unassigned) => Dave Chen (wei-d-chen)
--
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/1549705
Title:
migrate DB failed due to password cannot be null
Status in OpenStack Identity (keystone):
New
Bug description:
If there were user with null password existes, keystone-manage
db_sync will fail when migrate the DB to
091_migrate_data_to_local_user_and_password_tables.py.
This is beacuse the `password` doesn't allow the the `password` to be
null.
The stacktrace is,
2016-02-25 16:48:02.187 16248 TRACE keystone
_check_mysql_exception(errinfo)
2016-02-25 16:48:02.187 16248 TRACE keystone File
"/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in
_check_mysql_exception
2016-02-25 16:48:02.187 16248 TRACE keystone raise errorclass(errno,
errorvalue)
2016-02-25 16:48:02.187 16248 TRACE keystone DBError:
(pymysql.err.IntegrityError) (1048, u"Column 'password' cannot be null") [SQL:
u'INSERT INTO password (local_user_id, password) VALUES (%(local_user_id_0)s,
%(password_0)s), (%(local_user_id_1)s, %(password_1)s), (%(local_user_id_2)s,
%(password_2)s), (%(local_user_id_3)s, %(password_3)s), (%(local_user_id_4)s,
%(password_4)s), (%(local_user_id_5)s, %(password_5)s), (%(local_user_id_6)s,
%(password_6)s)'] [parameters: {u'local_user_id_5': 6, u'local_user_id_2': 3,
u'password_0':
u'$6$rounds=10000$9MsHCDa99KIsGgyl$ElIyqo1w.SvcmM2cg3Lml6snJ.5txHxlq63Pmu19bxpnAkvqndenOV9t0Nu0qTCoxawGCpj2pUjfxuV0fDBz4.',
u'password_1':
u'$6$rounds=10000$VBqe3vSR7zxy10GE$jRIqQtJQkfkRJWmzKVViChVn7NHstzcC5mJANnl7bpzQaluqz.33Q6BG5MGHyFu.hWRRz3jxoLjsgTvv2GOpa0',
u'password_2':
u'$6$rounds=10000$LtmUoF9GZAdPfLDo$pQ313zPsbtjB7NM7bR73Jg8V7bO2oM5LysJsi2wkjCk7nwSwoos9QJdvbVL.9rV8u/3MdcDgRY1Eu28EtahQ41',
u'password_3': u'$6$rounds=10000$rjTuGfpVeLXm608/$VjjU8S
hYDZT6PFKjqZvf0zUvg5P7IUlW1K1ZN6NfH2a/0hGbVkcaDqky/z7fujdRfMifKjtthpLnLCN0cPPnp1',
u'password_4':
u'$6$rounds=10000$KYR89pU.OwWJ9MdD$cMwW970ccn44gTISz2P9vZ3lD14zvQC6R4O7q0yLunNVcqH09RMV4o7Vr47MnkejpWKvnxYKntxrmYSmlm/yg/',
u'password_5':
u'$6$rounds=10000$i6WcGIGqDtNML2lX$7jSzlulHQXW2mbvYfniYvlJ.EmRjM2JxYqCaldhLVgKrULImg2Gj0ZqAmoq2xs9CgXcu5jJH1L9pCMxF4gMfM.',
u'password_6': None, u'local_user_id_4': 5, u'local_user_id_1': 2,
u'local_user_id_0': 1, u'local_user_id_6': 7, u'local_user_id_3': 4}]
To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1549705/+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
