Event filtering is non-obvious and broken

[Steven Hardy]

To use the event filtering, you really need internal knowledge of the DB schema, because the filters don't align with the displayed columns, particularly for resource_status

E.g:

  $ heat event-list overcloud -f "resource_status=CREATE_COMPLETE"
  +----+------------------------+-----------------+------------+
  | id | resource_status_reason | resource_status | event_time |
  +----+------------------------+-----------------+------------+
  +----+------------------------+-----------------+------------+

You have to specify it like this:

  heat event-list overcloud -f "resource_action=CREATE;resource_status=COMPLETE"

Which makes sense if you know the DB schema, but from a users perspective it's pretty mysterious..

[Steve Baker (steve-stevebaker)]

I've added heat, since I think this is a REST API issue rather than a client one.

There are 2 issues here:
- resource_status=CREATE_COMPLETE should work as expected
- the API also needs to return separate attributes for status and action, and these should also be filterable

[Steven Hardy (shardy)]

Also, it seems that filtering on ID and timestamp doesn't work - really for timestamp filtering to be useful it needs to support not only exact matching, but also ranges, e.g at a minimum events before/after timestampX.

[shardy@localhost python-heatclient]$ heat event-list overcloud -f "resource_action=UPDATE;resource_status=COMPLETE;resource_name=ObjectStorage;uuid=1a65c203-ab4d-4c34-a2c9-d85ae4ac8d08"
+---------------+--------------------------------------+------------------------+-----------------+----------------------+
| resource_name | id | resource_status_reason | resource_status | event_time |
+---------------+--------------------------------------+------------------------+-----------------+----------------------+
| ObjectStorage | 1a65c203-ab4d-4c34-a2c9-d85ae4ac8d08 | state changed | UPDATE_COMPLETE | 2015-04-15T13:24:32Z |
| ObjectStorage | 5c3e0f07-8c01-4d7b-9a48-9e2da93a2c3c | state changed | UPDATE_COMPLETE | 2015-04-15T13:41:36Z |
| ObjectStorage | cb52b058-1d3a-4878-b9c3-95649591564b | state changed | UPDATE_COMPLETE | 2015-04-16T17:35:30Z |
| ObjectStorage | 964067ad-f15d-49fe-bcc3-f28d3eb8d162 | state changed | UPDATE_COMPLETE | 2015-04-17T10:24:08Z |
+---------------+--------------------------------------+------------------------+-----------------+----------------------+
[shardy@localhost python-heatclient]$ heat event-list overcloud -f "resource_action=UPDATE;resource_status=COMPLETE;resource_name=ObjectStorage;id=1a65c203-ab4d-4c34-a2c9-d85ae4ac8d08"
+---------------+--------------------------------------+------------------------+-----------------+----------------------+
| resource_name | id | resource_status_reason | resource_status | event_time |
+---------------+--------------------------------------+------------------------+-----------------+----------------------+
| ObjectStorage | 1a65c203-ab4d-4c34-a2c9-d85ae4ac8d08 | state changed | UPDATE_COMPLETE | 2015-04-15T13:24:32Z |
| ObjectStorage | 5c3e0f07-8c01-4d7b-9a48-9e2da93a2c3c | state changed | UPDATE_COMPLETE | 2015-04-15T13:41:36Z |
| ObjectStorage | cb52b058-1d3a-4878-b9c3-95649591564b | state changed | UPDATE_COMPLETE | 2015-04-16T17:35:30Z |
| ObjectStorage | 964067ad-f15d-49fe-bcc3-f28d3eb8d162 | state changed | UPDATE_COMPLETE | 2015-04-17T10:24:08Z |
+---------------+--------------------------------------+------------------------+-----------------+----------------------+
[shardy@localhost tripleo]$ heat event-list overcloud -f "resource_action=UPDATE;resource_status=COMPLETE;resource_name=ObjectStorage;event_time=2015-04-15T13:24:32Z"
+---------------+--------------------------------------+------------------------+-----------------+----------------------+
| resource_name | id | resource_status_reason | resource_status | event_time |
+---------------+--------------------------------------+------------------------+-----------------+----------------------+
| ObjectStorage | 1a65c203-ab4d-4c34-a2c9-d85ae4ac8d08 | state changed | UPDATE_COMPLETE | 201...

[Steven Hardy (shardy)]

Satyanarayana Patibandla: If you're working on this, perhaps we can collaborate? I need the fix for timestamp filtering ASAP, so I may provide a partial fix resolving that, then you can follow up with the remaining fixes related to misaligned names?

Feel free to ping me on IRC to discuss (shardy in #heat on Freenode), I'm based in a UTC+1 timezone, thanks!

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Change abandoned by Steven Hardy (<email address hidden>) on branch: master
Review: https://review.openstack.org/176990
Reason: figured out another way to do hook-poll filtering using markers