[MDEV-13317] Mariadb 10.2.7 causes php5 to seg fault Created: 2017-07-13  Updated: 2017-08-20  Resolved: 2017-07-18

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2.7
Fix Version/s: 10.2.8

Type: Bug Priority: Critical
Reporter: paladox Assignee: Georg Richter
Resolution: Fixed Votes: 0
Labels: None
Environment:

debian 8.8 (jessie)



 Description   

Hi, since upgrading from 10.2.6 to 10.2.7, php has been segfaulting. To prove that i deleted the host and recreated it and installed mariadb10.2.7. Soon after maybe a couple minutes or 30mins-1 hour php begins segfaulting.

mariann 10.2.6 did not cause php to segfault.

also mariadb 10.2.7 is not on stretch.

I used this mirror http://mirrors.coreix.net/mariadb/repo/10.2/debian

I get this in the syslog

Jul 13 13:54:08 phabricator kernel: [ 7650.083207] php[1792]: segfault at 7f9da0a5c9a0 ip 00007f9da0a5c9a0 sp 00007ffe37bd65f8 error 14 in libffi.so.6.0.2[7f9da3ad6000+7000]



 Comments   
Comment by paladox [ 2017-07-13 ]

Since uninstalling mariadb the segfault goes.

These are the packages that are uninstalled

The following packages were automatically installed and are no longer required:
apt-file galera-3 libaio1 libconfig-file-perl libdbi-perl libjemalloc1 liblist-moreutils-perl libopts25 libpython2.7 libregexp-assemble-perl libssl1.0.2 linux-meta-4.4 python-gdbm ruby-hiera socat
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
exim4-daemon-light
The following packages will be REMOVED:
exim4-daemon-heavy* libdbd-mysql-perl* libmariadb3* libmariadbclient18* libmysqlclient18* mariadb-client* mariadb-client-10.1* mariadb-client-10.2* mariadb-client-core-10.2* mariadb-common*
mariadb-server* mariadb-server-10.1* mariadb-server-10.2* mariadb-server-core-10.2* php5-mysql* python-mysqldb*
The following NEW packages will be installed:
exim4-daemon-light

though none of those were installed or updated when i updated mariadb to 10.2.7.

Comment by paladox [ 2017-07-13 ]

i believe the issue is being caused by libmariadbclient18 and libmysqlclient18 10.2.7 worked with 10.2.6.

Comment by Elena Stepanova [ 2017-07-13 ]

paladox, can you provide any particular php script that is segfaulting?

Comment by paladox [ 2017-07-13 ]

when i ran php -v it showed segmentation fault at the bottom. Same for any php script i ran such as phabricator bin/phd start

https://secure.phabricator.com

also install php5-mysql.

Comment by Elena Stepanova [ 2017-07-13 ]

At least on php -v, I am not getting anything:

$ php -v
PHP 5.6.30-0+deb8u1 (cli) (built: Feb  8 2017 08:50:21) 
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
 
$ lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 8.8 (jessie)
Release:        8.8
Codename:       jessie
 
$ dpkg -l | grep -iE 'mysql|maria'
ii  libdbd-mysql-perl              4.028-2+deb8u2                     amd64        Perl5 database interface to the MySQL database
ii  libmariadb3                    10.2.7+maria~jessie                amd64        MariaDB database client library
ii  libmysqlclient18               10.2.7+maria~jessie                amd64        Virtual package to satisfy external depends
ii  mariadb-client-10.2            10.2.7+maria~jessie                amd64        MariaDB database client binaries
ii  mariadb-client-core-10.2       10.2.7+maria~jessie                amd64        MariaDB database core client binaries
ii  mariadb-common                 10.2.7+maria~jessie                all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii  mariadb-server                 10.2.7+maria~jessie                all          MariaDB database server (metapackage depending on the latest version)
ii  mariadb-server-10.2            10.2.7+maria~jessie                amd64        MariaDB database server binaries
ii  mariadb-server-core-10.2       10.2.7+maria~jessie                amd64        MariaDB database core server files
ii  mysql-common                   10.2.7+maria~jessie                all          MariaDB database common files (e.g. /etc/mysql/my.cnf)

Comment by paladox [ 2017-07-13 ]

Hmm, do you have php5-mysql installed?

also i had libmariadbclient18 installed.

Comment by Elena Stepanova [ 2017-07-13 ]

