• 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

MGSteve

Well-known member
#1
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.
 

Mike

XenForo developer
Staff member
#2
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).