All Activity

Still the same thing [Wed Apr 16 16:12:21.564404 2025] [wsgi:error] [pid 3963178:tid 3963190] [remote x.x.x.x:47984] raise OperationalError("MySQL Connection not available.") I have a connection monitoring script running. Try to trigger the error, or give me a URL I can refresh to see if I can cause the error to happen.

Error: 2025-04-16 16:12:21 Error 155.190.29.38 500 POST /bma/flask.wsgi/conteudo/cadastrar HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/cadastrar Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1000 Apache SSL/TLS access Refresh: 2025-04-16 16:16:38 Error 155.190.29.38 500 POST /bma/flask.wsgi/conteudo/cadastrar HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/cadastrar Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1000 Apache SSL/TLS access Refresh: 2025-04-16 16:16:42 Access 155.190.29.38 302 POST /bma/flask.wsgi/conteudo/cadastrar HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/cadastrar Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.28 K Apache SSL/TLS access 2025-04-16 16:16:43 Access 155.190.29.38 200 GET /bma/flask.wsgi/conteudo HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/cadastrar Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 21.2 K Apache SSL/TLS access 2025-04-16 16:16:44 Access 155.190.29.38 304 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 770 Apache SSL/TLS access

Oh gosh, the indentation, of course! I adjusted the code to make everything inline, and now it works for a much longer time without encountering the 500 error. SQLALCHEMY_ENGINE_OPTIONS = {'pool_size': 5, 'max_overflow': 2, 'pool_timeout': 20, 'pool_recycle': 280, 'connect_args': {'connect_timeout': 10}} However, could you please check what happened at this timestamp? 2025-04-16 16:12:21 Error 155.190.29.38 500 POST /bma/flask.wsgi/conteudo/cadastrar HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/cadastrar Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1000 Apache SSL/TLS access

One of the reasons I don't like Python very much [Wed Apr 16 15:13:59.541642 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] mod_wsgi (pid=3394794): Failed to exec Python script file '/home/talesaz.heliohost.us/httpdocs/bma/flask.wsgi'. [Wed Apr 16 15:13:59.541971 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] mod_wsgi (pid=3394794): Exception occurred processing WSGI script '/home/talesaz.heliohost.us/httpdocs/bma/flask.wsgi'. [Wed Apr 16 15:13:59.542404 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] Traceback (most recent call last): [Wed Apr 16 15:13:59.543014 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] File "/home/talesaz.heliohost.us/httpdocs/bma/flask.wsgi", line 9, in <module> [Wed Apr 16 15:13:59.543061 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] from run import app as application [Wed Apr 16 15:13:59.543106 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] File "/home/talesaz.heliohost.us/httpdocs/bma/run.py", line 1, in <module> [Wed Apr 16 15:13:59.543137 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] from app import app [Wed Apr 16 15:13:59.543179 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] File "/home/talesaz.heliohost.us/httpdocs/bma/app/__init__.py", line 6, in <module> [Wed Apr 16 15:13:59.543197 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] from config import Config # Importa o arquivo de configura\xc3\xa7\xc3\xa3o [Wed Apr 16 15:13:59.543208 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] ^^^^^^^^^^^^^^^^^^^^^^^^^ [Wed Apr 16 15:13:59.543271 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] File "/home/talesaz.heliohost.us/httpdocs/bma/config.py", line 5 [Wed Apr 16 15:13:59.543323 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] \tSQLALCHEMY_ENGINE_OPTIONS = { [Wed Apr 16 15:13:59.543380 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] ^ [Wed Apr 16 15:13:59.543423 2025] [wsgi:error] [pid 3394794:tid 3394834] [remote x.x.x.x:57302] TabError: inconsistent use of tabs and spaces in indentation

