Maybe post your script so people can try to investigate? On 6 October 2017 at 19:42, Russell Blau <[email protected]> wrote: > 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/cloud >
_______________________________________________ Cloud mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/cloud
