MariaDB [nova]> select * from services;
+---------------------+---------------------+------------+----+----------------------------+------------------+-------------+--------------+----------+---------+-----------------+
| created_at          | updated_at          | deleted_at | id | host                       | binary           | topic       | report_count | disabled | deleted | disabled_reason |
+---------------------+---------------------+------------+----+----------------------------+------------------+-------------+--------------+----------+---------+-----------------+
| 2014-10-20 12:39:10 | 2014-10-29 14:36:25 | NULL       |  1 | cloud-controller1.prod.lan | nova-cert        | cert        |        77944 |        0 |       0 | NULL            |
| 2014-10-20 12:39:12 | 2014-10-29 14:36:25 | NULL       |  2 | cloud-controller1.prod.lan | nova-consoleauth | consoleauth |        77944 |        0 |       0 | NULL            |
| 2014-10-20 12:39:14 | 2014-10-29 14:36:25 | NULL       |  3 | cloud-controller1.prod.lan | nova-scheduler   | scheduler   |        77944 |        0 |       0 | NULL            |
| 2014-10-20 12:39:15 | 2014-10-29 14:36:34 | NULL       |  4 | cloud-controller1.prod.lan | nova-conductor   | conductor   |        77978 |        0 |       0 | NULL            |
| 2014-10-20 12:55:32 | 2014-10-29 14:36:33 | NULL       |  5 | cloud-compute1.prod.lan    | nova-compute     | compute     |        76631 |        0 |       0 | None            |
| 2014-10-29 14:25:32 | 2014-10-29 14:25:47 | NULL       |  6 | cloud-controller1.prod.lan | nova-network     | network     |            2 |        0 |       0 | NULL            |
+---------------------+---------------------+------------+----+----------------------------+------------------+-------------+--------------+----------+---------+-----------------+
6 rows in set (0.00 sec)

MariaDB [nova]> delete from services where id=6;
Query OK, 1 row affected (0.05 sec)

MariaDB [nova]> select * from services;
+---------------------+---------------------+------------+----+----------------------------+------------------+-------------+--------------+----------+---------+-----------------+
| created_at          | updated_at          | deleted_at | id | host                       | binary           | topic       | report_count | disabled | deleted | disabled_reason |
+---------------------+---------------------+------------+----+----------------------------+------------------+-------------+--------------+----------+---------+-----------------+
| 2014-10-20 12:39:10 | 2014-10-29 14:37:15 | NULL       |  1 | cloud-controller1.prod.lan | nova-cert        | cert        |        77949 |        0 |       0 | NULL            |
| 2014-10-20 12:39:12 | 2014-10-29 14:37:15 | NULL       |  2 | cloud-controller1.prod.lan | nova-consoleauth | consoleauth |        77949 |        0 |       0 | NULL            |
| 2014-10-20 12:39:14 | 2014-10-29 14:37:15 | NULL       |  3 | cloud-controller1.prod.lan | nova-scheduler   | scheduler   |        77949 |        0 |       0 | NULL            |
| 2014-10-20 12:39:15 | 2014-10-29 14:37:14 | NULL       |  4 | cloud-controller1.prod.lan | nova-conductor   | conductor   |        77982 |        0 |       0 | NULL            |
| 2014-10-20 12:55:32 | 2014-10-29 14:37:13 | NULL       |  5 | cloud-compute1.prod.lan    | nova-compute     | compute     |        76635 |        0 |       0 | None            |
+---------------------+---------------------+------------+----+----------------------------+------------------+-------------+--------------+----------+---------+-----------------+
5 rows in set (0.00 sec)