VMware Cloud Community
SebastianGrugel
Hot Shot
Hot Shot

Cassandra 3.11 and additional metrics + vCD 9.5 + VCSA 6.7

I have LAB with fresh Cassandra installation (which worked before):

My goal is described in this post vCD 9.1.0 adding to Cassandra DB additional metrics to collect performance data  where i tried add additional metrics for billing and performance reasons.

Above issue existed in vCD 9.1

Few days ago i installed vCD 9.5 and Cassandra 3.11 and API requests (for metrics /current and /historical) and all worked fine on the beginning.

Next i uploaded 2 examples metrics and wanted check if Cassandra metrics will be visible in vCD.

mem.granted.average

mem.granted.maximum

In GUI all is working fine.

pastedImage_2.png

Honestly, i didn't check API requests after update metrics to DB.

Today im after vSphere upgrade from 6.5u2 to 6.7u1 and wanted double check if everything is still working.

Unfortunately API requests for metrics data are not working fine. Im using Visual Studio COde plugin for Rest:

pastedImage_3.png

pastedImage_5.png

In response I found an error:

"exceptions.InvalidQueryException: Undefined column name "mem.granted.average"
	at"

I'm not sure what should be the next step. I rebooted CELLS, Cassandra DB node1 and node 2 without results.

Some advice?

Sebastian

www.vSebastian.net

vExpert VSAN/NSX/CLOUD | VCAP5-DCA | VCP6-DCV/CMA/NV ==> akademiadatacenter.pl
Reply
0 Kudos
1 Reply
SebastianGrugel
Hot Shot
Hot Shot

Temporary resolved issue by removing metrics from SQL database.

1. Prepared empty file with metrics

2.Imported metrics to SQL DB

3.Update Cassandra Schema

4. and restart vCD services

pastedImage_0.png

but still dont know..why this issue happened...

vExpert VSAN/NSX/CLOUD | VCAP5-DCA | VCP6-DCV/CMA/NV ==> akademiadatacenter.pl
Reply
0 Kudos