Only ILP Apply Worker has 100% CPU and there are no special errors or messages in Quest DB Log or System Log. When this symptom occurs, Insert no longer proceeds and data is lost.
Hi @allen ,
How are you submitting data? High CPU usage is usually caused by lots of small, often out-of-order, commits.
Your table can become suspended. However, successful inserts should not result in data loss. If you are using ILP/HTTP, you should receive an error when trying to submit, if the data has not been committed.
To see the ‘lost’ data, you may need to unsuspend your table: ALTER TABLE RESUME WAL | QuestDB
1 Like