Database Is Locked

[asanchez128]

I use Monkey Cache to get data for two fragments that are displayed on a tab layout with a viewpager. Both fragments are loaded at the same time even though only one is visible at any given time. However, I get a "Database Is Locked" error in Crashlytics.

I quick workaround that came to mind was to just load one fragment at a time. However, both fragments have to be loaded for the sake of showing a sliding animation.

Perhaps using a singleton with locking for accessing Monkey Cache could also alleviate the problem.

Thank you for your help.

[jamesmontemagno]

Which monkey cache are you using? Sqlite? You could use a lock around your own access to it, however I do lock on most implemenations.

[asanchez128]

Thank you @jamesmontemagno for your reply. Yes, I'm using the Sqlite implementation. I ended up writing code to access the MonkeyCache just when the the property UserVisibleHint in the fragment is set to true.

public override bool UserVisibleHint
        {
            get { return base.UserVisibleHint; }
            set
            {
                base.UserVisibleHint = value;
                if (UserVisibleHint)
                {
                   // call MonkeyCache
                }
            }
        }

Thanks a lot for MonkeyCache!

[jamesmontemagno]

Do you have a sample before of what was causing issues?