Table 'sessions' is read only

hmaddy

• January 11, 2022 03:24

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

• 

  cPanelAnthony

  • January 11, 2022 17:29

  Hello! Just to confirm, which database are you seeing this issue in? Where do you go to trigger this error?

  0
• 

  hmaddy

  • January 13, 2022 05:29

  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.

  0
• 

  cPRex Jurassic Moderator

  • January 25, 2022 22:34

  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.

  0

Please sign in to leave a comment.