We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Answered Session table corrupted, mysql process hangs

    • 19328
    • 433 Posts
    michelle84 Reply #1, 11 years, 5 months ago
    One of our sites (Revo 2.2.14) showed blank pages all of the sudden, logging into the manager was also not possible anymore. The host told us that the my sql processes had stopped because of the following query that was waiting for a lock:

    DELETE FROM `modx_session` WHERE `access` < 1428327164


    A long time ago we had a similar issue on another site. It turned out that the modx_session table for that site had become corrupt. We repaired the table and everything worked again. For this site we tried the same and it also resolved the issue.

    However we would like to prevent this from happening again, but have no clue what could be causing the modx_session table becoming corrupt. Does anyone have an idea what could be the cause?

    This question has been answered by m.engel. See the first response.

      http://www.vierkante-meter.nl
    • discuss.answer
      • 40706
      • 128 Posts
      Michael Engel Reply #2, 11 years, 5 months ago
      Never got this Prblem, but if you have Problems using the Database Sessions, you could also switch to the default PHP session handling, by leaving the system_setting session_handler_class empty.

      http://rtfm.modx.com/revolution/2.x/administering-your-site/settings/system-settings/session_handler_class
        • 19328
        • 433 Posts
        michelle84 Reply #3, 11 years, 5 months ago
        Hi Michael, thanks, didn't know about that option. Do you know what would be the difference using the default php session handling? Would it have an effect on logging in etc?
          http://www.vierkante-meter.nl
          • 40706
          • 128 Posts
          Michael Engel Reply #4, 11 years, 5 months ago
          The only effect would be, that its no longer possible to log out all users afaik.

          We use the native session handling on all high traffic systems, for less MySQL load.