Cannot write using line protocol in UI

fab · September 7, 2020, 10:31am

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
Fab

fab · September 7, 2020, 10:33am

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

fab · September 7, 2020, 10:34am

And these are the tokens

fab · September 8, 2020, 11:12am

Any help from anybody?

michael · September 8, 2020, 5:53pm

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.

fab · September 9, 2020, 8:37am

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"}

ahannula · October 21, 2020, 7:21am

Any solutions on this problem? I’ve got RC1 and Python API writes give no error. Still no data is written by correct tokens to either local DB nor to the Cloud. Cannot figure out what’s wrong as the code should be ok, tokens are ok, no errors given by the writes etc…

fab · October 21, 2020, 8:46am

@ahannula I’m afraid I did not manage to get it running

ahannula · October 22, 2020, 1:04pm

Just to check, I installed a new fresh Influx RC0 on Ubuntu 20. Still has the same problem. Tokens are correct, Python client gives no error (ie. “wrote ok”) but influxd says “info, Unauthorized, error, session not found”. No idea what this refers to? It almost like refers to some missing authorization token/setup somewhere else than in the query (but there is no documentation for that…!)

Anybody having an idea, anybody actually has this working?

Anaisdg · December 3, 2020, 6:41pm

Hello @ahannula and @fab,
Out of curiosity have you tried the same with an all access token? Can you please try that? Also can you please create an issue for the python client(@ahannula) and influxdb(@fab) respectively?

dianaelias · October 14, 2021, 6:45am

Hello,
one year later - i have the same problem. Was there a solution @ahannula @fab ?
I would like to write datapoints to Influx, but i got the same issues like above. I tried it with an all access token and i’m workin on Windows.

Topic		Replies	Views
Line protocol write problem InfluxDB 2	5	439	October 13, 2021
No Data in UI After Python Script Write InfluxDB 2 python , docker	2	339	January 10, 2024
Line protocol broken in Web UI and API	1	187	October 24, 2023
Influxdb writing issue for python using UDP	0	913	October 19, 2018
Understanding the concept InfluxDB 2 influxdb	2	690	January 5, 2021

Cannot write using line protocol in UI

Related topics