sqlite3.OperationalError: database is locked about flask-profiler HOT 9 OPEN

@muatik I will try to replicate and fix it and submit a PR, i need this fix asap

from flask-profiler.

We've had this issue as well here.

from flask-profiler.

@teleyinex Can you switch to using sqlalchemy configurations? https://github.com/muatik/flask-profiler#sqlachemy

from flask-profiler.

That doesn't work either. Interestingly I get an SSL EOF error from psycopg2. Our solution has been to use MongoDB for now. I guess the main issue, is that flask_profile issues too many writes, and sqlite locks itself. Maybe changing the sampling could fix this?

from flask-profiler.

yes, you can reduce the sampling ratio via configuration too. but it will not be a permanent solution anyway.

from flask-profiler.

Yep. I don't know, the issue is that we're using them in production, and that's why we cannot debug it unless we write some load testing for the dev server. With sqlite I can imagine the issue is that, while with SQLAlchemy I'm not sure. We'll keep an eye on it in any case ;-)

from flask-profiler.

Same issue here. How do you recover?

from flask-profiler.

@aardvark82 you can use another db vendor via SQLAlchemy integration. check out README.md page for more information.

from flask-profiler.

Same issue here. SQLAlchemy docs seem to say that SQLite3 database locking could be even worse when using SQLAlchemy rather than using the native SQLite3 connector: https://docs.sqlalchemy.org/en/14/dialects/sqlite.html#database-locking-behavior-concurrency.

from flask-profiler.