Attachment 859550 Details for Bug 1061625 – query of instance table

query of instance table

instance-query.txt (text/plain), 4.19 KB, created by Ian Wienand on 2014-02-05 09:19:56 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Ian Wienand

Created: 2014-02-05 09:19:56 UTC

Size: 4.19 KB

patch

obsolete

>    mysql> select uuid,deleted,display_name,task_state,vm_state from nova.instances where instances.project_id = 'bd6159c7f8aa4baba9a33f0b2725e6d1' and task_state != 'deleted';
>    +--------------------------------------+---------+---------------------------------------------------------+------------+----------+
>    | uuid                                 | deleted | display_name                                            | task_state | vm_state |
>    +--------------------------------------+---------+---------------------------------------------------------+------------+----------+
>    | a6be3364-08f7-44d5-924f-c61a9563da04 |    1074 | gerritbot_47076_devstack_OSLAB_RHEL64_20131125183319    | deleting   | error    |
>    | 0507362c-d40e-41ca-92d8-eec909918f99 |    1063 | gerritbot_40676_devstack_OSLAB_RHEL65_20131125161605    | deleting   | error    |
>    | 0e02a4a0-eb1d-48da-8133-8c8a1579c825 |    1064 | gerritbot_40676_devstack_OSLAB_CENTOS64_20131125161605  | deleting   | error    |
>    | a89f313c-c8a0-40be-92f5-8c2ccdd4bf97 |    1065 | gerritbot_40676_devstack_OSLAB_RHEL64_20131125161605    | deleting   | error    |
>    | a5689f42-c13f-45c4-9682-2cbb0423777b |    1104 | gerritbot_52131_packstack_OSLAB_RHEL64_20131126090028   | deleting   | error    |
>    | dff7cdce-4dee-4306-82a5-e1ed221f6bc0 |    1110 | gerritbot_57544_devstack_OSLAB_RHEL64_20131126172936    | deleting   | error    |
>    | 5777706e-4ec8-4470-a522-83c8ec27974a |    1102 | gerritbot_52131_packstack_OSLAB_FEDORA19_20131126090028 | deleting   | error    |
>    | 774fe917-dc21-4bc0-9a2a-7973d25f08cb |    1103 | gerritbot_52131_packstack_OSLAB_RHEL65_20131126090027   | deleting   | error    |
>    | e2e99abf-b913-4ba8-b77f-fbf00d92b6fb |    1310 | gerritbot_59430_devstack_OSLAB_FEDORA19_20131202093115  | deleting   | error    |
>    | a25abf9d-1012-445b-a671-825a269450c5 |    1311 | gerritbot_59430_devstack_OSLAB_CENTOS64_20131202093115  | deleting   | error    |
>    | 1506f548-1fe3-41f6-8898-acaf36382972 |    1312 | gerritbot_59430_devstack_OSLAB_RHEL65_20131202093115    | deleting   | error    |
>    | db4fd683-6a55-4cc4-8ae6-294cf8c621f8 |    1309 | gerritbot_59430_devstack_OSLAB_FEDORA20_20131202093115  | deleting   | error    |
>    | db990d81-a7dd-4f58-baa9-616d6b491119 |    1582 | gerritbot_59956_packstack_OSLAB_FEDORA19_20131204061716 | deleting   | building |
>    | 0829041a-0560-40a4-adf0-c94ab88f4afa |    1774 | gerritbot_59244_devstack_OSLAB_CENTOS64_20131205204837  | deleting   | error    |
>    | a908b5cf-f14b-4841-85be-11fec8aad116 |    1771 | gerritbot_59244_devstack_OSLAB_FEDORA20_20131205194604  | deleting   | error    |
>    | 4e337662-5f4f-4da9-a26a-6413d655d414 |    1772 | gerritbot_59244_devstack_OSLAB_FEDORA19_20131205194604  | deleting   | error    |
>    | d6d83b5a-8d59-41fe-a8dd-751b7bf49570 |    1773 | gerritbot_59244_devstack_OSLAB_RHEL64_20131205194604    | deleting   | error    |
>    | a7834821-a2cb-4ccc-91f7-732220ae961d |    1777 | gerritbot_60077_devstack_OSLAB_CENTOS64_20131206040837  | deleting   | error    |
>    | 8969bffd-b845-44a3-9111-cbc7a889f836 |    1775 | gerritbot_60077_devstack_OSLAB_FEDORA19_20131206040837  | deleting   | error    |
>    | b815fe21-d28b-4977-a60e-ec147d73862d |    1776 | gerritbot_60077_devstack_OSLAB_FEDORA20_20131206040837  | deleting   | error    |
>    | 0bd5255a-c6f6-4eb3-8868-1a9535f364ba |    3430 | gerritbot_65834_devstack_OSLAB_CENTOS65_20140110133719  | deleting   | building |
>    | 9d3c30f6-1542-4ee0-b425-55fc730516e2 |    3433 | gerritbot_65503_packstack_OSLAB_RHEL64_20140112162039   | deleting   | building |
>    | 6454f62e-0965-4bd7-b5cc-7071daa5a10f |    3436 | gerritbot_65979_packstack_OSLAB_RHEL64_20140112162459   | deleting   | building |
>    | 5fec060d-ab16-4c7c-9238-13b4ae105226 |    3437 | gerritbot_65979_packstack_OSLAB_RHEL65_20140112162459   | deleting   | building |
>    | 733a5ec5-69b1-4881-ac55-df77df65bd0b |    3434 | gerritbot_65979_packstack_OSLAB_RHEL7_20140112162459    | deleting   | building |
>    | c91ff363-365d-48c2-97db-8d5f52832fec |    3435 | gerritbot_65979_packstack_OSLAB_FEDORA19_20140112162459 | deleting   | building |
>    +--------------------------------------+---------+---------------------------------------------------------+------------+----------+

Actions: View

Attachments on bug 1061625: 859550