I’ve got a weird one…
I have a small database on a local install of InfluxDB v1, less than 50 MB on disk.
But I can’t delete data. The query just hangs “forever”. (“Forever” being at least a week before I killed the processes that were piling up.)
My code does a delete from ... where multiple times a day and that hangs. If I go in with a blunt drop measurement that also hangs. This is not the first time this has happened, the last time a drop / create database did fix it, but apparently it comes back…
I don’t see any log activity to suggest anything is amiss, I don’t see anything odd in terms of cpu or memory usage or whatever while this is going on, the permissions on the data dir seem fine too. The query just hangs.
This was on a running 1.12.4 instance, on ubuntu 24.04. I tried updating influxdb to 1.13 just now, and now it works fine. Stupid in hindsight as now I don’t know whether it’s the reboot or the upgrade that fixed it.
Does anyone have any idea what’s going on?
Note: My username is ‘influxdata1’ because apparently this forum has a hard unchangeable link between your email address localpart and your username, and I use specific localparts for specific sites. I have nothing to do with InfluxData other than using their products. ![]()
