ID: 42625
Comment by: kalle at addikti dot net
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:
Hello,
And one more thing.
If I compile PHP without path to apxs the CLI will work.
example: ./sapi/cli/php -v
Previous Comments:
------------------------------------------------------------------------
[2008-03-04 09:06:54] kalle at addikti dot net
Hello,
Has someone solve this problem?
I just run to it, but I got little different opinion what is causing
this. Or im 100% sure that problem is not mysql AND mysqli compiled same
time.
I have two identical server's
OS: Debian Etch
MySQL_config: 5.0.32
PHP 5.2.5
Bought server's PHP has compiled with same options..
'./configure' \
'--includedir=/usr/include' \
'--prefix=/home/pete/wwwroot/php' \
'--with-apxs2=/home/pete/wwwroot/bin/apxs' \
'--with-config-file-path=/home/pete/wwwroot/php' \
'--with-mysql=/usr' \
'--with-pgsql' \
'--with-openssl' \
'--with-imap' \
'--with-imap-ssl' \
'--with-xpm-dir' \
'--with-mysqli=/usr/bin/mysql_config' \
'--enable-exif' \
'--enable-ftp' \
'--with-kerberos' \
'--with-mcrypt' \
'--with-gd' \
'--with-jpeg-dir=/usr/lib' \
'--with-png-dir=/usr/lib' \
'--with-mime-magic' \
'--with-zlib-dir=/usr/lib' \
'--with-pdo-mysql=/usr/bin/mysql_config' \
'--with-pdo-sqlite' \
'--with-xmlrpc' \
'--with-ttf' \
'--with-curl' \
'--with-mhash' \
'--enable-soap' \
'--enable-mbstring' \
'--enable-calendar' \
'--enable-gd-native-ttf' \
'--with-freetype-dir=/usr/src/freetype234' \
'--with-gettext' \
'--with-xsl' \
"$@"
Funny think is that this work on other server and not on other.
strace give me same error.
I have also tried this with 5.2.6-RC1.
It works on other and not on other.
So my opinion is that this is not directly PHP problem but it has
something to with some library??
Any help will be much pricieted.
------------------------------------------------------------------------
[2008-01-07 05:59:12] s dot s at terra dot com dot br
It seems a pthread version bug. Checking with gdb the result is:
Starting program: /usr/bin/php
[Thread debugging using libthread_db enabled]
[New Thread -1218722112 (LWP 24212)]
[New Thread -1219249232 (LWP 24215)]
[Thread -1219249232 (zombie) exited]
Program received signal SIGINT, Interrupt.
[Switching to Thread -1218722112 (LWP 24212)]
0xb7708fd9 in __lll_mutex_lock_wait () from /lib/tls/libpthread.so.0
And a backtrace:
(gdb) bt
#0 0xb7708fd9 in __lll_mutex_lock_wait () from
/lib/tls/libpthread.so.0
#1 0xb7706a64 in _L_mutex_lock_22 () from /lib/tls/libpthread.so.0
#2 0xb7fadaa0 in _dl_runtime_resolve () from /lib/ld-linux.so.2
#3 0xb7da51a1 in my_thread_global_end ()
from /usr/local/mysql/lib/libmysqlclient_r.so.15
#4 0xb7da51a1 in my_thread_global_end ()
from /usr/local/mysql/lib/libmysqlclient_r.so.15
#5 0xb7da10b5 in my_end () from
/usr/local/mysql/lib/libmysqlclient_r.so.15
#6 0xb7d9a27e in mysql_server_end ()
from /usr/local/mysql/lib/libmysqlclient_r.so.15
#7 0x081817eb in zm_shutdown_mysqli (type=1, module_number=23,
tsrm_ls=0x8600050)
at /usr/src/network/web/php-5.2.5/ext/mysqli/mysqli.c:676
#8 0x083236fe in module_destructor (module=0x863e220)
at /usr/src/network/web/php-5.2.5/Zend/zend_API.c:1916
#9 0x08329519 in zend_hash_apply_deleter (ht=0x85ffb80, p=0x863e1f0)
at /usr/src/network/web/php-5.2.5/Zend/zend_hash.c:611
#10 0x083295d7 in zend_hash_graceful_reverse_destroy (ht=0x85ffb80)
at /usr/src/network/web/php-5.2.5/Zend/zend_hash.c:646
#11 0x0831e4dd in zend_shutdown (tsrm_ls=0x8600050)
at /usr/src/network/web/php-5.2.5/Zend/zend.c:733
#12 0x082db92e in php_module_shutdown (tsrm_ls=0x8600050)
at /usr/src/network/web/php-5.2.5/main/main.c:1887
---Type <return> to continue, or q <return> to quit---
#13 0x083986b9 in main (argc=1, argv=0xbfc5d364)
at /usr/src/network/web/php-5.2.5/sapi/cli/php_cli.c:1335
------------------------------------------------------------------------
[2008-01-07 05:43:48] s dot s at terra dot com dot br
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)
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
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
