SQL lock errors

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • plongeur.com
    Senior Member
    • Mar 2017
    • 239
    • 5.2.x

    SQL lock errors

    Hi,

    I am having more and more SQL lock timeout issues with cacheevent table :

    Invalid SQL:
    /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
    ('getSearchResults_024492b51d195c19b349bea96ca6674d','perms_changed'),
    ('getSearchResults_024492b51d195c19b349bea96ca6674d','vB_ChannelStructure_chg'),
    ('getSearchResults_024492b51d195c19b349bea96ca6674d','vB_SearchResults_chg_0');

    MySQL Error : Lock wait timeout exceeded; try restarting transaction
    Error Number : 1205
    Request Date : Sunday, September 24th 2017 @ 04:07:00 AM
    Error Date : Sunday, September 24th 2017 @ 04:07:51 AM

    When i try to truncate the table the server crashes and i end up rebooting it (but it works in the end).
    The tabe grew to something like 700Mb which seems a lot.

    Is there any way to just disable cacheevent or at least make it rotate somehow ?

    Thanks.
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    Clear out the searchlog, cache and cacheevent tables all at the same time (well, one after other other) and see if that helps.
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • plongeur.com
      Senior Member
      • Mar 2017
      • 239
      • 5.2.x

      #3
      i did it and now it works fine, but errors come back after a couple or days. I would say i have between 1 and 3 errors per day.

      Although, no user complaint so i am not even sure i should care.

      Comment

      • Mark.B
        vBulletin Support
        • Feb 2004
        • 24286
        • 6.0.X

        #4
        It sounds like this could be the known issue that is fixed in 5.3.4.
        MARK.B
        vBulletin Support
        ------------
        My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
        My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

        Comment

        • plongeur.com
          Senior Member
          • Mar 2017
          • 239
          • 5.2.x

          #5
          that would be nice, although i am still in 5.3.1

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73979

            #6
            Originally posted by plongeur.com
            Although, no user complaint so i am not even sure i should care.
            Users should never see this error nor will it affect their use of the site. It is trying to rotate the records as you posted above.

            What is the innodb_lock_wait_timeout value for your database? You might try increasing this to 120 seconds.

            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment

            • plongeur.com
              Senior Member
              • Mar 2017
              • 239
              • 5.2.x

              #7
              Well, i asked my hoster and it looks like my innodb_buffer_pool_size setting was actually to high and cause this issue, i did set it to th enormal value (although i don't remember changing it) and it seems to be ok now.

              Just for people who might end up on this thread, th eserver has 24G of RAM, the setting was 8G and my hoster told me to set it to 1.

              Comment

              Related Topics

              Collapse

              Working...