#117 Warning message about non unique database keys

Uzavrená
otvorené 6 rokov pred užívateľom carlos.garcia · 2 komentárov

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
Carlos Garcia okomentoval 6 rokov pred
Vlastník

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

PRIMARY KEY(ipAddress,portDirection,portNumber,portProtocol)
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) ```
Jens Keim okomentoval 6 rokov pred
Spolupracovník

Was fixed in pull request #120.

Was fixed in pull request #120.
Prihláste sa pre zapojenie do konverzácie.
Žiadne štítky
Bug
Žiadny míľnik
Žiadny priradený
2 účastníkov
Načítavanie...
Zrušiť
Uložiť
Zatiaľ neexistuje žiadny obsah.