On Wed, Apr 8, 2015 at 10:55 AM, battossai <battossai@gmail.com> wrote:
Hi All,
I've seen a lot from the archive that this error :
*Wed Apr 8 10:39:43 2015 : Error: Discarding duplicate request from client ZIGY port 52824 - ID: 197 due to unfinished request 1182*
*Wed Apr 8 10:39:43 2015 : Error: Discarding conflicting packet from client ZIGY port 40402 - ID: 199 due to recent request 1184.*
*Wed Apr 8 10:39:43 2015 : Error: Discarding conflicting packet from client ZIGY port 48586 - ID: 201 due to recent request 1186.*
*Wed Apr 8 10:41:43 2015 : Error: Received conflicting packet from client ZIGY port 49888 - ID: 239 due to unfinished request 1226. Giving up on old request.*
was cause by an slow database or slow machine. Can i have a clue how to trace it out, because i don't know which table shoud be lood regagrading ID or request number.
Is it posibble what should i do about slow database, how we measure it.
Short version: hire a competent dba. Long version: learn about database performance monitoring and tuning, especially about - how to determine the "cost" of a query (e.g. "explain", mysql slow query log, etc) - index - maintaining table size for acceptable performance my GUESS is that you have a huge radacct table, in which case purging old records would help. However that might not be acceptable if you have some services that depends on it (e.g. user data/time quota), in which case you'd have to do some additional steps first (e.g. design new table structure and queries to use some kind of "summary" accounting records) -- Fajar