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
