Cannot write using line protocol in UI

Hi,

I’m new to InfluxDB but I have experienced its potential in the past. For this reason I’m trying to prototype for my organization a simple solution to show what we can do.
Unfortunately I seem to have issues in performing teh simplest steps like writing and reading back data. Can you please advise?

I resorted to using the UI to keep my prototype as simple as possible.
I write data using the UI and it all looks OK

However if I try to read I can’t find my data…

the log output shows some issues:
2020-09-07T10:21:30.877058Z info Unauthorized {"log_id": "0P5~6eBl000", "error": "token required"}

But I’m not able to understand if this is the problem as I believe I have everything configured correctly in the UI

Thanks in advance for your help :slight_smile:
Fab

This is what I’m trying to write.

mem,host=host1 used_percent=64.23 1577836800000000000
mem,host=host2 used_percent=72.01 1577836800000000000
mem,host=host1 used_percent=62.61 1577836810000000000
mem,host=host2 used_percent=72.98 1577836810000000000
mem,host=host1 used_percent=63.4 1577836820000000000
mem,host=host2 used_percent=73.77 1577836820000000000

Capture_writeok

And these are the tokens

Any help from anybody? :pray:t2:

Hey @fab what version of OSS are you using? Also, can you walk me through each of the steps that you’ve taken. I’d like to try to reproduce this locally and I’m having a hard time following the sequence of steps.

Thanks @michael
This is the version:

[fbs]  > influxd version
InfluxDB 2.0.0-beta.16 (git: 50964d732c) build_date: 2020-08-07T20:18:07Z

These are the steps:

  • Load Data -> buckets
  • Add Data in the bucket I chose
  • Line Protocol
  • Add data Using Line Protocol -> enter manually
  • I copy in the window the data I showed-> click on Write data
  • Data Explorer -> select the bucket I have just written
  • At this point I do not see any data

This is the log from the server

