Almost all Unicode are valid measurement names. I suspect someone's code is writing strange measurement names rather than corruption of the system.
> I can't execute "show series" for these measurements Why not? What is the output? > If the latter, how would I go about dropping them? DROP MEASUREMENT ";" DROP MEASUREMENT "�" > Does InfluxDB do any sanity checking on measurement names? https://docs.influxdata.com/influxdb/v1.1/query_language/spec/#identifiers On Mon, Nov 21, 2016 at 2:37 AM, <[email protected]> wrote: > I've just noticed two measurements in my DB that are appear to have had > their name corrupted, possibly since upgrading to v1.1. > > > show measurements > name: measurements > name > ---- > ; > aggregation_cpu > aggregation_percent > > ... > > processes_ps_state > processes_ps_vm > � > > If I execute "show measurements" via curl, it also indicates some extended > unicode chars in the names: > > "values": [ > [ > ";\u0003" > ], > [ > "aggregation_cpu" > ], > > ... > > [ > "processes_ps_vm" > ], > [ > "\ufffd" > ] > > I'm at a bit of a loss what to do. I can't execute "show series" for these > measurements, so I'm not sure if they are legitimate measurements that have > somehow had their name corrupted, or whether they're completely bogus. If > the latter, how would I go about dropping them? > > Does InfluxDB do any sanity checking on measurement names? I wonder if one > of my colleagues has accidentally inserted these gibberish measurements > whilst experimenting, and whether there are any safeguards against such > accidents. > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/32ea2cdb-e30f-4f9d-b9c7-9e9ac1004085%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvP3WZso9CBPvVtLUa6bxNV9mKqbVyZy1OTP4xrRVmfKsg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
