Re: Defrag?

2021-06-28 Thread Ilya Kasnacheev
Hello! Is it WAL (wal/) that is growing or checkpoint space (db/)? If latter, any specific caches that are growing unbound? If letter, you can try creating a new cache, moving the relevant data to this new cache, switch to using it, and then drop the old cache - should reclaim the space.

Re: Defrag?

2021-06-28 Thread Ryan Trollip
Is this why the native disk storage just keeps growing and does not reduce after we delete from ignite using SQL? We are up to 80GB on disk now on some instances. We implemented a custom archiving feature to move older data out of ignite cache to a PostgresSQL database but when we delete that data

Re: Intermittent Error

2021-06-28 Thread Aleksandr Shapkin
How did you create the cache? Most likely you would like yo use the PUBLIC one, or you should be able to access it using SQL_MYCACHE_TWSources. Here are the docs regarding the schemas creation https://ignite.apache.org/docs/latest/SQL/schemas > On 17 Jun 2021, at 13:28, Ilya Kasnacheev wrote: