pmacct-discussion,hi!
i am enjoy pmacct,and install it with mysql support,but when i collect
the NetFlow V5,
my config file is :
daemonize: false
aggregate: src_host,dst_host,src_port,dst_port,proto
! plugin_buffer_size: 1024
nfacctd_port: 9996
! nfacctd_time_secs: true
nfacctd_time_new: true
plugins: mysql
sql_db: pmacct
sql_table: acct
sql_table_version: 1
sql_passwd: arealsmartpwd
sql_user: pmacct
sql_refresh_time: 90
sql_optimize_clauses: true
sql_history: 10m
sql_history_roundoff: mh
about 1.5 minute,i get some warn information,below:
INFO ( default/core ): waiting for data on UDP port '9996'
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN: expecting flow '1396595014' but received '1396595770' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN: expecting flow '1396679038' but received '1396679308' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN: expecting flow '1397285657' but received '1397285846' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN: expecting flow '1397502413' but received '1397502791' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN: expecting flow '1397823794' but received '1397824280' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN: expecting flow '1397866211' but received '1397867372' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
WARN: expecting flow '1399896495' but received '1399896900' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN: expecting flow '1399986513' but received '1399988727' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN: expecting flow '1400281029' but received '1400281191' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
WARN ( default/mysql ): Maximum number of SQL writer processes reached (10).
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
WARN: expecting flow '1402008154' but received '1402008613' collector=(null):999
6 agent=xxx.xxx.x.xxx:0
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Too many connections
I want to know what's wrong with it ? and how to correct these error?
Thanks!
LYNN
[EMAIL PROTECTED]
2006-12-08
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
