JohnC
JohnC
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
👍
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
Thanks. By the way, I appreciate you taking the time to interact with me even though you do not work for Railway
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
So maybe I should change the settings... What you do think? Or what would you suggest
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
So here is the info from the Django documentation. The default value is 0 , preserving the historical behavior of closing the database connection at the end of each request. To enable persistent connections, set CONN_MAX_AGE to a positive integer of seconds. For unlimited persistent connections, set it to None .
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
Have you worked with Django
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
By the way I am new to full stack development and I appreciate your patience. I just graduated last may and built the entire application from scratch so...
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
Do you have any suggestions?
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
I read on a thread that closing unused connections every hour worked for them. Unfortunately it is not working for me
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
I see people complain about psycop2. Could that be the issue?
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
No
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
My mistake
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
Sorry lol I just assumed
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
Do you mean is the database that I have been using that is on your platform providing everything I just mentioned?
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
What does not make sense is that I am able to update the users during their sessions in the database while interacting with the frontend (decrementing available entries). But as soon as a payment is made and I go to update the user so they have these features I get an error that connection is closed.
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
I have a Django backend application that is deployed on your platform that interacts with a postgreSQL database on your platform as well. I have Django handling the backend and React handling the frontend. It is a SPA application that offers user authorization, interaction with forms where the user enters a numerical set and that set is used to create a matrix and then deconstructed into a set of numerical sets and then displayed to the user on the frontend. Each time a user enters a set the backend/frontend updates (decrements a daily entry count). There are several pages that are injected via React router. I have not had any issues with this part of the application. However, when a standard user navigates to the payment page and makes a purchase using the Stripe API, the transactions go through and the webhook executes after a successful payment ( I have no issues there either). The webhook uses an apScheduler to setup a cron job 30 seconds after a successful payment, and it is during this time that causes the error. So the cron job executes 30 seconds after the webhook finishes execution. In this function the user is accessed via stripe_checkout_id (foreign-key) and then updated in the user_table (changes from standard user to whatever membership was purchased) and updates entry fields as well. It is only during this process that I see the error. I am sorry if I am being to Verbose.
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
I used to get an error SSL SYSCALL error: EOF detectedError but now it just states connection already closed
28 replies
RRailway
Created by JohnC on 3/6/2024 in #✋|help
"Error: connection already closed."
f740c960-4ea5-4e0d-a8fc-7b3efef00d50
28 replies
RRailway
Created by JohnC on 3/1/2024 in #✋|help
Just updated codebase but no new deployments
Thanks @Ray
17 replies
RRailway
Created by JohnC on 3/1/2024 in #✋|help
Just updated codebase but no new deployments
The railway team are on top of issues. They act quickly. Great experience!
17 replies
RRailway
Created by JohnC on 3/1/2024 in #✋|help
Just updated codebase but no new deployments
f740c960-4ea5-4e0d-a8fc-7b3efef00d50
17 replies