En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

RDS Serveless V1 Timeouts

0

Since a few hours ago, we have been getting seemingly random timeouts from our RDS Serverless 1 cluster. They are very simple single table queries, eg looking up a user. A query can fail, then succeed as normal when running immediately again. Successful queries don't appear to be any slower than usual.

We have been using serverless since its launch, and have not experienced this before. Queries are called from different EC2 instances, they all exhibit the same problem, so I don't think the problem is there. The servers have been running for months, no recent changes.

The timeouts are similar to what happens when I try to access the database from a different VPC without granting access. Maybe the connections are being routed through a different something??

Gary

  • rePost-User-2057524
    il y a 2 ans

    Setting up some tests and I am totally lost. Simple php page on a new server setup:

    $pdo = new PDO("mysql:host=$servername", $username, $password);

    Keep reloading page, connects OK about 4/5 times.

Sujets
Sans serveurAnalytiqueBase de données
Balises
Sans serveurAmazon Aurora
Langue
English
rePost-User-2057524
demandé il y a 2 ans205 vues
2 réponses
0

Any chance your usage of the database is less than it used to be, and you're scaling down to 0? Cold starts are pretty long - usually over 30 seconds so do cause timeouts.

EXPERT
skinsman
répondu il y a 2 ans
  • rePost-User-2057524
    il y a 2 ans

    No, it is set to a minimum level 2 capacity units.

  • rePost-User-2057524
    il y a 2 ans

    For example, we have a button on our dashboard to reload a list of the user documents. Click that 4 times in a row and it will work, then the 5th one will fail. And may then work on the next 2, then timeout again. All running the same code on the same server.

0

And as quickly as the timeouts started, they stopped about 10 hours after they started. I did start a new database and the servers had no trouble connecting to it, so I was about to do a snapshot / restore to a new serverless database, when the old database started working again. No idea why.

rePost-User-2057524
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents