Missing table after update - flows_alerts

Hi Folks,

Today after update ntopng I got his errors on the ntopng log:

18/Oct/2017 09:17:14 [AlertsManager.cpp:814] ERROR: SQL Error: step [INSERT INTO flows_alerts (alert_tstamp, alert_type, alert_severity, alert_json, vlan_id, proto, l7_proto, first_switched, last_switched, cli_country, srv_country, cli_os, srv_os, cli_asn, srv_asn, cli_addr, srv_addr, cli_port, srv_port, cli2srv_bytes, srv2cli_bytes, cli2srv_packets, srv2cli_packets, cli2srv_tcpflags, srv2cli_tcpflags, cli_blacklisted, srv_blacklisted, cli_localhost, srv_localhost) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); ][SQL logic error or missing database]

A lots of this lines per second…

But if I check the database:

MariaDB [ntop]> show tables;
+----------------+
| Tables_in_ntop |
+----------------+
| aggrflowsv4    |
| aggrflowsv6    |
| flowsv4        |
| flowsv6        |
+----------------+
4 rows in set (0.00 sec)

MariaDB [ntop]>


The table “flows_alerts” isnt there…

Ntopng version:

root@mhost:/var/log/ntopng# ntopng -V
v.3.1.171018    [Enterprise/Professional build]
GIT rev:        dev:5809e7500a6d61c2e2caa56440ba8d3f3e160fb6:20171018
Pro rev:        r1196
Built on:       Debian GNU/Linux 8.2 (jessie)
System Id:      {REMOVED}
Platform:       x86_64
Edition:        Professional
License Type:   Permanent
Maintenance:    Until Thu Mar 22 12:28:01 2018 [155 days left]
License:        {REMOVED}
root@mhost:/var/log/ntopng#


Can you share with me the create statement for the missing table?


Thanks
Regards
Roberto
_______________________________________________
Ntop mailing list
[email protected]
http://listgateway.unipi.it/mailman/listinfo/ntop