2015:01:18-06:21:32 sum postgres[18694]: [3-1] ERROR: integer out of rangeJan 18 06:21:32 postgres[18694]: [3-2] CONTEXT: SQL statement "with upsert (flowcount) as (
2015:01:18-06:21:32 sum postgres[18694]: [3-3] update accounting set
2015:01:18-06:21:32 sum postgres[18694]: [3-4] raw_in_pktlen = raw_in_pktlen + in_len,
2015:01:18-06:21:32 sum postgres[18694]: [3-5] raw_in_pktcount = raw_in_pktcount + in_cnt,
2015:01:18-06:21:32 sum postgres[18694]: [3-6] raw_out_pktlen = raw_out_pktlen + out_len,
2015:01:18-06:21:32 sum postgres[18694]: [3-7] raw_out_pktcount = raw_out_pktcount + out_cnt,
2015:01:18-06:21:32 sum postgres[18694]: [3-8] flow_duration = flow_duration + duration,
2015:01:18-06:21:32 sum postgres[18694]: [3-9] flow_count = flow_count + 1
2015:01:18-06:21:32 sum postgres[18694]: [3-10] where
2015:01:18-06:21:32 sum postgres[18694]: [3-11] logday = day and
2015:01:18-06:21:32 sum postgres[18694]: [3-12] srcip = saddr and dstip = daddr and
2015:01:18-06:21:32 sum postgres[18694]: [3-13] l4_dport = port and ip_protocol = proto and
2015:01:18-06:21:32 sum postgres[18694]: [3-14] (srcid = src_id or (srcid IS NULL and src_id IS NULL)) and
2015:01:18-06:21:32 sum postgres[18694]: [3-15] (dstid = dst_id or (dstid IS NULL and dst_id IS NULL)) and
2015:01:18-06:21:32 sum postgres[18694]: [3-16] afc_proto = appid
2015:01:18-06:21:32 sum postgres[18694]: [3-17] returning
2015:01:18-06:21:32 sum postgres[18694]: [3-18] flow_count
2015:01:18-06:21:32 sum postgres[18694]: [3-19] ) insert into accounting (
2015:01:18-06:21:32 sum postgres[18694]: [3-20] srcip, srcid, dstip, dstid, ip_protocol, l4_dport, afc_proto,
2015:01:18-06:21:32 sum postgres[18694]: [3-21] raw_in_pktlen, raw_in_pktcount, raw_out_pktlen, raw_out_pktcount,
2015:01:18-06:21:32 sum ulogd[4779]: pg1: ERROR: integer out of range
2015:01:18-06:21:32 sum postgres[18694]: [3-22] logday, flow_duration, flow_count
2015:01:18-06:21:32 sum postgres[18694]: [3-23] ) select
2015:01:18-06:21:32 sum postgres[18694]: [3-24] saddr, src_id, daddr, dst_id, proto, port, appid,
2015:01:18-06:21:32 sum postgres[18694]: [3-25] in_len, in_cnt, out_len, out_cnt,
2015:01:18-06:21:32 sum postgres[18694]: [3-26] day, duration, 1
2015:01:18-06:21:32 sum postgres[18694]: [3-27] where not exists (select 1 from upsert)"
2015:01:18-06:21:32 sum postgres[18694]: [3-28] PL/pgSQL function ins_accounting(inet,inet,integer,integer,integer,bigint,bigint,bigint,bigint,integer,integer) line 21 at SQL statement
2015:01:18-06:21:32 sum postgres[18694]: [3-29] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
It seems as one of the integer type fields contains a value larger than integer range and overflows. What has gone wrong? How to fix this?
This thread was automatically locked due to age.