Anyone have suggestions?
95 views
Skip to first unread message
Rinse Lemstra
Apr 15, 2025, 7:02:57 AMApr 15
to H2 Database
Anyone have suggestions?
In an environment with approximately 1,000 databases ( .mw.db ) and around 75,000 mutations per week (mostly INSERTs), 2 to 5 records disappear each week. These are always newly added records.
After the INSERT, the records are always immediately queried and confirmed to be present in the database. Yet, after a few minutes, the record turns out to be gone. (As if a ROLLBACK occurred, but we are not using transactions.)
The database is never corrupt, and the logfile also contains no errors.
We added a `CHECKPOINT SYNC` before closing the table, but that had no effect.
Any suggestions?
In an environment with approximately 1,000 databases ( .mw.db ) and around 75,000 mutations per week (mostly INSERTs), 2 to 5 records disappear each week. These are always newly added records.
After the INSERT, the records are always immediately queried and confirmed to be present in the database. Yet, after a few minutes, the record turns out to be gone. (As if a ROLLBACK occurred, but we are not using transactions.)
The database is never corrupt, and the logfile also contains no errors.
We added a `CHECKPOINT SYNC` before closing the table, but that had no effect.
Any suggestions?
Noel Grandin
Apr 20, 2025, 9:04:24 AMApr 20
to h2-da...@googlegroups.com
Normally this happens because someone opens a transaction and then forgets to commit it
Bill
Apr 21, 2025, 2:11:38 AMApr 21
to h2-da...@googlegroups.com
What about an automated job that's doing something, as well as affecting these newly created records?
On Sun, Apr 20, 2025, 9:04 AM Noel Grandin <noelg...@gmail.com> wrote:
Normally this happens because someone opens a transaction and then forgets to commit it
--
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 email to h2-database...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/h2-database/CAFYHVnXfarhGWZMdTRK2MD_V9Wh7iGDBi%2BCajBSpXMEKeNuE%2BQ%40mail.gmail.com.
Rinse Lemstra
Apr 23, 2025, 6:58:31 AMApr 23
to H2 Database
I use a cache size of H2_CACHE_SIZE = 1000000, could that be the reason.
After I run a query over all databases, forcing a DATABASE DEFRAG and DATABASE COMPACT, it is followed with some missing records.
Could this be related?
Rinse
Op zondag 20 april 2025 om 15:04:24 UTC+2 schreef Noel Grandin:
Reply all
Reply to author
Forward
0 new messages