Show measurements give no result

InfluxDB 2
1

Hello,

I upgrade my database from InfluxDB 1.8 to 2.6.

When I execute from influxShell :

  • show databases ==> OK, I show all my databases
  • show measurements ==> KO : I have no results
  • show series ==> OK : I show all my series

So, when I execute my select * from table, I have my raws.

If I start InfluxDB with the 1.8 version, show measurements is OK.

Below the procedure I used to migrate my data :
[ Manually upgrade from InfluxDB 1.x to 2.6 | InfluxDB OSS 2.6 Documentation (influxdata.com)

Does somebody have an idea or meet the same issue ?

2

Hello @Grafone,
I’m sorry I’m confused what is your problem?
It sounds like you’re returning your data?

3

INTERNAL & PARTNERS

Hello Anaisdg,

Thank you first for your email and taking time on my issue.

I’m going to explain you more clearly my problem.

I had a 1.8 database version and I uprgrade it into 2.6 version (using Manually upgrade documentation Manually upgrade from InfluxDB 1.x to 2.6 | InfluxDB OSS 2.6 Documentation (influxdata.com)https://docs.influxdata.com/influxdb/v2.6/upgrade/v1-to-v2/manual-upgrade/#token-authentication

As my data are only located in one directory, I suppose that when I start my instance in 1.8 or in 2.6, it points to the same data.

  1. So, when I start my instance into 1.8 version and I execute influx.exe v1 shell, I show all my databases :

[//cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex015/uploads/influxdata/original/2X/a/a10fec6df0cd7835e4822621c19991b91cad0fa4.png]

Connected to one of them and executing SHOW MEASUREMENTS, I see all my measures

[//cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex015/uploads/influxdata/original/2X/4/4ee023cb6740202bd44ef602b7116535f42b80b2.png]
[//cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex015/uploads/influxdata/original/2X/6/6404f196c691aa91dca955bfa1cf1dac5a543b73.png]

  1. When I do the same things when I start my Instance into 2.6 version, I see all my databases but not the measurements :

[//cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex015/uploads/influxdata/original/2X/f/f73dcb1cb666c0062a7f6da93348799deaae4d1d.png]

[//cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex015/uploads/influxdata/original/2X/d/de2a937b2ea9d19cebae5ee8f1d7efb9a2f27e29.png]

However, I have data as my Show Series works :

[//cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex015/uploads/influxdata/original/2X/6/60d543b04b3e15af21ae1af8894f63c8b74f2f8d.png]

It is strange no ?