SQL Update

P

peterle1984

Member
Hallo,

Ich habe ein Upgrade für MySQL von 5.5 auf 5.6 gemacht aber leider hat es nicht geklappt :-(

Was habe ich falsch gemacht ?
und wie kann ich das reparieren ?

HTML: 
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.50-1.el7_2 for package:                                                                                                                      1:mariadb-devel-5.5.50-1.el7_2.x86_64
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server >= 5.0.60 for package: plesk-mysql-ser                                                                                                                     ver-17.0.17-cos7.build1700161005.19.x86_64
--> Processing Dependency: mariadb-server >= 5.0.60 for package: plesk-mysql-ser                                                                                                                     ver-17.0.17-cos7.build1700161005.19.x86_64
---> Package mysql-community-libs.x86_64 0:5.6.34-2.el6 will be obsoleting
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-devel for package: plesk-gems-pre-0.0.1-cento                                                                                                                     s7.16102516.x86_64
Package mariadb-devel is obsoleted by mysql-community-devel, but obsoleting pack                                                                                                                     age does not provide for requirements
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server >= 5.0.60 for package: plesk-mysql-ser                                                                                                                     ver-17.0.17-cos7.build1700161005.19.x86_64
--> Processing Dependency: mariadb-server >= 5.0.60 for package: plesk-mysql-ser                                                                                                                     ver-17.0.17-cos7.build1700161005.19.x86_64
---> Package mysql-community-devel.x86_64 0:5.6.34-2.el6 will be obsoleting
--> Finished Dependency Resolution
Error: Package: plesk-mysql-server-17.0.17-cos7.build1700161005.19.x86_64 (@PLES                                                                                                                     K_17_0_17-dist)
           Requires: mariadb-server >= 5.0.60
           Removing: 1:mariadb-server-5.5.50-1.el7_2.x86_64 (@updates)
               mariadb-server = 1:5.5.50-1.el7_2
           Obsoleted By: mysql-community-server-5.6.34-2.el6.x86_64 (mysql56-com                                                                                                                     munity)
               Not found
           Available: 1:mariadb-server-5.5.44-2.el7.centos.x86_64 (base)
               mariadb-server = 1:5.5.44-2.el7.centos
           Available: 1:mariadb-server-5.5.47-1.el7_2.x86_64 (updates)
               mariadb-server = 1:5.5.47-1.el7_2
Error: Package: plesk-gems-pre-0.0.1-centos7.16102516.x86_64 (@PLESK_17_0_17-dis                                                                                                                     t)
           Requires: mariadb-devel
           Removing: 1:mariadb-devel-5.5.50-1.el7_2.x86_64 (@updates)
               mariadb-devel = 1:5.5.50-1.el7_2
           Obsoleted By: mysql-community-devel-5.6.34-2.el6.x86_64 (mysql56-comm                                                                                                                     unity)
               Not found
           Available: 1:mariadb-devel-5.5.44-2.el7.centos.i686 (base)
               mariadb-devel = 1:5.5.44-2.el7.centos
           Available: 1:mariadb-devel-5.5.47-1.el7_2.i686 (updates)
               mariadb-devel = 1:5.5.47-1.el7_2
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@baby-lala ~]# ^C
[root@baby-lala ~]# clear
[root@baby-lala ~]# yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.daniel-jost.net
 * epel: mirror.daniel-jost.net
 * extras: mirror.daniel-jost.net
 * updates: mirror.daniel-jost.net
