Re: Percona 5.5 on CentOS 5.8

[Olivier Doucet]

Hi,


> 120829 10:42:48 [Note] Flashcache bypass: disabled
> 120829 10:42:48 [Note] Flashcache setup error is : ioctl failed

This can be safely ignored.


> ERROR: 1136 Column count doesn't match value count at row 1
> 120829 10:42:49 [ERROR] Aborting

mysql_upgrade was needed.


> $ mysql_upgrade -u root -p


> error : Table upgrade required. Please do "REPAIR TABLE `consumer`" or
> dump/reload to fix it!


Execute following command :
mysqlcheck -uroot -a -p -v --all-databases


> I extracted Percona-Server-server-55-5.5.27-rel28.0.291.rhel5.x86_64.rpm
> file and the my.cnf file was not present there either.

You can generate one here :
https://tools.percona.com/

Olivier

[dimka]

Thank you Olivier for the quick reply

On Wednesday, August 29, 2012 6:42:03 PM UTC+3, Olivier Doucet wrote:

Hi,


> 120829 10:42:48 [Note] Flashcache bypass: disabled
> 120829 10:42:48 [Note] Flashcache setup error is : ioctl failed

This can be safely ignored.


> ERROR: 1136  Column count doesn't match value count at row 1
> 120829 10:42:49 [ERROR] Aborting

mysql_upgrade was needed.


> $ mysql_upgrade -u root -p


> error    : Table upgrade required. Please do "REPAIR TABLE `consumer`" or
> dump/reload to fix it!


Execute following command :
mysqlcheck -uroot -a -p -v --all-databases

I ve executed the command you instructed and for the tables that was giving me a warning I now get.

cMyDB.consumer                   Table is already up to date



 

> I extracted Percona-Server-server-55-5.5.27-rel28.0.291.rhel5.x86_64.rpm
> file and the my.cnf file was not present there either.

You can generate one here :
https://tools.percona.com/

Olivier

Again thank you very much

Dimos