When I enable the flask-profiler, the app crashes when files from the <code class="not

The problem here is with a shared sqlite3 cursor. <div class="Bo

Flask crashes when static files are served (ProgrammingError: Recursive use of cursors not allowed) about flask-profiler HOT 7 CLOSED

muatik commented on May 24, 2024 1

Flask crashes when static files are served (ProgrammingError: Recursive use of cursors not allowed)

from flask-profiler.

Comments (7)

AbdealiLoKo commented on May 24, 2024 6

FWIW, I was using flask-profiler 1.7 all this while and didnt face an issue for a year. I just moved to 1.8.1 and am seeing it multiple times.

from flask-profiler.

ssharma94 commented on May 24, 2024

Hi nlohmann,
I am facing the same issue. Did you get to resolve the issue?

Thanks
Subhash

from flask-profiler.

nlohmann commented on May 24, 2024

We could not resolve the issue and decided to stop using Flask Profiler.

from flask-profiler.

ssharma94 commented on May 24, 2024

Oh I am putting a fix and let you know if it works. However, did you get any other open source project to do the same.

from flask-profiler.

nlohmann commented on May 24, 2024

No, we implemented some profiling ourselves. Nothing fancy, and a plugin like this would be appreciated.

from flask-profiler.

ragingra commented on May 24, 2024

Was a solution for this problem found? I'm getting something very similar and cant figure it out.

Traceback (most recent call last):
    File "\lib\site-packages\flask\app.py", line 1997, in __call__
        return self.wsgi_app(environ, start_response)
    File "\lib\site-packages\flask\app.py", line 1985, in wsgi_app
        response = self.handle_exception(e)
    File "\lib\site-packages\flask\app.py", line 1540, in handle_exception
        reraise(exc_type, exc_value, tb)
    File "\lib\site-packages\flask\app.py", line 1982, in wsgi_app
        response = self.full_dispatch_request()
    File "\lib\site-packages\flask\app.py", line 1614, in full_dispatch_request
        rv = self.handle_user_exception(e)
    File "\lib\site-packages\flask\app.py", line 1517, in handle_user_exception
        reraise(exc_type, exc_value, tb)
    File "\lib\site-packages\flask\app.py", line 1612, in full_dispatch_request
        rv = self.dispatch_request()
    File "\lib\site-packages\flask\app.py", line 1598, in dispatch_request
        return self.view_functions[rule.endpoint](**req.view_args)
    File "\lib\site-packages\flask_httpauth.py", line 93, in decorated
        return f(*args, **kwargs)
    File "\lib\site-packages\flask_profiler\flask_profiler.py", line 212, in getRequestsTimeseries
        return jsonify({"series": collection.getTimeseries(args)})
    File "\lib\site-packages\flask_profiler\storage\sqlite.py", line 158, in getTimeseries
        self.cursor.execute(sql)
ProgrammingError: Recursive use of cursors not allowed.

from flask-profiler.

iurisilvio commented on May 24, 2024

The problem here is with a shared sqlite3 cursor.

flask-profiler/flask_profiler/storage/sqlite.py

Line 33 in b9d4b7a

self.cursor = self.connection.cursor()

https://stackoverflow.com/questions/26629080/python-and-sqlite3-programmingerror-recursive-use-of-cursors-not-allowed

If this is the reason, using another storage will fix the problem.

from flask-profiler.

Flask crashes when static files are served (ProgrammingError: Recursive use of cursors not allowed) about flask-profiler HOT 7 CLOSED

Comments (7)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent