#117 Warning message about non unique database keys

Kapalı
carlos.garcia tarafından 6 yıl önce kere açıldı · 2 yorum
Carlos Garcia 6 yıl önce olarak yorumlandı

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 6 yıl önce olarak yorumlandı
Sahibi

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 6 yıl önce olarak yorumlandı
Katkıcı

Was fixed in pull request #120.

Was fixed in pull request #120.
Giriş yap bu konuşmaya katılmak için.
Kilometre Taşı Yok
Atanan Kişi Yok
2 Katılımcı
Yükleniyor...
İptal
Kaydet
Henüz bir içerik yok.