Re: mysqld breaks yum, help?

Hi all. Thanks for reading and replying.

> That is weird.
> yum works just fine for me on CentOS 5.2 w/ MySQL
>
> Who's MySQL are you running? Did your php updates possibly replace the
> stock MySQL or alter /etc/my.cnf ?
>

Because the default CentOS repos don't have the latest versions of  
PHP5,  I am using is "Jason's Utter Ramblings Repo" @  
www.jasonlitka.com and the only files I pulled from it are:

php.i386  5.2.6-jason.1
php-bcmath.i386  5.2.6-jason.1
php-cli.i386  5.2.6-jason.1
php-common.i386   5.2.6-jason.1
php-gd.i386  5.2.6-jason.1
php-mbstring.i386  5.2.6-jason.1
php-mysql.i386  5.2.6-jason.1
php-pdo.i386  5.2.6-jason.1
php-pgsql.i386   5.2.6-jason.1

As for which version of mysql, I am using what I believe to be the  
the defaults:

$ rpm -q mysql mysql-server python
mysql-5.0.45-7.el5
mysql-server-5.0.45-7.el5
python-2.4.3-21.el5

$ yum list installed
mysql.i386  5.0.45-7.el5
mysql-server.i386  5.0.45-7.el5
python.i386  2.4.3-21.el5

> I'd look at your MySQL
> config. to see if it's starting an excessive number of threads or
> something else that's weird, as I've not heard of this problem (and I
> don't see how MySQL could directly affect yum).


My /etc/my.conf is as follows:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Can you suggest how I would find out  about excessive threads? I  
searched for hours but didn't come up with anything.

I'll re-iterate for good measure:  `yum list php` doesn't work if  
mysqld is turned on. If I do `/etc/init.d/mysqld stop` (or `services  
mysqld stop`), `yum list php` works fine. So it's only failing when  
mysqld is turned on. (?!) And only on some commands. For example `yum  
list installed` works all the time.

Here's the full error:

]$ yum list php
Loading "fastestmirror" plugin
Loading "priorities" plugin
Loading mirror speeds from cached hostfile
  * utterramblings: www.jasonlitka.com
Traceback (most recent call last):
   File "/usr/bin/yum", line 29, in ?
     yummain.main(sys.argv[1:])
   File "/usr/share/yum-cli/yummain.py", line 105, in main
     result, resultmsgs = base.doCommands()
   File "/usr/share/yum-cli/cli.py", line 289, in doCommands
     self._getTs()
   File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 85,  
in _getTs
     self._getTsInfo()
   File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 91,  
in _getTsInfo
     self._tsInfo.setDatabases(self.rpmdb, self.pkgSack)
   File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 537,  
in <lambda>
     pkgSack = property(fget=lambda self: self._getSacks(),
   File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 392,  
in _getSacks
     self.repos.populateSack(which=repos)
   File "/usr/lib/python2.4/site-packages/yum/repos.py", line 214, in  
populateSack
     self.doSetup()
   File "/usr/lib/python2.4/site-packages/yum/repos.py", line 66, in  
doSetup
     self.ayum.plugins.run('postreposetup')
   File "/usr/lib/python2.4/site-packages/yum/plugins.py", line 169,  
in run
     func(conduitcls(self, self.base, conf, **kwargs))
   File "/usr/lib/yum-plugins/fastestmirror.py", line 90, in  
postreposetup_hook
     repomirrors[str(repo)] = FastestMirror(repo.urls).get_mirrorlist()
   File "/usr/lib/yum-plugins/fastestmirror.py", line 142, in  
get_mirrorlist
     self._poll_mirrors()
   File "/usr/lib/yum-plugins/fastestmirror.py", line 155, in  
_poll_mirrors
     pollThread.start()
   File "/usr/lib/python2.4/threading.py", line 416, in start
     _start_new_thread(self.__bootstrap, ())
thread.error: can't start new thread

Other than installing packages using yum, and modified /etc/services  
and removed /etc/rpc for security reasons, nothing much has been done  
with this system. I'm at a loss to understand why it doesn't work  
when mysqld is turned on.

Any other ideas?

---
http://www.sux0r.org/

_______________________________________________
Yum mailing list
[email protected]
http://lists.baseurl.org/mailman/listinfo/yum