Did my PostgreSQL database just get wiped?
During the development of a platform, I started receiving errors from PostgreSQL and when I accessed Xata to see if everything was ok, I realized that all my tables were gone, nothing even appears in the Schema History...
16 Replies
Hi Lucas, I'll investigate this immediately, thanks for your patience. Let me know if you have any questions or observations in the meantime.
@cmck, I connected it to the database via DataGrip and I can see the data there, but not through the Xata platform, at first it spent about 5 minutes in "Quering...", but when it showed, my platform started working again...
Thanks for the update, I believe there was a restart of the underlying Aurora cluster that might have caused the issue. Still investigating
Thanks for the support!
Hi Lucas, could you enable support access to your workspace? This will let us get a look at the issue from the UI perspective. If this is already enabled please turn it off and on again to resend the invite.
Yes, one moment
Got it, thanks.
Submited
To clarify, your platform is running again. This is the
aile database we're talking about, is that right?
Hey Lucas, so looks like the tables for that database are intact but in a subschema to the one typically used by xata, which is why they don't appear in the database view. as for datagrip taking a long time to query, it looks like the cluster was under some performance strain which caused the introspection run by datagrip to be killed due to an OOM issue.Thanks! How to change subschema inside Xata UI?
How many concurrent connections is accepted in Free accounts?
The concurrency limit for the free tier depends on the service you're using.
https://xata.io/docs/rest-api/limits#rate-limits
For the consistent transactional store it's 6. For the read replicas store, it's 9.
With regards the schema, would you mind taking a screenshot of what you see when you load your Xata database in DataGrip? What are the names of the schema?
Please reply on the support ticket you opened previously so we can keep any internal information off this forum.