[fbs] > influxd --reporting-disabled
2020-09-09T08:23:28.449369Z	info	Welcome to InfluxDB	{"log_id": "0P8VFDlG000", "version": "2.0.0-beta.16", "commit": "50964d732c", "build_date": "2020-08-07T20:18:07Z"}
2020-09-09T08:23:28.514090Z	info	Resources opened	{"log_id": "0P8VFDlG000", "service": "bolt", "path": "/user/fbs/.influxdbv2/influxd.bolt"}
2020-09-09T08:23:28.525625Z	info	Opening Series File (start)	{"log_id": "0P8VFDlG000", "service": "storage-engine", "service": "series-file", "op_name": "series_file_open", "path": "/user/fbs/.influxdbv2/engine/_series", "op_event": "start"}
2020-09-09T08:23:28.554315Z	info	Opening Series File (end)	{"log_id": "0P8VFDlG000", "service": "storage-engine", "service": "series-file", "op_name": "series_file_open", "path": "/user/fbs/.influxdbv2/engine/_series", "op_event": "end", "op_elapsed": "28.700ms"}
2020-09-09T08:23:28.561358Z	info	Index opened	{"log_id": "0P8VFDlG000", "service": "storage-engine", "index": "tsi", "partitions": 8}
2020-09-09T08:23:28.571928Z	info	Opened file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/user/fbs/.influxdbv2/engine/data/000000000000008-000000002.tsm", "id": 0, "duration": "0.226ms"}
2020-09-09T08:23:28.572197Z	info	Opened file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/user/fbs/.influxdbv2/engine/data/000000000000018-000000002.tsm", "id": 1, "duration": "0.111ms"}
2020-09-09T08:23:28.573023Z	info	Opened file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/user/fbs/.influxdbv2/engine/data/000000000000021-000000001.tsm", "id": 3, "duration": "0.106ms"}
2020-09-09T08:23:28.573375Z	info	Opened file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/user/fbs/.influxdbv2/engine/data/000000000000022-000000001.tsm", "id": 4, "duration": "0.105ms"}
2020-09-09T08:23:28.580944Z	info	Opened file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/user/fbs/.influxdbv2/engine/data/000000000000020-000000001.tsm", "id": 2, "duration": "8.470ms"}
2020-09-09T08:23:28.581809Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00103.wal", "size": 110}
2020-09-09T08:23:28.582968Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00104.wal", "size": 110}
2020-09-09T08:23:28.583992Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00105.wal", "size": 110}
2020-09-09T08:23:28.584720Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00106.wal", "size": 110}
2020-09-09T08:23:28.585443Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00107.wal", "size": 110}
2020-09-09T08:23:28.586234Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00108.wal", "size": 110}
2020-09-09T08:23:28.587031Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00109.wal", "size": 110}
2020-09-09T08:23:28.587882Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00110.wal", "size": 110}
2020-09-09T08:23:28.588757Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00111.wal", "size": 110}
2020-09-09T08:23:28.589463Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00112.wal", "size": 110}
2020-09-09T08:23:28.590208Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00113.wal", "size": 110}
2020-09-09T08:23:28.590899Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00114.wal", "size": 110}
2020-09-09T08:23:28.591759Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00115.wal", "size": 110}
2020-09-09T08:23:28.592476Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00116.wal", "size": 110}
2020-09-09T08:23:28.593226Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00117.wal", "size": 110}
2020-09-09T08:23:28.593960Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00118.wal", "size": 110}
2020-09-09T08:23:28.594936Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00119.wal", "size": 110}
2020-09-09T08:23:28.595674Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00120.wal", "size": 110}
2020-09-09T08:23:28.596146Z	info	Reading file	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal/_00121.wal", "size": 110}
2020-09-09T08:23:28.596428Z	info	Reloaded WAL	{"log_id": "0P8VFDlG000", "service": "storage-engine", "path": "/user/fbs/.influxdbv2/engine/wal", "duration": "15.343ms"}
2020-09-09T08:23:28.596474Z	info	Starting	{"log_id": "0P8VFDlG000", "service": "storage-engine", "component": "retention_enforcer", "check_interval": "1h"}
2020-09-09T08:23:28.596851Z	info	Starting query controller	{"log_id": "0P8VFDlG000", "service": "storage-reads", "concurrency_quota": 10, "initial_memory_bytes_quota_per_query": 9223372036854775807, "memory_bytes_quota_per_query": 9223372036854775807, "max_memory_bytes": 0, "queue_size": 10}
2020-09-09T08:23:28.890185Z	info	Listening	{"log_id": "0P8VFDlG000", "transport": "http", "addr": ":9999", "port": 9999}
2020-09-09T08:23:54.829407Z	info	Unauthorized	{"log_id": "0P8VFDlG000", "error": "session not found"}
2020-09-09T08:24:09.029960Z	error	api error encountered	{"log_id": "0P8VFDlG000", "handler": "session", "error": "unauthorized access"}
2020-09-09T08:24:41.565001Z	info	Unauthorized	{"log_id": "0P8VFDlG000", "error": "token required"}
2020-09-09T08:28:53.983581Z	info	Unauthorized	{"log_id": "0P8VFDlG000", "error": "token required"}
2020-09-09T08:28:56.908058Z	info	Unauthorized	{"log_id": "0P8VFDlG000", "error": "token required"}
^C2020-09-09T08:32:52.685794Z	info	Stopping	{"log_id": "0P8VFDlG000", "service": "scraper"}
2020-09-09T08:32:52.685992Z	info	Stopping	{"log_id": "0P8VFDlG000", "service": "task"}
2020-09-09T08:32:52.686107Z	info	Stopping	{"log_id": "0P8VFDlG000"}
2020-09-09T08:32:52.686156Z	info	Stopping	{"log_id": "0P8VFDlG000", "service": "nats"}
2020-09-09T08:32:52.686569Z	info	Stopping	{"log_id": "0P8VFDlG000", "service": "bolt"}
2020-09-09T08:32:52.687873Z	info	Stopping	{"log_id": "0P8VFDlG000", "service": "query"}
2020-09-09T08:32:52.687895Z	info	Stopping	{"log_id": "0P8VFDlG000", "service": "storage-engine"}
2020-09-09T08:32:52.687924Z	info	Stopping	{"log_id": "0P8VFDlG000", "service": "storage-engine", "component": "retention_enforcer", "check_interval": "1h"}