#32675 [Csd->Bgs]: mysql_fetch_field() causes segmentation fault

ID: 32675 Updated by: tony2001@php.net Reported By: michael at cosby dot dhs dot org -Status: Closed +Status: Bogus Bug Type: MySQL related Operating System: Linux 2.6 PHP Version: 5.0.4 New Comment: No PHP bug -> bogus. Previous Comments: ------------------------------------------------------------------------ [2005-04-12 08:43:35] michael at cosby dot dhs dot org Well, that's embarrasing... I was compiling with the mysql 4.1 include files but the 4.0.21 binaries, so of course my pre-compiled 5.0.2 kept working..... ------------------------------------------------------------------------ [2005-04-11 23:13:22] sniper@php.net Noticed this: "apache 2.0.52 in multi-threaded mode".. What if you try with prefork apache2? ------------------------------------------------------------------------ [2005-04-11 22:24:45] michael at cosby dot dhs dot org It appears that I'm already using the external mysql client library, or I'm reading phpinfo() wrong: MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 4.0.21 MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient ------------------------------------------------------------------------ [2005-04-11 20:04:08] michael at cosby dot dhs dot org For the libraries, it appears that my PHP is *not* compiling with the 4.1.11 client library, but with a 4.0.21 client library. I'm trying to get it to compile with with the 4.1.11 library to see what happens, but I doubt that will fix it since this same 4.0.21 client library works fine with PHP 5.0.2. ------------------------------------------------------------------------ [2005-04-11 20:01:16] michael at cosby dot dhs dot org It looks like my query cache is already disabled: mysql> show variables; +---------------------------------+----------------------------+ | Variable_name | Value | +---------------------------------+----------------------------+ ... | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 0 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | ... From the mysql manual at http://dev.mysql.com/doc/mysql/en/query-cache.html: " To disable the query cache at server startup, set the query_cache_size system variable to 0. By disabling the query cache code, there is no noticeable overhead. " (I'm not real familiar with the query cache, so I wanted to be 100% sure it was disabled). ------------------------------------------------------------------------ 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/32675 -- Edit this bug report at http://bugs.php.net/?id=32675&edit=1