Integration tests are failing with any other datastore rather than mysql

Bug #1328557 reported by Denis M.
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trove Integration
Fix Committed
Medium
Shalini khandelwal

Bug Description

Integration tests are failing with any other datastore rather than mysql

Prof. link: https://github.com/openstack/trove-integration/blob/master/scripts/redstack#L393-L442

ubuntu@ubuntu:~/trove-integration/scripts$ ./redstack int-tests --group=cassandra
*******************************************************************************
Running Trove Integration Tests...
*******************************************************************************
python -B /home/ubuntu/trove-integration/scripts/../tests//integration/int_tests.py --verbose --logging-clear-handlers --group=cassandra
RUNNING TEST ARGS : ['/home/ubuntu/trove-integration/scripts/../tests//integration/int_tests.py', '--verbose', '--logging-clear-handlers', '--group=cassandra']
nose.config: INFO: Ignoring files matching ['^\\.', '^_', '^setup\\.py$']
nose.plugins.manager: DEBUG: Configuring plugins
nose.plugins.manager: DEBUG: Plugins enabled: [<nose.plugins.capture.Capture object at 0x47a78d0>, <nose.plugins.logcapture.LogCapture object at 0x47a7910>, <nose.plugins.deprecated.Deprecated object at 0x47a7d10>, <nose.plugins.skip.Skip object at 0x4bd6590>]
No handlers could be found for logger "nose.core"
start_glance_registry
 Starts the Glance Registry.
        Starts the Glance Registry. OK 1.03
start_glance_api
 Starts the Glance API.
        Starts the Glance API. OK 1.02
start_nova_network
 Starts the Nova Network Service.
        Starts the Nova Network Service. OK 1.02
start_compute
 Starts the Nova Compute Service.
        Starts the Nova Compute Service. OK 1.02
start_scheduler
 Starts the Scheduler Service.
        Starts the Scheduler Service. OK 1.03
start_nova_api
 Starts the Nova Compute Service.
        Starts the Nova Compute Service. OK 1.09
start_trove_api
 Starts the Trove Service.
        Starts the Trove Service. OK 1.02
Flavors
        setUp OK 0.20
        confirm_flavors_lists_nearly_identical OK 0.67
        test_flavor_get_attrs OK 0.05
        test_flavor_list_attrs OK 0.02
        test_flavor_not_found OK 0.01
Versions
 Test listing all versions and verify the current version
        Sets up the client. OK 0.08
        test_list_versions_index OK 0.00
        test_no_slash_no_version OK 0.00
        test_no_slash_with_version OK 0.00
        test_request_bogus_version OK 0.00
        test_request_no_version OK 0.00
        test_with_slash_no_version OK 0.00
        test_with_slash_with_version OK 0.00
InstanceSetup
 Makes sure the client can hit the ReST service.
        Sets up the client. OK 0.17
        create_instance_name OK 0.00
        test_find_flavor OK 0.07
CreateInstance
 Test to create a Database Instance
        test_create ERROR
AfterInstanceCreation
        test_database_create_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_database_delete_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_database_index_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_instance_delete_right_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_resize_instance_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_resize_volume_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_root_create_root_user_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_root_is_root_enabled_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_users_create_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_users_delete_after_create SKIP: Failure in <function test_create at 0x45651b8>
        test_users_index_after_create SKIP: Failure in <function test_create at 0x45651b8>
WaitForGuestInstallationToFinish
        test_instance_created SKIP: Failure in <function test_create at 0x45651b8>
TestInstanceListing
 Test the listing of the instance information
        setUp SKIP: Failure in <function test_create at 0x45651b8>
        test_get_instance SKIP: Failure in <function test_create at 0x45651b8>
        test_get_instance_status SKIP: Failure in <function test_create at 0x45651b8>
        test_get_legacy_status SKIP: Failure in <function test_create at 0x45651b8>
        test_get_legacy_status_notfound SKIP: Failure in <function test_create at 0x45651b8>
        test_index_list SKIP: Failure in <function test_create at 0x45651b8>
        test_volume_found SKIP: Failure in <function test_create at 0x45651b8>

