postgres db service not accessible from my client

This morning, the DB refuses to accept connections and when I checked the logs, I saw this: does this cause DB downtime? any way to debug what is causing my DB instance to be unavailable? 2023-09-11 22:03:57.212 UTC [10992] LOG: the "timescaledb" extension is not up-to-date 2023-09-11 22:03:57.212 UTC [10992] HINT: The most up-to-date version is 2.11.2, the installed version is 2.1.1. 2023-09-12 02:57:22.262 UTC [11873] LOG: invalid length of startup packet project: 338a4c15-5f76-4fd4-a068-7f68f443c4c4
28 Replies
Percy
Percy•14mo ago
Project ID: 338a4c15-5f76-4fd4-a068-7f68f443c4c4
Brody
Brody•14mo ago
but you can access it?
Siraj Samsudeen
Siraj Samsudeen•14mo ago
when i go to railway interface, i am able to see the tables. when I try to access it from python code or TablePlus editor, both are throwing timeout error
Brody
Brody•14mo ago
are you sure you are using the correct credentials?
Siraj Samsudeen
Siraj Samsudeen•14mo ago
yes, till yesterday night, the code was working and today, i reran the code and it results in an error
Brody
Brody•14mo ago
give the database a restart restart it from its settings
Siraj Samsudeen
Siraj Samsudeen•14mo ago
ok. i was about to do it - but wanted to know whether that timescaledb extension issue and invalid length of startup had an issue.
Brody
Brody•14mo ago
ive seen that plenty, isnt a real problem
Siraj Samsudeen
Siraj Samsudeen•14mo ago
ok thanks restarted, still same issue - both python code and Tableplus is not able to connect any guidance to debug the issue in a step-by-step fashion?
Brody
Brody•14mo ago
try through a vpn?
Siraj Samsudeen
Siraj Samsudeen•14mo ago
i don't use vpn
Brody
Brody•14mo ago
i was asking you to use one to connect try spinning up another postgres database and try connecting to that
Siraj Samsudeen
Siraj Samsudeen•14mo ago
sorry, i am not familiar with using vpn -how does that vpn step help? can you please help me understand
Brody
Brody•14mo ago
thats out of the scope of these help threads, sorry let me know how this goes
Siraj Samsudeen
Siraj Samsudeen•14mo ago
sorry, i am new here, so i may not understand your rules and boundaries. since you asked me to connect using vpn, i wanted to understand how that helps in diagnosing the problem. i would like to understand the solution before trying it out - is that not ok?
Brody
Brody•14mo ago
its fine but i just dont want to explain what a vpn is i thought everyone knows what vpns do
Siraj Samsudeen
Siraj Samsudeen•14mo ago
i know what vpn is, and i have used it connect to my corporate emails, but here in this specific step,i am not sure how it helps.
Brody
Brody•14mo ago
let me know how this goes forget i asked about a vpn
Siraj Samsudeen
Siraj Samsudeen•14mo ago
sorry about the vpn discussion.
Brody
Brody•14mo ago
^
Siraj Samsudeen
Siraj Samsudeen•14mo ago
new db service up and running, but that is not connectable from tableplus. maybe, some issue with my network as i am in an another office today, may be they could have blocked some ports 🙂
Brody
Brody•14mo ago
yep that was what I was gonna tell you if you came back and said the new database doesn't work either looks like your work has a firewall, try again when you are on your home network
Siraj Samsudeen
Siraj Samsudeen•14mo ago
is this why you are suggesting to use a VPN? since that can bypass the firewall? now, i am beginning to get it
Brody
Brody•14mo ago
yes exactly
Siraj Samsudeen
Siraj Samsudeen•14mo ago
ok, i have done research and downloaded a vpn client and able to connect. thanks for your help. it would have been easier for me to try this step if you could have said something like this, Brody --- there might be some firewall blocking issue that is preventing your DB client from connecting - a quick way to check this would be to use a VPN to bypass all firewall restrictions - if it works under VPN, then you know that the service is up and the root cause of the problem is the firewall. though i have used a vpn client (some expensive client paid by my earlier employers), i never have used a free one for personal use - so, that is why i wanted to understand this step - as i need to install some new software
Brody
Brody•14mo ago
I didn't know it was a firewall issue at the time, I was just asking you to try basic debugging steps and didn't feel the need to explain something as mundine has what a VPN is
Siraj Samsudeen
Siraj Samsudeen•14mo ago
i see your point, Brody. sorry for giving you the trouble. have a nice day and thanks for helping me out
Brody
Brody•14mo ago
no worries!
Want results from more Discord servers?
Add your server