Requests that go on forever and no response
Hello! I use Datagrip to access my database and very often for very simple queries like:
SELECT id
FROM public.cosmetics t
LIMIT 201
I get no response and the query never gets the answer
8 Replies
And it only does it for my Xata databases
hi, can you tell me your workspace id (it's in the URL). If I get that I can look at the logs. If you'd rather have it private, please open a support request.
Hi ! This one ? https://Flavio-Moreno-s-workspace-3dpfnl.eu-central-1.xata.sh
Hi, thanks for sharing your workspace ID, I can see some errors in the logs here from the 21st starting 21:05 UTC. I assume this was when you were running your queries?
Yes, it probably is haha
I've noticed that it does this on tables with about 1000 rows, I don't have the problem on tables with about ten rows
Hi @CustomEntity thanks for your patience while we looked into this. Do you have any recent examples of the hanging select query? A rough timestamp of when you saw it last would help us diagnose the issue.
Hi, not sure if the same, but I am seeing maybe similar with Ruby on Rails? Seems like kind of "cold-start" behavior? After what seems like not more that 5 minutes of inactivity, the next run of my app (DB query) takes so long it timeouts. In logs I can see connection to DB took 38 seconds. After that, all is OK until I am inactive few minutes again.
Hi @Jan H, can you please open a ticket by contacting [email protected] ? Please include your workspace ID and any relevant timestamps, logs, error messages etc. and I'll take a look 👍