ID: 42625
Comment by: s dot s at terra dot com dot br
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:
Same problem since PHP 5.2.3.
My site configuration:
Distro: Slackware Linux 11.0 (will upgrade to 12.0 soon)
# httpd -v
Server version: Apache/2.2.6 (Unix)
Server built: Dec 9 2007 18:54:29
# php -v
PHP 5.2.5 (cli) (built: Dec 9 2007 21:25:26)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
# /usr/local/mysql/bin/mysql_config --version
5.0.41
-------------------------------
PHP and Apache was compiled by me.
MySQL is the default pre-compiled distribution from MySQL.com web
site.
Strace output on cli mode:
lstat64("/root", {st_mode=S_IFDIR|0710, st_size=1176, ...}) = 0
lstat64("/root/-", 0xbfcb65fc) = -1 ENOENT (No such file or
directory)
ioctl(0, SNDCTL_TMR_TIMEBASE or TCGETS, {B38400 opost isig icanon echo
...}) = 0
fstat64(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0xb7fbe000
read(0, "", 1024) = 0
close(0) = 0
munmap(0xb7fbe000, 4096) = 0
munmap(0xb7599000, 266240) = 0
mmap2(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
-1, 0) = 0xb7599000
setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={0, 0}}, NULL) =
0
gettimeofday({1199684414, 364083}, NULL) = 0
gettimeofday({1199684414, 365349}, NULL) = 0
futex(0xb7f655c0, FUTEX_WAIT, 2, NULL <unfinished ...>
p.s. Why it searches for a file called "-" on the current directory???
(see second lstat64)
Previous Comments:
------------------------------------------------------------------------
[2007-11-27 12:29:45] dirk at bean-it dot nl
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
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
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
