Comment 1 for bug 1177596

 select * from bm_nodes;
+---------------------+---------------------+------------+---------+----+------+-----------+----------+-------------+---------------+-------------+--------------+------------------+--------------------------------------+------------+---------------+------------------------------------------------+-------------------------------------------------------+----------------------------------+---------+---------+--------------------------------------+---------------+
| created_at | updated_at | deleted_at | deleted | id | cpus | memory_mb | local_gb | pm_address | pm_user | pm_password | service_host | prov_mac_address | instance_uuid | task_state | terminal_port | image_path | pxe_config_path | deploy_key | root_mb | swap_mb | uuid | instance_name |
+---------------------+---------------------+------------+---------+----+------+-----------+----------+-------------+---------------+-------------+--------------+------------------+--------------------------------------+------------+---------------+------------------------------------------------+-------------------------------------------------------+----------------------------------+---------+---------+--------------------------------------+---------------+
| 2013-05-07 02:18:07 | 2013-05-07 22:14:01 | NULL | 0 | 1 | 1 | 512 | 10 | x.x.x.47 | Administrator | xxx | ubuntu | NULL | 0690eecc-ef18-4804-be34-206b122724f1 | error | NULL | /var/lib/nova/instances/instance-00000005/disk | /tftpboot/0690eecc-ef18-4804-be34-206b122724f1/config | QIZMMZKBKGABI3NI24JPQQO2A221ZCFO | 10240 | 1 | a3b04bf3-351f-4f7d-8d7b-878dec5b796d | foo |
| 2013-05-07 03:15:24 | 2013-05-07 03:29:25 | NULL | 0 | 2 | 1 | 512 | 10 | x.x.x.46 | Administrator | xxx | ubuntu | NULL | b74cbb15-edf8-4dbc-911c-430c0ff60a31 | building | NULL | /var/lib/nova/instances/instance-00000003/disk | /tftpboot/b74cbb15-edf8-4dbc-911c-430c0ff60a31/config | I0RJ5KCT69L1PCF1NGDQLNFQC8OASBEC | 10240 | 1 | 08bea2d7-e0ac-4224-8ee8-98495b93a13b | bmtest3 |
| 2013-05-07 03:27:40 | 2013-05-07 20:40:31 | NULL | 0 | 3 | 1 | 512 | 10 | x.x.x.45 | Administrator | xxx | ubuntu | NULL | 952b9558-c550-4b9d-9f9e-bcf152835161 | building | NULL | /var/lib/nova/instances/instance-00000004/disk | /tftpboot/952b9558-c550-4b9d-9f9e-bcf152835161/config | 4PRO1Q1Z249Z65C0NQYVSNK7BDGV52GN | 10240 | 1 | f665421b-65f4-4a6c-82d5-4e54bb647cff | bmtest-cmsj1 |
| 2013-05-07 22:27:31 | 2013-05-07 22:49:32 | NULL | 0 | 6 | 1 | 4096 | 20 | x.x.x.49 | Administrator | xxx | ubuntu | NULL | fdbb2896-0d00-465a-bb93-8fa7a89672e3 | building | NULL | /var/lib/nova/instances/instance-0000000c/disk | /tftpboot/fdbb2896-0d00-465a-bb93-8fa7a89672e3/config | 99MV3CH4CF9IERWH4WWKQD0H8VOMTUZ2 | 10240 | 1 | a476f747-6f05-469f-8a40-a7e38b7499c0 | foo |
+---------------------+---------------------+------------+---------+----+------+-----------+----------+-------------+---------------+-------------+--------------+------------------+--------------------------------------+------------+---------------+------------------------------------------------+-------------------------------------------------------+----------------------------------+---------+---------+--------------------------------------+---------------+