Mysql yum update error

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
DarkF@der
Forum Regular
Forum Regular
Posts: 313
Joined: Thu May 07, 2009 12:46 pm

Mysql yum update error

Unread post by DarkF@der »

Hello,

Can somebody help me with this.
I can't update mysql anymore i got this error on yum:

Code: Select all

[xxxxxxxx@xxxxxx]# yum -y upgrade mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: www6.atomicorp.com
 * base: centos.mirror.triple-it.nl
 * extras: centos.mirror.triple-it.nl
 * updates: centos.mirror.triple-it.nl
Setting up Upgrade Process
Resolving Dependencies
--> Running transaction check
--> Processing Dependency: mysql = 5.1.58-2.el5.art for package: mysql-server
--> Processing Dependency: mysql = 5.1.58-2.el5.art for package: mysql-libs
---> Package mysql.x86_64 0:5.1.59-1.el5.art set to be updated
--> Running transaction check
---> Package mysql.i386 0:5.1.58-2.el5.art set to be updated
--> Processing Dependency: libmysqlclient_r.so.16 for package: mysql
--> Processing Dependency: libmysqlclient.so.16 for package: mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: mysql
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16) for package: mysql
---> Package mysql-server.x86_64 0:5.1.59-1.el5.art set to be updated
--> Running transaction check
---> Package mysql-libs.i386 0:5.1.59-1.el5.art set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
 Package                                   Arch                                Version                                        Repository                           Size
========================================================================================================================================================================
Updating:
 mysql                                     x86_64                              5.1.59-1.el5.art                               atomic                              4.2 M
Installing for dependencies:
 mysql                                     i386                                5.1.58-2.el5.art                               atomic                              4.2 M
 mysql-libs                                i386                                5.1.59-1.el5.art                               atomic                              2.1 M
Updating for dependencies:
 mysql-server                              x86_64                              5.1.59-1.el5.art                               atomic                               11 M

Transaction Summary
========================================================================================================================================================================
Install       2 Package(s)
Upgrade       2 Package(s)

Total size: 22 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test


Transaction Check Error:
  file /usr/share/mysql/charsets/cp1251.xml from install of mysql-libs-5.1.59-1.el5.art.i386 conflicts with file from package mysql-libs-5.1.58-2.el5.art.x86_64

Error Summary
-------------
[xxxxxx@xxxxxxx]# rpm -qa | grep mysql


Code: Select all

[root@astrahost darkfader]# rpm -qa | grep mysql
php-mysql-5.3.8-1.el5.art
mysqlclient15-5.0.90-1.el5.art
mysql-server-5.1.58-2.el5.art
ruby-mysql-2.7-200705221357
mysqltuner-1.2.0-1.el5.art
mysql-5.1.58-2.el5.art
asl-php-mysql-5.2.17-1.el5.art
mysql-libs-5.1.58-2.el5.art
mysql-connector-odbc-3.51.26r1127-1.el5
mysql-libs-5.1.59-1.el5.art

I really like to update.
Any help will be appreciated.

Thanx in advanced
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Mysql yum update error

Unread post by scott »

looks like youve got both the i386 & x86_64 packages on there for some reason. Just use yum update mysql.x86_64 when that happens

Also search is your friend... this has been answered before
DarkF@der
Forum Regular
Forum Regular
Posts: 313
Joined: Thu May 07, 2009 12:46 pm

Re: Mysql yum update error

Unread post by DarkF@der »

scott wrote:looks like youve got both the i386 & x86_64 packages on there for some reason. Just use yum update mysql.x86_64 when that happens

Also search is your friend... this has been answered before
Thanx scott for the feedback i searched allready tryed any thing what i have founded on this form:

Code: Select all

 yum update mysql.x86_64


Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: www6.atomicorp.com
 * base: centos.mirror.triple-it.nl
 * extras: centos.mirror.triple-it.nl
 * updates: centos.mirror.triple-it.nl
