Code Monkey home page Code Monkey logo

Comments (3)

FSX avatar FSX commented on May 28, 2024

I was even able to get the same error by bashing the F5 button. I think this is because of the connection pool cleaner. When I set the cleanup timeout on 0, disabling it, I didn't get any errors.

I'll have to check the connection spawning and cleaning.

from momoko.

FSX avatar FSX commented on May 28, 2024

I found what triggers the exceptions.

You create a Momoko object in each request handler:

    @property
    def db(self):
        if not self._db:
            # Setup the db connection when first accessed instead of at
            # initialization so that each child process gets its own
            # connection.
            self._db = Momoko({
                'host': 'localhost',
                'database': 'media_archive',
                'user': 'ma_db_user',
                'password': 'password',
                'min_conn': 5,
                'max_conn': 20,
                'cleanup_timeout': 5
            })
        return self._db

I think it's because a new Momoko object is created when a new RequestHandler object is created. That means at each request a new Momoko object is created (I think). Your code also triggers the cleanup function a lot. When I refresh the page 5 times, the cleanup function is triggered +5 times.

In my example code it creates a Momoko object per application (per process):

    @property
    def db(self):
        if not hasattr(self.application, 'db'):
            self.application.db = Momoko({
                'host': 'localhost',
                'database': 'media_archive',
                'user': 'ma_db_user',
                'password': 'password',
                'min_conn': 5,
                'max_conn': 20,
                'cleanup_timeout': 10
            })
        return self.application.db

I used siege to test it.

siege -b -c 5 -t30s http://localhost:8888/

from momoko.

clofresh avatar clofresh commented on May 28, 2024

Ohhh, great, thanks.

from momoko.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.