Ask Your Question

Unable to create trove db instances from Dashboard

asked 2014-09-15 07:38:22 -0500

ankush grover gravatar image

updated 2014-09-15 11:39:35 -0500

lafada gravatar image

Hi Friends,

I am trying to integrate trove with Openstack Icehouse on Centos 6.5 using the following guide -> . Whenver I am click on the Database Instances on the Horizon Dashboard it results in an error. Once it worked but there was no option to select the Flavor or Volume Size under "Details" whereas options like Database name, user, hosts were available but could not launch the db.

Running trove flavor-list result in below error

trove flavor-list
ERROR: Internal Server Error. Please keep this ID to help us figure out what went wrong: (9cabf9f3-1e1e-4ed4-bb88-2be538f9ab20)

Horizon logs

RESP BODY: {"tenants_links": [], "tenants": [{"description": "default tenant", "enabled": true, "id": "2c44a987e331411c9a2f2b4d0cd3f691", "name": "demo"}, {"description": "Service Tenant", "enabled": true, "id": "b1ffc0d30bcd4c2aaa37a7ed43a860ec", "name": "service"}, {"description": "admin tenant", "enabled": true, "id": "d2780c405b5640829b547c96a1a75e80", "name": "admin"}]}

2014-09-15 11:58:45,614 2031 INFO openstack_dashboard.dashboards.project.database_backups.workflows.create_backup Obtaining list of instances.
2014-09-15 11:58:45,614 2031 DEBUG openstack_dashboard.api.trove troveclient connection created using token "f24c24c32fe1caa7979bd3242873464a" and url ""
2014-09-15 11:58:59,305 2033 DEBUG openstack_dashboard.api.trove troveclient connection created using token "f24c24c32fe1caa7979bd3242873464a" and url ""
2014-09-15 11:58:59,362 2033 DEBUG openstack_dashboard.api.trove troveclient connection created using token "f24c24c32fe1caa7979bd3242873464a" and url ""
2014-09-15 11:58:59,390 2033 ERROR django.request Internal Server Error: /dashboard/project/databases/
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/django/core/handlers/", line 109, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  File "/usr/lib/python2.6/site-packages/horizon/", line 38, in dec
    return view_func(request, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/horizon/", line 54, in dec
    return view_func(request, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/horizon/", line 38, in dec
    return view_func(request, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/horizon/", line 86, in dec
    return view_func(request, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/django/views/generic/", line 48, in view
    return self.dispatch(request, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/django/views/generic/", line 69, in dispatch
    return handler(request, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/horizon/tables/", line 154, in get
    handled = self.construct_tables()
  File "/usr/lib/python2.6/site-packages/horizon/tables/", line 145, in construct_tables
    handled = self.handle_table(table)
  File "/usr/lib/python2.6/site-packages/horizon/tables/", line 118, in handle_table
    data = self._get_data_dict()
  File "/usr/lib/python2.6/site-packages/horizon/tables/", line 181, in _get_data_dict
    self._data = { self.get_data()}
  File "/usr/share/openstack-dashboard/openstack_dashboard/wsgi/../../openstack_dashboard/dashboards/project/databases/", line 85, in get_data
    map(self._extra_data, instances)
  File "/usr/share/openstack-dashboard/openstack_dashboard/wsgi/../../openstack_dashboard/dashboards/project/databases/", line 67, in _extra_data
    flavor = self.get_flavors().get(instance.flavor ...
edit retag flag offensive close merge delete


When creating the endpoint with keystone endpoint-create, have you used the right region? Because if you used for example Packstack to install OpenStack, the default region is "RegionOne", but the official OpenStack docs use "regionOne", and this is the default of python-keystoneclient.

beni gravatar imagebeni ( 2014-09-16 09:06:02 -0500 )edit

See this bug report against the docs regarding the default region

beni gravatar imagebeni ( 2014-09-16 09:07:08 -0500 )edit

Regarding instances stuck at BUILD: have a look at nova list and see what the status is there. And see the log file of Trove and the one of Nova, if the status of the instance is not ok in nova list.

beni gravatar imagebeni ( 2014-09-16 09:12:53 -0500 )edit

For questions concerning Trove, at the moment the best way is to join the IRC channel #openstack-trove on Freenode and ask there. Please post (question and) solution on then, so the community can profit! See for more IRC channels of OpenStack.

beni gravatar imagebeni ( 2014-09-16 09:16:41 -0500 )edit

Hi Beni, can you share the trove.conf, trove-conductor.conf, trove-guestagent.conf , api-paste.conf/ini and trove-taskmanager.conf as per the link you were successful in configuring the trove.

ankush grover gravatar imageankush grover ( 2014-09-25 02:37:14 -0500 )edit

4 answers

Sort by » oldest newest most voted

answered 2014-09-19 06:10:37 -0500

ankush grover gravatar image

Thanks!. Issue was not related to region as I am using RegionOne but was due to custom flavors.Somehow trove does not work with flavor having UUIDs. Deleted the custom flavors and now I am able to see the option of flavor on the Horizon. Now horizon does not assign any host to the Db instance.

edit flag offensive delete link more


It works for me! I did changed a default flavor, flavor Id was changed to 8c3e12ed-8a67-46ef-8a5b-2f3b3e976ffd from 64. I went to Horizon interface and delete it. Now I see a list of the flavors and created my first database instance with mysql.

LZ gravatar imageLZ ( 2014-10-27 14:12:40 -0500 )edit

answered 2015-10-02 22:13:57 -0500

xinwenzeng gravatar image

updated 2015-10-02 22:31:42 -0500

Hi! If you instance's status is alway "BULID",follow my step,have a try(My openstack is icehouse):

1,In controller node


2,create endpoint like this: image description

What is show in my server when "trove list"

image description


Then I tell my problem:I can create instance mysql-user and mysql-database by CLI(trove create/ trove user-create),but I can't open databases in dashboard.When I click databases,the http tell me wrong,like this:

image description image description

The http error log is:

image description

image description

edit flag offensive delete link more

answered 2015-09-13 02:14:31 -0500

prapul gravatar image


I am facing the same issue, horizon does not assign any host to the Db instance. i am successfully create the instance but in status column shows that not assign to any host....

How to solve this issue ? Thanks in Advance.



edit flag offensive delete link more


I have solve this problem:Flavor's ID must like this"1 2 3 4 ...",could not as the UUID(When we create flavor,if you did't assign a ID,the system would use the uuid as the ID default)

xinwenzeng gravatar imagexinwenzeng ( 2015-10-08 03:44:31 -0500 )edit

answered 2015-09-30 04:58:38 -0500

hyperbaba gravatar image

Trove can't use uuid for flavor id. It must be numeric

Regards, Vladimir

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools



Asked: 2014-09-15 07:38:22 -0500

Seen: 1,898 times

Last updated: Oct 02 '15