Mediaspend Prediction occasionally 500er Server Response
I can confirm that the connection is not close after the query is executed. The connection is keept open and than timeouts. The first request after the timeout get a 500er response.
query_categorizer.py query_covid_product.py query_filter_diverse.py query_mediaspend.py
(model-server) root@ml-model-server:/package/model-server/query# python query_mediaspend.py 227
<html>
<head>
<title>Internal Server Error</title>
</head>
<body>
<h1><p>Internal Server Error</p></h1>
</body>
</html>
(model-server) root@ml-model-server:/package/model-server/query# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49
Server version: 8.0.32-24 Percona Server (GPL), Release '24', Revision 'e5c6e9d2'
Copyright (c) 2009-2023 Percona LLC and/or its affiliates
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show status where variable_name = 'threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 1 |
+-------------------+-------+
1 row in set (0.01 sec)
mysql> show status where variable_name = 'threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 1 |
+-------------------+-------+
1 row in set (0.00 sec)
mysql> exit
Bye
(model-server) root@ml-model-server:/package/model-server/query# python query_mediaspend.py 227
[{"influencer_id": 227, "reach_min": 173, "reach_max": 3427, "cpp_min": 687, "cpp_max": 1031, "cpc_min": 0.2, "cpc_max": 5.96}]
(model-server) root@ml-model-server:/package/model-server/query# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 51
Server version: 8.0.32-24 Percona Server (GPL), Release '24', Revision 'e5c6e9d2'
Copyright (c) 2009-2023 Percona LLC and/or its affiliates
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show status where variable_name = 'threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 2 |
+-------------------+-------+
1 row in set (0.00 sec)
mysql> show status where variable_name = 'threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 2 |
+-------------------+-------+
1 row in set (0.00 sec)
mysql> show status where variable_name = 'threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 2 |
+-------------------+-------+
1 row in set (0.00 sec)
mysql>
The query prints the number of open connections to the db.
You have to close the connection after the query
Edited by Steffen Scheer