Recently I spent some time configuring vCloud Director metrics and storing them in a Cassandra cluster. If you have ever stepped outside of the default metrics and tried to provide your own via a Groovy file, you may have hit the following error in the
Invalid column name **metric** because it conflicts with an existing column
If your Groovy file contains the metric listed in the error message and you've only listed it once, you're probably thinking “where on earth is this duplicate coming from?". Well…
vCloud Director stores a list of default metrics that will be sent to the Cassandra cluster in the event you don't provide a Groovy file during configuration. Your groovy file must not conflict with the default metrics that vCloud Director is already aware of. So, all you need to do is remove the vCloud Director default metric values from your Groovy file. How do you know which ones are the defaults? Tomas Fojta has us covered.
As Tomas points out, the default metric names are stored in the vCloud Director database under the table “metric_configuration”. If your SQL database is handled by SQL admins and you can't get to this table, you're at their mercy (I know what that can be like). So, make sure the following metrics are not in your Groovy file:
metric("cpu.usagemhz.average") metric("disk.provisioned.latest") metric("disk.read.average") metric("mem.usage.average") metric("cpu.usage.maximum") metric("disk.used.latest") metric("disk.write.average") metric("cpu.usage.average")