Hi Nicholas, > Are there any steps suggested for dealing with the MySQL database errors > relating to Bug #1096, and the log entry: > > WARN: database query failed with: MySQL server has gone away. (errno: > 2006), will try again (pf::db::db_query_execute) > > I have already updated my.cnf with higher settings to handling more > connections, etc. But I was wondering if there was anything else I could > do, or information/troubleshooting I can facilitate to solve the issue.
Here's the story of this bug: In large environments we start getting errors like these. However, the database layer copes with it by automatically reconnecting and re-querying (if needed) so there's no real impact aside from lots of error messages in the logs. The engineer in me want this fixed because there's definitely something wrong (losing track of db handles, threading, ...?) however since it works fine no one's willing to fund the time fixing this and unfunded development to fix an issue that's not causing real problems (and that will be hard to track) is not a priority right now. I'm saddened to say that but it's business reality, we are giving our software for free after all.. > > I have a custom installed PacketFence system served from a ESXi v4 > environment. I don’t see there error a lot, but I am adding > switches/ports to the system each day and I am concerned about reaching > threshold at which point the error will start to cause a problem. > There are setups out-there with error like these every minute and they don't have issues because the db layer copes with it. So, if you are willing to fund a fix or fix it yourself we will be very interested! Otherwise we'll look at it whenever we have time. Cheers! -- Olivier Bilodeau [email protected] :: +1.514.447.4918 *115 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
