I'm using GreenDAO for database handling in Android. When performing many database changes (> 15.000) I get this error Message:
The connection pool for database '/data/data/...' has been unable to grant a connection to thread 312 (Thread-312) with flags 0x1 for 30.000002 seconds.
Everything gets stuck. Why does this error happen?
I got this message when creating too many connections to SQLite via DBFlow FlowQueryList . My solution was to make sure that once you were done with the query list to call endTransactionAndNotify() and then close() on the querylist.
Calling endTransactionAndNotify() alone did not do the trick.
I hope this helps, this thread certainly helped me.
