#42625 [Com]: When mysql and mysqli enabled both together, php CLI hangs when ZTS is enabled
dirk at bean-it dot nl
Comment by: dirk at bean-it dot nl
Reported By: jama at mk dot cvut dot cz
Status: Assigned
Bug Type: MySQL related
Operating System: Gentoo/Linux
PHP Version: 5.2.4
Assigned To: andrey
New Comment:
I'll have to get back on my previous post, it also happens on i686 :-(
So, when I enable mysql & mysqli, this results in a non working php.
(./configure --with-mysqli=/usr/bin/mysql_config --with-mysql=/usr)
Just enabling mysql or mysqli works fine.
(./configure --with-mysqli=/usr/bin/mysql_config) or (./configure
--with-mysql=/usr)
I've compared the mysql libs version on the i686 machines (one does
compile a good php, one doesn't) and they are the same.
Previous Comments:
------------------------------------------------------------------------
[2007-11-21 19:47:12] dirk at bean-it dot nl
I'm experiencing the same problem, but my 2 cents tell me this is only
happening on amd64 + mysql + mysqli. My various i386 systems, build with
the same configure options have no problems at all. Leaving mysql or
mysqli option out results in a fine working php. Enabling them both
results in a broken php (ie, no prompt is returned in the cli, and the
apache modules works extremely crappy, since tons of new apaches are
started and they all hang).
The problem still exists in 5.2.5 and was not in there 5.2.3.
I run Debian 4.0 (x86_64 GNU/Linux) on all systems, with stock kernels
(2.6.18)
I'm happy to provide more info, if necessary. Or to post a new bug, if
you think this is more appropriate...
------------------------------------------------------------------------
[2007-10-05 12:22:29] jama at mk dot cvut dot cz
I have updated mysql to:
mysql_config --version
5.1.22-rc
Downloaded new snapshots and new report seems OK for php..
./test.report.sh
php-5.2.4.log
OK php-5.2.4-mysqli ./configure --disable-all --enable-maintainer-zts
--with-mysqli=/usr/bin/mysql_config
OK php-5.2.4-mysqli-mysql ./configure --disable-all
--enable-maintainer-zts --with-mysql=/usr
--with-mysqli=/usr/bin/mysql_config
php5.2-200710051030.log
OK php5.2-200710051030-mysqli ./configure --disable-all
--enable-maintainer-zts --with-mysqli=/usr/bin/mysql_config
OK php5.2-200710051030-mysqli-mysql ./configure --disable-all
--enable-maintainer-zts --with-mysql=/usr
--with-mysqli=/usr/bin/mysql_config
php6.0-200710051030.log
OK php6.0-200710051030-mysqli ./configure --disable-all
--enable-maintainer-zts --with-mysqli=/usr/bin/mysql_config
OK php6.0-200710051030-mysqli-mysql ./configure --disable-all
--enable-maintainer-zts --with-mysql=/usr
--with-mysqli=/usr/bin/mysql_config
OK php6.0-200710051030-mysqli-mysqlng ./configure --disable-all
--enable-maintainer-zts --with-mysql=mysql --with-mysqli=mysqlnd
------------------------------------------------------------------------
[2007-09-24 09:39:40] jama at mk dot cvut dot cz
tested on php6.0-200709240630
mysqli OK
mysql+mysqli BAD
mysql+mysqlng OK
I created simple bash script for building and testing php snapshots for
this bug.
It's on
http://pastebin.com/m68372238
Runned in this case as
". ./test.sh php6.0-200709240630.tar.bz2 php6.0-200709240630
php6.0-200709240630"
Manualy killed when php -i was hanging on second test and result looks
like this:
# cat php6.0-200709240630.log
OK php6.0-200709240630-mysqli ./configure --disable-all
--enable-maintainer-zts --with-mysqli=/usr/bin/mysql_config
BAD php6.0-200709240630-mysqli-mysql ./configure --disable-all
--enable-maintainer-zts --with-mysql=/usr
--with-mysqli=/usr/bin/mysql_config
OK php6.0-200709240630-mysqli-mysqlng ./configure --disable-all
--enable-maintainer-zts --with-mysql=mysql --with-mysqli=mysqlnd
------------------------------------------------------------------------
[2007-09-22 08:47:41] and...@php.net
Hi,
- can you try building PHP6?
- if still han gs, can you try building with mysqlnd (PHP6,
--with-mysqli=mysqlnd --with-mysql=mysql) and see if there is still a
problem
Andrey
------------------------------------------------------------------------
[2007-09-19 14:08:19] scot...@php.net
I can't reproduce with MySQL 5.1.22
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/42625
--
Edit this bug report at http://bugs.php.net/?id=42625&edit=1
dirk at bean-it dot nl
Comment by: dirk at bean-it dot nl
Reported By: jama at mk dot cvut dot cz
Status: Assigned
Bug Type: MySQL related
Operating System: Gentoo/Linux
PHP Version: 5.2.4
Assigned To: andrey
New Comment:
Here I am again... :-)
Debian posted updated for mysql-5 and it libs today. Installing this
resolves my issue, I have a working php 5.2.5 now.
Non working debian mysql-5 version:
ii libmysqlclient15-dev 5.0.32-7etch1
ii libmysqlclient15off 5.0.32-7etch1
Working:
ii libmysqlclient15-dev 5.0.32-7etch3
ii libmysqlclient15off 5.0.32-7etch3
Cheers,
Dirk
Previous Comments:
------------------------------------------------------------------------
[2007-11-26 15:53:00] dirk at bean-it dot nl
I'll have to get back on my previous post, it also happens on i686 :-(
So, when I enable mysql & mysqli, this results in a non working php.
(./configure --with-mysqli=/usr/bin/mysql_config --with-mysql=/usr)
Just enabling mysql or mysqli works fine.
(./configure --with-mysqli=/usr/bin/mysql_config) or (./configure
--with-mysql=/usr)
I've compared the mysql libs version on the i686 machines (one does
compile a good php, one doesn't) and they are the same.
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
Andrey
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view