write doesn't work when the db starts with a lowercase letter

[ronytigo]

when I call :8086/query?q=show databases

I get only the databases that start with a capital letter.

[offa]

Please provide more information to reproduce the issue.

[ronytigo]

It happens on 2 different machines, but doesn't happen on 2 others, so I'm not sure how to make sure it's reproduced.
The code I'm running is the code from the example:

auto influxdb = influxdb::InfluxDBFactory::Get("http://localhost:8086?db=test");
influxdb->write(influxdb::Point{"test"}
  .addField("value", 10)
  .addTag("host", "localhost")
);

if I use Test instead of test, it works (I have both test and Test buckets)

[offa]

(I have both test and Test buckets)

Using two names that only differ in case sound's a bit risky.

It happens on 2 different machines, but doesn't happen on 2 others, so I'm not sure how to make sure it's reproduced.

Do these running the same OS?

[ronytigo]

It happens also if I use different names.
I use the same docker-compose file.
For the host, It works OK on this one:

NAME="Ubuntu"
VERSION="20.04.4 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.4 LTS"
VERSION_ID="20.04"

Doesn't work on this one:

NAME="Ubuntu"
VERSION="20.04.5 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.5 LTS"
VERSION_ID="20.04"

[offa]

Do they run the same influxdb version?

[ronytigo]

Yes, all machines use the docker image.
InfluxDB v2.4.0 (git: de247bab08) build_date: 2022-08-18T19:41:15Z

[offa]

Can you reproduce the issue with plain curl requests?

[ronytigo]

I'll check how I can add a bucket using the api.

[ronytigo]

@offa

curl --location '<ip>:8086/api/v2/buckets' \
--header 'Authorization: Token <token>' \
--header 'Content-Type: text/plain' \
--data '{
  "description": "abcd bucket",
  "name": "abcd",
  "orgID": "<orgID>",
  "retentionRules": [
  ],
  "rp": "0",
  "schemaType": "implicit"
}'

and

curl --location '<ip>:8086/api/v2/buckets' \
--header 'Authorization: Token <token>' \
--header 'Content-Type: text/plain' \
--data '{
  "description": "Abucket",
  "name": "A",
  "orgID": "<orgID>",
  "retentionRules": [
  ],
  "rp": "0",
  "schemaType": "implicit"
}'

and

curl --location '<ip>:8086/query?q=show%20databases' \
--header 'Authorization: Token <token>' \
--header 'Content-Type: text/plain' \
--data '{{body}}'

[offa]

What's the result of those? Were you able to reproduce the issue?

[ronytigo]

Yes, the buckets are created and only A is returned from /query?q=show databases.

[offa]

Wired …

If I understand aright, you do get the same behaviour with plain curl calls?

influxdb->execute(…) returns the response unchanged and eventually boils down to calling libcurl. You may have a look at the raw response (here).

[ronytigo]

Why should I look here if the problem occurs when I use plain curl calls? I already see a wrong response.