EIO reported in "Flows Summary" when selecting a port from Port Map of a virtual network

[Anda-Maria Nicolae]

Hi all,

I have a setup of 3 VMs: one OpenStack node, one Contrail controller node and 1 Contrail compute node.
All 3 VMs use RedHat 7.4. The 3 VMs run on an CentOS7 server.
I have installed Contrail R5.0 on my setup using contrail-ansible-deployer/.

I have created 2 virtual networks, named vn1 and vn2. From OpenStack, I have booted 2 virtual machines inside vn1 virtual network.
From Monitor -> Networking -> Networks, I have selected vn1. From Port Map tab associated to vn1, I have clicked on a port. A "Flows Summary" table has appeared.
However, inside this table it is shows: EIO.

Using Chrome debugger, I looked over the HTTP requests that were made. I've noticed that at HTTP POST request sent at:
https://<Contrail_Controller_IP>:8143/api/qe/query
was received 500 Internal Error

Thanks,
Anda

[Abhay Joshi (abhayj)]

Hi Abhay, for bug https://bugs.launchpad.net/juniperopenstack/+bug/1774364, it's clearly an analytics bug. The UI try to do a query on the opserver to construct a flow summary, and query API return a 500 internal server error.

[Sundaresan Rajangam (srajanga)]

Please provide the following info:

o/p of contrail-status
o/p of top from analyticsdb container
Please provide query-engine, collector and cassandra logs

If you have the setup in the same state, can you please share the setup?

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/44976
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/44977
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/44976
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/44977
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/44976
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/44977
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/45023
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/44976
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/45023
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/44977
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Reviewed: https://review.opencontrail.org/44977
Committed: http://github.com/Juniper/contrail-analytics/commit/a666e73204f39253ae6e0e4e884eac2d6da7424b
Submitter: Zuul v3 CI (<email address hidden>)
Branch: R5.0

commit a666e73204f39253ae6e0e4e884eac2d6da7424b
Author: mkheni <email address hidden>
Date: Thu Jul 26 14:55:14 2018 -0700

Fix <field>=* prifix queries in QueryEngine

Sometimes <field>=* prefix queries translate to <field> LIKE '%'
where condition in cassandra. Cassandra doesn't allow such where
clauses and returns error. If QE receives such where clause, ignore
it as it effectively translate to no where condition.

Added systemless test to verify the behavior

Change-Id: I893d3036fd22ce399186f4cc67812de2fa46701c
Closes-bug: #1774364

[OpenContrail Admin (ci-admin-f)]

Reviewed: https://review.opencontrail.org/44976
Committed: http://github.com/Juniper/contrail-analytics/commit/0a2d02e12cf4c3b274b32307d11e3f8b51170622
Submitter: Zuul v3 CI (<email address hidden>)
Branch: master

commit 0a2d02e12cf4c3b274b32307d11e3f8b51170622
Author: mkheni <email address hidden>
Date: Thu Jul 26 14:55:14 2018 -0700

Fix <field>=* prifix queries in QueryEngine

Sometimes <field>=* prefix queries translate to <field> LIKE '%'
where condition in cassandra. Cassandra doesn't allow such where
clauses and returns error. If QE receives such where clause, ignore
it as it effectively translate to no where condition.

Added systemless test to verify the behavior

Change-Id: I893d3036fd22ce399186f4cc67812de2fa46701c
Closes-bug: #1774364

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/45023
Submitter: mkheni (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Reviewed: https://review.opencontrail.org/45023
Committed: http://github.com/Juniper/contrail-controller/commit/7688544c43d1a981e2f72d91ddce0227c99146e2
Submitter: Zuul (<email address hidden>)
Branch: R4.1

commit 7688544c43d1a981e2f72d91ddce0227c99146e2
Author: mkheni <email address hidden>
Date: Fri Jul 27 12:33:31 2018 -0700

Fix <field>=* prefix queries in QueryEngine

Sometimes <field>=* prefix queries translate to <field> LIKE '%'
where condition in cassandra. Cassandra doesn't allow such where
clauses and returns error. If QE receives such where clause, ignore
it as it effectively translate to no where condition.

Added systemless test to verify the behavior

Change-Id: I893d3036fd22ce399186f4cc67812de2fa46701c
Closes-bug: #1774364