timescale / outflux

Export data from InfluxDB to TimescaleDB
Apache License 2.0
86 stars 22 forks source link

Error fetching fields when GUIDs are involved #82

Open mufflon opened 3 years ago

mufflon commented 3 years ago

We have issues running outflux with our current database structure. We have a large number of measurements where each are named using a unique GUID (example "015fab01-477f-40a1-99fa-cd020b7e8bf5") and where each measurement contain a single tag column containing guids (unique for each time series. Typically somewhere between 1 and 50 per measurement) (example '015fab01-477f-40a1-99fa-cd020b7e8bf5', though not the same as the measurement). Finally a field column named "value".

The output from outflux is field keys query returned unexpected result. no values returned for measure '01111498-68f7-4512-86fe-2de98a8d67bf' 2020/08/24 15:05:50 Will ignore measurement '0120704f-ddc2-488f-84cf-86ee9b5abe96' because: error fetching fields for measurement '0120704f-ddc2-488f-84cf-86ee9b5abe96'

And as it only says "unexpected result" we have issues diagnosing it further