Yes. I later figured it out after a lot of research. Thanks to this link: https://www.datadoghq.com/blog/nginx-502-bad-gateway-errors-gunicorn/ *AJAYI Sunday * (+234) 806 771 5394 *[email protected] <[email protected]>*
On Tue, Jul 7, 2020 at 1:46 AM Dan Madere <[email protected]> wrote: > Sounds like nginx is timing out waiting for Django, due to the slow query. > You can set proxy_connect_timeout and proxy_read_timeout in your nginx > config to allow it to wait longer. Another approach would be to optimize > the SQL query and add indexes, to have the query run faster and not cause > the timeout. > > Dan > > On Monday, July 6, 2020 at 9:24:48 AM UTC-4 [email protected] wrote: > >> I get this error from my postgresql log also : could not send data to >> client: Broken pipe >> *AJAYI Sunday * >> (+234) 806 771 5394 <+234%20806%20771%205394> >> *[email protected]* >> >> >> >> On Mon, Jul 6, 2020 at 2:06 PM Sunday Iyanu Ajayi <[email protected]> >> wrote: >> >>> I have a database sql function that I am running fine when on the >>> database but once i link the output via an api I created and test via >>> postman, I get Nginx 502 error and on my postgresql log I get : Çonnection >>> Timeout error. >>> >>> The sql db function link to a foreign table and pulls some data (between >>> 500-2000 rows) >>> >>> Please how can I fix this? >>> >>> >>> *AJAYI Sunday * >>> (+234) 806 771 5394 <+234%20806%20771%205394> >>> *[email protected]* >>> >>> -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/9a815404-3c51-4a1f-b85d-ba6886dfc9a0n%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/9a815404-3c51-4a1f-b85d-ba6886dfc9a0n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKYSAw2w16jsuSPt%3D6UxV4GupAPq2HCFWBi%2BvsJYS_kH%3DwQ5WA%40mail.gmail.com.
