[5.0 build 136 ]Query queues in contrail Webui reporting An unexpected error occurred!

[aswani kumar]

5.0.1 build 136 multinode

In Query under flow,session,logs query queue is showing following error
Error: An unexpected error occurred!

I have not done any query here

Errors from inspect element
Failed to load resource: the server responded with a status of 500 (Internal Server Error)
GET https://nodem14:8143/api/qe/query/queue?queryQueue=seqq&_=1531376720374 500 (Internal Server Error)
GET https://nodem14:8143/api/qe/query/queue?queryQueue=fqq&_=1531376720379 500 (Internal Server Error)

All other fields are fine flowseries,flowrecord,session series etc

#webui-log

07/12/2018 11:52:21 AM - debug: Query Request: {"queryQueue":"seqq","_":"1531376720374"}
07/12/2018 11:52:21 AM - error: TypeError: Cannot read property 'table_type' of undefined
    at getQueryOptions (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:253:35)
    at runNewQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:244:24)
    at runQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:239:9)
    at runGETQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:37:5)
    at Object.processPendingReq (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:141:3)
    at /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js:79:28
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:251:13
    at Object.checkUserAccess (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/rbac.api.js:195:11)
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:242:14
    at Object.setTokensIfValidByXAuthToken (/usr/src/contrail/contrail-web-core/src/serverroot/web/routes/handler.js:288:9)
07/12/2018 11:52:27 AM - debug: Query sent to Opserver at Thu Jul 12 2018 11:52:27 GMT+0530 (IST) {"start_time":1531375947000000,"end_time":1531376547000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"MessageTable","op":7}]]}
07/12/2018 11:52:28 AM - debug: Query results (0 records) received from opserver at Thu Jul 12 2018 11:52:28 GMT+0530 (IST) in 0secs. {"start_time":1531375947000000,"end_time":1531376547000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"MessageTable","op":7}]]}
07/12/2018 11:52:29 AM - debug: Query sent to Opserver at Thu Jul 12 2018 11:52:29 GMT+0530 (IST) {"start_time":1531375949000000,"end_time":1531376549000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"FlowSeriesTable","op":7}]]}
07/12/2018 11:52:30 AM - debug: Query Request: {"queryQueue":"fqq","_":"1531376720379"}
07/12/2018 11:52:30 AM - error: TypeError: Cannot read property 'table_type' of undefined
    at getQueryOptions (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:253:35)
    at runNewQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:244:24)
    at runQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:239:9)
    at runGETQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:37:5)
    at Object.processPendingReq (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:141:3)
    at /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js:79:28
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:251:13
    at Object.checkUserAccess (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/rbac.api.js:195:11)
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:242:14
    at Object.setTokensIfValidByXAuthToken (/usr/src/contrail/contrail-web-core/src/serverroot/web/routes/handler.js:288:9)
07/12/2018 11:52:30 AM - debug: Query results (0 records) received from opserver at Thu Jul 12 2018 11:52:30 GMT+0530 (IST) in 0secs. {"start_time":1531375949000000,"end_time":1531376549000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"FlowSeriesTable","op":7}]]}
07/12/2018 11:52:34 AM - debug: Query sent to Opserver at Thu Jul 12 2018 11:52:34 GMT+0530 (IST) {"start_time":1531375954000000,"end_time":1531376554000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"MessageTable","op":7}]]}
07/12/2018 11:52:35 AM - debug: Query results (0 records) received from opserver at Thu Jul 12 2018 11:52:35 GMT+0530 (IST) in 0secs. {"start_time":1531375954000000,"end_time":1531376554000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"MessageTable","op":7}]]}
07/12/2018 11:52:35 AM - debug: Query Request: {"queryQueue":"lqq","_":"1531376720382"}
07/12/2018 11:52:35 AM - error: TypeError: Cannot read property 'table_type' of undefined
    at getQueryOptions (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:253:35)
    at runNewQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:244:24)
    at runQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:239:9)
    at runGETQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:37:5)
    at Object.processPendingReq (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:141:3)
    at /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js:79:28
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:251:13
    at Object.checkUserAccess (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/rbac.api.js:195:11)
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:242:14
    at Object.setTokensIfValidByXAuthToken (/usr/src/contrail/contrail-web-core/src/serverroot/web/routes/handler.js:288:9)
