MantisBT - CDash
[2011-01-20T17:31:12][ERROR][pid=2391](Site Insert): SQL error: ERROR: value too long for type character varying(10)
[2011-01-20T17:31:12][ERROR][pid=2391](GetIdFromName): SQL error: ERROR: value too long for type character varying(10)
[2011-01-20T17:31:12][ERROR][pid=2391](Build:UpdateTestNumbers): SQL error: ERROR: value too long for type character varying(10)
[2011-01-20T17:31:12][ERROR][pid=2391](Build::ComputeTestTiming): BuildId is not set
Upon closer inspection, this error seems to be caused by erroneous parsing in
function get_geolocation. For a particular client host, api.hostip.info returns
the following data (IP blanked):
Country: GERMANY (DE)
City: Munich
Latitude: 48.1333
Longitude: 11.5833
IP: ***.***.***.***
The location data is translated into this SQL command:
INSERT INTO site (name,ip,latitude,longitude)
VALUES ('hostname','***.***.***.***','48.1333','11.5833
IP: ***.***.***.***
'
As seen above, the longitude field also includes the IP address.
This is fixed by limiting the substr range to the end of the "Longitude:" line.
2. Run "ctest -D Experimental" in build tree.
3. Submission fails if (public) host IP is known to api.host.info with latitude/longitude.
cdash_fix_geo_location_longitude.patch (491) 2011-01-20 18:45https://public.kitware.com/Bug/file/3649/cdash_fix_geo_location_longitude.patch