Opened 12 years ago
Closed 12 years ago
#141 closed (duplicate)
gmoc-db2 throws a 500 error when aggregate resource measurements are submitted from client v.1.1.4
Reported by: | chaos@bbn.com | Owned by: | somebody |
---|---|---|---|
Priority: | major | Milestone: | GEC15 demo |
Component: | Database | Version: | |
Keywords: | Cc: | ||
Dependencies: |
Description
My FOAM aggregate submitting to gmoc-db2 is now getting this when i try to report the aggregate measurements:
tau-verde,[~],22:38(148)$ sudo -u ganglia ./report_relations -d Submitting: <?xml version="1.0" ?> <gmoc_topology time="1350891529" version="4"> <pop name="urn:publicid:IDN+gmoc.geni.net+pop+gpolab"/> <aggregate name="foam5.gpolab.bbn.com:3626" organization="urn:publicid:IDN+gmoc.geni.net+organization+BBN" pop="urn:publicid:IDN+gmoc.geni.net+pop+gpolab" type="foam" version="0.8.2"> <sliver approved="true" created="1342549645" creator="urn:publicid:IDN+gmoc.geni.net+contact+user-not-known" expires="1362114000" local_name="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-montreve-macaddr:b72b0a06-beb9-4be2-94ba-cfbd8654ad82" slice_urn="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-montreve-macaddr" slice_uuid="None" state="Up" uuid="b72b0a06-beb9-4be2-94ba-cfbd8654ad82"> <resource_mapping local_name="b72b0a06-beb9-4be2-94ba-cfbd8654ad82" resource="urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:26:f1:3f:3b:00" type="flowspace"/> <resource_mapping local_name="b72b0a06-beb9-4be2-94ba-cfbd8654ad82" resource="urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:12:e2:b8:a5:d0" type="flowspace"/> </sliver> <sliver approved="true" created="1342549645" creator="urn:publicid:IDN+gmoc.geni.net+contact+user-not-known" expires="1362200400" local_name="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-poblano1101-datapath:9c3476a5-dfe9-4d8c-9d2d-3b20d846f36a" slice_urn="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-poblano1101-datapath" slice_uuid="None" state="Up" uuid="9c3476a5-dfe9-4d8c-9d2d-3b20d846f36a"> <resource_mapping local_name="9c3476a5-dfe9-4d8c-9d2d-3b20d846f36a" resource="urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:12:e2:b8:a5:d0" type="flowspace"/> </sliver> </aggregate> <resource aggregate="foam5.gpolab.bbn.com:3626" description="" name="urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:12:e2:b8:a5:d0" organization="urn:publicid:IDN+gmoc.geni.net+organization+BBN" pop="urn:publicid:IDN+gmoc.geni.net+pop+gpolab" state="Unknown" type="datapath"/> <resource aggregate="foam5.gpolab.bbn.com:3626" description="" name="urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:26:f1:3f:3b:00" organization="urn:publicid:IDN+gmoc.geni.net+organization+BBN" pop="urn:publicid:IDN+gmoc.geni.net+pop+gpolab" state="Unknown" type="datapath"/> </gmoc_topology> Submitting: <?xml version="1.0" ?> <timeseries_data originator="someone" time="1350873530" version="0.1"> <type_info name="foam_sliver_state"> <column_names> approved,enabled,pending,rejected </column_names> <column_units> N,N,N,N </column_units> </type_info> <type_info name="node_disk"> <column_names> disk_part_max_used </column_names> <column_units> percent </column_units> </type_info> <type_info name="foam_state"> <column_names> slivers </column_names> <column_units> N </column_units> </type_info> <type_info name="flowvisor_dpid_stats"> <column_names> ports,ro_rules,rw_rules,tx_msgs,rx_msgs,drop_msgs,tx_msgs_flow_mod,tx_msgs_flow_remove,tx_msgs_error,tx_msgs_packet_in,tx_msgs_packet_out,tx_msgs_vendor,tx_msgs_other,rx_msgs_flow_mod,rx_msgs_flow_remove,rx_msgs_error,rx_msgs_packet_in,rx_msgs_packet_out,rx_msgs_vendor,rx_msgs_other </column_names> <column_units> N,N,N,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s,msgs/s </column_units> </type_info> <type_info name="node_cpu"> <column_names> cpu_idle </column_names> <column_units> percent </column_units> </type_info> <node_info name="foam5.gpolab.bbn.com:3626"> <location> urn:publicid:IDN+gmoc.geni.net+pop+gpolab </location> <tags/> </node_info> <data_group end="1350873465" heartbeat="60" interval_type="open_closed" name="foam5.gpolab.bbn.com:3626-foam_state" start="1350873225" step="15"> <column_names> slivers </column_names> <type> foam_state </type> <node_name> foam5.gpolab.bbn.com:3626 </node_name> <tags> foam5.gpolab.bbn.com:3626 </tags> <data> 1350873210,; 1350873225,2.0; 1350873240,2.0; 1350873255,2.0; 1350873270,2.0; 1350873285,2.0; 1350873300,2.0; 1350873315,2.0; 1350873330,2.0; 1350873345,2.0; 1350873360,2.0; 1350873375,2.0; 1350873390,2.0; 1350873405,2.0; 1350873420,2.0; 1350873435,2.0; 1350873450,2.0; 1350873465,2.0; </data> </data_group> <data_group end="1350873465" heartbeat="60" interval_type="open_closed" name="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-montreve-macaddr:b72b0a06-beb9-4be2-94ba-cfbd8654ad82-foam_sliver_state-sliver_urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-montreve-macaddr:b72b0a06-beb9-4be2-94ba-cfbd8654ad82" start="1350873225" step="15"> <column_names> approved,enabled,pending,rejected </column_names> <type> foam_sliver_state </type> <node_name> urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-montreve-macaddr:b72b0a06-beb9-4be2-94ba-cfbd8654ad82 </node_name> <tags> sliver:urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-montreve-macaddr:b72b0a06-beb9-4be2-94ba-cfbd8654ad82 </tags> <data> 1350873210,,,,; 1350873225,1.0,1.0,0.0,0.0; 1350873240,1.0,1.0,0.0,0.0; 1350873255,1.0,1.0,0.0,0.0; 1350873270,1.0,1.0,0.0,0.0; 1350873285,1.0,1.0,0.0,0.0; 1350873300,1.0,1.0,0.0,0.0; 1350873315,1.0,1.0,0.0,0.0; 1350873330,1.0,1.0,0.0,0.0; 1350873345,1.0,1.0,0.0,0.0; 1350873360,1.0,1.0,0.0,0.0; 1350873375,1.0,1.0,0.0,0.0; 1350873390,1.0,1.0,0.0,0.0; 1350873405,1.0,1.0,0.0,0.0; 1350873420,1.0,1.0,0.0,0.0; 1350873435,1.0,1.0,0.0,0.0; 1350873450,1.0,1.0,0.0,0.0; 1350873465,1.0,1.0,0.0,0.0; </data> </data_group> <data_group end="1350873465" heartbeat="60" interval_type="open_closed" name="urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-poblano1101-datapath:9c3476a5-dfe9-4d8c-9d2d-3b20d846f36a-foam_sliver_state-sliver_urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-poblano1101-datapath:9c3476a5-dfe9-4d8c-9d2d-3b20d846f36a" start="1350873225" step="15"> <column_names> approved,enabled,pending,rejected </column_names> <type> foam_sliver_state </type> <node_name> urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-poblano1101-datapath:9c3476a5-dfe9-4d8c-9d2d-3b20d846f36a </node_name> <tags> sliver:urn:publicid:IDN+pgeni.gpolab.bbn.com+slice+chaos-poblano1101-datapath:9c3476a5-dfe9-4d8c-9d2d-3b20d846f36a </tags> <data> 1350873210,,,,; 1350873225,1.0,1.0,0.0,0.0; 1350873240,1.0,1.0,0.0,0.0; 1350873255,1.0,1.0,0.0,0.0; 1350873270,1.0,1.0,0.0,0.0; 1350873285,1.0,1.0,0.0,0.0; 1350873300,1.0,1.0,0.0,0.0; 1350873315,1.0,1.0,0.0,0.0; 1350873330,1.0,1.0,0.0,0.0; 1350873345,1.0,1.0,0.0,0.0; 1350873360,1.0,1.0,0.0,0.0; 1350873375,1.0,1.0,0.0,0.0; 1350873390,1.0,1.0,0.0,0.0; 1350873405,1.0,1.0,0.0,0.0; 1350873420,1.0,1.0,0.0,0.0; 1350873435,1.0,1.0,0.0,0.0; 1350873450,1.0,1.0,0.0,0.0; 1350873465,1.0,1.0,0.0,0.0; </data> </data_group> <data_group end="1350873465" heartbeat="60" interval_type="open_closed" name="urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:26:f1:3f:3b:00-flowvisor_dpid_stats-dpid_urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:26:f1:3f:3b:00" start="1350873225" step="15"> <column_names> ports,ro_rules,rw_rules,tx_msgs,rx_msgs,drop_msgs,tx_msgs_flow_mod,tx_msgs_flow_remove,tx_msgs_error,tx_msgs_packet_in,tx_msgs_packet_out,tx_msgs_vendor,tx_msgs_other,rx_msgs_flow_mod,rx_msgs_flow_remove,rx_msgs_error,rx_msgs_packet_in,rx_msgs_packet_out,rx_msgs_vendor,rx_msgs_other </column_names> <type> flowvisor_dpid_stats </type> <node_name> urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:26:f1:3f:3b:00 </node_name> <tags> dpid:urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:26:f1:3f:3b:00 </tags> <data> 1350873210,,,,,,,,,,,,,,,,,,,,; 1350873225,6.0,0.0,2.0,1.48983050848,3.63050847458,0.0,0.0661016949153,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.42203389831,0.0,0.0,0.203389830508; 1350873240,6.0,0.0,2.0,1.45932203389,3.69152542373,0.0,0.0355932203389,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.39152542372,0.0,0.0,0.203389830508; 1350873255,6.0,0.0,2.0,1.45932203389,3.69152542373,0.0,0.0355932203389,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.39152542372,0.0,0.0,0.203389830508; 1350873270,6.0,0.0,2.0,1.45932203389,3.69152542373,0.0,0.0355932203389,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.39152542372,0.0,0.0,0.203389830508; 1350873285,6.0,0.0,2.0,1.45932203389,3.69152542373,0.0,0.0355932203389,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.39152542372,0.0,0.0,0.203389830508; 1350873300,6.0,0.0,2.0,1.45762711864,3.53389830508,0.0,0.0338983050847,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.32542372882,0.0,0.0,0.203389830508; 1350873315,6.0,0.0,2.0,1.45762711864,3.53389830508,0.0,0.0338983050847,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.32542372882,0.0,0.0,0.203389830508; 1350873330,6.0,0.0,2.0,1.45762711864,3.53389830508,0.0,0.0338983050847,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.32542372882,0.0,0.0,0.203389830508; 1350873345,6.0,0.0,2.0,1.45762711864,3.53389830508,0.0,0.0338983050847,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.32542372882,0.0,0.0,0.203389830508; 1350873360,6.0,0.0,2.0,1.43414312617,3.66195856874,0.0,0.033352165725,None,0.0,0.0,1.2006779661,0.0,0.20011299435,0.0,None,0.0,3.39740112994,0.0,0.0,0.20011299435; 1350873375,6.0,0.0,2.0,1.43414312617,3.66195856874,0.0,0.033352165725,None,0.0,0.0,1.2006779661,0.0,0.20011299435,0.0,None,0.0,3.39740112994,0.0,0.0,0.20011299435; 1350873390,6.0,0.0,2.0,1.43414312617,3.66195856874,0.0,0.033352165725,None,0.0,0.0,1.2006779661,0.0,0.20011299435,0.0,None,0.0,3.39740112994,0.0,0.0,0.20011299435; 1350873405,6.0,0.0,2.0,1.43414312617,3.66195856874,0.0,0.033352165725,None,0.0,0.0,1.2006779661,0.0,0.20011299435,0.0,None,0.0,3.39740112994,0.0,0.0,0.20011299435; 1350873420,6.0,0.0,2.0,1.55302259887,3.79011299435,0.0,0.130480225989,None,0.0,0.0,1.2193220339,0.0,0.203220338983,0.0,None,0.0,3.48694915254,0.0,0.0,0.203220338983; 1350873435,6.0,0.0,2.0,1.55302259887,3.79011299435,0.0,0.130480225989,None,0.0,0.0,1.2193220339,0.0,0.203220338983,0.0,None,0.0,3.48694915254,0.0,0.0,0.203220338983; 1350873450,6.0,0.0,2.0,1.55302259887,3.79011299435,0.0,0.130480225989,None,0.0,0.0,1.2193220339,0.0,0.203220338983,0.0,None,0.0,3.48694915254,0.0,0.0,0.203220338983; 1350873465,6.0,0.0,2.0,1.55302259887,3.79011299435,0.0,0.130480225989,None,0.0,0.0,1.2193220339,0.0,0.203220338983,0.0,None,0.0,3.48694915254,0.0,0.0,0.203220338983; </data> </data_group> <data_group end="1350873465" heartbeat="60" interval_type="open_closed" name="foam5.gpolab.bbn.com:3626-node_cpu-aggregate_foam5.gpolab.bbn.com:3626" start="1350873225" step="15"> <column_names> cpu_idle </column_names> <type> node_cpu </type> <node_name> foam5.gpolab.bbn.com:3626 </node_name> <tags> aggregate:foam5.gpolab.bbn.com:3626 </tags> <data> 1350873210,; 1350873225,97.4; 1350873240,97.4; 1350873255,97.4; 1350873270,97.4; 1350873285,97.4; 1350873300,97.4; 1350873315,97.4; 1350873330,97.4; 1350873345,97.4; 1350873360,97.4; 1350873375,97.4; 1350873390,97.4; 1350873405,97.4; 1350873420,97.4; 1350873435,97.4; 1350873450,97.4; 1350873465,97.4; </data> </data_group> <data_group end="1350873465" heartbeat="60" interval_type="open_closed" name="urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:12:e2:b8:a5:d0-flowvisor_dpid_stats-dpid_urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:12:e2:b8:a5:d0" start="1350873225" step="15"> <column_names> ports,ro_rules,rw_rules,tx_msgs,rx_msgs,drop_msgs,tx_msgs_flow_mod,tx_msgs_flow_remove,tx_msgs_error,tx_msgs_packet_in,tx_msgs_packet_out,tx_msgs_vendor,tx_msgs_other,rx_msgs_flow_mod,rx_msgs_flow_remove,rx_msgs_error,rx_msgs_packet_in,rx_msgs_packet_out,rx_msgs_vendor,rx_msgs_other </column_names> <type> flowvisor_dpid_stats </type> <node_name> urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:12:e2:b8:a5:d0 </node_name> <tags> dpid:urn:publicid:IDN+openflow:foam:foam5.gpolab.bbn.com+datapath+04:4d:00:12:e2:b8:a5:d0 </tags> <data> 1350873210,,,,,,,,,,,,,,,,,,,,; 1350873225,5.0,0.0,3.0,1.55593220339,3.68559322033,0.0,0.132203389831,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.47203389831,0.0,0.0,0.203389830508; 1350873240,5.0,0.0,3.0,1.49491525424,3.82288135594,0.0,0.071186440678,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.42627118644,0.0,0.0,0.203389830508; 1350873255,5.0,0.0,3.0,1.49491525424,3.82288135594,0.0,0.071186440678,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.42627118644,0.0,0.0,0.203389830508; 1350873270,5.0,0.0,3.0,1.49491525424,3.82288135594,0.0,0.071186440678,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.42627118644,0.0,0.0,0.203389830508; 1350873285,5.0,0.0,3.0,1.49491525424,3.82288135594,0.0,0.071186440678,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.42627118644,0.0,0.0,0.203389830508; 1350873300,5.0,0.0,3.0,1.52372881356,3.65338983051,0.0,0.0999999999998,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.43983050847,0.0,0.0,0.203389830508; 1350873315,5.0,0.0,3.0,1.52372881356,3.65338983051,0.0,0.0999999999998,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.43983050847,0.0,0.0,0.203389830508; 1350873330,5.0,0.0,3.0,1.52372881356,3.65338983051,0.0,0.0999999999998,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.43983050847,0.0,0.0,0.203389830508; 1350873345,5.0,0.0,3.0,1.52372881356,3.65338983051,0.0,0.0999999999998,None,0.0,0.0,1.22033898305,0.0,0.203389830508,0.0,None,0.0,3.43983050847,0.0,0.0,0.203389830508; 1350873360,5.0,0.0,3.0,1.46862523541,3.74646892655,0.0,0.0678342749529,None,0.0,0.0,1.2006779661,0.0,0.20011299435,0.0,None,0.0,3.38524482109,0.0,0.0,0.20011299435; 1350873375,5.0,0.0,3.0,1.46862523541,3.74646892655,0.0,0.0678342749529,None,0.0,0.0,1.2006779661,0.0,0.20011299435,0.0,None,0.0,3.38524482109,0.0,0.0,0.20011299435; 1350873390,5.0,0.0,3.0,1.46862523541,3.74646892655,0.0,0.0678342749529,None,0.0,0.0,1.2006779661,0.0,0.20011299435,0.0,None,0.0,3.38524482109,0.0,0.0,0.20011299435; 1350873405,5.0,0.0,3.0,1.46862523541,3.74646892655,0.0,0.0678342749529,None,0.0,0.0,1.2006779661,0.0,0.20011299435,0.0,None,0.0,3.38524482109,0.0,0.0,0.20011299435; 1350873420,5.0,0.0,3.0,1.71570621469,4.05190677966,0.0,0.293163841808,None,0.0,0.0,1.2193220339,0.0,0.203220338983,0.0,None,0.0,3.64713276836,0.0,0.0,0.203220338983; 1350873435,5.0,0.0,3.0,1.71570621469,4.05190677966,0.0,0.293163841808,None,0.0,0.0,1.2193220339,0.0,0.203220338983,0.0,None,0.0,3.64713276836,0.0,0.0,0.203220338983; 1350873450,5.0,0.0,3.0,1.71570621469,4.05190677966,0.0,0.293163841808,None,0.0,0.0,1.2193220339,0.0,0.203220338983,0.0,None,0.0,3.64713276836,0.0,0.0,0.203220338983; 1350873465,5.0,0.0,3.0,1.71570621469,4.05190677966,0.0,0.293163841808,None,0.0,0.0,1.2193220339,0.0,0.203220338983,0.0,None,0.0,3.64713276836,0.0,0.0,0.203220338983; </data> </data_group> <data_group end="1350873465" heartbeat="60" interval_type="open_closed" name="foam5.gpolab.bbn.com:3626-node_disk-aggregate_foam5.gpolab.bbn.com:3626" start="1350873225" step="15"> <column_names> disk_part_max_used </column_names> <type> node_disk </type> <node_name> foam5.gpolab.bbn.com:3626 </node_name> <tags> aggregate:foam5.gpolab.bbn.com:3626 </tags> <data> 1350873210,; 1350873225,33.0; 1350873240,33.0; 1350873255,33.0; 1350873270,33.0; 1350873285,33.0; 1350873300,33.0; 1350873315,33.0; 1350873330,33.0; 1350873345,33.0; 1350873360,33.0; 1350873375,33.0; 1350873390,33.0; 1350873405,33.0; 1350873420,33.0; 1350873435,33.0; 1350873450,33.0; 1350873465,33.0; </data> </data_group> </timeseries_data> {'status': '500', 'content-length': '622', 'vary': 'Accept-Encoding', 'server': 'Apache/2.2.3 (Red Hat)', 'connection': 'close', '-content-encoding': 'gzip', 'date': 'Mon, 22 Oct 2012 02:38:50 GMT', 'content-type': 'text/html; charset=iso-8859-1'} <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>500 Internal Server Error</title> </head><body> <h1>Internal Server Error</h1> <p>The server encountered an internal error or misconfiguration and was unable to complete your request.</p> <p>Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.</p> <p>More information about this error may be available in the server error log.</p> <hr> <address>Apache/2.2.3 (Red Hat) Server at gmoc-db2.grnoc.iu.edu Port 443</address> </body></html>
These measurements worked before under 1.1.0, and nothing is jumping out at me.
Change History (2)
comment:1 Changed 12 years ago by
comment:2 Changed 12 years ago by
Resolution: | → duplicate |
---|---|
Status: | new → closed |
Yep, when i remove all sliver and datapath measurements, submission succeeds. So this is a duplicate of 136.
Note: See
TracTickets for help on using
tickets.
Oh, hah, never mind: of course, this is because it's recursively submitting the resource data too, and i bet 136 is still an issue. Let me remove all resource measurements and verify that that works.