Setting up Update Process
Resolving Dependencies
--> Running transaction check
--> Processing Dependency: mysql = 5.1.58-2.el5.art for package: mysql-server
--> Processing Dependency: mysql = 5.1.58-2.el5.art for package: mysql-libs
---> Package mysql.x86_64 0:5.1.59-1.el5.art set to be updated
--> Running transaction check
---> Package mysql.i386 0:5.1.58-2.el5.art set to be updated
--> Processing Dependency: libmysqlclient_r.so.16 for package: mysql
--> Processing Dependency: libmysqlclient.so.16 for package: mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: mysql
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16) for package: mysql
---> Package mysql-server.x86_64 0:5.1.59-1.el5.art set to be updated
--> Running transaction check
---> Package mysql-libs.i386 0:5.1.59-1.el5.art set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package             Arch          Version                  Repository     Size
================================================================================
Updating:
 mysql               x86_64        5.1.59-1.el5.art         atomic        4.2 M
Installing for dependencies:
 mysql               i386          5.1.58-2.el5.art         atomic        4.2 M
 mysql-libs          i386          5.1.59-1.el5.art         atomic        2.1 M
Updating for dependencies:
 mysql-server        x86_64        5.1.59-1.el5.art         atomic         11 M

Transaction Summary
================================================================================
Install       2 Package(s)
Upgrade       2 Package(s)

Total size: 22 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test


Transaction Check Error:
  file /usr/share/mysql/charsets/cp1251.xml from install of mysql-libs-5.1.59-1.el5.art.i386 conflicts with file from package mysql-libs-5.1.58-2.el5.art.x86_64

Error Summary
-------------
But with no luck
User avatar
mikeshinn
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 4149
Joined: Thu Feb 07, 2008 7:49 pm
Location: Chantilly, VA

Re: Mysql yum update error

Unread post by mikeshinn »

Did you remove the 32 bit version? You have both the 64 bit and 32 bit versions installed, and you really should only have one.
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Mysql yum update error

Unread post by scott »

Every time I feel compelled to answer this question, I think about this:

http://www.youtube.com/watch?v=piVnArp9ZE0
DarkF@der
Forum Regular
Forum Regular
Posts: 313
Joined: Thu May 07, 2009 12:46 pm

Re: Mysql yum update error

Unread post by DarkF@der »

Thanx for helping i was a lillte bit scared to remove packages without break mysql.
but your right after removing it i works.

Thanx for the info.
User avatar
mikeshinn
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 4149
Joined: Thu Feb 07, 2008 7:49 pm
Location: Chantilly, VA

Re: Mysql yum update error

Unread post by mikeshinn »

Hurray! Our pleasure. :-)
kingemissary
New Forum User
New Forum User
Posts: 1
Joined: Thu Feb 09, 2012 9:03 pm
Location: london

Re: Mysql yum update error

Unread post by kingemissary »

I have

[root@s15830902 ~]# rpm -qa | grep mysql
mysqlclient15-5.0.90-1.el5.art
mysql-server-5.5.17-2.el5.art
mysql-5.5.20-2.el5.art
php-mysql-5.3.10-5.el5.art
mysql-libs-5.5.20-2.el5.art
mysql-server-5.5.20-2.el5.art

and I have problems starting mysqld

can I yum remove mysql-server and the databases stay intact?
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Mysql yum update error

Unread post by scott »

Sure, just make sure nothing else has dependencies on it.
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: Mysql yum update error

Unread post by faris »

Remove the line that talks about "skip-bdb" from my.cnf and mysql will start OK

In 5.5., things changes from 5.1.x and that line kills it.

It could be something else, but that's my guess. There's an article in the Atomic wiki http://www.atomicorp.com/wiki/index.php/Mysql

Really hope this helps. I know it is horrible to be in this situation. Sorry if your prob is not related to this.

Remember to run the mysql_upgrade script afterwards.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Re: Mysql yum update error

Unread post by breun »

faris wrote:Remove the line that talks about "skip-bdb" from my.cnf and mysql will start OK

In 5.5., things changes from 5.1.x and that line kills it.

It could be something else, but that's my guess.
Instead of guessing I recommend checking /var/log/mysqld.log :)
Lemonbit Internet Dedicated Server Management
Post Reply