MVStore claims to have unsaved changes after calling nitriteDatabase.getCollection(...)

[chris9182]

MVStore claims to have unsaved changes after calling nitriteDatabase.getCollection(...)

[chris9182]

Also, we saw that autoCompact is no longer an option that can be set in MVStoreModule.withConfig() and there is no manual call to compact either anymore. Is this a deliberate decision?

[anidotnet]

At a first glance its look like a config issue in your code. The error message says,

Caused by: org.h2.mvstore.MVStoreException: This store is read-only [2.2.224/2]
...

In the builder, you are setting,

MVStoreModule storeModule = MVStoreModule.withConfig()
        .filePath(databaseLocation)
        .readOnly(readOnly)  <-----
        .build();

I believe, you are opening the db in readonly mode, where no changes to the collection will be saved. That's the reason why you are getting the error.

Regarding autoCompact, it was a deliberate decision, as this MVStore feature is buggy, so I omitted it in the new version.

[chris9182]

I did intentionally open the db in read only mode. Is nitriteDatabase.getCollection() not supported when using read-only mode? How else would I access the data when opening in read-only mode?

[anidotnet]

Ok, I need to check that.

[anidotnet]

@chris9182 the changes are in latest 4.2.1-SNAPSHOT. Please check and report back in case you are still seeing the issue.