Traditional - tenantstate table does not have column ResultSet

James Ressler
James Ressler
  • Updated

Author: James Ressler

Date: December 15, 2023

Audience: Everyone

Environmental details: Self hosted

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 the jama 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

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.