https://questdb.io logo
Title
k

Kurt

05/24/2023, 1:48 AM
hey, our logs are being spammed with the following message:
2023-05-24T01:47:03.069975Z I i.q.c.TableReader open partition /var/lib/questdb/db/interval_data~5/2020-03-22.15916 [rowCount=1900527, partitionNameTxn=15916, transientRowCount=234441, partitionIndex=81, partitionCount=366]
this is after the database has been restarted. nothing is currently querying the database, but it was occurring before the database shut down when we were querying it. is this normal?
it appears to be running the O3PartitionPurgeJob
b

Bolek Ziobrowski

05/24/2023, 7:38 AM
Hi Kurt. It could be e.g. WAL job applying updates .
k

Kurt

05/24/2023, 7:40 AM
yeah you're right. just a lot of updates to work through.
b

Bolek Ziobrowski

05/24/2023, 7:42 AM
Keep in mind that updates create copies of affected partitions so they could be slow to apply, especially if there's many single-row updates .