> Then you may be missing the sql_history and sql_history_roundoff then.

Paolo, thank you. Created table has correct name. 

Which is strange - with my config
sql_table[storage]                      : traffic_%d%m%Y
sql_table_schema[storage]               : /etc/pmacct/nfacct_schema.psql
sql_table_type[storage]                 : bgp
sql_dont_try_update[storage]            : true
sql_use_copy[storage]                   : true
sql_history[storage]                    : 1d
sql_history_roundoff[storage]           : d

data purged in table in one minute range (based on stamp_updated?) . as I 
tested it:
on sql server i periodically(once per 10sec ) run SQL QUERY (9-10 queryes), 
such as
select * from traffic_16032018 order by id_key desc limit 1;
and see line in attach1.txt. after minute data in table changed and i see (same 
query) line in attach2.txt. 
In the daemon log could pass 10-15 INFO ( storage/pgsql ): Purging cache - 
START/END calls.
Is this normal behavior?


I will also be very grateful for your comment about the errors in the sql 
server logs that I sended at the end of my previous email.



-- 
ANK32-RIPE
 id_key  | as_src | as_dst |     ip_src     |     ip_dst     | port_src | 
port_dst | ip_proto | iface_in | iface_out | packets | bytes |   
timestamp_start   | timestamp_start_residual |    timestamp_end    | 
timestamp_end_residual |    stamp_updated    |   stamp_inserted    
---------+--------+--------+----------------+----------------+----------+----------+----------+----------+-----------+---------+-------+---------------------+--------------------------+---------------------+------------------------+---------------------+---------------------
 8751053 |  57774 |  14061 | 176.107.196.58 | 165.227.129.48 |    57818 |     
8080 |        6 |      546 |       725 |       1 |    40 | 2018-03-16 13:56:37 
|                   634000 | 2018-03-16 13:56:37 |                 634000 | 
2018-03-16 13:59:19 | 2018-03-16 00:00:00
 id_key  | as_src | as_dst |   ip_src    |     ip_dst     | port_src | port_dst 
| ip_proto | iface_in | iface_out | packets | bytes |   timestamp_start   | 
timestamp_start_residual |    timestamp_end    | timestamp_end_residual |    
stamp_updated    |   stamp_inserted    
---------+--------+--------+-------------+----------------+----------+----------+----------+----------+-----------+---------+-------+---------------------+--------------------------+---------------------+------------------------+---------------------+---------------------
 9126683 |   9198 |   8870 | 5.251.17.62 | 93.171.243.123 |    13463 |    55127 
|        6 |      725 |       546 |       2 |    96 | 2018-03-16 13:46:54 |     
              181000 | 2018-03-16 13:47:00 |                 217000 | 
2018-03-16 14:00:19 | 2018-03-16 00:00:00
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Reply via email to