ID: 32110
Updated by: [EMAIL PROTECTED]
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
