Re: Help needed to test new reporting tool
Posted: Tue Mar 21, 2017 5:18 pm
by ronagel
Hi modesfan,
here's an excerpt of the log file.
Please note that all aircraft are shown with an altitude on my local installation (dump1090 accessed by a browser)
Hope this helps.
Tue Mar 21 16:57:05 UTC 2017 Received MSGs: 73313 filtered MSGs: 41884
149456 MSGs of types: 713, 0, 6554, 6628, 37083, 8306, 20658, 69109
Executed com.mysql.jdbc.JDBC4PreparedStatement@1940d4e: UPDATE statusPI SET Altitude = '25375' where HexCode = '3CE005'
Lat
format error
[MSG, 3, 1, 1, 896461, 1, 2017/03/21, 16:57:16.069, 2017/03/21, 16:57:16.117, , 40000, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 896461, 1, 2017/03/21, 16:57:18.044, 2017/03/21, 16:57:18.087, , 40025, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 506C22, 1, 2017/03/21, 16:57:18.899, 2017/03/21, 16:57:18.954, , 38000, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 896461, 1, 2017/03/21, 16:57:21.069, 2017/03/21, 16:57:21.096, , 40000, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 3C660B, 1, 2017/03/21, 16:57:21.439, 2017/03/21, 16:57:21.475, , 34975, , , , , , , , , , 0]
Exception: Exc H3 LATLONPI. Try to requeue.com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.LATLONPI' doesn't exist
Lat
format error
[MSG, 3, 1, 1, 896461, 1, 2017/03/21, 16:57:22.181, 2017/03/21, 16:57:22.232, , 40000, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 40087C, 1, 2017/03/21, 16:57:26.800, 2017/03/21, 16:57:26.827, , 38000, , , , , , , , , , 0]
Executed com.mysql.jdbc.JDBC4PreparedStatement@c5da09: UPDATE statusPI SET Altitude = '1875' where HexCode = '4D00D4'
Lat
format error
[MSG, 3, 1, 1, 3C660B, 1, 2017/03/21, 16:57:27.709, 2017/03/21, 16:57:27.751, , 34975, , , , , , , , , , 0]
Executed com.mysql.jdbc.JDBC4PreparedStatement@7af6a: INSERT IGNORE INTO liveidPI(hexcodeID, DateID, TimeID, CSID, Locatie) VALUES ('398560','2017/03/21','16:56:25.999','---','MyStation,DE')
Executed com.mysql.jdbc.JDBC4PreparedStatement@1e28167: INSERT IGNORE INTO LATLONPI(Hexcode, Location, Date, Time, Lat, Lng, head, Callsign, Alt, Squawk, TimeCreated) VALUES ('4784A1','MyStation,DE','2017/03/21','16:56:20.309','50.65599','4.40328','---','---','39075','0743','2017,03,11 10:02.02')
Lat
format error
[MSG, 3, 1, 1, 4B19E8, 1, 2017/03/21, 16:57:30.965, 2017/03/21, 16:57:30.981, , 24000, , , , , , , , , , 0]
4A91F8 removed from db.
406D4E removed from db.
4BA9A8 removed from db.
Executed com.mysql.jdbc.JDBC4PreparedStatement@13bcc34: INSERT IGNORE INTO statusPI(HexCode, Location, Date ,Time, GMTTIME, squawk, Altitude) VALUES ('398560','MyStation,DE','2017/03/21','16:56:37.083','16:56:37.083','1000','---')
format error
[MSG, 7, 1, 1, 4CA6FD, 1, 2017/03/21, 16:57:40.161, 2017/03/21, 16:57:40.203]
Executed com.mysql.jdbc.JDBC4PreparedStatement@199fac5: INSERT IGNORE INTO liveidPI(hexcodeID, DateID, TimeID, CSID, Locatie) VALUES ('4D020F','2017/03/21','16:57:37.228','---','MyStation,DE')
Executed com.mysql.jdbc.JDBC4PreparedStatement@d98a5b: INSERT IGNORE INTO liveidPI(hexcodeID, DateID, TimeID, CSID, Locatie) VALUES ('405636','2017/03/21','16:56:47.455','---','MyStation,DE')
Executed com.mysql.jdbc.JDBC4PreparedStatement@1b2f396: INSERT IGNORE INTO statusPI(HexCode, Location, Date ,Time, GMTTIME, squawk, Altitude) VALUES ('405636','MyStation,DE','2017/03/21','16:56:47.523','16:56:47.523','7523','---')
Lat
format error
[MSG, 3, 1, 1, 4D212D, 1, 2017/03/21, 16:57:50.701, 2017/03/21, 16:57:50.743, , 45000, , , , , , , , , , 0]