When analyzing the file found in 1, the following error is displayed when writing the statistics to the database:
Exception in statistics_db: UNIQUE constraint failed: ip_ports.ipAddress, ip_ports.portDirection, ip_ports.portNumber
When analyzing the file found in [1], the following error is displayed when writing the statistics to the database:
```
Exception in statistics_db: UNIQUE constraint failed: ip_ports.ipAddress, ip_ports.portDirection, ip_ports.portNumber
```
[1]: http://www.fukuda-lab.org/mawilab/v1.1/2018/04/04/20180404.html
This warning was more serious than expected: the `ip_ports` table would not be created.
The issue happens when IP A sends packets to B using the same ports but different protocols (i.e., UDP and TCP).
Solution: change the primary key of `ip_ports` to include the protocol
```sql
PRIMARY KEY(ipAddress,portDirection,portNumber,portProtocol)
```
When analyzing the file found in 1, the following error is displayed when writing the statistics to the database:
This warning was more serious than expected: the
ip_portstable would not be created.The issue happens when IP A sends packets to B using the same ports but different protocols (i.e., UDP and TCP).
Solution: change the primary key of
ip_portsto include the protocolWas fixed in pull request #120.