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