Table 'sessions' is read only

hmaddy

Well-Known Member
May 6, 2020
268
30
28
Chennai
cPanel Access Level
Root Administrator
Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1036 Table 'sessions' is read only


Most of the tables have the same issues. How to fix this
 

hmaddy

Well-Known Member
May 6, 2020
268
30
28
Chennai
cPanel Access Level
Root Administrator
All Database are going to read-only. Restored the database manually from backups and reinstalled mysql/mariadb and reconfigured the user permissions. After that all are working fine.

But this error is happening frequently on same server.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
10,999
1,734
363
cPanel Access Level
Root Administrator
The most likely explanation for that behavior is a hardware issue of some sort, either with the disk or the RAM. I wouldn't expect databases to become unstable by themselves, so if you aren't finding anything useful in the MySQL logs I would recommend reaching out to the datacenter to have them check the hardware of the machine.