[h2] In-Memory H2 deleted rows not garbage collected.

2023-05-20 Thread Arjun Sahoo
Hi, I am using Spring boot In-Memory H2DB. I am storing latest 100k records in the database, so keep on deleting old records and inserting new records. Application runs fine for 4-5 hours, after that it throws OOM Exception. The memory consumption keeps on increasing even after deleting old re

Re: [h2] In-Memory H2 deleted rows not garbage collected.

2023-05-20 Thread Noel Grandin
check that all your transactions are being closed. Holding a transaction open means that the storage cannot be freed. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an

Re: [h2] In-Memory H2 deleted rows not garbage collected.

2023-05-20 Thread Arjun Sahoo
I am using spring data jpa to delete the records. @Modifying @Transactional @Query(value = "delete from table where start_time_ms <= :startTimeMs", nativeQuery = true) Integer deleteInBulkByStartTime(@Param("startTimeMs") Long startTimeMs) throws SQLException; Spring takes care of managing the