Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[WSGI:ERROR] No commit has been made, due to the following error: "NAME-OF-ENDPOINT" #368

Open
GabrieleCalarota opened this issue Nov 11, 2020 · 1 comment

Comments

@GabrieleCalarota
Copy link

GabrieleCalarota commented Nov 11, 2020

Describe the bug
Since I've integrated the flask-monitoringdashboard into flask apps with just this 2 lines of code in every file with a flask app (in order to have a share dashboard for every app)

dashboard.config.init_from(file=os.path.join(os.path.dirname(__file__), fileName_dashboard_config))
dashboard.bind(app)

I've started noticing this error in apache2/error.log

[WSGI:ERROR] No commit has been made, due to the following error: "NAME-OF-ENDPOINT"

Where NAME-OF-ENDPOINT is every name of my endpoint on flask API that I've been calling on production server.
Can't say if it's correlated but my API with a WSGIScriptAlias have been stuck in "pending requests" and made my system not working/working only in particular scenarios

Screenshots
image

Desktop (please complete the following information):

  • OS: "Ubuntu 20.04.1 LTS"
  • Browser Chrome (not relevant)
  • FMD Version 3.1.0

Additional context
Flask is running on virtualhost apache configuration like below port 443

<IfModule mod_ssl.c>
<VirtualHost 0.0.0.0:443>
....
LogLevel info ssl:warn

        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined


  WSGIDaemonProcess SquisEatDEV user=u group=squiseatdev threads=5
  WSGIScriptAlias /SquisEatDEV /home/u/SquisEatDEV/riCibiamo_bot/FlaskAPI/SquisEat.wsgi process-group=SquisEatDEV
  WSGIScriptAlias /SquisEatBotDEV /home/u/SquisEatDEV/riCibiamo_bot/FlaskAPI/UserBot.wsgi process-group=SquisEatDEV
  WSGIScriptAlias /SquisEatPerformanceDEV /home/u/SquisEatDEV/riCibiamo_bot/FlaskAPI/Performance.wsgi process-group=SquisEatDEV
  WSGIScriptAlias /SquisEatB2BDEV /home/u/SquisEatDEV/riCibiamo_bot/FlaskAPI/B2B.wsgi process-group=SquisEatDEV
  WSGIScriptAlias /SquisEatFBDEV /home/u/SquisEatDEV/riCibiamo_bot/FlaskAPI/FB.wsgi process-group=SquisEatDEV
  WSGIScriptAlias /SquisEatWebDEV /home/u/SquisEatDEV/riCibiamo_bot/FlaskAPI/WebApp.wsgi process-group=SquisEatDEV
  WSGIScriptAlias /SquisEatStripeDEV /home/u/SquisEatDEV/riCibiamo_bot/FlaskAPI/Stripe.wsgi process-group=SquisEatDEV

  <Directory /home/u/SquisEatDEV>
      WSGIProcessGroup SquisEatDEV
      WSGIScriptReloading On
      WSGIApplicationGroup %{GLOBAL}
      Require all granted
  </Directory>
....
</VirtualHost>
</IfModule>

I've tried to search on past issues but the only one with a not so similar error is #324

@asaljalilvand
Copy link

asaljalilvand commented Dec 7, 2021

Hi,
I got this error too using default database configs. Then I switched to using postgres, and I get a new error similar to previous one

| No commit has been made, due to the following error: (psycopg2.InternalError) current transaction is aborted, commands ignored until end of transaction block
asset-manager                    | 
asset-manager                    | [SQL: INSERT INTO "fmd_asset_managerRequest" (endpoint_id, duration, time_requested, version_requested, group_by, ip, status_code) VALUES (%(endpoint_id)s, %(duration)s, %(time_requested)s, %(version_requested)s, %(group_by)s, %(ip)s, %(status_code)s) RETURNING "fmd_asset_managerRequest".id]

here is how make the configurations:

dashboard.config.table_prefix = "fmd_asset_manager"
dashboard.config.database_name = "postgresql://{}:{}@{}:{}/{}".format(DB_CONF.get("user"), DB_CONF.get("password"),
                                                                      DB_CONF.get("host"), DB_CONF.get("port"),
                                                                      DB_CONF.get("db"))
dashboard.bind(app)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants