|Anonymous | Login||2022-11-29 10:43 EST|
|Main | My View | View Issues | Change Log | Roadmap|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001096||PacketFence||error-handling||public||2010-10-21 11:26||2015-02-13 15:42|
|Priority||normal||Severity||minor||Reproducibility||have not tried|
|Target Version||investigate||Fixed in Version|
|Summary||0001096: a lot of failed database query in large environments|
|Description||A LOT of entries like the following can be seen in some of our largest environments:|
WARN: database query failed with: MySQL server has gone away. (errno: 2006), will try again (pf::db::db_query_execute)
Up to several thousands of messages like this per week.
I thought they were related with running out of MySQL handles but we checked today and it seems they are not.
It will need further investigation.
|Tags||No tags attached.|
|fixed in git revision|
|fixed in mtn revision|
It might be related to the per-switch connections that are made by the switch module when starting to handle every trap.
If the issue is reproducible with 1.9.x and not with trunk then we might have the culprit.
Please provide more information:
- logs switched to debug or trace level on pf::db
- logs containing timestamps and mysql connections stats (like dstat -t --mysql5-conn --output mysql_stats.csv)
- mysql server variables values (especially interactive_timeout, wait_timeout)
- mysql query logs (if you log queries and related thread/connection ids)
These bugs have been sitting untouched since 2012.
Closing them and possibly reopening in github tracker where relevant.
|2010-10-21 11:26||obilodeau||New Issue|
|2010-10-29 14:44||obilodeau||Note Added: 0001739|
|2011-01-18 10:03||obilodeau||Target Version||=> 2.0.1|
|2011-01-26 15:30||obilodeau||Target Version||2.0.1 => 2.0.2|
|2011-03-03 15:19||obilodeau||Target Version||2.0.2 => +1|
|2012-04-05 10:23||harold||Note Added: 0002636|
|2012-10-19 12:11||fgaudreault||Target Version||general => investigate|
|2015-02-13 15:42||lmunro||Note Added: 0003794|
|2015-02-13 15:42||lmunro||Status||new => closed|
|Copyright © 2000 - 2012 MantisBT Group|