Mysql errors
Roberto Alvarado <[email protected]>
| Newsgroups | gmane.linux.ntop.general |
|---|---|
| Message-ID | <0100015eb73428b6-0bce054c-37d9-488e-82e4-fc9379ff2784-000000@email.amazonses.com> |
Hi Folks,
Do you have an idea to fix this kind of errors:
Sep 25 00:52:01 mhost ntopng: [MySQLDB.cpp:55] ERROR: MySQL error: Out of range value for column 'idx' at row 1 [rc=-1]
Sep 25 00:52:01 mhost ntopng: [MySQLDB.cpp:56] ERROR: INSERT INTO `flowsv4` (VLAN_ID,L7_PROTO,IP_SRC_ADDR,L4_SRC_PORT,IP_DST_ADDR,L4_DST_PORT,PROTOCOL,IN_BYTES,OUT_BYTES,PACKETS,FIRST_SWITCHED,LAST_SWITCHED,INFO,JSON,NTOPNG_INSTANCE_NAME,INTERFACE_ID,PROFILE) VALUES (‘0’,’91’,’2417852771’,'39889','2327448076','443','6','80','0','2','1506311491','1506311491','',COMPRESS('{ "8": "144.29.129.99", "12": "REMOVED", "7": 39889, "11": 443, "4": 6, "57590": 91, "57591": "SSL", "6": 20, "2": 2, "1": 80, "24": 0, "23": 0, "22": 1506311491, "21": 1506311491, "json": { "15": "REMOVED", "10": "24", "14": "18", "5": "72", "16": "26258", "17": "52511", "130": "172.20.0.1" }, "57595": 0.000000, "57596": 0.000000, "SRC_IP_COUNTRY": "US", "SRC_IP_LOCATION": [ -83.376297, 42.464500 ], "DST_IP_COUNTRY": "CL", "DST_IP_LOCATION": [ -70.400002, -23.650000 ], "NTOPNG_INSTANCE_NAME": "REMOVED", "INTERFACE": "tcp:\/\/127.0.0.1:5556" }'), 'REMOVED', '0','')
Sep 25 00:52:01 mhost ntopng: [MySQLDB.cpp:55] ERROR: MySQL error: Out of range value for column 'idx' at row 1 [rc=-1]
Sep 25 00:52:01 mhost ntopng: [MySQLDB.cpp:56] ERROR: INSERT INTO `flowsv4` (VLAN_ID,L7_PROTO,IP_SRC_ADDR,L4_SRC_PORT,IP_DST_ADDR,L4_DST_PORT,PROTOCOL,IN_BYTES,OUT_BYTES,PACKETS,FIRST_SWITCHED,LAST_SWITCHED,INFO,JSON,NTOPNG_INSTANCE_NAME,INTERFACE_ID,PROFILE) VALUES (‘0’,’0’,'2327448016','11211','3638218325','36721','6','136','0','2','1506311491','1506311491','',COMPRESS('{ "8": "REMOVED", "12": "216.218.206.85", "7": 11211, "11": 36721, "4": 6, "6": 49, "2": 2, "1": 136, "24": 0, "23": 0, "22": 1506311491, "21": 1506311491, "json": { "15": "192.168.67.185", "10": "0", "14": "24", "5": "192", "16": "52511", "17": "6939", "130": "172.20.0.1" }, "57595": 0.000000, "57596": 0.000000, "SRC_IP_COUNTRY": "CL", "SRC_IP_LOCATION": [ -70.400002, -23.650000 ], "DST_IP_COUNTRY": "US", "DST_IP_LOCATION": [ -121.962097, 37.549702 ], "NTOPNG_INSTANCE_NAME": "REMOVED", "INTERFACE": "tcp:\/\/127.0.0.1:5556" }'), 'REMOVED', '0','')
root@mhost:/var/log# ntopng -V
v.3.1.170925 [Enterprise/Professional build]
GIT rev: dev:462e6aa0725d3e25aec5264554736bc7a933dbbf:20170925
Pro rev: r1172
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 [178 days left]
License: REMOVED
root@mhost:/var/log#
Log Level Config: Normal
Thanks
Regards
Roberto
_______________________________________________
Ntop mailing list
[email protected]
http://listgateway.unipi.it/mailman/listinfo/ntop