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

XF 1.1 Command Line Import - Excessive Connection count

Discussion in 'Installation, Upgrade, and Import Support' started by MGSteve, Feb 14, 2012.

  1. MGSteve

    MGSteve Well-Known Member

    I'm running the CLI as I type and I'm getting dbErrors caused by the sheer number of idle connections. I've currently got 513 threads connected and the vast majority of them are asleep, waiting to timeout.

    Is there anything the CLI could do to stop this?

    I should add the DB errors are showing up in other sites run on the server, the CLI appears to be coping with it OK. Also normally there are 1 or 2 idle connections, so the CLI is responsible for the steady accumulation of idle connections.
     
  2. Mike

    Mike XenForo Developer Staff Member

    I'm unsure what causes this. We explicitly close connections in the CLI import, but one seems to hang around anyway.

    The easiest way to workaround it is to simply reduce your wait_timeout in MySQL (to something like 60).
     
    Jake Bunce likes this.
  3. MGSteve

    MGSteve Well-Known Member

    Yeah, that's what I did in the end. It was set to 2880!
     

Share This Page