I'm trying to debug a PHP script that runs various queries against the enwiki_p database on the new server (enwiki.analytics.db.svc.eqiad.wmflabs), and I've run into a wall. To simplify the question, I'm running three SQL queries in succession using mysqli_query. The first two queries return results as expected, but the third one doesn't. It just hangs the script indefinitely until the server times out. If I go into the MariaDB client while the script is running and try SHOW FULL PROCESSLIST, it shows the script's connection is sleeping.
Here's what has me stumped: if I comment out the first two queries and just submit the third, it runs fine and returns the data I am looking for. So I know it's not an error in my query string or in PHP syntax. Am I running up against some limit on successive queries? What should I be doing differently?
If it makes a difference, none of these are extremely slow queries. Each one separately completes in about 30-60 seconds depending on server load.
Sent from my iPhone