Resolved messs after update

[jfvdvelden]

Hi 2 all,

today i updated my server. first plesk to the latest version. Ans wen one of my websites (woo commerce) asked for a newer MySQL server i ran the update by the KB of plesk.

now mysql won't start anymore.

My mysqld isn't anymore in /var/init.d/mysqld

and this is installed:

[root@monitor ~]# yum list installed | grep mysql

mysql-community-client.x86_64 5.5.53-2.el6 @mysql55-community

mysql-community-common.x86_64 5.6.34-2.el6 @mysql56-community

mysql-community-libs.x86_64 5.6.34-2.el6 @mysql56-community

mysql-connector-odbc.x86_64 5.3.6-1.el6 @mysql-connectors-community

mysql57-community-release.noarch el6-7 @/mysql57-community-release-el6-7.noarch

mysqlclient16.x86_64 5.1.59-2.el6.art @atomic

php-mysql.x86_64 5.4.45-56.el6.art @atomic

plesk-php54-mysql.x86_64 5.4.45-centos6.16032517 @PLESK_17_PHP54

plesk-php55-mysql.x86_64 5.5.38-centos6.16072212 @PLESK_17_PHP55

plesk-php56-mysql.x86_64 5.6.28-centos6.16111112 @PLESK_17_PHP56

plesk-php70-mysql.x86_64 7.0.13-centos6.16111018 @PLESK_17_PHP70

[root@monitor ~]# yum list installed | grep -i mysql

mysql-community-client.x86_64 5.5.53-2.el6 @mysql55-community

mysql-community-common.x86_64 5.6.34-2.el6 @mysql56-community

mysql-community-libs.x86_64 5.6.34-2.el6 @mysql56-community

mysql-connector-odbc.x86_64 5.3.6-1.el6 @mysql-connectors-community

mysql57-community-release.noarch el6-7 @/mysql57-community-release-el6-7.noarch

mysqlclient16.x86_64 5.1.59-2.el6.art @atomic

perl-DBD-MySQL.x86_64 4.013-3.el6 @base

php-mysql.x86_64 5.4.45-56.el6.art @atomic

plesk-php54-mysql.x86_64 5.4.45-centos6.16032517 @PLESK_17_PHP54

plesk-php55-mysql.x86_64 5.5.38-centos6.16072212 @PLESK_17_PHP55

plesk-php56-mysql.x86_64 5.6.28-centos6.16111112 @PLESK_17_PHP56

plesk-php70-mysql.x86_64 7.0.13-centos6.16111018 @PLESK_17_PHP70

 

[UFHH01]

Hi jfvdvelden,

i ran the update by the KB of plesk.

... Could you pls. provide the information, WHICH KB - article you are referring to?

# yum list installed | grep -i mysql

mysql-community-client.x86_64 5.5.53-2.el6 @mysql55-community

mysql-community-common.x86_64 5.6.34-2.el6 @mysql56-community

mysql-community-libs.x86_64 5.6.34-2.el6 @mysql56-community

mysql-connector-odbc.x86_64 5.3.6-1.el6 @mysql-connectors-community

mysql57-community-release.noarch el6-7 @/mysql57-community-release-el6-7.noarch

mysqlclient16.x86_64 5.1.59-2.el6.art @atomic
...

You seem to mess up your packages here. Pls. try to follow STEP-BY-STEP the suggestions from for example:

How to upgrade MySQL 5.5 to 5.6 ( KB - article 127962 )​

 

[jfvdvelden]

i used this KB

https://kb.plesk.com/en/125589

and then section for centos 6.*

 

[jfvdvelden]

got mysql working again but stil got problems

mysqladmin -u root -p status

Enter password:

Uptime: 10405 Threads: 1 Questions: 2072 Slow queries: 0 Opens: 1314 Flush tables: 1 Open tables: 1169 Queries per second avg: 0.199

 

[jfvdvelden]

[root@monitor ~]# tail -f /var/log/mysqld.log

2016-11-18 09:13:10 27929 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure

2016-11-18 09:13:10 27929 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure

2016-11-18 09:13:10 27929 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure

2016-11-18 09:13:10 27929 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure

2016-11-18 09:13:10 27929 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure

2016-11-18 09:13:10 27929 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure

2016-11-18 09:13:10 27929 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure

2016-11-18 09:13:10 27929 [Note] Event Scheduler: Loaded 0 events

2016-11-18 09:13:10 27929 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.6.34' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

 

[jfvdvelden]

mysql must see de db files again.. in
/var/lib/mysql

but how?