Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Column Limit issue #575

Closed
MatinF opened this issue May 11, 2023 · 1 comment
Closed

Column Limit issue #575

MatinF opened this issue May 11, 2023 · 1 comment
Labels
bug Something isn't working

Comments

@MatinF
Copy link

MatinF commented May 11, 2023

Specifications

Writing pandas dataframe to InfluxDB Cloud 2.0 with Python client

Code sample to reproduce problem

Using below repository:
https://github.com/CSS-Electronics/canedge-influxdb-writer

Expected behavior

Expected all data to be written to InfluxDB. This works with our older accounts created about a year ago, but not on newly created accounts.

Actual behavior

We get below error when trying to write data. The issue seems to be that we're trying to add more than 200 unique signals (i.e. fields) for the same measurement - and apparently that is not possible in newer versions of the cloud?

Reason: Bad Request
HTTP response headers: HTTPHeaderDict({'Date': 'Tue, 09 May 2023 09:01:43 GMT', 'Content-Type': 'application/json', 'Content-Length': '216', 'Connection': 'keep-alive', 'trace-id': 'a5e2abe810cb6c3f', 'trace-sampled': 'false', 'Strict-Transport-Security': 'max-age=15724800; includeSubDomains', 'X-Influxdb-Request-ID': '3402a4e1bf06f25e3e0b3d6523c10cde', 'X-Influxdb-Build': 'Cloud'})
HTTP response body: {"code":"invalid","message":"dml handler error: service limit reached: couldn't create columns in table E7DEAEE7; table contains 199 existing columns, applying this write would result in 267 columns, limit is 200"}

Additional info

No response

@MatinF MatinF added the bug Something isn't working label May 11, 2023
@powersj
Copy link
Contributor

powersj commented May 21, 2024

Expected all data to be written to InfluxDB. This works with our older accounts created about a year ago, but not on newly created accounts.

Sorry no one ever commented on this. Newer accounts are using InfluxDB IOX-backed are limited to 200 columns.

This isn't really an issue with the client libraries, so I am closing this.

@powersj powersj closed this as not planned Won't fix, can't repro, duplicate, stale May 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants