Open MPI logo

MTT Devel Mailing List Archives

  |   Home   |   Support   |   FAQ   |   all MTT Devel mailing list

From: Josh Hursey (jjhursey_at_[hidden])
Date: 2007-09-22 10:56:44


So I got two of these emails this morning. Any thoughts on why these
2 latency/bandwidth submissions are failing?

The problem is with:
SQL ERROR: ERROR: malformed array literal:
"{136.36,124.59,124.58,124.61,124.74,124.52,124.57,137.98,124.62,124.69,
,
124.81,140.91,186.13,187.51,309.31,419.06,743.33,1574.05,3542.81,7342.21
,15831.27,38853.38,77511.53,130775.23}"

More specifically it is probably the empty array entry about 11
entries into the array ("124.69,,124.81"). Could this be the result
of an error that was not caught properly?

-- josh

On Sep 22, 2007, at 8:23 AM, jjhursey_at_[hidden] wrote:

>
> SQL QUERY: INSERT INTO latency_bandwidth
> (latency_bandwidth_id, message_size, latency_min, latency_avg,
> latency_max, bandwidth_min, bandwidth_avg, bandwidth_max) VALUES
> ('107215',
> '{0,1,2,4,8,16,32,64,128,256,19024,512,1024,2048,4096,8192,16384,32768
> ,65536,131072,262144,524288,1048576,2097152,4194304}',
> '{135.69,124.04,124.28,124.20,124.40,124.27,124.17,124.29,124.26,124.2
> 9,5,124.40,140.17,185.32,187.23,307.94,418.52,741.56,1568.65,3537.90,7
> 314.73,15428.99,37013.45,68857.91,111194.49}',
> '{136.36,124.59,124.58,124.61,124.74,124.52,124.57,137.98,124.62,124.6
> 9,,124.81,140.91,186.13,187.51,309.31,419.06,743.33,1574.05,3542.81,73
> 42.21,15831.27,38853.38,77511.53,130775.23}',
> '{137.07,125.04,125.02,125.07,125.17,124.93,124.93,151.80,125.04,125.0
> 8,,125.29,141.53,187.11,187.89,310.59,419.98,744.73,1580.83,3546.58,73
> 71.56,16254.56,40249.37,87200.25,149653.98}', DEFAULT,
> '{0.00,0.03,0.06,0.12,0.24,0.49,0.98,1.61,3.90,7.81,,15.59,27.60,41.75
> ,
> 83.16,100.61,148.82,167.85,158.14,140.98,135.66,123.04,99.38,91.74,106
> .91}', DEFAULT)
> SQL ERROR: ERROR: malformed array literal:
> "{136.36,124.59,124.58,124.61,124.74,124.52,124.57,137.98,124.62,124.6
> 9,,124.81,140.91,186.13,187.51,309.31,419.06,743.33,1574.05,3542.81,73
> 42.21,15831.27,38853.38,77511.53,130775.23}"
> SQL ERROR: