Page MenuHomePhabricator

Fetching sessions from the Trove database sometimes times out
Open, Needs TriagePublic

Description

/var/www/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php: 667 - SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

URL: https://xtools.wmcloud.org/ec/ja.wikivoyage.org

Please provide any further details here

XTools version: 3.17.9-a8eac612

Event Timeline

MusikAnimal moved this task from Backlog to General / other on the XTools board.
MusikAnimal subscribed.

This one actually is different from the issue with the replicas. Sessions are stored in a Trove database, which is separate from tools-db and the replicas. I've been seeing this error a lot since we made the change to shared session storage about a month ago. This is the first time however I've seen confirmation that it's actually effecting end users... so I will try to prioritize fixing this.

MusikAnimal renamed this task from PLEASE REPLACE WITH A DESCRIPTION OF THE ERROR to Fetching sessions from the Trove database sometimes timeout.May 30 2023, 12:30 PM
MusikAnimal renamed this task from Fetching sessions from the Trove database sometimes timeout to Fetching sessions from the Trove database sometimes times out.

Oh, sorry, my bad. There's been a lot of redundant reports lately and I saw the HY000 error which had appeared in some other reports too, but thanks for fixing my mistake.

Oh, sorry, my bad. There's been a lot of redundant reports lately and I saw the HY000 error which had appeared in some other reports too, but thanks for fixing my mistake.

No worries, and thank you for closing the duplicates! If it's something database related, it's probably safe to close as a duplicate unless you see PdoSessionHandler or tools.db.svc.wikimedia.cloud.

Come to think of it, while this error was happening prior to the replicas maintenance, it could be exasperated by it. Queries seem to be much slower right now, meaning the connection to the sessions database needs to stay alive longer, too. This is only a theory, but I think it makes sense.