https://questdb.io logo
Title
f

Franco Almonacid

03/13/2023, 2:17 PM
Hi everyone! We upgraded to version
7.0.1
and converted our tables to WAL tables. Before that we could query the inserted data almost immediately but after changing to WAL tables we have to wait several minutes to see the data, similar to having a high commit lag. The only way we found to fix this is going back to non-WAL tables, is there something else we can do?
i

Imre

03/13/2023, 2:22 PM
hi @Franco Almonacid, there is a fix for the problem already. currently being reviewed, and will be included in the next release. https://github.com/questdb/questdb/pull/3063
f

Franco Almonacid

03/13/2023, 2:23 PM
thanks @Imre
a

Andy Beyer

03/13/2023, 3:04 PM
ah OK nice. as mentioned in a previous thread, I worked around the same issue by closing my writers (Java ILP Senders) often and recreating them, which seems to force a flush much more frequently
r

Roj Codeur

03/14/2023, 6:05 AM
I faced the same issue. Also, if I truncate the table, the effects are not visible instantly anymore