1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 DB Server crash

Discussion in 'Troubleshooting and Problems' started by Stuart Wright, Nov 26, 2014.

  1. Stuart Wright

    Stuart Wright Well-Known Member

    I installed an addon and activated a sidebar widget earlier and it crashed our database servers.
    Tim at Nimbus asks
    I don't know what to tell him.
    Any ideas?
    Thanks.
     
    Last edited: Nov 26, 2014
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You can actually disable that option and truncate the table.

    How many days do you have it set to?

    With regards to the add-on though, you would need to get support from the developer as to why it would cause that.
     
  3. Stuart Wright

    Stuart Wright Well-Known Member

    Thanks. It was set to 30 days. Have brought it down to 10. Does that sounds about right?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    30 days is the default - 18 million rows seems like an awful lot but then I suppose it depends how busy the site is.
    I personally have it disabled as I didn't see much benefit but again that will vary from site to site.

    Is everything now running normally?
     
  5. Stuart Wright

    Stuart Wright Well-Known Member

    No, it's taking an age for new threads to be created for me. Timing out, in fact. I.e. hit submit and the XF 'working' animation starts and then... nothing.
     
  6. rainmotorsports

    rainmotorsports Well-Known Member

    Did you go ahead and truncate the table? The cache will rebuild itself. Might take a cpu hit in the mean time but its worth it.
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Have you disabled the add-on you installed just prior to the problem starting?
     
  8. Stuart Wright

    Stuart Wright Well-Known Member

    Just done it. There were still 13 million rows.
     
  9. Stuart Wright

    Stuart Wright Well-Known Member

    It was the User Cloud in the XenMods addon for Widgets Framework. So I've deleted the User Cloud widget, but there's no need to disable the addon.
    Didn't expect it to perform a query so big that it would crash the db.
     
  10. Mike

    Mike XenForo Developer Staff Member

    Updating add-ons will effectively cause entries in that table to be invalidated (as BB code parsing rules may change).

    You may actually find that it's better to not have the caching option enabled. It's a balance between more disk usage and potentially a large number of writes (particularly when invalidated) vs some amount of CPU savings.

    I don't know what the query was, but there are be indexes in place that should make it fast.
     
  11. Stuart Wright

    Stuart Wright Well-Known Member

    Thanks for your help, fellas.
     

Share This Page