ID: 42704
Updated by: [EMAIL PROTECTED]
Reported By: carl dot washburn at iridium dot com
-Status: Open
+Status: Feedback
Bug Type: Sybase (dblib) related
Operating System: Solaris 10
PHP Version: 5.2.4
New Comment:
Since ext/soap has absolutely nothing to do with ext/sybase it sounds a
bit far fetched that simply disabling ext/soap in the build would have
any effect on this. Are you sure you don't have some prepend/append
stuff set in your php.ini that might be doing something with soap? What
is the full configure line that causes the problem? And what is the full
configure line that works?
Previous Comments:
------------------------------------------------------------------------
[2007-09-18 23:10:30] carl dot washburn at iridium dot com
Added info:
This is 64 bit php build. 32 bit has not been tested.
Code that reproduces bug:
<?php
$btime=mktime(0,0,0,09,17,2007);
$etime=mktime(23,59,59,09,18,2007);
sybase_connect('OURhost','OURuser','OURpass');
sybase_select_db("OURdb");
$querytxt="SELECT COUNT(MT_ID_) FROM MTTS_MaintenanceTicket WHERE
(Creation_Date_Time__Submit__ BETWEEN CONVERT(INT,'$btime') AND
CONVERT(INT,'$etime') OR Modified_Date_Time_ BETWEEN
CONVERT(INT,'$btime') AND CONVERT(INT,'$etime')) AND
CONVERT(VARCHAR,Priority__code_) like '%' AND CONVERT(VARCHAR,MT_State_)
like '%' AND Assigned_to__Login_Name_ LIKE '%' AND MT_ID_ like '%'
AND(Ownership_Server_ LIKE '%' OR To_Server LIKE '$server' or
Current_Server LIKE '$server') ORDER BY Creation_Date_Time__Submit__";
$mttsq=sybase_query("$querytxt");
?>
------------------------------------------------------------------------
[2007-09-18 19:16:16] carl dot washburn at iridium dot com
Description:
------------
I have seen this problem in both 5.2.3 and 5.2.4.
If I compile php with:
--with-sybase=/usr/local/freetds
--enable-soap,
I receive the following when calling sybase_query:
"Allowed memory size of 104857600 bytes exhausted (tried to allocate
4722688 bytes)"
If I use:
ini_set("memory_limit","-1");
ini_set("max_execution_time","-1");
I receive from the same call to sybase_query:
"Out of memory (allocated 8156348416) (tried to allocate 370671616
bytes)" .
The query returns requested information if I do not enable soap
extensions.
Expected result:
----------------
Query to return the same information as without --enable-soap.
Actual result:
--------------
Query fails.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=42704&edit=1
