After migrating data, I get different record counts between ForestDB and SQLite

[Brendan Duddridge]

Hi,

I'm having an issue where I get a different number of rows in my database depending on whether I'm using ForestDB or SQLite as the storageType.

I have code which migrates my old database over to Couchbase and in one of my forms, with ForestDB, I'm getting 789 records, but in SQLite I'm getting the full 11,040 records as expected. The SQLite version is correct. The ForestDB version is incorrect.

I did notice in the log this message appearing:

00:27:50.218| WARNING: Unexpected CBForest exception iterating query

There's nothing other than that in the log from Couchbase.

My progress indicator says that I am importing all 11040 records, but after I open my database file after the migration completes, I only see the 789.

This is on OS X 10.11 Beta (15A263e)

I realize this isn't much information to go on and I'd be happy to send both the SQLite and ForestDB versions of the files to someone to examine if that would help diagnose this issue. But it definitely makes me not want to use ForestDB for my app at the moment.

Thanks,

Brendan

[Jens Alfke]

Yikes, that’s not good. Please file an issue and we’ll get to the bottom of it. (Make sure to state which version or commit of CBL you’re using.)

—Jens

[Brendan Duddridge]

Ok, I've posted an issue on Github:

https://github.com/couchbase/couchbase-lite-ios/issues/899

Thanks,

Brendan