Dear Paolo, all,
I hope you can help me with a problem I'm facing with pmacct storing data in
MySQL. Pmacct is setup with a 5 minute cycle, on every 5th minute it tries to
store the collected data into MySQL but it runs into this error every time:
( 5mins/mysql ) *** Purging cache - START ***
ERROR ( 5mins/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( 5mins/mysql ): The SQL server says: Table
'pmacct.acct_bgp_5mins_20110428_10-15' doesn't exist
( 5mins/mysql ) *** Purging cache - END (QN: 0, ET: 0) ***
Then on the 6th minute (where the next collection cycle begins) it tries to
store the data again, and this time the table is created and data is stored
into it.
Sometimes pmacct runs into this error several times, eventually it succeeds
storing the data.
I'm worried not all the data is being stored because of these errors. How can I
resolve this behavior, what is going on?
Here's the pmacct config and table file I use.
If there's any more info I need to provide please let me know.
Thanks in advance.
Kind regards,
Stephan Mol
========================== Debug output below
ERROR ( 5mins/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( 5mins/mysql ): The SQL server says: Table
'pmacct.acct_bgp_5mins_20110428_10-10' doesn't exist
( 5mins/mysql ) *** Purging cache - END (QN: 0, ET: 0) ***
( 5mins/mysql ) *** Purging cache - START ***
DEBUG ( 5mins/mysql ): 4091 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4066 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4060 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4054 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4027 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4029 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4007 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4005 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4008 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3994 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3992 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3980 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3980 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 2937 VALUES statements sent to the MySQL server.
( 5mins/mysql ) *** Purging cache - END (QN: 55231, ET: 5) ***
DEBUG ( 5mins/mysql ): purging process (CAUSE: safe action)
( 5mins/mysql ) *** Purging cache - START ***
ERROR ( 5mins/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( 5mins/mysql ): The SQL server says: Table
'pmacct.acct_bgp_5mins_20110428_10-15' doesn't exist
( 5mins/mysql ) *** Purging cache - END (QN: 0, ET: 0) ***
DEBUG ( 5mins/mysql ): purging process (CAUSE: safe action)
( 5mins/mysql ) *** Purging cache - START ***
ERROR ( 5mins/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( 5mins/mysql ): The SQL server says: Table
'pmacct.acct_bgp_5mins_20110428_10-15' doesn't exist
( 5mins/mysql ) *** Purging cache - END (QN: 0, ET: 0) ***
DEBUG ( 5mins/mysql ): purging process (CAUSE: safe action)
( 5mins/mysql ) *** Purging cache - START ***
ERROR ( 5mins/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( 5mins/mysql ): The SQL server says: Table
'pmacct.acct_bgp_5mins_20110428_10-15' doesn't exist
( 5mins/mysql ) *** Purging cache - END (QN: 0, ET: 0) ***
DEBUG ( 5mins/mysql ): purging process (CAUSE: safe action)
( 5mins/mysql ) *** Purging cache - START ***
ERROR ( 5mins/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( 5mins/mysql ): The SQL server says: Table
'pmacct.acct_bgp_5mins_20110428_10-15' doesn't exist
( 5mins/mysql ) *** Purging cache - END (QN: 0, ET: 0) ***
DEBUG ( 5mins/mysql ): purging process (CAUSE: safe action)
( 5mins/mysql ) *** Purging cache - START ***
ERROR ( 5mins/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( 5mins/mysql ): The SQL server says: Table
'pmacct.acct_bgp_5mins_20110428_10-15' doesn't exist
( 5mins/mysql ) *** Purging cache - END (QN: 0, ET: 0) ***
( 5mins/mysql ) *** Purging cache - START ***
DEBUG ( 5mins/mysql ): 4069 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4061 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4047 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4040 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4036 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4022 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4016 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4017 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 4000 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3987 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3992 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3988 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3987 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3978 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 3967 VALUES statements sent to the MySQL server.
DEBUG ( 5mins/mysql ): 804 VALUES statements sent to the MySQL server.
( 5mins/mysql ) *** Purging cache - END (QN: 61012, ET: 5) ***
==========================
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
