PM - myisamchk: [ERROR] unknown variable 'read_buffer=2M'

book

Article ID: 211885

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration

Issue/Introduction

We are facing the issue described in "Can't launch CAPC URL" tech doc:
https://knowledge.broadcom.com/external/article/46055/cant-launch-capc-url.html

However after running the command to repair the database tables we get the following error:

[[email protected]]# myisamchk --recover /opt/ca/MySql/data/netqosportal/*.MYI
myisamchk: [ERROR] unknown variable 'read_buffer=2M'

Environment

Any release

Resolution

In order to address this issue please try the folowing:

1) Run below commands:

mysqlcheck -uroot -p -c netqosportal
mysqlcheck -uroot -p -c em
mysqlcheck -uroot -p -r netqosportal

Note: It will prompt you to the mysql password.

") Start the CAPC services and try to login into CAPC