Telegraf Line protocol import error - Tag value with escaped spaces

[mickymots]

Relevant telegraf.conf:

Telegraf Configuration

[global_tags]
# Configuration for telegraf agent
[agent]
  ## Default data collection interval for all inputs
  interval = "60s"
  round_interval = true
  metric_batch_size = 1000

  metric_buffer_limit = 10000

  collection_jitter = "0s"

  flush_interval = "10s"
  flush_jitter = "0s"

  precision = "ns"

  hostname = ""
  omit_hostname = false

###############################################################################
#                            OUTPUT PLUGINS                                   #
###############################################################################

# Configuration for sending metrics to InfluxDB
[[outputs.influxdb]]
  urls = ["http://127.0.0.1:8086"]
  database = "_influxdb"

###############################################################################
#                            INPUT PLUGINS                                    #
###############################################################################

# Read metrics from one or more commands that can output to stdout
[[inputs.exec]]
  ## Commands array
  commands = [
    "/home/amit/telegraf/import.sh"
  ]

  ## Timeout for each command to complete.
  timeout = "60s"

  ## measurement name suffix (for separating different commands)
  # name_suffix = ""

  data_format = "influx"

 # Measurement name
  name_override = "oozie"

System info:

[Include Telegraf version, operating system name, and other relevant details]

Steps to reproduce:

1. /create a script to output below line:

ooziecoord,coordJobName=AMI\\ CPAT\\ Omniture\\ Validation\\ Coordinator,status=SUCCEEDED coordJobName="AMI\\ CPAT\\ Omniture\\ Validation\\ Coordinator",status="SUCCEEDED",nextMaterializedTimeInMillis=1529874000000,dateStartTimeInMillis=1529640000000,dateEndTimeInMillis=1529812800000 1529874000000000000

2. configure telegraf as per the config given above

Expected behavior:

data gets imported in _influxdb

Actual behavior:

An Error is thrown:

Error in plugin [inputs.exec]: metric parse error: expected field at offset 26934:

Additional info:

data can be imported successfully using infludbDB cli import command:

step 1. create a data file (datarrr.txt) with the following lines:

# DDL
CREATE DATABASE _influxdb
# DML
# CONTEXT-DATABASE: _influxdb

ooziecoord,coordJobName=AMI\\ CPAT\\ Omniture\\ Validation\\ Coordinator,status=SUCCEEDED coordJobName="AMI\\ CPAT\\ Omniture\\ Validation\\ Coordinator",status="SUCCEEDED",nextMaterializedTimeInMillis=1529874000000,dateStartTimeInMillis=1529640000000,dateEndTimeInMillis=1529812800000 1529874000000000000

Step 2 - run command

influx -import -path=datarrr.txt -precision=ns

Step 3 - Verify data is present in _influxdb

[danielnelson]

Thanks for the report, assuming you don't want the tag value to have backslashes in it, you can use a single backslash:

coordJobName=AMI\ CPAT\ Omniture\ Validation\ Coordinator

I suggest moving to this style even when this bug is fixed.

[danielnelson]

Also need to take a look at the production of line protocol with this escaping:

acc.AddFields("test", map[string]interface{}{"value": int64(42)}, map[string]string{"id": `PS\ Old\ Gen`})