Failed to sync database with mysql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack DBaaS (Trove) |
New
|
Undecided
|
Unassigned |
Bug Description
Encountered below error while trying to deploy Trove as per https:/
2019-10-30 12:23:43.571 6750 CRITICAL root [-] Unhandled error: ArgumentError: Textual column expression 'id' should be explicitly declared with text('id'), or use column('id') for more specificity
....output ommited...
2019-10-30 12:23:43.571 6750 ERROR root ArgumentError: Textual column expression 'id' should be explicitly declared with text('id'), or use column('id') for more specificity
2019-10-30 12:23:43.571 6750 ERROR root
Version: Stein
Command: su -s /bin/sh -c "trove-manage db_sync" trove
Database: Mariadb 10.3.10
Services: Minimal deployment for Stein + Trove
Steps to reproce: Please follow all steps in https:/
Log file: please refer to attachment.
Config file: please refer to attachment.
I have tried to delete database and re-sync, but failed again. I also disabled FOREIGN_KEY_CHECKS in Mariadb ,but no effect. KEY_CHECKS; ------- ------- --+ KEY_CHECKS | ------- ------- --+ ------- ------- --+
MariaDB [mysql]> SELECT @@FOREIGN_
+------
| @@FOREIGN_
+------
| 0 |
+------
1 row in set (0.000 sec)