Problem with populating mysql tables
Andreas Davour
I just did this:
cfs-l> t
Available tables for cfs-l:
Table Name Row Count
EVENT_DATA 0
EVENT_INFO 0
FILESYSTEM_AGGREGATE_DAY 189
FILESYSTEM_AGGREGATE_HOUR 4347
FILESYSTEM_AGGREGATE_MONTH 18
FILESYSTEM_AGGREGATE_WEEK 36
FILESYSTEM_AGGREGATE_YEAR 9
FILESYSTEM_INFO 1
MDS_AGGREGATE_DAY 105
MDS_AGGREGATE_HOUR 2415
MDS_AGGREGATE_MONTH 10
MDS_AGGREGATE_WEEK 20
MDS_AGGREGATE_YEAR 5
MDS_DATA 347090
MDS_INFO 1
MDS_OPS_DATA 7289898
MDS_VARIABLE_INFO 7
OPERATION_INFO 81
OSS_DATA 607886
OSS_INFO 2
OSS_INTERFACE_DATA 0
OSS_INTERFACE_INFO 0
OSS_VARIABLE_INFO 7
OST_AGGREGATE_DAY 999
OST_AGGREGATE_HOUR 22869
OST_AGGREGATE_MONTH 81
OST_AGGREGATE_WEEK 189
OST_AGGREGATE_YEAR 54
OST_DATA 1823554
OST_INFO 6
OST_OPS_DATA 0
OST_VARIABLE_INFO 11
ROUTER_AGGREGATE_DAY 0
ROUTER_AGGREGATE_HOUR 0
ROUTER_AGGREGATE_MONTH 0
ROUTER_AGGREGATE_WEEK 0
ROUTER_AGGREGATE_YEAR 0
ROUTER_DATA 0
ROUTER_INFO 0
ROUTER_VARIABLE_INFO 4
TIMESTAMP_INFO 392083
VERSION 0
Note that some tables seem to be empty? Should they? The aggregator script
runs every 20 minutes and have been for a few weeks now.
/andreas
--
Systems Engineer
PDC Center for High Performance Computing
CSC School of Computer Science and Communication
KTH Royal Institute of Technology
SE-100 44 Stockholm, Sweden
Phone: 087906658
"A satellite, an earring, and a dust bunny are what made America great!"
Jim Garlick
Sorry for the delay. I suspect this is not a problem, but I opened it
as issue 54 for further investigation:
http://code.google.com/p/lmt/issues/detail?id=54
Jim
> --
> You received this message because you are subscribed to the Google Groups "lmt-discuss" group.
> To post to this group, send email to lmt-d...@googlegroups.com.
> To unsubscribe from this group, send email to lmt-discuss...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/lmt-discuss?hl=en.
Andreas Davour
> Andreas,
>
> Sorry for the delay. I suspect this is not a problem, but I opened it
> as issue 54 for further investigation:
> http://code.google.com/p/lmt/issues/detail?id=54
I still have zero records for some tables. I have no idea if I should have. I
realized that some data from cerebro might give a hint, but I'm not able to
parse the output:
From the mngm node:
# cerebro-stat -n -t -m lmt_mdt
MODULE DIR = /usr/lib64/cerebro
cfs-mds-mgs-l.pdc.kth.se(2011-03-22 01:25:57pm): 1;cfs-mds-mgs-
l.pdc.kth.se;0.000000;65.581799;cfs-l-
MDT0000;2984762;3007075;11939048;12428964;45875140;0;0;21142834;0;0;376;0;0;220;0;0;12839586;0;0;70030;0;0;133786;0;0;934842;0;0;10994;0;0;1;0;0;16;0;0;0;0;0;10;0;0;3371301;0;0;202;0;0;195;0;0;10929839;0;0;63960772;0;0;6;0;0;31;0;0;24;0;0
# cerebro-stat -n -t -m lmt_ost
MODULE DIR = /usr/lib64/cerebro
cfs-oss-l-3.pdc.kth.se(2011-02-25 02:16:55pm): 2;cfs-oss-
l-3.pdc.kth.se;9.754877;92.968581;cfs-l-
OST0003;406868729;406872064;5628308332;6407757804;2540981148949;1352412923748;7257492;8;704;1;0;18;1;COMPLETE
1/1 0s remaining;cfs-l-
OST0004;406868850;406872064;5209074208;6407757820;3780626629355;1671297507834;8781514;8;746;1;0;18;1;COMPLETE
1/1 0s remaining;cfs-l-
OST0005;406868596;406872064;4881443844;6407763320;4211128046730;2232296858352;9474383;8;729;1;0;18;1;COMPLETE
1/1 0s remaining;
cfs-oss-l-4.pdc.kth.se(2011-03-22 01:33:06pm): 2;cfs-oss-
l-4.pdc.kth.se;0.049950;67.330178;cfs-l-
OST0000;406867569;406872064;5395772504;6407757804;2734003439109;1769990952303;8011774;8;753;0;0;18;1;COMPLETE
1/1 0s remaining;cfs-l-
OST0001;406867404;406872064;5418263168;6407757820;3707337514405;1801143177878;8908332;8;824;0;0;18;1;COMPLETE
1/1 0s remaining;cfs-l-
OST0002;406867112;406872064;5666907904;6407763320;2051650819332;1335871857257;6983619;8;757;0;0;18;1;COMPLETE
1/1 0s remaining;
# cerebro-stat -n -t -m lmt_osc
MODULE DIR = /usr/lib64/cerebro
cfs-mds-mgs-l.pdc.kth.se(2011-03-22 01:33:42pm): 1;cfs-mds-mgs-
l.pdc.kth.se;cfs-l-OST0000;F;cfs-l-OST0001;F;cfs-l-OST0002;F;cfs-l-
OST0003;F;cfs-l-OST0004;F;cfs-l-OST0005;F
I have no idea what those "F" means.