ANM 5.2.1 (0) no historical data available

[renekrueger]

Hi guys,

we use ANM 5.2.1(0) virtual appliance on our setup. Now I would like to graph historical data (e.g. realserver statistics conn/sec) . The output of request is "No data is available for the selected time range " ( 1hours). I can see "real time" data only.

How can I analyze if data available on disk? In which location?

Thanks for your help

Kind regards

René Krüger

[chrhiggi · Accepted solution]

Hello Rene!

Sounds like the DB could be corrupt - which is easily fixable!  The files are stored in a mysql database under /var/lib/anm/mysql/dcm_ems. If you have ANM installed on redhat, you can do this yourself.  If it is installed as an OVA image, you will need a TAC engineer to execute this process for you.

/* Stop ANM */

# /opt/CSCOanm/bin/anm-tool stop

/* Change Directory to Mysql Database */

#cd /var/lib/anm/mysql/dcm_ems/

/* Check Database "dcm_ems" */

#/opt/CSCOanm/mysql/bin/myisamchk -s *.MYI

This is what a corrupt table looks like when it is found:

myisamchk: MyISAM file stats_csm_slb_stat_raw.MYI

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 client is using or hasn't closed the table properly

myisamchk: error: Found 8863 keys of 8864

MyISAM-table 'stats_csm_slb_stat_raw.MYI' is corrupted

Fix it using switch "-r" or "-o"

myisamchk: MyISAM file stats_global_real_server_raw.MYI

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 client is using or hasn't closed the table properly

myisamchk: error: Found 445844 keys of 445846

MyISAM-table 'stats_global_real_server_raw.MYI' is corrupted

Fix it using switch "-r" or "-o"

myisamchk: MyISAM file stats_interface_raw.MYI

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 client is using or hasn't closed the table properly

myisamchk: error: Found 23953 keys of 23954

MyISAM-table 'stats_interface_raw.MYI' is corrupted

Fix it using switch "-r" or "-o"

myisamchk: MyISAM file stats_real_server_raw.MYI

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 client is using or hasn't closed the table properly

myisamchk: error: Found 474572 keys of 474575

MyISAM-table 'stats_real_server_raw.MYI' is corrupted

Fix it using switch "-r" or "-o"

myisamchk: MyISAM file stats_resource_usage_raw.MYI

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 client is using or hasn't closed the table properly

myisamchk: error: Invalid key block position: 292171025846016487  key block size: 1024

file_length: 6983680

myisamchk: error: key delete-link-chain corrupted

MyISAM-table 'stats_resource_usage_raw.MYI' is corrupted

Fix it using switch "-r" or "-o"

myisamchk: MyISAM file stats_slb_stat_raw.MYI

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 client is using or hasn't closed the table properly

myisamchk: error: Found 8702 keys of 8703

MyISAM-table 'stats_slb_stat_raw.MYI' is corrupted

Fix it using switch "-r" or "-o"

myisamchk: MyISAM file stats_virtual_server_raw.MYI

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 client is using or hasn't closed the table properly

myisamchk: error: Key in wrong position at page 2015232

MyISAM-table 'stats_virtual_server_raw.MYI' is corrupted

Fix it using switch "-r" or "-o"

myisamchk: MyISAM file X_EVENTRATE.MYI

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 client is using or hasn't closed the table properly

/opt/CSCOanm/mysql/bin/myisamchk: Unknown error 126

myisamchk: error: Can't read key from filepos: 1693696

MyISAM-table 'X_EVENTRATE.MYI' is corrupted

Fix it using switch "-r" or "-o"

To repair it:

#/opt/CSCOanm/mysql/bin/myisamchk -s -r *.MYI

#/opt/CSCOanm/mysql/bin/myisamchk -s *.MYI

/* Restart ANM */

# /opt/CSCOanm/bin/anm-tool start

Regards,

Chris Higgins

[renekrueger]

Hello Christopher,

thanks for your answer. I have installed an OVA image. Okay, I must open a TAC request for analyze the problem. Thanks!

Regards, René