[PHOENIX-7290] Cannot load or instantiate class org.apache.phoenix.query.DefaultGuidePostsCacheFactory from SquirrelSQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.2.1, 5.3.0, 5.1.4
• Component/s: core
• Assignee: Istvan Toth
• Reporter: Jeff
• Created: 26/Mar/24 21:00
• Updated: 12/Nov/24 13:27
• Resolved: 23/Apr/24 08:32

Description

Recently we're trying to update to phoenix 5.1.3 and we're running into an issue.

org.apache.phoenix.exception.PhoenixNonRetryableRuntimeException: Could not load/instantiate class org.apache.phoenix.query.DefaultGuidePostsCacheFactory 

I believe there are other areas where this has been brought up such as in SO:
https://stackoverflow.com/questions/73194696/phoenixnonretryableruntimeexception-could-not-load-instantiate-class-org-apache

The issue seems to have been introduced in 5.1.0, anything in 4.8 or below seems to work fine.  

Steps to reproduce:

1. Use Squirrel SQL 4.7.1
2. Create the drivers and load phoenix 5.1.3 into the class path
3. Define alias and test connection

Issue Links

• is caused by: PHOENIX-5231 Configurable Stats Cache
• relates to: PHOENIX-7132 HBase cannot load ClientRpcControllerFactory when adding connector with the --jar option to Spark
• links to: GitHub Pull Request #1873