Miranda NG Official Community Forum

Forum for English speaking Miranda NG users => Support/Help => Topic started by: BigMike on 27 05 2019, 13:01:17

Title: Stability of libmdbx
Post by: BigMike on 27 05 2019, 13:01:17
Hi,

libmdbx caused a lot of pain and headache, when it replaced dbx_mmap.
After having lost my database once, I downgraded Miranda and stayed with dbx_mmap until now.

I didn't read about problems with the new database plugin for a long time.
Is it quite stable now? Or did people just get used to the methods of restoring their data after a crash?
Title: Re: Stability of libmdbx
Post by: Vulpix on 27 05 2019, 19:22:29
I think there is some planned effort to migrate to sqlite; so I wouldn't hurry forward with libmdbx just yet.

That said, I have not had any issues for quite a few weeks already, yeah.
Title: Re: Stability of libmdbx
Post by: BigMike on 01 06 2019, 20:19:32
Ok, thank you. Then, I'll wait some more time.
Title: Re: Stability of libmdbx
Post by: Vulpix on 10 06 2019, 06:10:17
It looks like the sqlite fixes / improvements (to get it ready for stable?) are being pushed in, thanks to the effort of sss123. Many new commits happening quite often recently, so I suppose it might be ready soon. As a note, the old sqlite and new (after current rework) sqlite plugin will not be compatible so it is highly recommended that if you are using the old sqlite at the moment, migrate it to libmdbx (make sure to have backups at every step), and then back to sqlite after upgrading miranda.

The time for that has not come yet though, I suspect there will be an official word from the likes of Ghazan or Dartraiden when this is the case.
Title: Re: Stability of libmdbx
Post by: Vulpix on 13 06 2019, 14:44:00
I am now testing sqlite fulltime. Migration of mdbx to sqlite was successful. I lost some events but it was because there was some corruption (which I knew about already) in my mdbx profile. I used json export to reimport the data that was missing.

I'll report back here if I see any issues but so far so good.

The database size is approximately 15-20% larger than mdbx.

EDIT:

Bug: https://github.com/miranda-ng/miranda-ng/issues/1985
Bug: https://github.com/miranda-ng/miranda-ng/issues/1643
Title: Re: Stability of libmdbx
Post by: BigMike on 13 06 2019, 17:52:46
Thank you for doing the tests for me