Failed to sync database with mysql

Bug #1850588 reported by Kevin
6
This bug affects 1 person
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://docs.openstack.org/trove/train/install/install-rdo.html.

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://docs.openstack.org/trove/train/install/install-rdo.html.
Log file: please refer to attachment.
Config file: please refer to attachment.

Revision history for this message
Kevin (liuwenlongfox) wrote :
Revision history for this message
Kevin (liuwenlongfox) wrote :

I have tried to delete database and re-sync, but failed again. I also disabled FOREIGN_KEY_CHECKS in Mariadb ,but no effect.
MariaDB [mysql]> SELECT @@FOREIGN_KEY_CHECKS;
+----------------------+
| @@FOREIGN_KEY_CHECKS |
+----------------------+
| 0 |
+----------------------+
1 row in set (0.000 sec)

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.