Unable to reset db
Hi, I needed to urgently reset my prod db due to a criticalissue. However neon is not letting me. Really quite disappointed in this service.
12 Replies
other-emeraldOP•2y ago
It keeps saying invalid date even tho the date is clearly valid
I also have 14-day retention w/ the pro plan
Edit - only happening on safari. Chrome works fine
quickest-silver•2y ago
@Soham sorry that this happened to you. I'm glad you figured it out.
Since you're on the Pro Plan, can you please file a support issue using the Support link on https://console.neon.tech ?
stormy-gold•2y ago
I'll see if we can reproduce this issue with safari.
If not, you can generate a HAR file for troubleshooting.
Open Safari and go to the Develop menu.
Select Show Web Inspector.
Click the Network tab. You must keep it open while you reproduce the issue.
Reproduce the issue while the network requests are recorded.
Click the Export icon and save the HAR file.
safari export logs
Upload the HAR file and we can see what is being passed to the API.
other-emeraldOP•2y ago
Done. Just filed a support ticket
Unfortunately I don't want to "test" resetting my prod db as it contains live customer data
And I don't think I can create another branch because I'm almost at the storage limits of the pro plan
Is there any way your team can reproduce?
quickest-silver•2y ago
I can reproduce đź‘Ť
quickest-silver•2y ago
Seems to be a client-side JS issue. I see no request to perform the reset being sent to the server
@Brendan I'm logging this in the GH Issue tracker
other-emeraldOP•2y ago
Thanks @ShinyPokemon
Do you have a link / issue number I can follow for updates?
quickest-silver•2y ago
@Soham our issue tracker for these things is not public at the moment. Best to keep an eye on your support ticket or check back here for an update. The console team has acknowledged the issue
other-emeraldOP•2y ago
@ShinyPokemon sounds good! Thanks. Also unrelated but do you know if enabling pgbouncer for Prisma connections improves the query speed (I use a serverless model on vercel)?
other-emeraldOP•2y ago
Rn Sentry says each of my queries take around 200ms which seems really long to me
quickest-silver•2y ago
Ideally PgBouncer (
-pooler URLs) and direct connections are similar in performance, but I can't say for sure without investigating more. Using the pooler added some overhead until recently, but that has been addressed: https://neon.tech/docs/changelog/2024-02-09-console
To investigate query performance, I'd run the query directly in our console's SQL Editor to get a baseline (the query time is shown in the bottom right). Compare the SQL Editor result with your sentry logs.
The difference between the sentry log time and SQL Editor will come down to 1) proximity of your backend to Neon 2) any overhead added by Prisma 3) other sources of overhead, e.g establishing a new DB connection versus reusing one from a connection poolNeon
Console changelog Feb 09, 2024 - Neon
IPv6 support coming soon Neon will soon start accepting IPv6 connections at no extra charge. We will keep supporting IPv4 connections, also at no extra charge. ...
other-emeraldOP•2y ago
Got it. So assuming that I don't use a connection pooler, then prisma has to establish a new connection to Neon which can take some setup time. However, when I do use a connection pooler then the DB connection is auto established (assuming the DB is currently active and not autoscaled to 0)?