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
_______________________________________________
Cloud mailing list
Cloud@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/cloud