Hi Stephan, I'd like to know what version you are using and whether you can post your configuration (can't spot it in your original email) and the content of the file pointed by the sql_table_schema directive.
Cheers, Paolo On Thu, Apr 28, 2011 at 10:41:47AM +0200, Stephan Mol | Atrato IP Networks wrote: > 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 > > [ ... ] _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