07/12/2018 11:53:01 AM - debug: Query Request: {"queryQueue":"seqq","_":"1531376720383"}
07/12/2018 11:53:01 AM - error: TypeError: Cannot read property 'table_type' of undefined
    at getQueryOptions (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:253:35)
    at runNewQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:244:24)
    at runQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:239:9)
    at runGETQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:37:5)
    at Object.processPendingReq (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:141:3)
    at /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js:79:28
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:251:13
    at Object.checkUserAccess (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/rbac.api.js:195:11)
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:242:14
    at Object.setTokensIfValidByXAuthToken (/usr/src/contrail/contrail-web-core/src/serverroot/web/routes/handler.js:288:9)
07/12/2018 12:02:25 PM - debug: Query sent to Opserver at Thu Jul 12 2018 12:02:25 GMT+0530 (IST) {"start_time":1531376545000000,"end_time":1531377145000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"SessionSeriesTable","op":7}]]}
07/12/2018 12:02:26 PM - debug: Query results (0 records) received from opserver at Thu Jul 12 2018 12:02:26 GMT+0530 (IST) in 0secs. {"start_time":1531376545000000,"end_time":1531377145000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"SessionSeriesTable","op":7}]]}
07/12/2018 12:02:44 PM - debug: Query sent to Opserver at Thu Jul 12 2018 12:02:44 GMT+0530 (IST) {"start_time":1531376564000000,"end_time":1531377164000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"FlowSeriesTable","op":7}]]}
07/12/2018 12:02:45 PM - debug: Query results (0 records) received from opserver at Thu Jul 12 2018 12:02:45 GMT+0530 (IST) in 0secs. {"start_time":1531376564000000,"end_time":1531377164000000,"select_fields":["name","fields.value"],"table":"StatTable.FieldNames.fields","where":[[{"name":"name","value":"FlowSeriesTable","op":7}]]}
07/12/2018 12:03:36 PM - debug: Query Request: {"queryQueue":"fqq","_":"1531376720390"}
07/12/2018 12:03:36 PM - error: TypeError: Cannot read property 'table_type' of undefined
    at getQueryOptions (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:253:35)
    at runNewQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:244:24)
    at runQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:239:9)
    at runGETQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:37:5)
    at Object.processPendingReq (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:141:3)
    at /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js:79:28
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:251:13
    at Object.checkUserAccess (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/rbac.api.js:195:11)
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:242:14
    at Object.setTokensIfValidByXAuthToken (/usr/src/contrail/contrail-web-core/src/serverroot/web/routes/handler.js:288:9)

[Jeba Paulaiyan (jebap)]

Keeping this open in 5.0.2 to address gaps between New UI Vs Contrail-command

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/47366
Submitter: Michal Skalski (<email address hidden>)

[OpenContrail Admin (ci-admin-f)]

Review in progress for https://review.opencontrail.org/47386
Submitter: Michal Skalski (<email address hidden>)

[Kevin Chai (chaimh1)]

My setup also has the error ' Error: An unexpected error occurred!' in the Query Queue,My setup is using the 5.0.1.Though I have merged your fix to my setup, the issue is still there.

[Kevin Chai (chaimh1)]

Here is the error log.

11/09/2018 05:32:50 PM - debug: Query Request: {"queryQueue":"fqq","_":"1541741384234"}
11/09/2018 05:32:50 PM - error: TypeError: Cannot read property 'table_type' of undefined
    at getQueryOptions (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:253:35)
    at runNewQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:244:24)
    at runQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:239:9)
    at runGETQuery (/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/query.api.js:37:5)
    at Object.processPendingReq (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:141:3)
    at /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js:79:28
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:251:13
    at Object.checkUserAccess (/usr/src/contrail/contrail-web-core/src/serverroot/web/core/rbac.api.js:202:11)
    at /usr/src/contrail/contrail-web-core/src/serverroot/web/core/longPolling.api.js:242:14
    at Object.setTokensIfValidByXAuthToken (/usr/src/contrail/contrail-web-core/src/serverroot/web/routes/handler.js:279:9)

[Michal Skalski (mskalski)]

Hi Kevin,

The change modify file used during building of contrail_webui_web container for generating /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js. If your container is already run you can modify /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js directly on all web containers and restart them.

[Vu Duc Manh (manhvu)]

Hi Michal Skalski, can you tell me what need modify in /usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js. I got same errors.

[Giuseppe Petralia (peppepetra)]

Hi,

can you please share how

/usr/src/contrail/contrail-web-core/webroot/reports/qe/api/url.routes.js

should look like?