I’ve been using influxdb for about 2 years now and as I get deeper into it, I’m getting really frustrated. As a user that has been collecting data for some time, I now need to look at how to manage all that data because just magically increasing storage capacity isn’t always the solution. Do I look at downsampling or deletion or …
This has led me down the path of looking at how to down sample data and after running into some problems, looking at the open issues. There’s a shocking trail of broken behaviour that has me questioning about whether my choice to use influxdb was sound.
Problems that keep popping up in issues:
- drop measurements don’t disappear. sometimes they do, better odds if you restart influxdb. There’s a constant “try the latest version” as if that will have some magic, without any hint from those suggesting that about why the latest version should be better.
- deleting of data may or may not work, even when the query matches times in the database.
- doing a select usually results in correct data being returned but sometimes it does not - it depends on how many influxdb specials are used with it. Using “select into” seems to be a subscription for random behaviour. Then there are problems with the use of fill() that are long standing and unresolved.
These are all fundamental database operations and they do not function with 100% reliability. If mysql was this unreliable people would abandon it in droves for postgres (or at least face massive market suspicion).
The only database operation that seems to work with any amount of reliability is INSERT.
Of course, I’m using it for free, so what should I expect? A product that works well enough that makes me want to buy support for it and convince management that it is worth money. Afterall, that is what they’re selling - that plus the cluster/cloud service.
Let me rephrase that, they’re attempting to sell a database that has bugs opened against it that demonstrate a failure to pass basic database functionality.
But flux. I don’t really care about flux if long standing bugs aren’t fixed - and closing them with a “stale” bot isn’t the answer, that’s just sweeping the dirt under the carpet and hoping nobody goes looking.
Do I jump ship and if so where to? Or stick around and hope that someone can find all the holes to stop the ship sinking?