Author: James Ressler
Updated: July 2024
Audience: Everyone
Environment: Self-hosted, Replicated - Traditional/Native
Summary
A common issue found when upgrading from 8.36 to 8.49 is an SQLGrammarException. You may see the error problem: problem getting tenant status: could not extract ResultSet (SQLGrammarException)
Solution
- Drop the
tenantstate
table from thejama
database - Recreate with the query below
CREATE TABLE `tenantstate` (
`tenantId` varchar(255) NOT NULL,
`message` longtext,
`isOpen` char(1) NOT NULL,
`provisioningState` varchar(255) NOT NULL,
`upgradeRequestErrorMessage` longtext,
`upgradeRequestState` varchar(255) DEFAULT NULL,
PRIMARY KEY (`tenantId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
- delete
/data/tenant/tenant.properties
-
Restart all replicated services
sudo replicatedctl app stop -a
sudo systemctl stop replicated replicated-ui replicated-operator
sudo docker stop $(sudo docker ps -a -q)
sudo systemctl restart docker
sudo systemctl start replicated replicated-ui replicated-operator
- Then start the app from the Admin Console
Related to
Comments
0 comments
Please sign in to leave a comment.