Changeset 9713

Timestamp:

04/10/2020 08:39:16 AM (5 years ago)

Author:

dd32

Message:

Translate: When the query times out, don't overwrite the old cached data.

See #3155.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-routes/inc/routes/class-stats.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-routes/inc/routes/class-stats.php

@@ -19 +19 @@
     public function cache_waiting_strings() {
         global $wpdb;
+
+        // Run the query on a primary DB server to avoid timing out.
+        if ( method_exists( $qpdb, 'send_reads_to_masters' ) ) {
+            $wpdb->send_reads_to_masters();
+        }
 
         $cached_projects = [
@@ -36 +41 @@
         foreach ( $cached_projects as $project ) {
             $rows = $wpdb->get_results( $wpdb->prepare( $sql, $project->id ) );
+            if ( ! $rows ) {
+                continue;
+            }
 
             $cached_data = [];