Resolving Dependencies
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.50-1.el7_2 will be obsoleted
---> Package mariadb-devel.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-devel for package: plesk-gems-pre-0.0.1-centos7.16102516.x86_64
Package mariadb-devel is obsoleted by mysql-community-devel, but obsoleting package does not provide for requirements
---> Package mariadb-libs.x86_64 1:5.5.50-1.el7_2 will be obsoleted
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server >= 5.0.60 for package: plesk-mysql-server-17.0.17-cos7.build1700161005.19.x86_64
--> Processing Dependency: mariadb-server >= 5.0.60 for package: plesk-mysql-server-17.0.17-cos7.build1700161005.19.x86_64
---> Package mysql-community-client.x86_64 0:5.6.34-2.el6 will be obsoleting
---> Package mysql-community-devel.x86_64 0:5.6.34-2.el6 will be obsoleting
---> Package mysql-community-libs.x86_64 0:5.6.34-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) >= 5.6.10 for package: mysql-community-libs-5.6.34-2.el6.x86_64
---> Package mysql-community-server.x86_64 0:5.6.34-2.el6 will be obsoleting
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-devel for package: plesk-gems-pre-0.0.1-centos7.16102516.x86_64
Package mariadb-devel is obsoleted by mysql-community-devel, but obsoleting package does not provide for requirements
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server >= 5.0.60 for package: plesk-mysql-server-17.0.17-cos7.build1700161005.19.x86_64
--> Processing Dependency: mariadb-server >= 5.0.60 for package: plesk-mysql-server-17.0.17-cos7.build1700161005.19.x86_64
---> Package mysql-community-common.x86_64 0:5.6.34-2.el6 will be installed
--> Finished Dependency Resolution
Error: Package: plesk-mysql-server-17.0.17-cos7.build1700161005.19.x86_64 (@PLESK_17_0_17-dist)
           Requires: mariadb-server >= 5.0.60
           Removing: 1:mariadb-server-5.5.50-1.el7_2.x86_64 (@updates)
               mariadb-server = 1:5.5.50-1.el7_2
           Obsoleted By: mysql-community-server-5.6.34-2.el6.x86_64 (mysql56-community)
               Not found
           Available: 1:mariadb-server-5.5.44-2.el7.centos.x86_64 (base)
               mariadb-server = 1:5.5.44-2.el7.centos
           Available: 1:mariadb-server-5.5.47-1.el7_2.x86_64 (updates)
               mariadb-server = 1:5.5.47-1.el7_2
Error: Package: plesk-gems-pre-0.0.1-centos7.16102516.x86_64 (@PLESK_17_0_17-dist)
           Requires: mariadb-devel
           Removing: 1:mariadb-devel-5.5.50-1.el7_2.x86_64 (@updates)
               mariadb-devel = 1:5.5.50-1.el7_2
           Obsoleted By: mysql-community-devel-5.6.34-2.el6.x86_64 (mysql56-community)
               Not found
           Available: 1:mariadb-devel-5.5.44-2.el7.centos.i686 (base)
               mariadb-devel = 1:5.5.44-2.el7.centos
           Available: 1:mariadb-devel-5.5.47-1.el7_2.i686 (updates)
               mariadb-devel = 1:5.5.47-1.el7_2
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
 
peterle1984 said:
Ich habe ein Upgrade für MySQL von 5.5 auf 5.6 gemacht aber leider hat es nicht geklappt :-(
Click to expand...
Sieht aber eher nach Upgrade von MySQL auf MariaDB aus.
Was war denn die Befehlszeile zum Upgraden? Die Ausgangssituation ist unklar.

Auf den ersten Blick sieht das nach einen Plesk unter CentOS aus.
Spotan würde ich auf einen Mix von Repositories tippen. Da tauchen Centos6 und Centos7 Pakete auf.

Ist das System CentOS 6 oder CentOS 7? Welche Pleskversion? Und was wurde gemacht?
 
Last edited by a moderator:
peterle1984 said:
Ich habe die Install mit # yum install http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm gemacht und mit yum update
und dann hat das Problem begonnen.
Click to expand...
Woher hast Du die Idee ein Paket direkt von MySQL.com zu installieren?
Zumal es das Paket für CentOS 6 ist.

Unter CentOS 7 wird standardmäßig MariaDB eingesetzt.
Daher dürftest Du MariaDB 5.5 laufen gehabt haben und nicht MySQL.
In Plesk wird das dann scheinbar als MySQL angezeigt.
Vgl. https://kb.plesk.com/en/129113

Also das MySQL Paket wieder deinstallieren. Alles was unter (mysql56-community) reingekommen ist, muss wieder raus. Mit dem Mischmasch wird es nicht mehr sauber laufen.
 
You must log in or register to reply here.
Back
Top