That's it. I had retured sql_cache_entries to default value. Tunning it solved my problem.
Thanks. 2010/5/20 Paolo Lucente <[email protected]> > Hi Sergio, > > Please have a look to the following thread and see if it helps: > > http://www.mail-archive.com/[email protected]/msg01545.html > > It might be the case as i guess you are all set for 5 minutes time-bins > ('sql_history: 5m', 'sql_refresh_time: 300') but i see very "unaligned" > stamp_updated in the queries below, ie. 2010-05-20 08:23:39, 2010-05-20 > 08:33:43, etc. > > Cheers, > Paolo > > > On Thu, May 20, 2010 at 08:45:30AM -0300, Sergio Charpinel Jr. wrote: > > Hi, > > > > I'm getting duplicated entrys in PostgreSQL: > > CONTEXTO: COPY acct_2010_05, linha 8: "2010-05-20 08:23:39,2010-05-20 > > 08:20:00,200.137.65.109,66.220.153.19,53559,80,16,6,1,40,1" > > ERRO: duplicar chave viola a restri??o de unicidade "acct_2010_05_pk" > > CONTEXTO: COPY acct_2010_05, linha 50: "2010-05-20 08:25:01,2010-05-20 > > 08:20:00,201.17.106.35,200.137.68.39,43196,51413,0,17,1,58,1" > > ERRO: duplicar chave viola a restri??o de unicidade "acct_2010_05_pk" > > CONTEXTO: COPY acct_2010_05, linha 36: "2010-05-20 08:28:52,2010-05-20 > > 08:25:00,200.137.65.102,64.233.163.152,44063,80,20,6,1,40,1" > > ERRO: duplicar chave viola a restri??o de unicidade "acct_2010_05_pk" > > CONTEXTO: COPY acct_2010_05, linha 6: "2010-05-20 08:30:01,2010-05-20 > > 08:25:00,200.137.65.102,188.126.64.2,16871,80,0,17,3,296,3" > > ERRO: duplicar chave viola a restri??o de unicidade "acct_2010_05_pk" > > CONTEXTO: COPY acct_2010_05, linha 3: "2010-05-20 08:33:43,2010-05-20 > > 08:30:00,200.137.65.109,64.233.163.104,48418,80,20,6,1,40,1" > > ERRO: duplicar chave viola a restri??o de unicidade "acct_2010_05_pk" > > CONTEXTO: COPY acct_2010_05, linha 20: "2010-05-20 08:35:01,2010-05-20 > > 08:30:00,95.34.206.145,200.137.65.102,0,0,0,1,1,56,1" > > > > Here is my table: > > > > pmacct=> \d acct_2010_05 > > Tabela "public.acct_2010_05" > > Coluna | Tipo | > > Modificadores > > > ----------------+-----------------------------+------------------------------------------------------------------------ > > ip_src | inet | not null default > > '0.0.0.0'::inet > > ip_dst | inet | not null default > > '0.0.0.0'::inet > > as_src | bigint | not null default 0 > > as_dst | bigint | not null default 0 > > port_src | integer | not null default 0 > > port_dst | integer | not null default 0 > > tcp_flags | smallint | not null default 0 > > ip_proto | smallint | not null default 0 > > packets | integer | not null > > flows | integer | not null default 0 > > bytes | bigint | not null > > stamp_inserted | timestamp without time zone | not null default > '0001-01-01 > > 00:00:00 BC'::timestamp without time zone > > stamp_updated | timestamp without time zone | > > ?ndices: > > "acct_2010_05_pk" PRIMARY KEY, btree (stamp_inserted, ip_src, ip_dst, > > port_src, port_dst, ip_proto) > > "ibytes_acct_2010_05" btree (bytes) > > > > > > What am I doing wrong? > > > > Thanks in advance. > > > > Cheers. > > > > -- > > Sergio Roberto Charpinel Jr. > > > _______________________________________________ > > pmacct-discussion mailing list > > http://www.pmacct.net/#mailinglists > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists > -- Sergio Roberto Charpinel Jr.
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
