Telegraf inputs.file timestamp "unix"

I’m getting error plugin:
Jan 17 14:05:20 tl-rhel-74 telegraf[2469]: 2019-01-17T19:05:20Z E! [inputs.file]: Error in plugin: parsing time “131922246173139818” as “unix”: cannot parse “131922246173139818” as “unix”
inpute file:

          Timestamp | Total Queued || Queued in P0 | Queued in P1 | Dropped |     All | Process | Modload |    File |     Net |     DNS |   Proxy | Blocked |   Other |
  131922145722147338 |            0 ||            0 |            0 |       0 |       3 |       0 |       0 |       0 |       0 |       2 |       0 |       0 |       1 |
  131922145872546833 |            0 ||            0 |            0 |       0 |       4 |       0 |       0 |       0 |       0 |       2 |       0 |       0 |       2 |

Any idea?

Can you show your configuration for this plugin?

Sure,

[[inputs.file]]
files =["/test/events-detail"]
data_format = “csv”
csv_header_row_count =1
csv_delimiter = “|”
csv_trim_space = true
csv_timestamp_column = “Timestamp”
csv_timestamp_format = “unix”

Looks like we don’t yet have support for nanosecond timestamps in the csv parser, we will need to add a new format, unix_ns, in the same manner we did with the JSON parser. Could you open a feature request on github for this?

sure, I will open it, but how do you suggest that I can configure it in order to add it. or can i skip the field?

You could skip it with csv_skip_columns = 1 and remove the timestamp parameters.

I updated my configuration to:
[[inputs.file]]
files =["/proc/cb/events-detail"]
data_format = “csv”
csv_header_row_count =1
csv_delimiter = “|”
csv_trim_space = true
csv_skip_columns =3

But I’m getting this error:

Jan 18 11:00:20 tl-rhel-74 telegraf[10620]: 2019-01-18T16:00:20Z E! [serializers.influx] could not serialize metric: invalid name; discarding metric
Jan 18 11:00:20 tl-rhel-74 telegraf[10620]: 2019-01-18T16:00:20Z E! [serializers.influx] could not serialize metric: invalid name; discarding metric
Jan 18 11:00:20 tl-rhel-74 telegraf[10620]: 2019-01-18T16:00:20Z E! [serializers.influx] could not serialize metric: invalid name; discarding metric
Jan 18 11:00:20 tl-rhel-74 telegraf[10620]: 2019-01-18T16:00:20Z E! [serializers.influx] could not serialize metric: invalid name; discarding metric
Jan 18 11:00:20 tl-rhel-74 telegraf[10620]: 2019-01-18T16:00:20Z E! [serializers.influx] could not serialize metric: invalid name; discarding metric

Sorry about the super slow response, you can try adding this as a workaround:

  name_override = "whatever"

I opened an issue on the Telegraf issue tracker for this: #5530

1 Like