#32110 [NEW]: MSSQL connection crash when set mssql.textlimit and mssql.textsize

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