======================================================================
ERROR: proboscis.case.MethodTest (test_create)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/proboscis/case.py", line 296, in testng_method_mistake_capture_func
    compatability.capture_type_error(s_func)
  File "/usr/local/lib/python2.7/dist-packages/proboscis/compatability/exceptions_2_6.py", line 27, in capture_type_error
    func()
  File "/usr/local/lib/python2.7/dist-packages/proboscis/case.py", line 350, in func
    func(test_case.state.get_state())
  File "/opt/stack/trove/trove/tests/api/instances.py", line 638, in test_create
    datastore_version=instance_info.dbaas_datastore_version)
  File "/opt/stack/python-troveclient/troveclient/v1/instances.py", line 76, in create
    return self._create("/instances", body, "instance")
  File "/opt/stack/python-troveclient/troveclient/base.py", line 173, in _create
    resp, body = self.api.client.post(url, body=body)
  File "/opt/stack/python-troveclient/troveclient/compat/client.py", line 243, in post
    return self._cs_request(url, 'POST', **kwargs)
  File "/opt/stack/python-troveclient/troveclient/compat/client.py", line 231, in _cs_request
    return request()
  File "/opt/stack/python-troveclient/troveclient/compat/client.py", line 221, in request
    **kwargs)
  File "/opt/stack/python-troveclient/troveclient/compat/client.py", line 209, in _time_request
    resp, body = self.request(url, method, **kwargs)
  File "/opt/stack/python-troveclient/troveclient/compat/client.py", line 187, in request
    raise exceptions.from_response(resp, body)
