PHP Fatal error: Uncaught RedisException: LOADING Redis is loading the dataset

Hello @futureyoon

I am sorry about the issue you are experiencing and I am happy to help!
“LOADING Redis is loading the dataset in memory”?error?occurs if connections requests reach before the system completely loads the dataset into memory and makes Redis ready for connections
In most cases, a frequent display of the error message can be related to some recent changes made on the site in relation to Redis.

The solution here would be to flush the Redis cache.

To  Flush the Redis Cache, either the FLUSHDB or the  FLUSHALL commands could be used. FLUSHDB command deletes all the keys of the DBs selected and the FLUSHALL command deletes all the keys of all the existing databases, not just the selected one.

The syntax for the commands are:

redis-cli FLUSHDB
redis-cli -n DB_NUMBER FLUSHDB
redis-cli -n DB_NUMBER FLUSHDB ASYNC
redis-cli FLUSHALL
redis-cli FLUSHALL ASYNC

For instance, to delete all the keys of a database #4 from the Redis cache, the syntax to be used is:

$ redis-cli -n 4 FLUSHDB

This will help to fix the issue. To prevent it from happening frequently, we need to revert the changes that were made earlier.

Thanks!

Thank you for the info. I ran 2 of them and at least the system didnt crash last night. Thank you for that!

redis-cli FLUSHDB
redis-cli FLUSHALL

Just curious that above commands are not running when “purge all caches” is performed?

If so, maybe can this be part of option under Redis tab?

Thank you

Hello @futureyoon

Thank you for your feedback.
No, this is not performed when purging all caches.

FLUSHDB – Delete all the keys of the currently selected DB
And flushing all cache, is triggering the flush of the cached content in the memory (page cache, object cache or whatever was used)

This cannot be added to the W3TC as the W3 Total Cache only utilizes the Redis that needs to be installed and enabled on the server.

I hope this explains this.

Thanks!