Hi, I tried running this code again, and the error happens immediately after the first refresh. 2025-04-16 15:05:24 Error 155.190.29.38 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.22 K Apache SSL/TLS access 2025-04-16 15:05:32 Error 155.190.29.38 404 GET /favicon.ico HTTP/1.0 https://talesaz.heliohost.us/bma/ Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 910 Apache SSL/TLS access 2025-04-16 15:06:27 Error 155.190.29.38 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.22 K Apache SSL/TLS access 2025-04-16 15:07:21 Error 155.190.29.38 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.22 K Apache SSL/TLS access 2025-04-16 15:09:40 Error 155.190.29.38 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 2.68 K Apache SSL/TLS access When I remove the SQL_ENGINE_OPTIONS, it works fine with Python's backend. 2025-04-16 15:10:41 Access 155.190.29.38 302 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.21 K Apache SSL/TLS access 2025-04-16 15:10:43 Access 155.190.29.38 200 GET /bma/flask.wsgi/login?next=%2Fbma%2Fflask.wsgi%2F HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 4.61 K Apache SSL/TLS access 2025-04-16 15:10:43 Access 155.190.29.38 200 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/login?next=%2Fbma%2Fflask.wsgi%2F Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 297 K Apache SSL/TLS access 2025-04-16 15:10:50 Access 155.190.29.38 302 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.22 K Apache SSL/TLS access 2025-04-16 15:10:50 Access 155.190.29.38 200 GET /bma/flask.wsgi/login?next=%2Fbma%2Fflask.wsgi%2F HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 4.61 K Apache SSL/TLS access 2025-04-16 15:10:50 Access 155.190.29.38 304 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/login?next=%2Fbma%2Fflask.wsgi%2F Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 770 Apache SSL/TLS access 2025-04-16 15:11:04 Access 155.190.29.38 200 POST /bma/flask.wsgi/login HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/login?next=%2Fbma%2Fflask.wsgi%2F Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 4.60 K Apache SSL/TLS access 2025-04-16 15:11:05 Access 155.190.29.38 304 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/login Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 770 Apache SSL/TLS access 2025-04-16 15:11:14 Access 155.190.29.38 302 POST /bma/flask.wsgi/login HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/login Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.26 K Apache SSL/TLS access 2025-04-16 15:11:14 Access 155.190.29.38 200 GET /bma/flask.wsgi/ HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/login Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 8.36 K Apache SSL/TLS access 2025-04-16 15:11:15 Access 155.190.29.38 304 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/ Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 770 Apache SSL/TLS access 2025-04-16 15:11:22 Access 155.190.29.38 200 GET /bma/flask.wsgi/conteudo HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/ Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 14.2 K Apache SSL/TLS access 2025-04-16 15:11:22 Access 155.190.29.38 304 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 770 Apache SSL/TLS access 2025-04-16 15:11:26 Access 155.190.29.38 200 GET /bma/flask.wsgi/conteudo/7 HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 10.3 K Apache SSL/TLS access 2025-04-16 15:11:27 Access 155.190.29.38 304 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/7 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 770 Apache SSL/TLS access 2025-04-16 15:11:35 Access 155.190.29.38 200 GET /bma/flask.wsgi/conteudo/editar/7 HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 13.2 K Apache SSL/TLS access 2025-04-16 15:11:35 Access 155.190.29.38 304 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/editar/7 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 770 Apache SSL/TLS access 2025-04-16 15:12:31 Access 155.190.29.38 302 POST /bma/flask.wsgi/conteudo/editar/7 HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/editar/7 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.29 K Apache SSL/TLS access 2025-04-16 15:12:31 Access 155.190.29.38 200 GET /bma/flask.wsgi/conteudo HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/editar/7 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 14.6 K Apache SSL/TLS access 2025-04-16 15:12:31 Access 155.190.29.38 304 GET /bma/flask.wsgi/static/logo.png HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 770 Apache SSL/TLS access However, when I add the code back, the error appears again. 2025-04-16 15:13:38 Error 155.190.29.38 500 GET /bma/flask.wsgi/conteudo HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/conteudo/editar/7 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 2.68 K Apache SSL/TLS access 2025-04-16 15:13:49 Error 155.190.29.38 500 GET /bma/flask.wsgi/conteudo HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.22 K Apache SSL/TLS access 2025-04-16 15:13:59 Error 155.190.29.38 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1.22 K Apache SSL/TLS access For those who host Python + Flask solutions on Heliohost, do they usually prefer using SQLAlchemy, or do they opt for traditional SQL access to the database?

That doesn't give a lot of information. Maybe it's timing out? Try this again, and when you get the 500 error let me know the timestamp and I'll see if there are any more information in the logs that you can't access.

I understand that the database connection limit on HelioHost is restricted to 10 simultaneous connections. To ensure that my application does not exceed this limit, I tried two different approaches, but both resulted in errors. First Approach: Using SQLAlchemy Advanced Configuration I configured the SQLALCHEMY_ENGINE_OPTIONS as follows: SQLALCHEMY_ENGINE_OPTIONS = { 'pool_size': 5, 'max_overflow': 2, 'pool_timeout': 20, 'pool_recycle': 280, 'connect_args': { 'connect_timeout': 10 # 10-second timeout for database connections } } However, this resulted in the following errors: 2025-04-16 03:19:26 Error 186.205.7.186 504 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 967 Apache SSL/TLS access 2025-04-16 03:19:47 Error 186.205.7.186 504 GET /bma/flask.wsgi/usuarios HTTP/1.0 https://talesaz.heliohost.us/bma/flask.wsgi/usuarios/11 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 967 Apache SSL/TLS access 2025-04-16 03:20:26 Error 186.205.7.186 Timeout when reading response headers from daemon process 'talesaz_wsgi': /home/talesaz.heliohost.us/httpdocs/bma/flask.wsgi Apache error Second Approach: Managing Connections Manually I then tried to manually open and close connections for each request using the following code: @app.before_request def before_request(): g.db = db.session() @app.teardown_request def teardown_request(exception): db.session.remove() Unfortunately, this also resulted in errors: 2025-04-16 03:55:58 Error 186.205.7.186 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 986 Apache SSL/TLS access 2025-04-16 03:59:18 Error 186.205.7.186 500 GET /bma/ HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 986 Apache SSL/TLS access Could you please provide any guidance or tips on how to ensure that my application does not exceed the connection limit imposed by HelioHost? I would greatly appreciate any advice on how to configure SQLAlchemy or manage connections more effectively in this environment. Thank you in advance for your help!

[Tue Apr 15 23:37:05.906471 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ret = self._execute_context( [Tue Apr 15 23:37:05.906475 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906480 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1818, in _execute_context [Tue Apr 15 23:37:05.906484 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] self._handle_dbapi_exception( [Tue Apr 15 23:37:05.906489 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception [Tue Apr 15 23:37:05.906495 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] raise sqlalchemy_exception.with_traceback(exc_info[2]) from e [Tue Apr 15 23:37:05.906499 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1812, in _execute_context [Tue Apr 15 23:37:05.906504 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] context = constructor( [Tue Apr 15 23:37:05.906509 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906513 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1429, in _init_compiled [Tue Apr 15 23:37:05.906518 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] self.cursor = self.create_cursor() [Tue Apr 15 23:37:05.906523 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906527 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1768, in create_cursor [Tue Apr 15 23:37:05.906532 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] return self.create_default_cursor() [Tue Apr 15 23:37:05.906536 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906541 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/dialects/mysql/mysqlconnector.py", line 59, in create_default_cursor [Tue Apr 15 23:37:05.906546 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] return self._dbapi_connection.cursor(buffered=True) [Tue Apr 15 23:37:05.906550 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906555 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 1486, in cursor [Tue Apr 15 23:37:05.906560 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] return self.dbapi_connection.cursor(*args, **kwargs) [Tue Apr 15 23:37:05.906564 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [Tue Apr 15 23:37:05.906569 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] File "/usr/local/python3.12/lib/python3.12/site-packages/mysql/connector/connection_cext.py", line 824, in cursor [Tue Apr 15 23:37:05.906573 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] raise OperationalError("MySQL Connection not available.") [Tue Apr 15 23:37:05.906581 2025] [wsgi:error] [pid 291720:tid 291730] [remote 186.205.7.186:53756] sqlalchemy.exc.OperationalError: (mysql.connector.errors.OperationalError) MySQL Connection not available. MariaDB hasn't restarted for 8 hours, and has had 100% uptime during this error. How many database connections are you using? We limit people to 10 connections so if you try to open more than 10 connections it would explain why you can't open more connections. We used to offer unlimited database connections, but some jerk decided to take advantage of our generosity by opening 173 connections and never closing any of them. One jerk always ruins the fun for everyone else.

Domain added. We can't enable WSGI control until a flask app is installed on the domain (the wsgi file has to exist before we can enable it), so you'll need to install an app first (it can be anything, even a hello world app, as long as it exists). The domain will take up to 2 hours to start working.

Hi Guy, Could you create a second website,talesazoeto.heliohost.us (or something similar), with WSGI restart access enabled? Thank you so much!

Now it works! Thank you so much! Sometimes the website still shows a 500 Internal Server Error, but much less frequently than yesterday, and refreshing the page usually resolves it. The logs don’t provide much information about how to address the issue: 2025-04-15 23:28:23 Error 186.205.7.186 500 GET /bma/flask.wsgi/usuarios/cadastrar HTTP/1.0https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 1000 Apache SSL/TLS access 2025-04-15 23:28:25 Access 186.205.7.186 200 GET /bma/flask.wsgi/usuarios/cadastrar HTTP/1.0https://talesaz.heliohost.us/bma/flask.wsgi/conteudo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 10.8 K Apache SSL/TLS access If you could provide more detailed logs for this event at this timestamp, I would greatly appreciate it.

WSGI control access has been enabled on the domain app.zhirofund.com. To restart your Django app and load new code changes in simply edit /home/app.zhirofund.com/httpdocs/djangotest/djangotest/dispatch.wsgi. Adding a blank line, removing a blank line, adding a space, or removing a space are examples of editing the file. As long as the last modified timestamp changes it will clear the server cache. Let us know if you run into any issues.

This support request is being escalated to our root admins who can set that up for you.

Request WSGI Control Access username: szhiro domain: app.zhirofund.com

WSGI control access has been enabled on the domain talesaz.heliohost.us. To restart your Flask app and load new code changes in simply edit /home/talesaz.heliohost.us/httpdocs/bma/flask.wsgi. Adding a blank line, removing a blank line, adding a space, or removing a space are examples of editing the file. As long as the last modified timestamp changes it will clear the server cache. Let us know if you run into any issues. If you get a 500 error check the error logs, and if there isn't much useful information in there let us know and we may be able to get some more logs for you. Plesk isn't very good at filtering Flask logs into the right user accessible logs. At least with WSGI restart access you won't get 500 errors from bugs that you've already fixed, which is very confusing and frustrating.

Domain added. it can take up to 2 hours to start working.

Sorry, I didn’t read this article earlier, so I didn’t restart. Could you grant me WSGI Control Access? My username is talesaz, and my URL is talesaz.heliohost.us:https://talesaz.heliohost.us/bma.

Hello, When convenient, can you please add "smoothtalker.fwh.is" to my domain list for account under the name "fatalslink" please? Thanks a million! Best, Mike

Did you request WSGI restart access? Source: https://wiki.helionet.org/Flask#WSGI_Uses_Caching

thank you

Yes, please reset the account, that'd be great. And if you could tell me if there's a way to install it without errors, properly. I don't want to have to reset the account. Laravel is all confusing, and I can't even tell if the Laravel application I bought is compatible with heliohost :')

I've removed those 2 domains from your account. Please note there is a risk of data loss when domains are removed, since the folder for the domain inside Plesk will be deleted. I made a full account backup for you before I removed the domains, in case you need any of the old files. You can download the backup here: https://heliohost.org/backup If you're not sure how to extract the backup files, please follow our how-to guide here: https://wiki.helionet.org/Account_Backups I've also added the new domains to your account for you. Please note that it may take up to 2 hours for the domain changes to take effect. If after a full 2 hours it doesn't work on your side, please make sure you clear your web browser cache: https://wiki.helionet.org/Clear_Your_Cache

It looks like you just created your account today. Websites can take several weeks to months to appear on Google. It just happens whenever Google gets around indexing it. We don't have any control over that. You could sign up for the Google search console and submit it for indexing to help speed this up. As for the SEO tools in Plesk, we don't have a license for the premium version, so the rank tracker feature does not work. The free version only has the site audit.

I've reset your account as requested. You should receive an email shortly so you can take the next steps to recreate it. I made a backup before the reset, so if you discover you need any of your old files, you can download the backup here: https://heliohost.org/backup If you're not sure how to extract the backup files, please follow our how-to guide here: https://wiki.helionet.org/Account_Backups

Krydos might have more of an idea about why this would happen. I'm not terribly familiar with Python...escalating.