Hi Andrey, Yes what i meant is: any chance you can try to understand what precisely is the problematic value? If it's a specific one or there is a set of values that give problems? Having this info would put us in pole position for troubleshooting the issue. Since the field type is 'inet' i'm ruling out this is just about v6 addresses.
Paolo On Mon, Mar 19, 2018 at 08:49:32AM +0200, Andrey Koblyuk wrote: > Hi Paolo, > > > On the error from your other email: any chance you can post what is the > > problematic column (since you said it's always the same one)? It would > > allow to formulate an idea and/or reproduce the issue. I can confirm the > > error as it is spit out does not ring a bell to me. > > This error appears once on each operation > INFO ( storage/pgsql ): *** Purging cache - START (PID: 4927) *** > INFO ( storage/pgsql ): *** Purging cache - END (PID: 4927, QN: 69211/69211, > ET: 0) *** > > and yes - she always appears at the same column (ip_src). only the line > number differs. > > 2018-03-19 08:47:34.339 EET  pmacct@pmacct ERROR: invalid input syntax > for type inet: "" > 2018-03-19 08:47:34.339 EET  pmacct@pmacct CONTEXT: COPY > traffic_19032018, line 9781, column ip_src: "" > 2018-03-19 08:47:34.339 EET  pmacct@pmacct STATEMENT: COPY > traffic_19032018 (stamp_updated, stamp_inserted, ip_src, ip_dst, as_src, > iface_in, iface_out, as_dst, port_src, port_dst, ip_proto, timestamp_start, > timestamp_start_residual, timestamp_end, timestamp_end_residual, packets, > bytes) FROM STDIN DELIMITER ',' > > > -- > ANK32-RIPE > _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists