#32110 [Opn->Bgs]: MSSQL connection crash when set mssql.textlimit and mssql.textsize
| From: | fmk@php.net | Date: | Fri, 25 Feb 2005 23:23:50 +0000 |
| Subject: | #32110 [Opn->Bgs]: MSSQL connection crash when set mssql.textlimit and mssql.textsize | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-74603@lists.php.net to get a copy of this message | ||
ID: 32110
Updated by: fmk@php.net
Reported By: marcos at ivirtua dot com dot br
-Status: Open
+Status: Bogus
Bug Type: Reproducible crash
Operating System: Linux
PHP Version: 4.3.10
New Comment:
The MSSQL library used for this extension is not thread safe, and mght
cause problems under any threaded web server.
DBTEXTLIMIT is not supported by FreeTDS. I'll commit a patch for this.
Previous Comments:
------------------------------------------------------------------------
[2005-02-25 15:24:32] marcos at ivirtua dot com dot br
Sorry, the echo line must be:
echo($row[0]);
All the rest keep the same.
------------------------------------------------------------------------
[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=32110&edit=1