Create instance are always being builed,can not running,and can't connect to mysql database through mysqlclient

Bug #1868956 reported by zhangss on 2020-03-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
New
Undecided
Unassigned

Bug Description

Install trove's components through koll-ansible.

This is trove-api log error messages.

634 2020-03-24 18:17:35.169 23 INFO trove.instance.service [-] Showing database instance '85d4dc77-97a1-4394-955f-30eea2693d79' for tenant '22a0bbf1a 0fe4aaf8f757f5b2cd2c607'
    635 2020-03-24 18:17:35.699 23 INFO eventlet.wsgi [-] 10.16.138.230,10.16.138.93 - - [24/Mar/2020 18:17:35] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c6 07/instances/85d4dc77-97a1-4394-955f-30eea2693d79 HTTP/1.1" 200 2060 0.535123
    636 2020-03-24 18:18:07.271 27 INFO eventlet.wsgi [-] 10.16.138.230,10.16.138.93 - - [24/Mar/2020 18:18:07] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c6 07/flavors/6 HTTP/1.1" 200 404 0.097989
    637 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api [-] Error calling guest_log_list: MessagingTimeout: Timed out waiting for a reply to messag e ID 49b226c9ce4d46f387b30d64acec9671
    638 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api Traceback (most recent call last):
    639 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api File "/usr/lib/python2.7/site-packages/trove/guestagent/api.py", line 90, in _call
    640 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api result = cctxt.call(self.context, method_name, **kwargs)
    641 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/client.py", line 178, in call
    642 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api retry=self.retry)
    643 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api File "/usr/lib/python2.7/site-packages/oslo_messaging/transport.py", line 128, in _send
    644 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api retry=retry)
    645 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api File "/usr/lib/python2.7/site-packages/oslo_messaging/_drivers/amqpdriver.py", line 645, in send
    646 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api call_monitor_timeout, retry=retry)
    647 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api File "/usr/lib/python2.7/site-packages/oslo_messaging/_drivers/amqpdriver.py", line 634, in _send
    648 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api call_monitor_timeout)
    649 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api File "/usr/lib/python2.7/site-packages/oslo_messaging/_drivers/amqpdriver.py", line 520, in wait
    650 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api message = self.waiters.get(msg_id, timeout=timeout)
    651 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api File "/usr/lib/python2.7/site-packages/oslo_messaging/_drivers/amqpdriver.py", line 397, in get
    652 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api 'to message ID %s' % msg_id)
    653 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api MessagingTimeout: Timed out waiting for a reply to message ID 49b226c9ce4d46f387b30d64acec9 671
    654 2020-03-24 18:18:49.017 23 ERROR trove.guestagent.api

and run command(create one database instance) on controller node will report one error:

Validation error: instance['volume']['type'] None is not of type 'string' (HTTP 400)

run command openstack database instance show
| fault_details | Server type: api |
| | Traceback (most recent call last): |
| | File "/usr/lib/python2.7/site-packages/trove/instance/service.py", line 279, in delete |
| | instance.delete() |
| | File "/usr/lib/python2.7/site-packages/trove/instance/models.py", line 664, in delete |
| | _delete_resources) |
| | File "/usr/lib/python2.7/site-packages/trove/quota/quota.py", line 366, in run_with_quotas |
| | result = f() |
| | File "/usr/lib/python2.7/site-packages/trove/instance/models.py", line 641, in _delete_resources |
| | (self.id, self.status)) |
| | UnprocessableEntity: |
| | Instance 85d4dc77-97a1-4394-955f-30eea2693d79 is not ready. |
| | (Status is BUILD).

zhangss (intentc) wrote :
Download full text (3.5 KiB)

supplementary trove-api log error messages.
   2936 2020-03-30 16:39:41.918 26 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:39:41] "GET /v1.0/22a0bbf1a0fe4aaf8f
2020-03-30 16:38:14.562 26 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:38:14] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c607/datastores/mysql/versions/5.6/flavors HTTP/1.1" 200 1534 0.133708
2020-03-30 16:38:14.720 27 WARNING keystonemiddleware.auth_token [-] Using the in-process token cache is deprecated as of the 4.2.0 release and may be removed in the 5.0.0 release or the 'O' development cycle. The in-process cache causes inconsistent results and high memory usage. When the feature is removed the auth_token middleware will not cache tokens by default which may result in performance issues. It is recommended to use memcache for the auth_token token cache by setting the memcached_servers option.
2020-03-30 16:38:15.709 27 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:38:15] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c607/datastores/mysql5.6/versions/5.6b/flavors HTTP/1.1" 200 1534 0.990416
2020-03-30 16:38:16.123 27 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:38:16] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c607/datastores/mysql5.6/versions/5.6/flavors HTTP/1.1" 200 1534 0.131029
2020-03-30 16:38:16.513 27 INFO trove.instance.service [-] Listing database instances for tenant '22a0bbf1a0fe4aaf8f757f5b2cd2c607'
2020-03-30 16:38:16.900 27 ERROR trove.common.exception [-] Cannot find compute instance 626e26cc-0822-4904-bf4e-404c5a06740b for instance a6146651-a142-4e63-8124-6cb09932677b.
2020-03-30 16:38:16.908 27 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:38:16] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c607/instances?limit=20 HTTP/1.1" 200 825 0.400771
2020-03-30 16:38:17.577 27 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:38:17] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c607/flavors HTTP/1.1" 200 1534 0.103650
2020-03-30 16:38:51.773 26 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:38:51] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c607/datastores/mysql/versions HTTP/1.1" 200 1071 0.014150
2020-03-30 16:38:52.047 24 WARNING keystonemiddleware.auth_token [-] Using the in-process token cache is deprecated as of the 4.2.0 release and may be removed in the 5.0.0 release or the 'O' development cycle. The in-process cache causes inconsistent results and high memory usage. When the feature is removed the auth_token middleware will not cache tokens by default which may result in performance issues. It is recommended to use memcache for the auth_token token cache by setting the memcached_servers option.
2020-03-30 16:38:52.655 24 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:38:52] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c607/datastores/mysql5.6/versions HTTP/1.1" 200 2011 0.609275
2020-03-30 16:38:53.065 25 INFO eventlet.wsgi [-] 10.16.138.93,10.16.138.91 - - [30/Mar/2020 16:38:53] "GET /v1.0/22a0bbf1a0fe4aaf8f757f5b2cd2c607/datastores/mysql5.6/versions/5.6d/flavors HTTP/1.1" 200 1534 0.134199
2020-03-30 16:38:53.444 25 IN...

Read more...

Lingxian Kong (kong) wrote :

Hi please use https://storyboard.openstack.org/#!/project/openstack/trove for trove features and bugs tracking.

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

Other bug subscribers