#117 Warning message about non unique database keys

Zamknięty
otworzone 6 lat temu przez carlos.garcia · 2 komentarzy
Carlos Garcia skomentował 6 lat temu

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 skomentował 6 lat temu
Właściciel

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 skomentował 6 lat temu
Współpracownik

Was fixed in pull request #120.

Was fixed in pull request #120.
Zaloguj się, aby dołączyć do tej rozmowy.
Brak etykiety
Bug
Brak kamienia milowego
Brak przypisania
2 uczestników
Ładowanie...
Anuluj
Zapisz
Nie ma jeszcze treści.