Debian Bug report logs - #397904
php5-mysql: apache2 segfaults on php shutdown in zm_startup_mysql

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Vladimir Stavrinov <vs@inist.ru>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: libapache2-mod-php5: apache segfault

Date: Wed, 08 Nov 2006 16:28:05 +0300

Package: libapache2-mod-php5
Version: 5.2.0-1
Severity: grave
Justification: renders package unusable


After upgrade child apache process segfault on every request.

-- System Information:
Debian Release: 4.0
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-1-k7
Locale: LANG=C, LC_CTYPE=ru_RU.KOI8-R (charmap=KOI8-R)

Versions of packages libapache2-mod-php5 depends on:
ii  apache2- 2.2.3-3                         Traditional model for Apache HTTPD
ii  apache2. 2.2.3-3                         Next generation, scalable, extenda
ii  libbz2-1 1.0.3-6                         high-quality block-sorting file co
ii  libc6    2.3.6.ds1-8                     GNU C Library: Shared libraries
ii  libcomer 1.39+1.40-WIP-2006.10.02+dfsg-2 common error description library
ii  libdb4.4 4.4.20-8                        Berkeley v4.4 Database Libraries [
ii  libkrb53 1.4.4-3                         MIT Kerberos runtime libraries
ii  libmagic 4.17-4                          File type determination library us
ii  libpcre3 6.7-1                           Perl 5 Compatible Regular Expressi
ii  libssl0. 0.9.8c-3                        SSL shared libraries
ii  libxml2  2.6.27.dfsg-1                   GNOME XML library
ii  mime-sup 3.37-1                          MIME files 'mime.types' & 'mailcap
ii  php5-com 5.2.0-1                         Common files for packages built fr
ii  ucf      2.0016                          Update Configuration File: preserv
ii  zlib1g   1:1.2.3-13                      compression library - runtime

libapache2-mod-php5 recommends no packages.

-- no debconf information

Message #12 received at 397625@bugs.debian.org (full text, mbox, reply):

From: Antoni Villalonga <antoni@friki.cat>

To: 397625@bugs.debian.org

Subject: me too

Date: Fri, 10 Nov 2006 00:14:20 +0100

[Message part 1 (text/plain, inline)]

Same 'Alien' problem here too.

I'm very confused. This is the minimal script that I can write to do a
segfault on php5.

Some functions are not used, but if I remove it the scripts 'magically'
works.

I don't know if it can help, because it's 63 lines length.

Bye

PD: Some times when I edit the file, it start to work, even if I revert
the script to this version. When I restart apache2 it start to segfault
again.

--

Antoni Villalonga Noceras
http://friki.cat

[test_mini.php.gz (application/gzip, inline)]

Message #17 received at 397625@bugs.debian.org (full text, mbox, reply):

From: Antoni Villalonga <antoni@friki.cat>

To: 397625@bugs.debian.org

Subject: Re: me too

Date: Fri, 10 Nov 2006 08:59:22 +0100

Hi!

I forget to say I'm using update packages (5.2.0-2 not 5.2.0-1). I think
it's not fixed at all.

Thanks.

Message #22 received at 397625@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: antoni@friki.cat, 397625@bugs.debian.org

Subject: Re: [php-maint] Bug#397625: me too

Date: Fri, 10 Nov 2006 09:19:00 +0100

Antoni Villalonga píše v Pá 10. 11. 2006 v 08:59 +0100:
> I forget to say I'm using update packages (5.2.0-2 not 5.2.0-1). I think
> it's not fixed at all.

Ok, could you provide backtrace?

(instructions included f.e. in #323773).

Ondrej.
-- 
Ondřej Surý <ondrej@sury.org>

Message #27 received at 397625@bugs.debian.org (full text, mbox, reply):

From: Daniel Franz <daniel2712@gmx.de>

To: 397625@bugs.debian.org

Subject: Re: [php-maint] Bug#397625: me too

Date: Fri, 10 Nov 2006 09:58:52 +0100

Same problem here.

My backtrace:
#0  0xb7b5685c in free () from /lib/i686/cmov/libc.so.6
#1  0xb6964f31 in my_no_flags_free () from /usr/lib/libmysqlclient.so.15
#2  0xb698ae7b in mysql_select_db () from /usr/lib/libmysqlclient.so.15
#3  0xb698b138 in mysql_close () from /usr/lib/libmysqlclient.so.15
#4  0xb6db1eee in zm_startup_mysql () from /usr/lib/php5/20060613/mysql.so
#5  0xb74fc723 in list_entry_destructor ()
  from /usr/lib/apache2/modules/libphp5.so
#6  0xb74f9738 in zend_hash_quick_find ()
  from /usr/lib/apache2/modules/libphp5.so
#7  0xb74f99d7 in zend_hash_graceful_reverse_destroy ()
  from /usr/lib/apache2/modules/libphp5.so
#8  0xb74fc56d in zend_destroy_rsrc_list ()
  from /usr/lib/apache2/modules/libphp5.so
#9  0xb74ef8af in zend_deactivate () from 
/usr/lib/apache2/modules/libphp5.so
#10 0xb74ab7fc in php_request_shutdown ()
  from /usr/lib/apache2/modules/libphp5.so
#11 0xb7572dac in php_ap2_register_hook ()
  from /usr/lib/apache2/modules/libphp5.so
#12 0x08074587 in ap_run_handler ()
#13 0x08077731 in ap_invoke_handler ()
#14 0x08084728 in ap_process_request ()
#15 0x080819ce in ap_register_input_filter ()
#16 0x0807b3c7 in ap_run_process_connection ()
#17 0x08088704 in ap_graceful_stop_signalled ()
#18 0x08088964 in ap_graceful_stop_signalled ()
#19 0x0808972a in ap_mpm_run ()
#20 0x080621ef in main ()

Daniel

Message #32 received at 397625@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: Daniel Franz <daniel2712@gmx.de>, 397625@bugs.debian.org, Antoni Villalonga <antoni@friki.cat>

Subject: Re: Bug#397625: [php-maint] Bug#397625: me too

Date: Fri, 10 Nov 2006 11:35:14 +0100

Could you do

grep mysql /etc/php5/apache2/php.ini

and

dpkg -l php5-mysql

and send us output?

Ondrej
-- 
Ondřej Surý <ondrej@sury.org>

Message #37 received at 397625@bugs.debian.org (full text, mbox, reply):

From: Antoni Villalonga <antoni@friki.cat>

To: Ondřej Surý <ondrej@sury.org>, 397625@bugs.debian.org

Subject: Re: Bug#397625: [php-maint] Bug#397625: me too

Date: Fri, 10 Nov 2006 11:40:07 +0100

En/na Ondřej Surý ha escrit:
> Could you do
> 
> grep mysql /etc/php5/apache2/php.ini
> 
> and
> 
> dpkg -l php5-mysql
> 
> and send us output?
> 
> Ondrej

Here is:

antoni@X1:/tmp$ grep mysql /etc/php5/apache2/php.ini
extension=mysql.so
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
; Default port number for mysql_connect().  If unset, mysql_connect()
will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
mysql.default_port =
mysql.default_socket =
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =
; Default password for mysql_connect() (doesn't apply in safe mode).
; *Any* user with PHP access can run 'echo
get_cfg_var("mysql.default_password")
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
mysqli.max_links = -1
; Default port number for mysqli_connect().  If unset, mysqli_connect()
will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
mysqli.default_port = 3306
mysqli.default_socket =
; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =
; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =
; Default password for mysqli_connect() (doesn't apply in safe mode).
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
mysqli.default_pw =
mysqli.reconnect = Off
antoni@X1:/tmp$ dpkg -l php5-mysql
Desitjat=Desconegut(u)/Instal·la(i)/Elimina(r)/Neteja(p)/Atura(h)
| Estat=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Estat,Err:
majúsc.=dolent)
||/ Nom                               Versió
Descripció
+++-=================================-=================================-==================================================================================
ii  php5-mysql                        5.2.0-2
MySQL module for php5
antoni@X1:/tmp$

Some more:
ii  libapache2-mod-php5              5.2.0-2
server-side, HTML-embedded scripting language (apache
ii  php5-common                      5.2.0-2
Common files for packages built from the php5 source
ii  php5-mysql                       5.2.0-2
MySQL module for php5

Bye!!

Message #42 received at 397625@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: antoni@friki.cat, 397625@bugs.debian.org

Subject: Re: Bug#397625: [php-maint] Bug#397625: me too

Date: Fri, 10 Nov 2006 12:13:26 +0100

> mysql.allow_persistent = On

Could you please disable persistent connections and try if it still
crashes?  Memory handling is bit different for persistent and
non-persistent connections.

Ondrej
-- 
Ondřej Surý <ondrej@sury.org>

Message #53 received at 397904@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: antoni@friki.cat

Cc: 397904@bugs.debian.org

Subject: Re: Bug#397904: [php-maint] Bug#397625: me too

Date: Fri, 10 Nov 2006 13:46:49 +0100

[I have cloned bug report, please send any replies to this new bugreport number]

Strange.

What version of mysql library do you have installed?
(dpkg -l libmysqlclient\*)

And what is output of:

ldd /usr/lib/php5/*/mysql.so

I looked for changes between 5.1.6 and 5.2.0 and I cannot find anything
suspicious.

Ondrej
-- 
Ondřej Surý <ondrej@sury.org>

Message #60 received at 397904@bugs.debian.org (full text, mbox, reply):

From: Antoni Villalonga <antoni@friki.cat>

To: Ondřej Surý <ondrej@sury.org>, 397904@bugs.debian.org

Subject: Re: Bug#397904: [php-maint] Bug#397625: me too

Date: Fri, 10 Nov 2006 14:37:30 +0100

En/na Ondřej Surý ha escrit:
> [I have cloned bug report, please send any replies to this new bugreport number]
> 
> Strange.
> 
> What version of mysql library do you have installed?
> (dpkg -l libmysqlclient\*)
> 
> And what is output of:
> 
> ldd /usr/lib/php5/*/mysql.so
> 
> I looked for changes between 5.1.6 and 5.2.0 and I cannot find anything
> suspicious.
> 
> Ondrej

mmm

I'm using mysql from debian experimental :S

antoni@X1:~$ ldd /usr/lib/php5/*/mysql.so
        linux-gate.so.1 =>  (0xb7faf000)
        libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7da9000)
        libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb7c69000)
        libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb7c51000)
        libcrypt.so.1 => /lib/i686/cmov/libcrypt.so.1 (0xb7c23000)
        libnsl.so.1 => /lib/i686/cmov/libnsl.so.1 (0xb7c0c000)
        libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7be6000)
        libz.so.1 => /usr/lib/libz.so.1 (0xb7bd2000)
        /lib/ld-linux.so.2 (0x80000000)
antoni@X1:~$ apt-cache policy libmysqlclient15-dev
libmysqlclient15-dev:
  Instal·lat: 5.1.11beta-1
  Candidat: 5.1.11beta-1
  Taula de versió:
 *** 5.1.11beta-1 0
          1 http://ftp.uk.debian.org experimental/main Packages
        100 /var/lib/dpkg/status
     5.0.26-3 0
        500 http://ftp.uk.debian.org sid/main Packages
     5.0.24a-9 0
        500 http://ftp.uk.debian.org etch/main Packages
antoni@X1:~$

A simple $foo=array(); in some scripts, some times segfault too. I don't
know if mysql is the problem...

I'll downgrade mysql to sid and php5 to 5.1.6 and mail you again.

Bye!!

--

Antoni Villalonga Noceras

Message #65 received at 397904@bugs.debian.org (full text, mbox, reply):

From: sean finney <seanius@debian.org>

To: antoni@friki.cat, 397904@bugs.debian.org

Cc: Ondřej Surý <ondrej@sury.org>

Subject: Re: Bug#397904: [php-maint] Bug#397625: me too

Date: Fri, 10 Nov 2006 18:16:02 +0100

[Message part 1 (text/plain, inline)]

On Fri, 2006-11-10 at 14:37 +0100, Antoni Villalonga wrote:
> 
> I'm using mysql from debian experimental :S

hmm... it's possible that there are unpublished ABI differences
between unstable<->experimental libmysqlclient, as mysql every now and
then accidentally introduces them and i've only been keeping a close
eye on what goes in unstable.  i'll check on this later but in
the meantime you should check to see if migrating to what's
in testing/unstable (and rebooting if possible) fixes your problem.


	sean

[signature.asc (application/pgp-signature, inline)]

Message #70 received at 397904@bugs.debian.org (full text, mbox, reply):

From: Antoni Villalonga <antoni@friki.cat>

To: sean finney <seanius@debian.org>

Cc: 397904@bugs.debian.org, Ondr(ej Surý <ondrej@sury.org>

Subject: Re: Bug#397904: [php-maint] Bug#397625: me too

Date: Sat, 11 Nov 2006 00:02:11 +0100

En/na sean finney ha escrit:
> On Fri, 2006-11-10 at 14:37 +0100, Antoni Villalonga wrote:
>> I'm using mysql from debian experimental :S
> 
> hmm... it's possible that there are unpublished ABI differences
> between unstable<->experimental libmysqlclient, as mysql every now and
> then accidentally introduces them and i've only been keeping a close
> eye on what goes in unstable.  i'll check on this later but in
> the meantime you should check to see if migrating to what's
> in testing/unstable (and rebooting if possible) fixes your problem.
> 
> 
> 	sean

Some hours after... ( ;-D )

I start to test over a un-updated sid machine. Using testing packages it
works, and using sid packages works too. The problem starts when I
update mysql to experimental.

Here is the comand used:
aptitude install mysql-common mysql-server -t experimental

And here is a part of aptitude log: (i'm sorry it's in catalan, not in
english).

vvvvvvvv
[Instal·la, dependències] libmysqlclient15-dev
[Instal·la, dependències] mysql-client-5.1
[Instal·la, dependències] mysql-server-5.1
[Instal·la, dependències] zlib1g-dev
[Suprimeix, dependències] mysql-client-5.0
[Suprimeix, dependències] mysql-server-5.0
[Actualitza] libmysqlclient15off 5.0.26-3 -> 5.1.11beta-1
[Actualitza] mysql-common 5.0.26-3 -> 5.1.11beta-1
[Actualitza] mysql-server 5.0.26-3 -> 5.1.11beta-1
^^^^^^^^

Instal·la -> Install
dependències -> dependences
Suprimeix -> Remove
Actualitza -> update

I don't know in what of these packages is the problem
(libmysqlclient15-dev, mysql-client-5.1, mysql-server-5.1, zlib1g-dev,
libmysqlclient15off, mysql-common or mysql-server). It's hard to
downgrade mysql from 5.1 to 5.0.


It's all for now. Thanks guys!

PS: If I can do more tests for you just ask.

Message #75 received at 397904@bugs.debian.org (full text, mbox, reply):

From: Antoni Villalonga <antoni@friki.cat>

To: sean finney <seanius@debian.org>, 397904@bugs.debian.org

Subject: Re: Bug#397904: [php-maint] Bug#397625: me too

Date: Sat, 11 Nov 2006 17:26:56 +0100

En/na sean finney ha escrit:
> On Fri, 2006-11-10 at 14:37 +0100, Antoni Villalonga wrote:
>> I'm using mysql from debian experimental :S
> 
> hmm... it's possible that there are unpublished ABI differences
> between unstable<->experimental libmysqlclient, as mysql every now and
> then accidentally introduces them and i've only been keeping a close
> eye on what goes in unstable.  i'll check on this later but in
> the meantime you should check to see if migrating to what's
> in testing/unstable (and rebooting if possible) fixes your problem.
> 
> 
> 	sean

Finaly I solved the problem downgrading libmysqlclient15off package from
5.1.11beta-1 (experimental) to 5.0.26.-3 (sid).

Bye!

Message #80 received at 397904@bugs.debian.org (full text, mbox, reply):

From: sean finney <seanius@debian.org>

To: antoni@friki.cat

Cc: 397904@bugs.debian.org, 397904-submitter@bugs.debian.org, control <control@bugs.debian.org>, christian hammers <ch@debian.org>

Subject: Re: Bug#397904: [php-maint] Bug#397625: me too

Date: Sat, 11 Nov 2006 19:40:25 +0100

[Message part 1 (text/plain, inline)]

severity 397904 important
tags 397904 moreinfo unreproducible
thanks

(christian, i'm cc'ing you on this php bug because it may have to do
with libmysqlclient in experimental)

On Sat, 2006-11-11 at 17:26 +0100, Antoni Villalonga wrote:
> 
> Finaly I solved the problem downgrading libmysqlclient15off package from
> 5.1.11beta-1 (experimental) to 5.0.26.-3 (sid).

great, good to know.  from my checking there are indeed "unannounced"
ABI-incompatible changes in the experimental version of libmysqlclient,
which would explain the problems you were having.

to other people seeing this: what versions of libmysqlclient are you
running?

if i don't hear back from anyone in a week or two i'll close the bug
assuming it's fixed, and in the meantime i'm going to downgrade the
severity to prevent it from blocking php5's path to testing.


	sean

[signature.asc (application/pgp-signature, inline)]

Message #92 received at 397904@bugs.debian.org (full text, mbox, reply):

From: Elizabeth Fong <elizabeththegrey@gmail.com>

To: 397904@bugs.debian.org

Cc: control@bugs.debian.org

Subject: Another confirmation of this bug reproducing

Date: Thu, 01 Feb 2007 01:19:56 -0800

Version: 5.2.0-8
tags 397904 - moreinfo unreproducible
thanks

Hi, all.

I'm getting similar segfault symptoms on this end from an installation 
of Mediawiki on top of PHP5 using mysqli, and from an installation of 
phpBB on top of PHP5 using either the mysqli or mysql functions (but as 
far as I can tell, only mysqli.so is actually loaded).  The segfaults 
occur mid-request, but before any data can be sent to the client and I 
can generally pin them down to specific function calls in the PHP 
scripts being compiled/run.


Thanks,

Elizabeth Fong

Here's a sample backtrace:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread -1216465216 (LWP 31403)]
0xb7b98909 in free () from /lib/tls/libc.so.6
(gdb)
(gdb) backtrace
#0  0xb7b98909 in free () from /lib/tls/libc.so.6
#1  0xb6cd9f31 in my_no_flags_free () from /usr/lib/libmysqlclient.so.15
#2  0xb6cffe7b in mysql_select_db () from /usr/lib/libmysqlclient.so.15
#3  0xb6d00138 in mysql_close () from /usr/lib/libmysqlclient.so.15
#4  0xb6994eee in zm_startup_mysql () from 
/usr/lib/php5/20060613+lfs/mysql.so
#5  0xb731f8b3 in list_entry_destructor () from 
/usr/lib/apache2/modules/libphp5.so
#6  0xb731c8c8 in zend_hash_quick_find () from 
/usr/lib/apache2/modules/libphp5.so
#7  0xb731cb67 in zend_hash_graceful_reverse_destroy () from 
/usr/lib/apache2/modules/libphp5.so
#8  0xb731f6fd in zend_destroy_rsrc_list () from 
/usr/lib/apache2/modules/libphp5.so
#9  0xb7312a3f in zend_deactivate () from 
/usr/lib/apache2/modules/libphp5.so
#10 0xb72ce14c in php_request_shutdown () from 
/usr/lib/apache2/modules/libphp5.so
#11 0xb7395f8c in php_ap2_register_hook () from 
/usr/lib/apache2/modules/libphp5.so
#12 0x08074587 in ap_run_handler ()
#13 0x08077731 in ap_invoke_handler ()
#14 0x08084728 in ap_process_request ()
#15 0x080819ce in ap_register_input_filter ()
#16 0x0807b3c7 in ap_run_process_connection ()
#17 0x08088704 in ap_graceful_stop_signalled ()
#18 0x08088964 in ap_graceful_stop_signalled ()
#19 0x0808972a in ap_mpm_run ()
#20 0x080621ef in main ()

elizabeth@sally:/etc/php5/apache2$ grep mysql php.ini
extension=mysqli.so
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
; Default port number for mysql_connect().  If unset, mysql_connect() 
will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
mysql.default_port =
mysql.default_socket =
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =
; Default password for mysql_connect() (doesn't apply in safe mode).
; *Any* user with PHP access can run 'echo 
get_cfg_var("mysql.default_password")
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
mysqli.max_links = -1
; Default port number for mysqli_connect().  If unset, mysqli_connect() 
will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
mysqli.default_port = 3306
mysqli.default_socket =
; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =
; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =
; Default password for mysqli_connect() (doesn't apply in safe mode).
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
mysqli.default_pw =
mysqli.reconnect = Off

-- System Information:
Debian Release: 4.0
  APT prefers unstable
  APT policy: (990, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16.11h
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages php5-mysql depends on:
ii  libapache2-mod-php5 [phpapi 5.2.0-8      server-side, HTML-embedded 
scripti
ii  libc6                       2.3.6.ds1-10 GNU C Library: Shared libraries
ii  libmysqlclient15off         5.1.11beta-1 mysql database client library
ii  php5-cli [phpapi-20060613+l 5.2.0-8      command-line interpreter 
for the p
ii  php5-common                 5.2.0-8      Common files for packages 
built fr

php5-mysql recommends no packages.

-- debconf information:
  php5/remove_extension: true
  php5/extension_mysql_apache2: true
  php5/add_extension: true
  php5/extension_mysql_cli: true

Message #99 received at 397904@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: Elizabeth Fong <elizabeththegrey@gmail.com>, 397904@bugs.debian.org

Subject: Re: [php-maint] Bug#397904: Another confirmation of this bug reproducing

Date: Thu, 01 Feb 2007 10:42:33 +0100

There is inneed some ABI incompatibility with libmysqlclient from
experimental.  Downgrade your libmysqlclient15off to version from
unstable and you should be fine.  This is in fact not a PHP bug, but
MySQL bug, but since Sean is in mysql team as well, I'll let him handle
this.

Ondrej. 

On Čt, 2007-02-01 at 01:19 -0800, Elizabeth Fong wrote:
> Version: 5.2.0-8
> tags 397904 - moreinfo unreproducible
> thanks
> 
> Hi, all.
> 
> I'm getting similar segfault symptoms on this end from an installation 
> of Mediawiki on top of PHP5 using mysqli, and from an installation of 
> phpBB on top of PHP5 using either the mysqli or mysql functions (but as 
> far as I can tell, only mysqli.so is actually loaded).  The segfaults 
> occur mid-request, but before any data can be sent to the client and I 
> can generally pin them down to specific function calls in the PHP 
> scripts being compiled/run.
> 
> 
> Thanks,
> 
> Elizabeth Fong
> 
> Here's a sample backtrace:
> Program received signal SIGSEGV, Segmentation fault.
> [Switching to Thread -1216465216 (LWP 31403)]
> 0xb7b98909 in free () from /lib/tls/libc.so.6
> (gdb)
> (gdb) backtrace
> #0  0xb7b98909 in free () from /lib/tls/libc.so.6
> #1  0xb6cd9f31 in my_no_flags_free () from /usr/lib/libmysqlclient.so.15
> #2  0xb6cffe7b in mysql_select_db () from /usr/lib/libmysqlclient.so.15
> #3  0xb6d00138 in mysql_close () from /usr/lib/libmysqlclient.so.15
> #4  0xb6994eee in zm_startup_mysql () from 
> /usr/lib/php5/20060613+lfs/mysql.so
> #5  0xb731f8b3 in list_entry_destructor () from 
> /usr/lib/apache2/modules/libphp5.so
> #6  0xb731c8c8 in zend_hash_quick_find () from 
> /usr/lib/apache2/modules/libphp5.so
> #7  0xb731cb67 in zend_hash_graceful_reverse_destroy () from 
> /usr/lib/apache2/modules/libphp5.so
> #8  0xb731f6fd in zend_destroy_rsrc_list () from 
> /usr/lib/apache2/modules/libphp5.so
> #9  0xb7312a3f in zend_deactivate () from 
> /usr/lib/apache2/modules/libphp5.so
> #10 0xb72ce14c in php_request_shutdown () from 
> /usr/lib/apache2/modules/libphp5.so
> #11 0xb7395f8c in php_ap2_register_hook () from 
> /usr/lib/apache2/modules/libphp5.so
> #12 0x08074587 in ap_run_handler ()
> #13 0x08077731 in ap_invoke_handler ()
> #14 0x08084728 in ap_process_request ()
> #15 0x080819ce in ap_register_input_filter ()
> #16 0x0807b3c7 in ap_run_process_connection ()
> #17 0x08088704 in ap_graceful_stop_signalled ()
> #18 0x08088964 in ap_graceful_stop_signalled ()
> #19 0x0808972a in ap_mpm_run ()
> #20 0x080621ef in main ()
> 
> elizabeth@sally:/etc/php5/apache2$ grep mysql php.ini
> extension=mysqli.so
> mysql.allow_persistent = On
> mysql.max_persistent = -1
> mysql.max_links = -1
> ; Default port number for mysql_connect().  If unset, mysql_connect() 
> will use
> ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
> mysql.default_port =
> mysql.default_socket =
> ; Default host for mysql_connect() (doesn't apply in safe mode).
> mysql.default_host =
> ; Default user for mysql_connect() (doesn't apply in safe mode).
> mysql.default_user =
> ; Default password for mysql_connect() (doesn't apply in safe mode).
> ; *Any* user with PHP access can run 'echo 
> get_cfg_var("mysql.default_password")
> mysql.default_password =
> mysql.connect_timeout = 60
> mysql.trace_mode = Off
> mysqli.max_links = -1
> ; Default port number for mysqli_connect().  If unset, mysqli_connect() 
> will use
> ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
> mysqli.default_port = 3306
> mysqli.default_socket =
> ; Default host for mysql_connect() (doesn't apply in safe mode).
> mysqli.default_host =
> ; Default user for mysql_connect() (doesn't apply in safe mode).
> mysqli.default_user =
> ; Default password for mysqli_connect() (doesn't apply in safe mode).
> ; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
> mysqli.default_pw =
> mysqli.reconnect = Off
> 
> -- System Information:
> Debian Release: 4.0
>    APT prefers unstable
>    APT policy: (990, 'unstable'), (1, 'experimental')
> Architecture: i386 (i686)
> Shell:  /bin/sh linked to /bin/bash
> Kernel: Linux 2.6.16.11h
> Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
> 
> Versions of packages php5-mysql depends on:
> ii  libapache2-mod-php5 [phpapi 5.2.0-8      server-side, HTML-embedded 
> scripti
> ii  libc6                       2.3.6.ds1-10 GNU C Library: Shared libraries
> ii  libmysqlclient15off         5.1.11beta-1 mysql database client library
> ii  php5-cli [phpapi-20060613+l 5.2.0-8      command-line interpreter 
> for the p
> ii  php5-common                 5.2.0-8      Common files for packages 
> built fr
> 
> php5-mysql recommends no packages.
> 
> -- debconf information:
>    php5/remove_extension: true
>    php5/extension_mysql_apache2: true
>    php5/add_extension: true
>    php5/extension_mysql_cli: true
> 
> 
> 
> _______________________________________________
> pkg-php-maint mailing list
> pkg-php-maint@lists.alioth.debian.org
> http://lists.alioth.debian.org/mailman/listinfo/pkg-php-maint
-- 
Ondřej Surý <ondrej@sury.org>  ***  http://blog.rfc1925.org/
Kulturní občasník              ***  http://www.obcasnik.cz/

Message #104 received at 397904@bugs.debian.org (full text, mbox, reply):

From: sean finney <seanius@debian.org>

To: Ondřej Surý <ondrej@sury.org>, 397904@bugs.debian.org

Cc: Elizabeth Fong <elizabeththegrey@gmail.com>

Subject: Re: Bug#397904: [php-maint] Bug#397904: Another confirmation of this bug reproducing

Date: Thu, 01 Feb 2007 12:23:19 +0100

[Message part 1 (text/plain, inline)]

On Thu, 2007-02-01 at 10:42 +0100, Ondřej Surý wrote:
> There is inneed some ABI incompatibility with libmysqlclient from
> experimental.  Downgrade your libmysqlclient15off to version from
> unstable and you should be fine.  This is in fact not a PHP bug, but
> MySQL bug, but since Sean is in mysql team as well, I'll let him handle
> this.

to back up ondrej here, there are known ABI incompatibilities between
the mysql 5.1 in experimental and the 5.0 in testing/unstable (and thus
between 5.1 and everything that links against the libmysqlclient15off
package).

i'll follow up with christian and find out what our plan is for
preventing this from being a long-term problem (fixing the ABI or
changing the soname).


	sean

[signature.asc (application/pgp-signature, inline)]

Message #109 received at 397904@bugs.debian.org (full text, mbox, reply):

From: Elizabeth Fong <elizabeth@ctyalcove.org>

To: sean finney <seanius@debian.org>

Cc: Ondřej Surý <ondrej@sury.org>, 397904@bugs.debian.org, control@bugs.debian.org

Subject: Re: Bug#397904: [php-maint] Bug#397904: Another confirmation of this bug reproducing

Date: Thu, 01 Feb 2007 13:17:44 -0800

tags 397904 experimental
thanks

>> There is inneed some ABI incompatibility with libmysqlclient from
>> experimental.  Downgrade your libmysqlclient15off to version from
>> unstable and you should be fine.  This is in fact not a PHP bug, but
>> MySQL bug, but since Sean is in mysql team as well, I'll let him handle
>> this.
> 
> to back up ondrej here, there are known ABI incompatibilities between
> the mysql 5.1 in experimental and the 5.0 in testing/unstable (and thus
> between 5.1 and everything that links against the libmysqlclient15off
> package).
> 
> i'll follow up with christian and find out what our plan is for
> preventing this from being a long-term problem (fixing the ABI or
> changing the soname).
Thanks very much, downgrading libmysql15off and reinstalling 
mysql-5.0-[client|server] solved my problem.  Uck, I wasted hours 
chasing heisenbugs - should have asked you folks sooner...

I won't mark this issue resolved, as it is still possible to 
accidentally trigger it by upgrading to mysql packages in experimental; 
I'll tag it experimental instead.


Thanks,

Elizabeth Fong

Message #120 received at 397904-done@bugs.debian.org (full text, mbox, reply):

From: Christian Hammers <ch@lathspell.de>

To: 397904-done@bugs.debian.org

Subject: Re: php5-mysql: apache2 segfaults on php shutdown in zm_startup_mysql

Date: Sun, 5 Jul 2009 23:05:54 +0200

This can be closed as MySQL-5.1 from experimental now uses
a new library soname version.

bye,

-christian-

Send a report that this bug log contains spam.