Re: [PacketFence-users] MySQL has gone away?
True... In this case it makes no sense. On 02.10.2016 01:42, Jason 'XenoPhage' Frisvold wrote: > I'm not so sure here.. This happens immediately after starting the > system up, right after a reboot.. So it doesn't feel like a timeout > issue to me.. > > On 9/29/16 1:57 PM, g4-l...@tonarchiv.ch wrote: >> Hi Jason, >> >> we had a similar issue, and after some searching on the mailing list i >> read that this could be a MySQL socket timeout. >> >> The default timeout is AFAIK 8 hours. I.e. if there is absolutely >> nothing going on on PF for more than 8 hours, MySQL stops listening on >> the socket. >> Although I have no idea how it can happen that PF does not use the DB >> for so many hours. Maybe when pfmon is not running for some reason? >> >> We never had this issue again, but nevertheless I set wait_timeout in >> my.cf to 43200 = 12 hours. >> >> Maybe this helps in you, too. >> >> Regards, >> Till >> >> On 29.09.2016 19:34, Jason 'XenoPhage' Frisvold wrote: >>> On 9/16/16 10:01, Louis Munro wrote: Hi Jason, >>> Man, it's been a month.. sorry for the delay here.. >>> Are you running this as a cluster or a single node? >>> Single Node. >>> And are there other database errors in the logs? >>> No, those are pretty much the only ones.. >>> Any sign that mysql may be restarted (by systemd perhaps)? >>> You mean that mysql was being restarted when these errors occurred? No, >>> it was up and running ... >>> Regards, -- Louis Munro >>> >>> -- >>> >>> >>> ___ >>> PacketFence-users mailing list >>> PacketFence-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/packetfence-users >> >> >> -- >> >> >> >> ___ >> PacketFence-users mailing list >> PacketFence-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/packetfence-users >> > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > > ___ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/packetfence-users -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
Re: [PacketFence-users] MySQL has gone away?
Which version of packetfence do you have? Also do you have a huge amount of switches? James Rouzier jrouz...@inverse.ca :: +1.514.447.4918 (x115) :: http://www.inverse.ca Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence (http://www.packetfence.org) On 2016-10-01 7:42 PM, Jason 'XenoPhage' Frisvold wrote: I'm not so sure here.. This happens immediately after starting the system up, right after a reboot.. So it doesn't feel like a timeout issue to me.. On 9/29/16 1:57 PM, g4-l...@tonarchiv.ch wrote: Hi Jason, we had a similar issue, and after some searching on the mailing list i read that this could be a MySQL socket timeout. The default timeout is AFAIK 8 hours. I.e. if there is absolutely nothing going on on PF for more than 8 hours, MySQL stops listening on the socket. Although I have no idea how it can happen that PF does not use the DB for so many hours. Maybe when pfmon is not running for some reason? We never had this issue again, but nevertheless I set wait_timeout in my.cf to 43200 = 12 hours. Maybe this helps in you, too. Regards, Till On 29.09.2016 19:34, Jason 'XenoPhage' Frisvold wrote: On 9/16/16 10:01, Louis Munro wrote: Hi Jason, Man, it's been a month.. sorry for the delay here.. Are you running this as a cluster or a single node? Single Node. And are there other database errors in the logs? No, those are pretty much the only ones.. Any sign that mysql may be restarted (by systemd perhaps)? You mean that mysql was being restarted when these errors occurred? No, it was up and running ... Regards, -- Louis Munro -- ___ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users -- ___ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot ___ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
Re: [PacketFence-users] MySQL has gone away?
I'm not so sure here.. This happens immediately after starting the system up, right after a reboot.. So it doesn't feel like a timeout issue to me.. On 9/29/16 1:57 PM, g4-l...@tonarchiv.ch wrote: > Hi Jason, > > we had a similar issue, and after some searching on the mailing list i > read that this could be a MySQL socket timeout. > > The default timeout is AFAIK 8 hours. I.e. if there is absolutely > nothing going on on PF for more than 8 hours, MySQL stops listening on > the socket. > Although I have no idea how it can happen that PF does not use the DB > for so many hours. Maybe when pfmon is not running for some reason? > > We never had this issue again, but nevertheless I set wait_timeout in > my.cf to 43200 = 12 hours. > > Maybe this helps in you, too. > > Regards, > Till > > On 29.09.2016 19:34, Jason 'XenoPhage' Frisvold wrote: >> On 9/16/16 10:01, Louis Munro wrote: >>> Hi Jason, >> Man, it's been a month.. sorry for the delay here.. >> >>> Are you running this as a cluster or a single node? >> Single Node. >> >>> And are there other database errors in the logs? >> No, those are pretty much the only ones.. >> >>> Any sign that mysql may be restarted (by systemd perhaps)? >> You mean that mysql was being restarted when these errors occurred? No, >> it was up and running ... >> >>> Regards, >>> -- >>> Louis Munro >> >> >> -- >> >> >> ___ >> PacketFence-users mailing list >> PacketFence-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/packetfence-users > > > > -- > > > > ___ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/packetfence-users > -- --- Jason 'XenoPhage' Frisvold xenoph...@godshell.com --- “Space,” it says, “is big. Really big. You just won’t believe how vastly, hugely, mindbogglingly big it is. I mean, you may think it’s a long way down the road to the chemist’s, but that’s just peanuts to space.” - The Hitchhikers Guide to the Galaxy signature.asc Description: OpenPGP digital signature -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
