#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=32110edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32110r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=32110r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=32110r=trysnapshot51
Fixed in CVS:http://bugs.php.net/fix.php?id=32110r=fixedcvs
Fixed in release:http://bugs.php.net/fix.php?id=32110r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=32110r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=32110r=needscript
Try newer version: http://bugs.php.net/fix.php?id=32110r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=32110r=support
Expected behavior: http://bugs.php.net/fix.php?id=32110r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=32110r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=32110r=submittedtwice
register_globals:http://bugs.php.net/fix.php?id=32110r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32110r=php3
Daylight Savings:http://bugs.php.net/fix.php?id=32110r=dst
IIS Stability: http://bugs.php.net/fix.php?id=32110r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=32110r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=32110r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=32110r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=32110r=mysqlcfg
#32110 [Opn]: MSSQL connection crash when set mssql.textlimit and mssql.textsize
ID: 32110
User updated by: marcos at ivirtua dot com dot br
Reported By: marcos at ivirtua dot com dot br
Status: Open
Bug Type: Reproducible crash
Operating System: Linux
PHP Version: 4.3.10
New Comment:
Sorry, the echo line must be:
echo($row[0]);
All the rest keep the same.
Previous Comments:
[2005-02-25 15:21:07] marcos at ivirtua dot com dot br
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 this bug report at http://bugs.php.net/?id=32110edit=1
