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? -- 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+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/h2-database/40cdc947-e392-496b-a594-ab85e1756a6fn%40googlegroups.com.
