Bootstrap DB fail : SQL syntax error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Designate |
Invalid
|
Undecided
|
Unassigned |
Bug Description
Hi,
I try to deploy designate with kolla. Since I builded new image, I can't boostrap the BDD.
The migration 98 fail :
2018-05-29 10:40:54.853 16 INFO migrate.
2018-05-29 10:40:54.864 16 CRITICAL designate [designate-manage - - - - -] Unhandled error: DbMigrationError: (pymysql.
server version for the right syntax to use near 'ALTER TABLE service_statuses CONVERT TO CHARACTER SET utf8;\n SET foreign_key_' at line 2") [SQL: 'SET foreign_key_checks = 0;\n ALTER TABLE service_statuses CONVERT TO CHARACTER SE
T utf8;\n SET foreign_key_checks = 1;\n ALTER DATABASE designate DEFAULT CHARACTER SET utf8;\n ']
2018-05-29 10:40:54.864 16 ERROR designate Traceback (most recent call last):
2018-05-29 10:40:54.864 16 ERROR designate File "/usr/bin/
2018-05-29 10:40:54.864 16 ERROR designate sys.exit(main())
2018-05-29 10:40:54.864 16 ERROR designate File "/usr/lib/
2018-05-29 10:40:54.864 16 ERROR designate fn(*fn_args)
2018-05-29 10:40:54.864 16 ERROR designate File "/usr/lib/
2018-05-29 10:40:54.864 16 ERROR designate get_manager(
2018-05-29 10:40:54.864 16 ERROR designate File "/usr/lib/
2018-05-29 10:40:54.864 16 ERROR designate results.
2018-05-29 10:40:54.864 16 ERROR designate File "/usr/lib/
2018-05-29 10:40:54.864 16 ERROR designate init_version=
2018-05-29 10:40:54.864 16 ERROR designate File "/usr/lib/
2018-05-29 10:40:54.864 16 ERROR designate raise exception.
2018-05-29 10:40:54.864 16 ERROR designate DbMigrationError: (pymysql.
'ALTER TABLE service_statuses CONVERT TO CHARACTER SET utf8;\n SET foreign_key_' at line 2") [SQL: 'SET foreign_key_checks = 0;\n ALTER TABLE service_statuses CONVERT TO CHARACTER SET utf8;\n SET foreign_key_checks = 1;\n ALT
ER DATABASE designate DEFAULT CHARACTER SET utf8;\n ']
The version of pymysql is 0.8.0 . I can see the commit c1a77a3ae00a04e
pip list of my designate container