Installed libmariadbclient18 and php5-mysql, still not getting anything:

buildbot@debian-jessie-amd64:~$ php -v
PHP 5.6.30-0+deb8u1 (cli) (built: Feb  8 2017 08:50:21) 
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies

buildbot@debian-jessie-amd64:~$ dpkg -l | grep -iE 'mysql|maria'
ii  libdbd-mysql-perl              4.028-2+deb8u2                     amd64        Perl5 database interface to the MySQL database
ii  libmariadb3                    10.2.7+maria~jessie                amd64        MariaDB database client library
ii  libmariadbclient18             10.2.7+maria~jessie                amd64        Virtual package to satisfy external depends
ii  libmysqlclient18               10.2.7+maria~jessie                amd64        Virtual package to satisfy external depends
ii  mariadb-client-10.2            10.2.7+maria~jessie                amd64        MariaDB database client binaries
ii  mariadb-client-core-10.2       10.2.7+maria~jessie                amd64        MariaDB database core client binaries
ii  mariadb-common                 10.2.7+maria~jessie                all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii  mariadb-server                 10.2.7+maria~jessie                all          MariaDB database server (metapackage depending on the latest version)
ii  mariadb-server-10.2            10.2.7+maria~jessie                amd64        MariaDB database server binaries
ii  mariadb-server-core-10.2       10.2.7+maria~jessie                amd64        MariaDB database core server files
ii  mysql-common                   10.2.7+maria~jessie                all          MariaDB database common files (e.g. /etc/mysql/my.cnf)
ii  php5-mysql                     5.6.30+dfsg-0+deb8u1               amd64        MySQL module for php5

You mentioned earlier that you re-installed 10.2.7 on a clean system, right? That's what I'm trying to reproduce.
The previous setup, where you had both 10.1 and 10.2 servers and clients and some mix of libraries, couldn't go well, no wonder it would misbehave. But if it still crashes on a clean setup, that's a problem.

Could you please run the same dpkg -l | grep -iE 'mysql|maria' and paste the results, so I could compare and install what's missing in mine?
Thanks.

Comment by paladox [ 2017-07-13 ]

Hmm, i've downgraded to mariadb 10.1 now. But i had used the puppet phabricator role from wmf https://github.com/wikimedia/puppet/blob/production/modules/phabricator/manifests/init.pp

on a wmf test instance http://wikitech.wikimedia.org

Comment by paladox [ 2017-07-13 ]

It also had exim4 installed though.

Comment by Alice Sherepa [ 2017-07-17 ]

Reproduced with MariaDB 10.2.7, using docker image debian~jessie. Can not reproduce it with 10.1.25.

Steps to reproduce:

1) install MariaDB 10.2.7 for debian (as recommended her https://downloads.mariadb.org/mariadb/repositories/#mirror=dotsrc&distro=Debian&distro_release=jessie--jessie&version=10.2)

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://mirrors.dotsrc.org/mariadb/repo/10.2/debian jessie main'
sudo apt-get update
sudo apt-get install mariadb-server

2) install php5, php5-mysql, php5-curl

 
apt-get install php5
apt-get install php5-mysql
apt-get install php5-curl

3) php -v returns segmentation fault

 
HP 5.6.30-0+deb8u1 (cli) (built: Feb  8 2017 08:50:21) 
CopyrighPt (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
Segmentation fault (core dumped)
 
root@234402563df1:/tmp# dpkg -l | grep -iE 'mysql|maria|php'
 
ii  libapache2-mod-php5           5.6.30+dfsg-0+deb8u1             amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  libdbd-mysql-perl             4.028-2+deb8u2                   amd64        Perl5 database interface to the MySQL database
ii  libmariadb3                   10.2.7+maria~jessie              amd64        MariaDB database client library
ii  libmysqlclient18              10.2.7+maria~jessie              amd64        Virtual package to satisfy external depends
ii  mariadb-client-10.2           10.2.7+maria~jessie              amd64        MariaDB database client binaries
ii  mariadb-client-core-10.2      10.2.7+maria~jessie              amd64        MariaDB database core client binaries
ii  mariadb-common                10.2.7+maria~jessie              all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii  mariadb-server                10.2.7+maria~jessie              all          MariaDB database server (metapackage depending on the latest version)
ii  mariadb-server-10.2           10.2.7+maria~jessie              amd64        MariaDB database server binaries
ii  mariadb-server-core-10.2      10.2.7+maria~jessie              amd64        MariaDB database core server files
ii  mysql-common                  10.2.7+maria~jessie              all          MariaDB database common files (e.g. /etc/mysql/my.cnf)
ii  php5                          5.6.30+dfsg-0+deb8u1             all          server-side, HTML-embedded scripting language (metapackage)
ii  php5-cli                      5.6.30+dfsg-0+deb8u1             amd64        command-line interpreter for the php5 scripting language
ii  php5-common                   5.6.30+dfsg-0+deb8u1             amd64        Common files for packages built from the php5 source
ii  php5-curl                     5.6.30+dfsg-0+deb8u1             amd64        CURL module for php5
ii  php5-json                     1.3.6-1                          amd64        JSON module for php5
ii  php5-mysql                    5.6.30+dfsg-0+deb8u1             amd64        MySQL module for php5
ii  php5-readline                 5.6.30+dfsg-0+deb8u1             amd64        Readline module for php5

Core dump

Thread 1 (Thread 0x7f0e844ad740 (LWP 5720)):
#0  0x00007f0e7d3999a0 in ?? ()
#1  0x00007f0e836d1828 in ERR_remove_thread_state () from /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
#2  0x00007f0e7fe89439 in ?? () from /usr/lib/x86_64-linux-gnu/libcurl.so.4
#3  0x00007f0e7fe5e805 in curl_global_cleanup () from /usr/lib/x86_64-linux-gnu/libcurl.so.4
#4  0x00007f0e800acdf8 in zm_shutdown_curl () from /usr/lib/php5/20131226/curl.so
#5  0x0000000000700d97 in module_destructor ()
#6  0x00000000007064a6 in ?? ()
#7  0x0000000000707ca8 in zend_hash_graceful_reverse_destroy ()
#8  0x00000000006f8ecf in zend_shutdown ()
#9  0x0000000000695a7b in php_module_shutdown ()
#10 0x0000000000462beb in main ()

I found an old bug from php and it looks related to this
http://www.logikdev.com/2011/03/14/segmentation-fault-at-end-of-php-script/
I tried that solution, it worked.

we need to comment out the line extension=curl.so from the file /etc/php5/cli/conf.d/curl.ini:
 
	# configuration for php CURL module
	#extension=curl.so
 
And add it to the file /etc/php5/cli/conf.d/mysql.ini AFTER the line extension=mysql.so:
 
	# configuration for php MySQL module
	extension=mysql.so
	extension=curl.so

Comment by paladox [ 2017-07-17 ]

Hi the workaround won't work if php uses a path to load the extensions. IE on debian it is not loaded in php.ini it's loaded from a directory. So it's impossible to move it up or down.

Comment by paladox [ 2017-07-17 ]

it'd the conf.d directory /etc/php5/apache2/conf.d

Comment by paladox [ 2017-07-17 ]

Oh i see. But the problem was some how introduced in 10.2.7 as i did not experience it with 10.2.6.

Comment by Georg Richter [ 2017-07-18 ]

Fixed in rev. d9bc9908518b81bed3454af6529e631238a2fcc9 (submodule libmariadb)

Connector/C needs to check if callback functions for crypto locking were already registered. In this case there is no need to register (and overwrite) them again.

Comment by paladox [ 2017-07-18 ]

thanks

Comment by Alexander Chernov [ 2017-07-25 ]

@paladox Actually you CAN change the order, just rename files. I.e. on my server I had to do following:

ll /etc/php5/mods-available/
total 64
rw-rr- 1 root root 70 Feb 8 10:07 001_mysql.ini
rw-rr- 1 root root 71 Feb 8 10:07 002_mysql.ini
rw-rr- 1 root root 68 Feb 8 10:07 curl.ini
rw-rr- 1 root root 64 Feb 8 10:07 gd.ini
rw-rr- 1 root root 60 Oct 21 2014 imagick.ini
rw-rr- 1 root root 68 Aug 1 2014 json.ini
rw-rr- 1 root root 72 Feb 8 10:07 mcrypt.ini
rw-rr- 1 root root 229 Oct 25 2014 memcache.ini
rw-rr- 1 root root 83 Feb 8 10:07 opcache.ini
rw-rr- 1 root root 66 Feb 8 10:07 pdo.ini
rw-rr- 1 root root 74 Feb 8 10:07 pdo_mysql.ini
rw-rr- 1 root root 79 Feb 8 10:07 pdo_pgsql.ini
rw-rr- 1 root root 76 Feb 8 10:07 pdo_sqlite.ini
rw-rr- 1 root root 75 Feb 8 10:07 pgsql.ini
rw-rr- 1 root root 76 Feb 8 10:07 readline.ini
rw-rr- 1 root root 73 Feb 8 10:07 sqlite3.ini

Comment by Yoann Laissus [ 2017-08-19 ]

After the 10.2.8 upgrade, there are still segfaults due to the curl module, the backtrace is identical.

Comment by Georg Richter [ 2017-08-19 ]

Hi,

can you please attach ouput of

php -i

(in case it segfaults, please change the order of mysql and curl shared objects).

Comment by Yoann Laissus [ 2017-08-19 ]

Hi,
Thanks for your reply.
Here is the output of php -i taken from a fresh Debian 8 docker instance. Only mysql and curl php module have been installed (in addition to the default ones)

phpinfo()
PHP Version => 5.6.30-0+deb8u1
 
System => Linux 7c7781d87c3a 4.12.8-1-ARCH #1 SMP PREEMPT Thu Aug 17 08:37:20 CEST 2017 x86_64
Build Date => Feb  8 2017 08:49:41
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /etc/php5/cli
Loaded Configuration File => /etc/php5/cli/php.ini
Scan this dir for additional .ini files => /etc/php5/cli/conf.d
Additional .ini files parsed => /etc/php5/cli/conf.d/05-opcache.ini,
/etc/php5/cli/conf.d/10-pdo.ini,
/etc/php5/cli/conf.d/20-curl.ini,
/etc/php5/cli/conf.d/20-json.ini,
/etc/php5/cli/conf.d/20-mysql.ini,
/etc/php5/cli/conf.d/20-mysqli.ini,
/etc/php5/cli/conf.d/20-pdo_mysql.ini,
/etc/php5/cli/conf.d/20-readline.ini
 
PHP API => 20131106
PHP Extension => 20131226
Zend Extension => 220131226
Zend Extension Build => API220131226,NTS
PHP Extension Build => API20131226,NTS
Debug Build => no
Thread Safety => disabled
Zend Signal Handling => disabled
Zend Memory Manager => enabled
Zend Multibyte Support => provided by mbstring
IPv6 Support => enabled
DTrace Support => enabled
 
Registered PHP Streams => https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip
Registered Stream Socket Transports => tcp, udp, unix, udg, ssl, sslv3, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filters => zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk
 
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
 
 
 _______________________________________________________________________
 
 
Configuration
 
bcmath
 
BCMath support => enabled
 
Directive => Local Value => Master Value
bcmath.scale => 0 => 0
 
bz2
 
BZip2 Support => Enabled
Stream Wrapper support => compress.bzip2://
Stream Filter support => bzip2.decompress, bzip2.compress
BZip2 Version => 1.0.6, 6-Sept-2010
 
calendar
 
Calendar support => enabled
 
Core
 
PHP Version => 5.6.30-0+deb8u1
 
Directive => Local Value => Master Value
allow_url_fopen => On => On
allow_url_include => Off => Off
always_populate_raw_post_data => 0 => 0
arg_separator.input => & => &
arg_separator.output => & => &
asp_tags => Off => Off
auto_append_file => no value => no value
auto_globals_jit => On => On
auto_prepend_file => no value => no value
browscap => no value => no value
default_charset => UTF-8 => UTF-8
default_mimetype => text/html => text/html
disable_classes => no value => no value
disable_functions => no value => no value
display_errors => Off => Off
display_startup_errors => Off => Off
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => Off => Off
enable_post_data_reading => On => On
error_append_string => no value => no value
error_log => no value => no value
error_prepend_string => no value => no value
error_reporting => 22527 => 22527
exit_on_timeout => Off => Off
expose_php => On => On
extension_dir => /usr/lib/php5/20131226 => /usr/lib/php5/20131226
file_uploads => On => On
highlight.comment => <font style="color: #FF8000">#FF8000</font> => <font style="color: #FF8000">#FF8000</font>
highlight.default => <font style="color: #0000BB">#0000BB</font> => <font style="color: #0000BB">#0000BB</font>
highlight.html => <font style="color: #000000">#000000</font> => <font style="color: #000000">#000000</font>
highlight.keyword => <font style="color: #007700">#007700</font> => <font style="color: #007700">#007700</font>
highlight.string => <font style="color: #DD0000">#DD0000</font> => <font style="color: #DD0000">#DD0000</font>
html_errors => Off => Off
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => Off => Off
implicit_flush => On => On
include_path => .:/usr/share/php:/usr/share/pear => .:/usr/share/php:/usr/share/pear
input_encoding => no value => no value
internal_encoding => no value => no value
log_errors => On => On
log_errors_max_len => 1024 => 1024
mail.add_x_header => On => On
mail.force_extra_parameters => no value => no value
mail.log => no value => no value
max_execution_time => 0 => 0
max_file_uploads => 20 => 20
max_input_nesting_level => 64 => 64
max_input_time => -1 => -1
max_input_vars => 1000 => 1000
memory_limit => -1 => -1
open_basedir => no value => no value
output_buffering => 0 => 0
output_encoding => no value => no value
output_handler => no value => no value
post_max_size => 8M => 8M
precision => 14 => 14
realpath_cache_size => 16K => 16K
realpath_cache_ttl => 120 => 120
register_argc_argv => On => On
report_memleaks => On => On
report_zend_debug => Off => Off
request_order => GP => GP
sendmail_from => no value => no value
sendmail_path => /usr/sbin/sendmail -t -i  => /usr/sbin/sendmail -t -i 
serialize_precision => 17 => 17
short_open_tag => Off => Off
SMTP => localhost => localhost
smtp_port => 25 => 25
sql.safe_mode => Off => Off
sys_temp_dir => no value => no value
track_errors => Off => Off
unserialize_callback_func => no value => no value
upload_max_filesize => 2M => 2M
upload_tmp_dir => no value => no value
user_dir => no value => no value
user_ini.cache_ttl => 300 => 300
user_ini.filename => .user.ini => .user.ini
variables_order => GPCS => GPCS
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
zend.detect_unicode => On => On
zend.enable_gc => On => On
zend.multibyte => Off => Off
zend.script_encoding => no value => no value
 
ctype
 
ctype functions => enabled
 
curl
 
cURL support => enabled
cURL Information => 7.38.0
Age => 3
Features
AsynchDNS => Yes
CharConv => No
Debug => No
GSS-Negotiate => No
IDN => Yes
IPv6 => Yes
krb4 => No
Largefile => Yes
libz => Yes
NTLM => Yes
NTLMWB => Yes
SPNEGO => Yes
SSL => Yes
SSPI => No
TLS-SRP => Yes
Protocols => dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtmp, rtsp, scp, sftp, smtp, smtps, telnet, tftp
Host => x86_64-pc-linux-gnu
SSL Version => OpenSSL/1.0.1t
ZLib Version => 1.2.8
libSSH Version => libssh2/1.4.3
 
date
 
date/time support => enabled
"Olson" Timezone Database Version => 0.system
Timezone Database => internal
Default timezone => UTC
 
Directive => Local Value => Master Value
date.default_latitude => 31.7667 => 31.7667
date.default_longitude => 35.2333 => 35.2333
date.sunrise_zenith => 90.583333 => 90.583333
date.sunset_zenith => 90.583333 => 90.583333
date.timezone => no value => no value
 
dba
 
DBA support => enabled
libdb header version => Berkeley DB 5.3.28: (September  9, 2013)
libdb library version => Berkeley DB 5.3.28: (September  9, 2013)
Supported handlers => cdb cdb_make db4 inifile flatfile qdbm 
 
Directive => Local Value => Master Value
dba.default_handler => flatfile => flatfile
 
dom
 
DOM/XML => enabled
DOM/XML API Version => 20031129
libxml Version => 2.9.1
HTML Support => enabled
XPath Support => enabled
XPointer Support => enabled
Schema Support => enabled
RelaxNG Support => enabled
 
ereg
 
Regex Library => Bundled library enabled
 
exif
 
EXIF Support => enabled
EXIF Version => 1.4 $Id: 1c8772f76be691b7b3f77ca31eb788a2abbcefe5 $
Supported EXIF Version => 0220
Supported filetypes => JPEG,TIFF
 
Directive => Local Value => Master Value
exif.decode_jis_intel => JIS => JIS
exif.decode_jis_motorola => JIS => JIS
exif.decode_unicode_intel => UCS-2LE => UCS-2LE
exif.decode_unicode_motorola => UCS-2BE => UCS-2BE
exif.encode_jis => no value => no value
exif.encode_unicode => ISO-8859-15 => ISO-8859-15
 
fileinfo
 
fileinfo support => enabled
version => 1.0.5
libmagic => 517
 
filter
 
Input Validation and Filtering => enabled
Revision => $Id: 5b79667bd9a68977a9b4f7505223a8e216e04908 $
 
Directive => Local Value => Master Value
filter.default => unsafe_raw => unsafe_raw
filter.default_flags => no value => no value
 
ftp
 
FTP support => enabled
 
gettext
 
GetText Support => enabled
 
hash
 
hash support => enabled
Hashing Engines => md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 
 
iconv
 
iconv support => enabled
iconv implementation => glibc
iconv library version => 2.19
 
Directive => Local Value => Master Value
iconv.input_encoding => no value => no value
iconv.internal_encoding => no value => no value
iconv.output_encoding => no value => no value
 
json
 
json support => enabled
json version => 1.3.6
JSON-C headers version => 0.11.99
JSON-C library version => 0.11.99
 
libxml
 
libXML support => active
libXML Compiled Version => 2.9.1
libXML Loaded Version => 20901
libXML streams => enabled
 
mbstring
 
Multibyte Support => enabled
Multibyte string engine => libmbfl
HTTP input encoding translation => disabled
libmbfl version => 1.3.2
 
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
 
Multibyte (japanese) regex support => enabled
Multibyte regex (oniguruma) version => 5.9.5
 
Directive => Local Value => Master Value
mbstring.detect_order => no value => no value
mbstring.encoding_translation => Off => Off
mbstring.func_overload => 0 => 0
mbstring.http_input => no value => no value
mbstring.http_output => no value => no value
mbstring.http_output_conv_mimetypes => ^(text/|application/xhtml\+xml) => ^(text/|application/xhtml\+xml)
mbstring.internal_encoding => no value => no value
mbstring.language => neutral => neutral
mbstring.strict_detection => Off => Off
mbstring.substitute_character => no value => no value
 
mhash
 
MHASH support => Enabled
MHASH API Version => Emulated Support
 
mysql
 
MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 10.2.8
MYSQL_MODULE_TYPE => external
MYSQL_SOCKET => /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE => -I/usr/include/mysql
MYSQL_LIBS => -L/usr/lib/x86_64-linux-gnu -lmysqlclient_r 
 
Directive => Local Value => Master Value
mysql.allow_local_infile => On => On
mysql.allow_persistent => On => On
mysql.connect_timeout => 60 => 60
mysql.default_host => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => /var/run/mysqld/mysqld.sock => /var/run/mysqld/mysqld.sock
mysql.default_user => no value => no value
mysql.max_links => Unlimited => Unlimited
mysql.max_persistent => Unlimited => Unlimited
mysql.trace_mode => Off => Off
 
mysqli
 
MysqlI Support => enabled
Client API library version => 10.2.8
Active Persistent Links => 0
Inactive Persistent Links => 0
Active Links => 0
Client API header version => 5.5.53
MYSQLI_SOCKET => /var/run/mysqld/mysqld.sock
 
Directive => Local Value => Master Value
mysqli.allow_local_infile => On => On
mysqli.allow_persistent => On => On
mysqli.default_host => no value => no value
mysqli.default_port => 3306 => 3306
mysqli.default_pw => no value => no value
mysqli.default_socket => /var/run/mysqld/mysqld.sock => /var/run/mysqld/mysqld.sock
mysqli.default_user => no value => no value
mysqli.max_links => Unlimited => Unlimited
mysqli.max_persistent => Unlimited => Unlimited
mysqli.reconnect => Off => Off
mysqli.rollback_on_cached_plink => Off => Off
 
openssl
 
OpenSSL support => enabled
OpenSSL Library Version => OpenSSL 1.0.1t  3 May 2016
OpenSSL Header Version => OpenSSL 1.0.1t  3 May 2016
Openssl default config => /usr/lib/ssl/openssl.cnf
 
Directive => Local Value => Master Value
openssl.cafile => no value => no value
openssl.capath => no value => no value
 
pcntl
 
pcntl support => enabled
 
pcre
 
PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 8.35 2014-04-04
 
Directive => Local Value => Master Value
pcre.backtrack_limit => 1000000 => 1000000
pcre.recursion_limit => 100000 => 100000
 
PDO
 
PDO support => enabled
PDO drivers => mysql
 
pdo_mysql
 
PDO Driver for MySQL => enabled
Client API version => 10.2.8
 
Directive => Local Value => Master Value
pdo_mysql.default_socket => /var/run/mysqld/mysqld.sock => /var/run/mysqld/mysqld.sock
 
Phar
 
Phar: PHP Archive support => enabled
Phar EXT version => 2.0.2
Phar API version => 1.1.1
SVN revision => $Id: 780be432570e80dd34c1a9c217ef87ade22bf136 $
Phar-based phar archives => enabled
Tar-based phar archives => enabled
ZIP-based phar archives => enabled
gzip compression => enabled
bzip2 compression => enabled
OpenSSL support => enabled
 
 
Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
Directive => Local Value => Master Value
phar.cache_list => no value => no value
phar.readonly => On => On
phar.require_hash => On => On
 
posix
 
Revision => $Id: 5f4acc20904b1406142f2a0ede068db048c77e77 $
 
readline
 
Readline Support => enabled
Readline library => EditLine wrapper
 
Directive => Local Value => Master Value
cli.pager => no value => no value
cli.prompt => \b \>  => \b \> 
 
Reflection
 
Reflection => enabled
Version => $Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $
 
session
 
Session Support => enabled
Registered save handlers => files user 
Registered serializer handlers => php_serialize php php_binary wddx 
 
Directive => Local Value => Master Value
session.auto_start => Off => Off
session.cache_expire => 180 => 180
session.cache_limiter => nocache => nocache
session.cookie_domain => no value => no value
session.cookie_httponly => Off => Off
session.cookie_lifetime => 0 => 0
session.cookie_path => / => /
session.cookie_secure => Off => Off
session.entropy_file => /dev/urandom => /dev/urandom
session.entropy_length => 32 => 32
session.gc_divisor => 1000 => 1000
session.gc_maxlifetime => 1440 => 1440
session.gc_probability => 0 => 0
session.hash_bits_per_character => 5 => 5
session.hash_function => 0 => 0
session.name => PHPSESSID => PHPSESSID
session.referer_check => no value => no value
session.save_handler => files => files
session.save_path => /var/lib/php5/sessions => /var/lib/php5/sessions
session.serialize_handler => php => php
session.upload_progress.cleanup => On => On
session.upload_progress.enabled => On => On
session.upload_progress.freq => 1% => 1%
session.upload_progress.min_freq => 1 => 1
session.upload_progress.name => PHP_SESSION_UPLOAD_PROGRESS => PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix => upload_progress_ => upload_progress_
session.use_cookies => On => On
session.use_only_cookies => On => On
session.use_strict_mode => Off => Off
session.use_trans_sid => 0 => 0
 
shmop
 
shmop support => enabled
 
SimpleXML
 
Simplexml support => enabled
Revision => $Id: d7077fc935154236afb4fe70814ba358efdbdca4 $
Schema support => enabled
 
soap
 
Soap Client => enabled
Soap Server => enabled
 
Directive => Local Value => Master Value
soap.wsdl_cache => 1 => 1
soap.wsdl_cache_dir => /tmp => /tmp
soap.wsdl_cache_enabled => 1 => 1
soap.wsdl_cache_limit => 5 => 5
soap.wsdl_cache_ttl => 86400 => 86400
 
sockets
 
Sockets Support => enabled
 
SPL
 
SPL support => enabled
Interfaces => Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes => AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException
 
standard
 
Dynamic Library Support => enabled
Path to sendmail => /usr/sbin/sendmail -t -i 
 
Directive => Local Value => Master Value
assert.active => 1 => 1
assert.bail => 0 => 0
assert.callback => no value => no value
assert.quiet_eval => 0 => 0
assert.warning => 1 => 1
auto_detect_line_endings => 0 => 0
default_socket_timeout => 60 => 60
from => no value => no value
url_rewriter.tags => a=href,area=href,frame=src,input=src,form=fakeentry => a=href,area=href,frame=src,input=src,form=fakeentry
user_agent => no value => no value
 
sysvmsg
 
sysvmsg support => enabled
Revision => $Id: 58590192720bc56939152fde3645d808b348bb9b $
 
tokenizer
 
Tokenizer Support => enabled
 
wddx
 
WDDX Support => enabled
WDDX Session Serializer => enabled
 
xml
 
XML Support => active
XML Namespace Support => active
libxml2 Version => 2.9.1
 
xmlreader
 
XMLReader => enabled
 
xmlwriter
 
XMLWriter => enabled
 
Zend OPcache
 
Opcode Caching => Disabled
Optimization => Disabled
Startup Failed => Opcode Caching is disabled for CLI
 
Directive => Local Value => Master Value
opcache.blacklist_filename => no value => no value
opcache.consistency_checks => 0 => 0
opcache.dups_fix => Off => Off
opcache.enable => On => On
opcache.enable_cli => Off => Off
opcache.enable_file_override => Off => Off
opcache.error_log => no value => no value
opcache.fast_shutdown => 0 => 0
opcache.file_update_protection => 2 => 2
opcache.force_restart_timeout => 180 => 180
opcache.inherited_hack => On => On
opcache.interned_strings_buffer => 4 => 4
opcache.load_comments => 1 => 1
opcache.lockfile_path => /tmp => /tmp
opcache.log_verbosity_level => 1 => 1
opcache.max_accelerated_files => 2000 => 2000
opcache.max_file_size => 0 => 0
opcache.max_wasted_percentage => 5 => 5
opcache.memory_consumption => 64 => 64
opcache.optimization_level => 0x7FFFBFFF => 0x7FFFBFFF
opcache.preferred_memory_model => no value => no value
opcache.protect_memory => 0 => 0
opcache.restrict_api => no value => no value
opcache.revalidate_freq => 2 => 2
opcache.revalidate_path => Off => Off
opcache.save_comments => 1 => 1
opcache.use_cwd => On => On
opcache.validate_permission => Off => Off
opcache.validate_root => Off => Off
opcache.validate_timestamps => On => On
 
zip
 
Zip => enabled
Zip version => 1.12.5
Libzip version => 0.11.2
 
zlib
 
ZLib Support => enabled
Stream Wrapper => compress.zlib://
Stream Filter => zlib.inflate, zlib.deflate
Compiled Version => 1.2.8
Linked Version => 1.2.8
 
Directive => Local Value => Master Value
zlib.output_compression => Off => Off
zlib.output_compression_level => -1 => -1
zlib.output_handler => no value => no value
 
Additional Modules
 
Module Name
sysvsem
sysvshm
 
Environment
 
Variable => Value
HOSTNAME => 7c7781d87c3a
TERM => xterm
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PWD => /
SHLVL => 1
HOME => /root
_ => /usr/bin/php
 
PHP Variables
 
Variable => Value
_SERVER["HOSTNAME"] => 7c7781d87c3a
_SERVER["TERM"] => xterm
_SERVER["PATH"] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
_SERVER["PWD"] => /
_SERVER["SHLVL"] => 1
_SERVER["HOME"] => /root
_SERVER["_"] => /usr/bin/php
_SERVER["PHP_SELF"] => 
_SERVER["SCRIPT_NAME"] => 
_SERVER["SCRIPT_FILENAME"] => 
_SERVER["PATH_TRANSLATED"] => 
_SERVER["DOCUMENT_ROOT"] => 
_SERVER["REQUEST_TIME_FLOAT"] => 1503144845.2526
_SERVER["REQUEST_TIME"] => 1503144845
_SERVER["argv"] => Array
(
)
 
_SERVER["argc"] => 0
 
PHP License
This program is free software; you can redistribute it and/or modify
it under the terms of the PHP License as published by the PHP Group
and included in the distribution in the file:  LICENSE
 
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 
If you did not receive a copy of the PHP license, or have any
questions about PHP licensing, please contact license@php.net.
Segmentation fault (core dumped)

Comment by Georg Richter [ 2017-08-20 ]

As you can see under the mysqli section, PHP was compiled with MySQL 5.5.53 header files:

Client API library version => 10.2.8
Client API header version => 5.5.53

The mysqli extension is using a lot of internal functions and structures which are not part of the MySQL/MariaDB api and might crash therefore. The mysql extension should be fine, however the config.m4 file in ext/mysql needs some adjustments, since it doesn't use mysql_config and has hardcoded paths for include and library lookups.

I would recommend to use/install mysqlnd instead of MySQL or MariaDB client libraries.

Generated at Thu Feb 08 08:04:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.