Skip to content

PHP Notice: Undefined index: global__r #138

@sanchit-hwd

Description

@sanchit-hwd

PHP Notice: Undefined index: global__r in /wp-content/db.php on line 507
PHP Notice: Trying to access array offset on value of type null in /wp-content/db.php on line 507
PHP Notice: Undefined index: global__r in /wp-content/db.php on line 510
PHP Notice: Undefined index: global__r in /wp-content/db.php on line 519

When defining the get_lag and get_lag_cache functions with the threshold, I get the above error.

`function get_lag_cache($wpdb) {
try {
// Create a new Redis instance
$redis = new Redis();
$redis->connect('127.0.0.1', 6379); // Adjust host and port as needed

    $lag_data = $redis->get($wpdb->lag_cache_key);

    if ($lag_data === false || !isset($lag_data['timestamp']) || !isset($lag_data['lag'])) {
        return false;
    }

    if ($wpdb->lag_cache_ttl < time() - $lag_data['timestamp']) {
        return false;
    }

    return $lag_data['lag'];
} catch (Exception $e) {
    return false;
}

}

function get_lag($wpdb) {
// Query to get the replication lag
$results = $wpdb->get_results("SHOW SLAVE STATUS", ARRAY_A);
if (isset($results[0]['Seconds_Behind_Master'])) {
error_log($results[0]['Seconds_Behind_Master']);
return $results[0]['Seconds_Behind_Master'];
} else {
return false;
}
}`

@dd32 Can you please help with this issue? I am not able to enable a lag monitor because of these warnings.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions