From: marcos at ivirtua dot com dot br
Operating system: Linux
PHP version: 4.3.10
PHP Bug Type: Reproducible crash
Bug description: MSSQL connection crash when set mssql.textlimit and
mssql.textsize
Description:
------------
I need to retrive more than 4k from a blob field (rtf text).
I've set these values in my php.ini:
mssql.textlimit = 2147483647;
mssql.textsize = 2147483647;
Everything works fine using CGI, but when using SAPI (dll) after some
operations I can't connect to database anymore. A server restart is
needed, and everything works fine again for some time, and crash again.
I'm using Apache/1.3.33 (Win32) PHP/4.3.9, but it still happens in Apache
2.0 (Linux) PHP/4.3.10
Reproduce code:
---------------
Use PHP ISAPI.
<?
ini_set("mssql.textlimit", "2147483647");
ini_set("mssql.textsize", "2147483647");
mssql_connect('db_host', 'db_user', 'db_pass');
mssql_select_db('db_name');
$qry= mssql_query('select myblobfield from table');
$row=mssql_fetch_row($qry);
echo($row_aux[0]);
?>
Repeat for some times (10, 20, 30 times, etc).
Expected result:
----------------
The full content of blob field, wich has more then 100KB, every time I run
the code.
Actual result:
--------------
The full content of blob field for just some times. After a period, the
server must be restarted because I can't connect with:
mssql_connect('db_host', 'db_user', 'db_pass');
mssql_select_db('db_name');
--
Edit bug report at http://bugs.php.net/?id=32110&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32110&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=32110&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=32110&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=32110&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=32110&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=32110&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=32110&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=32110&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=32110&r=support
Expected behavior: http://bugs.php.net/fix.php?id=32110&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=32110&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=32110&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=32110&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32110&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=32110&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=32110&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=32110&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=32110&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=32110&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=32110&r=mysqlcfg
