Здравствуйте, Paolo. Вы писали 21 березня 2018 р., 1:18:26:
> 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. Flow contains only ipv4 data. Results with the debug option enabled: First purge after daemon start: Error: 2018-03-21 09:09:22.167 EET [19801] pmacct@pmacct CONTEXT: COPY traffic_21032018, line 1, column ip_src: "" Data (a few lines): DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,,,0,0,0,0,0,0,0,2018-03-21 09:09:05,0,1970-01-01 03:00:00,0,0,0 ---?????? DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,191.234.72.188,94.125.122.215,12883,725,507,12883,443,49896,6,2018-03-21 09:07:36,164000,2018-03-21 09:08:45,586000,91,53509 DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,212.90.184.234,185.16.28.49,12883,507,725,12883,39748,50737,6,2018-03-21 09:08:39,323000,2018-03-21 09:08:40,427000,3,120 DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,35.158.154.235,212.90.176.70,12883,725,507,12883,443,38889,6,2018-03-21 09:07:40,917000,2018-03-21 09:08:46,44000,12,1147 Error: 2018-03-21 09:09:33.265 EET [19804] pmacct@pmacct ERROR: invalid input syntax for type inet: "" 2018-03-21 09:09:33.265 EET [19804] pmacct@pmacct CONTEXT: COPY traffic_21032018, line 44702, column ip_src: "" Data: DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,212.90.175.202,31.134.211.47,12883,507,755,56823,0,0,1,2018-03-21 09:08:11,516000,2018-03-21 09:08:20,989000,3,228 DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,212.90.162.142,185.158.208.144,12883,507,755,12883,56257,443,6,2018-03-21 09:09:12,776000,2018-03-21 09:09:12,817000,101,6713 DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,,,12883,0,0,15497,0,0,0,2018-03-21 09:09:15,0,1970-01-01 03:00:00,0,0,0 ---?????? DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,2.62.60.114,171.25.204.96,12389,725,546,12883,56156,37777,6,2018-03-21 09:07:42,644000,2018-03-21 09:07:45,637000,2,104 DEBUG ( storage/pgsql ): 2018-03-21 09:09:22,2018-03-21 00:00:00,212.90.183.149,120.29.215.38,12883,507,725,12883,53,19131,17,2018-03-21 09:04:59,926000,2018-03-21 09:04:59,995000,25,37500 I see that under strange conditions the daemon generates an incorrect data string that does not contain valid data (except the fields src_as,dst_as,timestamp_start)... -- ANK32-RIPE _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