BadRequest: Bad request (HTTP Datastore 'mysql' cannot be found. (HTTP 400)
-------------------- >> begin captured logging << --------------------
troveclient.compat.client: DEBUG: REQ: curl -i http://172.18.196.62:8779/v1.0/531983aa109042a59a1b7e550186b9e2/instances -X POST -H "X-Auth-Project-Id: demo" -H "User-Agent: python-troveclient" -H "Content-Type: application/json" -H "Accept: application/json" -H "X-Auth-Token: MIITvQYJKoZIhvcNAQcCoIITrjCCE6oCAQExCTAHBgUrDgMCGjCCEhMGCSqGSIb3DQEHAaCCEgQEghIAeyJhY2Nlc3MiOiB7InRva2VuIjogeyJpc3N1ZWRfYXQiOiAiMjAxNC0wNi0xMFQxNDowMzo0MC43MjI2ODkiLCAiZXhwaXJlcyI6ICIyMDE0LTA2LTEwVDE1OjAzOjQwWiIsICJpZCI6ICJwbGFjZWhvbGRlciIsICJ0ZW5hbnQiOiB7ImRlc2NyaXB0aW9uIjogbnVsbCwgImVuYWJsZWQiOiB0cnVlLCAiaWQiOiAiNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIiLCAibmFtZSI6ICJkZW1vIn19LCAic2VydmljZUNhdGFsb2ciOiBbeyJlbmRwb2ludHMiOiBbeyJhZG1pblVSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo4Nzc0L3YyLzUzMTk4M2FhMTA5MDQyYTU5YTFiN2U1NTAxODZiOWUyIiwgInJlZ2lvbiI6ICJSZWdpb25PbmUiLCAiaW50ZXJuYWxVUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6ODc3NC92Mi81MzE5ODNhYTEwOTA0MmE1OWExYjdlNTUwMTg2YjllMiIsICJpZCI6ICJhN2M0ODhiMDlkMDM0MWRlODVjZjY5YjNhZGQ5YTBjMyIsICJwdWJsaWNVUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6ODc3NC92Mi81MzE5ODNhYTEwOTA0MmE1OWExYjdlNTUwMTg2YjllMiJ9XSwgImVuZHBvaW50c19saW5rcyI6IFtdLCAidHlwZSI6ICJjb21wdXRlIiwgIm5hbWUiOiAibm92YSJ9LCB7ImVuZHBvaW50cyI6IFt7ImFkbWluVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjg3NzYvdjIvNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIiLCAicmVnaW9uIjogIlJlZ2lvbk9uZSIsICJpbnRlcm5hbFVSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo4Nzc2L3YyLzUzMTk4M2FhMTA5MDQyYTU5YTFiN2U1NTAxODZiOWUyIiwgImlkIjogIjU3NDNiODI0MzFhZjRlODVhNDU4NWMxNjU1YWZmYWFiIiwgInB1YmxpY1VSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo4Nzc2L3YyLzUzMTk4M2FhMTA5MDQyYTU5YTFiN2U1NTAxODZiOWUyIn1dLCAiZW5kcG9pbnRzX2xpbmtzIjogW10sICJ0eXBlIjogInZvbHVtZXYyIiwgIm5hbWUiOiAiY2luZGVydjIifSwgeyJlbmRwb2ludHMiOiBbeyJhZG1pblVSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo4Nzc5L3YxLjAvNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIiLCAicmVnaW9uIjogIlJlZ2lvbk9uZSIsICJpbnRlcm5hbFVSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo4Nzc5L3YxLjAvNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIiLCAiaWQiOiAiMDJlMWQ1YjA5YTk3NDlhNWExYmZmYTIwODdhZWUwODUiLCAicHVibGljVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjg3NzkvdjEuMC81MzE5ODNhYTEwOTA0MmE1OWExYjdlNTUwMTg2YjllMiJ9XSwgImVuZHBvaW50c19saW5rcyI6IFtdLCAidHlwZSI6ICJkYXRhYmFzZSIsICJuYW1lIjogInRyb3ZlIn0sIHsiZW5kcG9pbnRzIjogW3siYWRtaW5VUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6MzMzMyIsICJyZWdpb24iOiAiUmVnaW9uT25lIiwgImludGVybmFsVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjMzMzMiLCAiaWQiOiAiMTAxZTIwOGViYzRkNGI3MGIzMjEyZGVkZWFiMzM0OGYiLCAicHVibGljVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjMzMzMifV0sICJlbmRwb2ludHNfbGlua3MiOiBbXSwgInR5cGUiOiAiczMiLCAibmFtZSI6ICJzMyJ9LCB7ImVuZHBvaW50cyI6IFt7ImFkbWluVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjkyOTIiLCAicmVnaW9uIjogIlJlZ2lvbk9uZSIsICJpbnRlcm5hbFVSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo5MjkyIiwgImlkIjogIjJiYjVhNmFkZDIwMzQ4YWJiNmM3ZmQwZWI5MjhjMTU2IiwgInB1YmxpY1VSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo5MjkyIn1dLCAiZW5kcG9pbnRzX2xpbmtzIjogW10sICJ0eXBlIjogImltYWdlIiwgIm5hbWUiOiAiZ2xhbmNlIn0sIHsiZW5kcG9pbnRzIjogW3siYWRtaW5VUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6ODc3NC92MyIsICJyZWdpb24iOiAiUmVnaW9uT25lIiwgImludGVybmFsVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjg3NzQvdjMiLCAiaWQiOiAiMjBmN2IyNmYwNTAyNGE2M2JjMzI2ZjAyOWIxN2FjNzciLCAicHVibGljVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjg3NzQvdjMifV0sICJlbmRwb2ludHNfbGlua3MiOiBbXSwgInR5cGUiOiAiY29tcHV0ZXYzIiwgIm5hbWUiOiAibm92YXYzIn0sIHsiZW5kcG9pbnRzIjogW3siYWRtaW5VUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6ODAwMC92MSIsICJyZWdpb24iOiAiUmVnaW9uT25lIiwgImludGVybmFsVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjgwMDAvdjEiLCAiaWQiOiAiNGVhNWZhNmYwNzdlNGFhMzk3ZmY5MmIxN2U5MDAxMTAiLCAicHVibGljVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjgwMDAvdjEifV0sICJlbmRwb2ludHNfbGlua3MiOiBbXSwgInR5cGUiOiAiY2xvdWRmb3JtYXRpb24iLCAibmFtZSI6ICJoZWF0In0sIHsiZW5kcG9pbnRzIjogW3siYWRtaW5VUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6ODc3Ni92MS81MzE5ODNhYTEwOTA0MmE1OWExYjdlNTUwMTg2YjllMiIsICJyZWdpb24iOiAiUmVnaW9uT25lIiwgImludGVybmFsVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjg3NzYvdjEvNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIiLCAiaWQiOiAiNWVhOTZlZjA3ZGFiNGNlZDljZWU2OGUzYmNhYTM5ZTgiLCAicHVibGljVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjg3NzYvdjEvNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIifV0sICJlbmRwb2ludHNfbGlua3MiOiBbXSwgInR5cGUiOiAidm9sdW1lIiwgIm5hbWUiOiAiY2luZGVyIn0sIHsiZW5kcG9pbnRzIjogW3siYWRtaW5VUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6ODc3My9zZXJ2aWNlcy9BZG1pbiIsICJyZWdpb24iOiAiUmVnaW9uT25lIiwgImludGVybmFsVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjg3NzMvc2VydmljZXMvQ2xvdWQiLCAiaWQiOiAiOGFkYjIyNTNmYjZjNDgzZGI1YTM1YjE3NGM2NTIwYTEiLCAicHVibGljVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjg3NzMvc2VydmljZXMvQ2xvdWQifV0sICJlbmRwb2ludHNfbGlua3MiOiBbXSwgInR5cGUiOiAiZWMyIiwgIm5hbWUiOiAiZWMyIn0sIHsiZW5kcG9pbnRzIjogW3siYWRtaW5VUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6ODAwNC92MS81MzE5ODNhYTEwOTA0MmE1OWExYjdlNTUwMTg2YjllMiIsICJyZWdpb24iOiAiUmVnaW9uT25lIiwgImludGVybmFsVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjgwMDQvdjEvNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIiLCAiaWQiOiAiMDIyZTQyMTA4ODlkNDM0NWJmNGRkMDE4MzcyZGYyMDgiLCAicHVibGljVVJMIjogImh0dHA6Ly8xNzIuMTguMTk2LjYyOjgwMDQvdjEvNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIifV0sICJlbmRwb2ludHNfbGlua3MiOiBbXSwgInR5cGUiOiAib3JjaGVzdHJhdGlvbiIsICJuYW1lIjogImhlYXQifSwgeyJlbmRwb2ludHMiOiBbeyJhZG1pblVSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo4MDgwIiwgInJlZ2lvbiI6ICJSZWdpb25PbmUiLCAiaW50ZXJuYWxVUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6ODA4MC92MS9BVVRIXzUzMTk4M2FhMTA5MDQyYTU5YTFiN2U1NTAxODZiOWUyIiwgImlkIjogIjBkN2M0ZDFhMDM4YzRkYjY4ZTlhOTdmMTNmMmQwYWQ2IiwgInB1YmxpY1VSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo4MDgwL3YxL0FVVEhfNTMxOTgzYWExMDkwNDJhNTlhMWI3ZTU1MDE4NmI5ZTIifV0sICJlbmRwb2ludHNfbGlua3MiOiBbXSwgInR5cGUiOiAib2JqZWN0LXN0b3JlIiwgIm5hbWUiOiAic3dpZnQifSwgeyJlbmRwb2ludHMiOiBbeyJhZG1pblVSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42MjozNTM1Ny92Mi4wIiwgInJlZ2lvbiI6ICJSZWdpb25PbmUiLCAiaW50ZXJuYWxVUkwiOiAiaHR0cDovLzE3Mi4xOC4xOTYuNjI6NTAwMC92Mi4wIiwgImlkIjogIjAzZjk4ODMyNzAwNDQwY2Q4ZTdiZGM0YjU5NWEyYmQ3IiwgInB1YmxpY1VSTCI6ICJodHRwOi8vMTcyLjE4LjE5Ni42Mjo1MDAwL3YyLjAifV0sICJlbmRwb2ludHNfbGlua3MiOiBbXSwgInR5cGUiOiAiaWRlbnRpdHkiLCAibmFtZSI6ICJrZXlzdG9uZSJ9XSwgInVzZXIiOiB7InVzZXJuYW1lIjogImRlbW8iLCAicm9sZXNfbGlua3MiOiBbXSwgImlkIjogImE1YjhhYTAxZjEzMDQyNzBhYjkwMTlhZjkxZjY5ZTI5IiwgInJvbGVzIjogW3sibmFtZSI6ICJfbWVtYmVyXyJ9LCB7Im5hbWUiOiAiTWVtYmVyIn0sIHsibmFtZSI6ICJhbm90aGVycm9sZSJ9LCB7Im5hbWUiOiAiaGVhdF9zdGFja19vd25lciJ9XSwgIm5hbWUiOiAiZGVtbyJ9LCAibWV0YWRhdGEiOiB7ImlzX2FkbWluIjogMCwgInJvbGVzIjogWyI5ZmUyZmY5ZWU0Mzg0YjE4OTRhOTA4NzhkM2U5MmJhYiIsICJlNmJiMjhlZWQ1ZWQ0ZGI4YTk0ZmNhZWFkYTk3Mzk2ZiIsICI0NGFlZGYxNGY1MjM0N2VmYjI3YmI3YzlmNmZmMDZhYyIsICIzODg5OWU1Y2U1ODc0YmMxODk5Y2E4NzdjYThjMDVkMCJdfX19MYIBgTCCAX0CAQEwXDBXMQswCQYDVQQGEwJVUzEOMAwGA1UECAwFVW5zZXQxDjAMBgNVBAcMBVVuc2V0MQ4wDAYDVQQKDAVVbnNldDEYMBYGA1UEAwwPd3d3LmV4YW1wbGUuY29tAgEBMAcGBSsOAwIaMA0GCSqGSIb3DQEBAQUABIIBACkZ8lgWdOE+5UkfRDd9KiUV0MwnCeUpDqPrPuhgPCnZnM4oVVlgBNZ29JWVvsVgTAlg648KkovjCWmzAz61X5BbPVBKf-O7KGu1uWyeaQh4+WP8QATuxi45+ewXJ3sm-6PtpNjNSdAHpZL7XFY+iW6QtkA+Ha2x1r5e3j43POukh7V3P-LB1VU8j8vGtIEW984bE0mYz6byBFuHEvuPpvBvSb8n4+qazclNwKEIuuvbCKj5anvowCxXvD4z3dIm71g5DCE-rH8IhV9HqL9W3HVGFLS4eT9IBZUXVtmyMTQizD46UmvmjCTuNC4REtGA-Gx8UGP1AvMtJPcziA4BK18="

troveclient.compat.client: DEBUG: REQ BODY: {"instance": {"users": [{"password": "litepass", "name": "lite", "databases": [{"name": "firstdb"}]}], "availability_zone": "nova", "flavorRef": "https://172.18.196.62:8779/v1.0/531983aa109042a59a1b7e550186b9e2/flavors/7", "volume": {"size": 1}, "databases": [{"collate": "latin2_general_ci", "name": "firstdb", "character_set": "latin2"}, {"name": "db2"}], "datastore": {"version": "5.5", "type": "mysql"}, "name": "TEST_2014-06-10 07:03:40.751888"}}

troveclient.compat.client: DEBUG: RESP:{'date': 'Tue, 10 Jun 2014 14:03:40 GMT', 'status': '400', 'content-length': '78', 'content-type': 'application/json; charset=UTF-8'} {"badRequest": {"message": "Datastore 'mysql' cannot be found.", "code": 400}}

--------------------- >> end captured logging << ---------------------)

----------------------------------------------------------------------
Ran 43 tests in 8.644s

FAILED (SKIP=19, errors=1)
Slowest 5 tests took 5.19 secs:
    1.09 proboscis.case.FunctionTest (start_nova_api)
    1.03 proboscis.case.FunctionTest (start_glance_registry)
    1.03 proboscis.case.FunctionTest (start_scheduler)
    1.02 proboscis.case.FunctionTest (start_nova_network)
    1.02 proboscis.case.FunctionTest (start_compute)

Denis M. (dmakogon)
Changed in trove-integration:
assignee: nobody → Denis M. (dmakogon)
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove-integration (master)

Fix proposed to branch: master
Review: https://review.openstack.org/99126

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on trove-integration (master)

Change abandoned by Denis M. (<email address hidden>) on branch: master
Review: https://review.openstack.org/99126

Revision history for this message
Nikhil Manchanda (slicknik) wrote :

This has been addressed by: https://review.openstack.org/#/c/84964/ which is now merged.

Changed in trove-integration:
assignee: Denis M. (dmakogon) → Shalini khandelwal (shalini-khandelwal)
importance: Undecided → Medium
milestone: none → juno-2
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers