mysql.connector.errors.DatabaseError: 1040 (HY000): Too many connections // Werkzeug Debugger

DatabaseError

mysql.connector.errors.DatabaseError: 1040 (HY000): Too many connections

Traceback (most recent call last)

File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 354, in `_open_connection`

        if os.name == "nt" and self._auth_plugin_class == "MySQLKerberosAuthPlugin":

            cnx_kwargs["use_kerberos_gssapi"] = True

        try:

            self._cmysql.connect(**cnx_kwargs)

            self._cmysql.converter_str_fallback = self._converter_str_fallback

            if self.converter:

                self.converter.str_fallback = self._converter_str_fallback

        except MySQLInterfaceError as err:

            if hasattr(err, "errno"):

The above exception was the direct cause of the following exception:

File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1536, in `call`

    ) -> cabc.Iterable[bytes]:

        """The WSGI server calls the Flask application object as the

        WSGI application. This calls :meth:`wsgi_app`, which can be

        wrapped to apply middleware.

"""

        return self.wsgi_app(environ, start_response)

File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1514, in `wsgi_app`

            try:

                ctx.push()

                response = self.full_dispatch_request()

            except Exception as e:

                error = e

                response = self.handle_exception(e)

            except:

                error = sys.exc_info()[1]

                raise

            return response(environ, start_response)

        finally:

File "/usr/local/lib/python3.10/site-packages/flask_cors/extension.py", line 176, in `wrapped_function`

        # These error handlers will still respect the behavior of the route

        if options.get("intercept_exceptions", True):

            def _after_request_decorator(f):

                def wrapped_function(*args, **kwargs):

                    return cors_after_request(app.make_response(f(*args, **kwargs)))

                return wrapped_function

            if hasattr(app, "handle_exception"):

                app.handle_exception = _after_request_decorator(app.handle_exception)

File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1511, in `wsgi_app`

        ctx = self.request_context(environ)

        error: BaseException | None = None

        try:

            try:

                ctx.push()

                response = self.full_dispatch_request()

            except Exception as e:

                error = e

                response = self.handle_exception(e)

            except:

                error = sys.exc_info()[1]

File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 919, in `full_dispatch_request`

            request_started.send(self, _async_wrapper=self.ensure_sync)

            rv = self.preprocess_request()

            if rv is None:

                rv = self.dispatch_request()

        except Exception as e:

            rv = self.handle_user_exception(e)

        return self.finalize_request(rv)

    def finalize_request(

        self,

        rv: ft.ResponseReturnValue | HTTPException,

File "/usr/local/lib/python3.10/site-packages/flask_cors/extension.py", line 176, in `wrapped_function`

        # These error handlers will still respect the behavior of the route

        if options.get("intercept_exceptions", True):

            def _after_request_decorator(f):

                def wrapped_function(*args, **kwargs):

                    return cors_after_request(app.make_response(f(*args, **kwargs)))

                return wrapped_function

            if hasattr(app, "handle_exception"):

                app.handle_exception = _after_request_decorator(app.handle_exception)

File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 917, in `full_dispatch_request`

        try:

            request_started.send(self, _async_wrapper=self.ensure_sync)

            rv = self.preprocess_request()

            if rv is None:

                rv = self.dispatch_request()

        except Exception as e:

            rv = self.handle_user_exception(e)

        return self.finalize_request(rv)

    def finalize_request(

File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 902, in `dispatch_request`

            and req.method == "OPTIONS"

):

            return self.make_default_options_response()

        # otherwise dispatch to the handler for that endpoint

        view_args: dict[str, t.Any] = req.view_args  # type: ignore[assignment]

        return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)  # type: ignore[no-any-return]

    def full_dispatch_request(self) -> Response:

        """Dispatches the request and on top of that performs request

        pre and postprocessing as well as HTTP exception catching and

        error handling.

File "/app/app.py", line 435, in `get_channel_vods`

        'oldest': 'v.stream_date ASC',

        'longest': 'v.duration DESC',

    order = order_map.get(sort, 'v.stream_date DESC')

    total_row = db.query_one("""

        SELECT COUNT(*) as total FROM vods v

        LEFT JOIN channels c ON v.channel_id = c.id

        WHERE c.slug = %s

    """, (slug,))

    total = total_row['total'] if total_row else 0

File "/app/db_access.py", line 42, in `query_one`

        finally:

            cursor.close()

            conn.close()

    def query_one(self, sql, params=None):

        conn = self.get_connection()

        cursor = conn.cursor(dictionary=True)

        try:

            if params:

                cursor.execute(sql, params)

            else:

File "/app/db_access.py", line 13, in `get_connection`

        self.user = os.getenv('DB_USER', 'root')

        self.password = os.getenv('DB_PASSWORD', 'ateliermarkt3162')

        self.database = os.getenv('DB_NAME', 'kick_vods')

    def get_connection(self):

        return mysql.connector.connect(

            host=self.host,

            port=self.port,

            user=self.user,

            password=self.password,

            database=self.database

File "/usr/local/lib/python3.10/site-packages/mysql/connector/pooling.py", line 322, in `connect`

        del kwargs["use_pure"]  # Remove 'use_pure' from kwargs

        if not use_pure and CMySQLConnection is None:

            raise ImportError(ERROR_NO_CEXT)

    if CMySQLConnection and not use_pure:

        return CMySQLConnection(*args, **kwargs)

    return MySQLConnection(*args, **kwargs)

def generate_pool_name(**kwargs: Any) -> str:

    """Generate a pool name

File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 142, in `init`

        self.converter: Optional[MySQLConverter] = None

        super().__init__()

        if kwargs:

            try:

                self.connect(**kwargs)

            except Exception:

                self.close()

                raise

    def _add_default_conn_attrs(self) -> None:

File "/usr/local/lib/python3.10/site-packages/mysql/connector/abstracts.py", line 1604, in `connect`

        # open connection using the default charset id

        if kwargs:

            self.config(**kwargs)

        self.disconnect()

        self._open_connection()

        charset, collation = (

            kwargs.pop("charset", None),

            kwargs.pop("collation", None),

File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 360, in `_open_connection`

            self._cmysql.converter_str_fallback = self._converter_str_fallback

            if self.converter:

                self.converter.str_fallback = self._converter_str_fallback

        except MySQLInterfaceError as err:

            if hasattr(err, "errno"):

                raise get_mysql_exception(

                    err.errno, msg=err.msg, sqlstate=err.sqlstate

                ) from err

            raise InterfaceError(str(err)) from err

        self._do_handshake()

mysql.connector.errors.DatabaseError: 1040 (HY000): Too many connections

This is the Copy/Paste friendly version of the traceback.

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 354, in _open_connection
    self._cmysql.connect(**cnx_kwargs)
_mysql_connector.MySQLInterfaceError: Too many connections

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1536, in __call__
    return self.wsgi_app(environ, start_response)
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1514, in wsgi_app
    response = self.handle_exception(e)
  File "/usr/local/lib/python3.10/site-packages/flask_cors/extension.py", line 176, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1511, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 919, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python3.10/site-packages/flask_cors/extension.py", line 176, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 917, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 902, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)  # type: ignore[no-any-return]
  File "/app/app.py", line 435, in get_channel_vods
    total_row = db.query_one("""
  File "/app/db_access.py", line 42, in query_one
    conn = self.get_connection()
  File "/app/db_access.py", line 13, in get_connection
    return mysql.connector.connect(
  File "/usr/local/lib/python3.10/site-packages/mysql/connector/pooling.py", line 322, in connect
    return CMySQLConnection(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 142, in __init__
    self.connect(**kwargs)
  File "/usr/local/lib/python3.10/site-packages/mysql/connector/abstracts.py", line 1604, in connect
    self._open_connection()
  File "/usr/local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 360, in _open_connection
    raise get_mysql_exception(
mysql.connector.errors.DatabaseError: 1040 (HY000): Too many connections

The debugger caught an exception in your WSGI application. You can now look at the traceback which led to the error. If you enable JavaScript you can also use additional features such as code execution (if the evalex feature is enabled), automatic pasting of the exceptions and much more.

Console Locked

The console is locked and needs to be unlocked by entering the PIN. You can find the PIN printed out on the standard output of your shell that runs the server.

senemdoga