Hi,

 

I have a question regarding growing an LMDB database when a write transaction hits MDB_MAP_FULL.

I would like to avoid defining a high mapsize value because my application will contain many MDB_envs, and because I have Windows users (Windows allocates the whole file on the disk).

 

Based on the intuition that MDB_MAP_FULL should not leave the database in a weird state, I have made the following little experiment. When MDB_MAP_FULL is encountered I tried to:

·         copy the current env (mdb_env_copy) into another directory (fine: it does not seem to contain uncommited data)

·         reset the transaction « error  bit » (modified LMDB code to introduce a « txn->mt_flags &= ~MDB_TXN_ERROR » somewhere)

·         commit the transaction

·         close the database

·         close the env

·         reopen it with a higher mapsize value

·         reopen the database

·         create another transaction

·         continue writing

… and it seems to be working pretty well.

 

Assuming I am ready to « relax » some of the ACID requirements, does it sound reasonable to think that MDB_MAP_FULL does not leave LMDB is a weird state? And that the « trick » described above should always be working? By « working » I mean: the copied environment will never contain uncommitted data (so I can rely on it to implement a kind of rollback), the reopened environment will always be valid and contain the expected data (data written before hitting MDB_MAP_FULL)?

 

Thanks in advance for any insight,

Best regards,

 

Bruno.