I've noticed the following errors on my system log whilst downloading via utorrent
2011:06:26-00:05:04 ****** postgres[7988]: [2-1] ERROR: duplicate key value violates unique constraint "websec_reqcat_request_key"
2011:06:26-00:05:04 ****** postgres[7988]: [2-2] CONTEXT: SQL statement "insert into websec_reqcat (request, category) values ( $1 , unnest( $2 ))"
2011:06:26-00:05:04 ****** postgres[7988]: [2-3] PL/pgSQL function "ins_websecurity" line 27 at SQL statement
2011:06:26-00:05:04 ****** postgres[7988]: [2-4] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [3-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [3-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [4-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [4-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [5-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [5-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [6-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [6-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [7-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [7-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [8-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [8-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [9-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [9-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [10-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [10-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [11-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [11-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [12-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [12-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [13-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:06:26-00:05:04 ****** postgres[7988]: [13-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:06:26-00:05:04 ****** postgres[7988]: [14-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
Also the relevant process went high as well
root 5561 86.3 0.7 39792 29208 ? R 15:52 0:00 \_ confd [worker[:P]rpc:system]
postgres 25332 40.6 0.1 49316 6028 ? Ss 14:54 0:02 \_ postgres: postgres pop3 127.0.0.1(54673) idle
Thanks
