#44560 [NEW]: Apache crashes with PDO_OCI and both persistent and non-persistent connectios

2008-03-28 Thread jarismar_silva at adplabs dot com dot br 
From: jarismar_silva at adplabs dot com dot br
Operating system: Windows XP SP2
PHP version:  5.2.6RC3
PHP Bug Type: PDO related
Bug description:  Apache crashes with PDO_OCI and both persistent and 
non-persistent connectios

Description:

Sometimes our DBAs restart oracle without restarting the apache server,
due to this if apache has persistent connections, those connections are in
invalid state.
 In this scenario trying to connect to oracle results in on of the
following errors:
 ORA-00028: your session has been killed
 ORA-01012: not logged on
 ORA-03113 end-of-file on communication channel
 I'm trying to handle this errors and skipping creating the persistent
connection and then creating a new non-persistent connection (see the php
snippet). I was in hope that doing this could force apache to free the
invalid persistent connection, but instead apache crashes (it seems a
problem freeing the statements).

Reproduce code:
---
try {
  $oPDO = new PDO($sDSN, $sUserName, $sPassword,
array(PDO::ATTR_PERSISTENT = true));
  print Persistent connection created\n;
  $oPDO-setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (Exception $oE) {
  echo Error : .$oE-getMessage().\n;
  $oPDO = new PDO($sDSN, $sUserName, $sPassword,
array(PDO::ATTR_PERSISTENT = false));
  print Non persistent connection created\n;
}

try {
  $oStatement = $oPDO-prepare('Select 1+1 as test from dual');
  var_dump($oStatement-execute());
  var_dump($oStatement-fetchAll());
} catch (Exception $oE) {
  echo Error : .$oE-getMessage().\n;
} 

$oPDO = null;

Expected result:

  I expect either the system get ride of invalid persistent connections or
when one create a non-peristent connection it replaces the persistent one
if there is any.


Actual result:
--
  Unhandled exception at 0x0087ac76 (php5ts.dll) in Apache.exe:
0xC005: Access violation reading location 0x002b5ffc.
   php5ts.dll!_zend_mm_free_int(_zend_mm_heap * heap=0x01ded100, void *
p=0x0005000c)  Line 1960C
php5ts.dll!_efree(void * ptr=0x00265ff8)  Line 2293 + 0xb bytes C
php_pdo_oci.dll!oci_stmt_dtor(_pdo_stmt_t * stmt=0x, void * * *
tsrm_ls=0x01debeb0)  Line 90 + 0x3 bytesC
php_pdo.dll!free_statement(_pdo_stmt_t * stmt=0x02b9ad48, void * * *
tsrm_ls=0x01debeb0)  Line 2355 + 0x8 bytes  C
php_pdo.dll!php_pdo_stmt_delref(_pdo_stmt_t * stmt=0x02b9ad48, void * *
* tsrm_ls=0x01debeb0)  Line 2397 + 0xb bytesC
php_pdo.dll!pdo_dbstmt_free_storage(_pdo_stmt_t * stmt=0x02b9ad48, void
* * * tsrm_ls=0x01debeb0)  Line 2402 + 0xf bytesC
php5ts.dll!zend_objects_store_del_ref_by_handle(unsigned int handle=2,
void * * * tsrm_ls=0x01debeb0)  Line 206 + 0x11 bytes   C
php5ts.dll!zend_objects_store_del_ref(_zval_struct * zobject=0x02b9ab00,
void * * * tsrm_ls=0x01debeb0)  Line 169C
php5ts.dll!_zval_dtor_func(_zval_struct * zvalue=0x02b9ab00)  Line 60   
C
php5ts.dll!_zval_ptr_dtor(_zval_struct * * zval_ptr=0x02b9aefc)  Line
414 + 0xc bytes C
php5ts.dll!zend_hash_apply_deleter(_hashtable * ht=0x01e22460, bucket *
p=0x02b9aef0)  Line 611 + 0x6 bytes C
php5ts.dll!zend_hash_reverse_apply(_hashtable * ht=0x01e22460, int (void
*, void * * *)* apply_func=0x00907bb0, void * * * tsrm_ls=0x01debeb0)  Line
760 + 0xb bytes C
php5ts.dll!shutdown_destructors(void * * * tsrm_ls=0x01debeb0)  Line
212 C
php5ts.dll!zend_call_destructors(void * * * tsrm_ls=0x01debeb0)  Line
845 + 0x6 bytes C
php5ts.dll!php_request_shutdown(void * dummy=0x)  Line 1445 +
0x6 bytes   C
php5apache2.dll!php_apache_request_dtor(request_rec * r=0x01bc6de0, void
* * * tsrm_ls=0x01debeb0)  Line 468 + 0x8 bytes C
php5apache2.dll!php_handler(request_rec * r=0x01bc6de0)  Line 641 + 0x7
bytes   C
libhttpd.dll!6ff01575() 
[Frames below may be incorrect and/or missing, no symbols loaded for
libhttpd.dll]   
libhttpd.dll!6ff019fd() 
libhttpd.dll!6ff0e15c() 
libhttpd.dll!6ff09966() 
libhttpd.dll!6ff04275() 
libhttpd.dll!6ff044f2() 
libhttpd.dll!6ff1c3b8() 
msvcr71.dll!7c36b381()  
ntdll.dll!7c91849f()
msvcr71.dll!7c3638e2()  
kernel32.dll!7c80b683() 
ntdll.dll!7c91849f()


-- 
Edit bug report at http://bugs.php.net/?id=44560edit=1
-- 
Try a CVS snapshot (PHP 5.2): 
http://bugs.php.net/fix.php?id=44560r=trysnapshot52
Try a CVS snapshot (PHP 5.3): 
http://bugs.php.net/fix.php?id=44560r=trysnapshot53
Try a CVS snapshot (PHP 6.0): 
http://bugs.php.net/fix.php?id=44560r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=44560r=fixedcvs
Fixed in release: 
http://bugs.php.net/fix.php?id=44560r=alreadyfixed
Need backtrace:   http://bugs.php.net/fix.php

#44560 [Opn]: Apache crashes with PDO_OCI and both persistent and non-persistent connections.

2008-03-28 Thread jarismar_silva at adplabs dot com dot br 
 ID:   44560
 User updated by:  jarismar_silva at adplabs dot com dot br
-Summary:  Apache crashes with PDO_OCI and both persistent and
   non-persistent connectios
 Reported By:  jarismar_silva at adplabs dot com dot br
 Status:   Open
 Bug Type: PDO related
 Operating System: Windows XP SP2
 PHP Version:  5.2.6RC3
 New Comment:

You can more reproduce this error by killing the persistent
connection.
First you need to discovering the SID and Serial# from the persistent 
connection in order to kill it:

This SQL retrieve SID and SERIAL# :
select * from  (
select
  nvl(ses.USERNAME,'ORACLE PROC') username,
  PROGRAM,
  MACHINE,
  ses.status status,
PROCESS pid,
ses.SID SID,
SERIAL#
fromv$session ses,
v$sess_io sio
where   ses.SID = sio.SID
order   by PHYSICAL_READS, ses.USERNAME
) where username = 'RPTDEV7'
order by machine, pid, sid

Then kill the session with
ALTER SYSTEM KILL SESSION 'SID,SERIAL#';


Previous Comments:


[2008-03-28 14:53:42] jarismar_silva at adplabs dot com dot br

Description:

Sometimes our DBAs restart oracle without restarting the apache server,
due to this if apache has persistent connections, those connections are
in invalid state.
 In this scenario trying to connect to oracle results in on of the
following errors:
 ORA-00028: your session has been killed
 ORA-01012: not logged on
 ORA-03113 end-of-file on communication channel
 I'm trying to handle this errors and skipping creating the persistent
connection and then creating a new non-persistent connection (see the
php snippet). I was in hope that doing this could force apache to free
the invalid persistent connection, but instead apache crashes (it seems
a problem freeing the statements).

Reproduce code:
---
try {
  $oPDO = new PDO($sDSN, $sUserName, $sPassword,
array(PDO::ATTR_PERSISTENT = true));
  print Persistent connection created\n;
  $oPDO-setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (Exception $oE) {
  echo Error : .$oE-getMessage().\n;
  $oPDO = new PDO($sDSN, $sUserName, $sPassword,
array(PDO::ATTR_PERSISTENT = false));
  print Non persistent connection created\n;
}

try {
  $oStatement = $oPDO-prepare('Select 1+1 as test from dual');
  var_dump($oStatement-execute());
  var_dump($oStatement-fetchAll());
} catch (Exception $oE) {
  echo Error : .$oE-getMessage().\n;
} 

$oPDO = null;

Expected result:

  I expect either the system get ride of invalid persistent connections
or when one create a non-peristent connection it replaces the persistent
one if there is any.


Actual result:
--
  Unhandled exception at 0x0087ac76 (php5ts.dll) in Apache.exe:
0xC005: Access violation reading location 0x002b5ffc.
   php5ts.dll!_zend_mm_free_int(_zend_mm_heap * heap=0x01ded100, void *
p=0x0005000c)  Line 1960C
php5ts.dll!_efree(void * ptr=0x00265ff8)  Line 2293 + 0xb bytes C
php_pdo_oci.dll!oci_stmt_dtor(_pdo_stmt_t * stmt=0x, void * *
* tsrm_ls=0x01debeb0)  Line 90 + 0x3 bytes  C
php_pdo.dll!free_statement(_pdo_stmt_t * stmt=0x02b9ad48, void * * *
tsrm_ls=0x01debeb0)  Line 2355 + 0x8 bytes  C
php_pdo.dll!php_pdo_stmt_delref(_pdo_stmt_t * stmt=0x02b9ad48, void *
* * tsrm_ls=0x01debeb0)  Line 2397 + 0xb bytes  C
php_pdo.dll!pdo_dbstmt_free_storage(_pdo_stmt_t * stmt=0x02b9ad48,
void * * * tsrm_ls=0x01debeb0)  Line 2402 + 0xf bytes   C
php5ts.dll!zend_objects_store_del_ref_by_handle(unsigned int
handle=2, void * * * tsrm_ls=0x01debeb0)  Line 206 + 0x11 bytes C
php5ts.dll!zend_objects_store_del_ref(_zval_struct *
zobject=0x02b9ab00, void * * * tsrm_ls=0x01debeb0)  Line 169C
php5ts.dll!_zval_dtor_func(_zval_struct * zvalue=0x02b9ab00)  Line
60  C
php5ts.dll!_zval_ptr_dtor(_zval_struct * * zval_ptr=0x02b9aefc)  Line
414 + 0xc bytes C
php5ts.dll!zend_hash_apply_deleter(_hashtable * ht=0x01e22460, bucket
* p=0x02b9aef0)  Line 611 + 0x6 bytes   C
php5ts.dll!zend_hash_reverse_apply(_hashtable * ht=0x01e22460, int
(void *, void * * *)* apply_func=0x00907bb0, void * * *
tsrm_ls=0x01debeb0)  Line 760 + 0xb bytes   C
php5ts.dll!shutdown_destructors(void * * * tsrm_ls=0x01debeb0)  Line
212 C
php5ts.dll!zend_call_destructors(void * * * tsrm_ls=0x01debeb0)  Line
845 + 0x6 bytes C
php5ts.dll!php_request_shutdown(void * dummy=0x)  Line 1445 +
0x6 bytes   C
php5apache2.dll!php_apache_request_dtor(request_rec * r=0x01bc6de0,
void * * * tsrm_ls=0x01debeb0)  Line 468 + 0x8 bytesC
php5apache2.dll!php_handler(request_rec * r=0x01bc6de0)  Line 641 +
0x7 bytes   C
libhttpd.dll!6ff01575() 
[Frames below may be incorrect and/or missing, no symbols loaded for
libhttpd.dll]   
libhttpd.dll!6ff019fd

#41566 [NEW]: SOAP Server not properly generating href attributes.

2007-06-01 Thread jarismar_silva at adplabs dot com dot br 
From: jarismar_silva at adplabs dot com dot br
Operating system: 
PHP version:  5.2.3
PHP Bug Type: SOAP related
Bug description:  SOAP Server not properly generating href attributes.

Description:

SoapServer response xml contains wrong references to node ids.

With PHP 5.2.3 we got this for returned items...
item xsi:type=ns1:User id=ref1
  sName xsi:type=xsd:stringuserA/sName
/item
item href=#ref1/
item href=ref1/ -- See the missing '#' char
item href=ref1/ -- See the missing '#' char

Manually changing the response xml to include the '#' solves the problem:
item xsi:type=ns1:User id=ref1
  sName xsi:type=xsd:stringuserA/sName
/item
item href=#ref1/
item href=#ref1/
item href=#ref1/


Reproduce code:
---
To reproduce this problem try to return the same object many times on any
SOAP Service.
  
/** @return User[] */ 
function UserSoapService() {
  $aUser = new User();
  $aUser-sName = 'newUser';

  $aUsers = Array();
  $aUsers[] = $aUser;
  $aUsers[] = $aUser;
  $aUsers[] = $aUser;
  $aUsers[] = $aUser;
  return $aUsers;
}

/* Simple User definition */
Class User {
  /** @var string */
  public $sName;
}


Expected result:

Array with 4 times the same user object.

Actual result:
--
Exception of class SoapFault
SOAP-ERROR: Encoding: External reference 'ref1'

-- 
Edit bug report at http://bugs.php.net/?id=41566edit=1
-- 
Try a CVS snapshot (PHP 4.4): 
http://bugs.php.net/fix.php?id=41566r=trysnapshot44
Try a CVS snapshot (PHP 5.2): 
http://bugs.php.net/fix.php?id=41566r=trysnapshot52
Try a CVS snapshot (PHP 6.0): 
http://bugs.php.net/fix.php?id=41566r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=41566r=fixedcvs
Fixed in release: 
http://bugs.php.net/fix.php?id=41566r=alreadyfixed
Need backtrace:   http://bugs.php.net/fix.php?id=41566r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=41566r=needscript
Try newer version:http://bugs.php.net/fix.php?id=41566r=oldversion
Not developer issue:  http://bugs.php.net/fix.php?id=41566r=support
Expected behavior:http://bugs.php.net/fix.php?id=41566r=notwrong
Not enough info:  
http://bugs.php.net/fix.php?id=41566r=notenoughinfo
Submitted twice:  
http://bugs.php.net/fix.php?id=41566r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=41566r=globals
PHP 3 support discontinued:   http://bugs.php.net/fix.php?id=41566r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=41566r=dst
IIS Stability:http://bugs.php.net/fix.php?id=41566r=isapi
Install GNU Sed:  http://bugs.php.net/fix.php?id=41566r=gnused
Floating point limitations:   http://bugs.php.net/fix.php?id=41566r=float
No Zend Extensions:   http://bugs.php.net/fix.php?id=41566r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=41566r=mysqlcfg

#39199 [Csd-Opn]: Cannot load Lob data with more than 4000 bytes on ORACLE 10

2006-11-07 Thread jarismar_silva at adplabs dot com dot br 
 ID:   39199
 User updated by:  jarismar_silva at adplabs dot com dot br
 Reported By:  jarismar_silva at adplabs dot com dot br
-Status:   Closed
+Status:   Open
 Bug Type: PDO related
-Operating System: Linux
+Operating System: SuSE, WinXP
-PHP Version:  5.2.0RC5
+PHP Version:  5.2.0
 Assigned To:  wez
 New Comment:

I'm reopening this bug. I have found that this bug still occurs with
Oracle Client 10.2 and SuSE Enterprise Server v.9 Patch Lvl 3 / WinXP.


Previous Comments:


[2006-10-23 12:17:04] jarismar_silva at adplabs dot com dot br

I'm closing this bug, as updating to new Oracle instant client seems to
solve the problem.



[2006-10-23 12:10:12] jarismar_silva at adplabs dot com dot rb

I got this bug when working with Oracle instant client 10.2.0.1.
Upgrading to 10.2.0.2 solved the problem.



[2006-10-19 14:59:33] jarismar_silva at adplabs dot com dot br

jarismar_silva at adplabs.com.br



[2006-10-19 14:50:44] jarismar_silva at adplabs dot com dot br

Description:

Trying to read a CLOB field with has more than 4000 bytes result on
empty stream.

Reproduce code:
---
?php
/* Table structure
CREATE TABLE test_clob (
  id  NUMBER(10),
  data CLOB
)
*/

$sDSN = 'oci:dbname=//server:1521/database;charset=UTF-8';
$sUserName = 'user';
$sPassword = 'passwd';

try {
  $oPDO = new PDO($sDSN, $sUserName, $sPassword, $aDriverOptions);
  $oStmt = $oPDO-prepare(insert into test_clob (id, data) values
(:id, EMPTY_CLOB()));
  $iID = 1;
  $oStmt-bindParam(':id', $iID);
  if ($oStmt-execute()) {
$oStmt = $oPDO-prepare(update test_clob set data=:value where
id=1);
$sData = '4000 bytes or more';
$oStmt-bindParam(':value', $sData);
if ($oStmt-execute() === false) {
  throw new Exception('Error on update clob');
}
  } else {
throw new Exception('Error on insert EMPTY_CLOB');
  }

  $oStmt = $oPDO-prepare(select data from test_clob where id =
:id);
  $oStmt-bindParam('id', $iID);
  $oStmt-execute();
  $oResult = $oStmt-fetch();
  echo 'Read '.strlen(stream_get_contents($oResult['DATA'])).'
characters br';

} catch (Exception $oE) {
  echo 'pre';print_r($oStmt-errorInfo());echo /prebr\n;
  echo $oException-getMessage().br\n;
}
$oPDO = null;

Expected result:

Read N characters (N 0)

Actual result:
--
Read 0 characters





-- 
Edit this bug report at http://bugs.php.net/?id=39199edit=1

#39199 [Opn]: Cannot load Lob data with more than 4000 bytes on ORACLE 10

2006-11-07 Thread jarismar_silva at adplabs dot com dot br 
 ID:   39199
 User updated by:  jarismar_silva at adplabs dot com dot br
 Reported By:  jarismar_silva at adplabs dot com dot br
 Status:   Open
 Bug Type: PDO related
 Operating System: SuSE, WinXP
 PHP Version:  5.2.0
 Assigned To:  wez
 New Comment:

Previously (when close the bug) I have tested on Slackware 11 with
Oracle Instant Client 10.2 and I stop getting this bug. The same on
another box running Kubuntu and Oracle Instant Client 10.2. But I got
the bug on a Suse server and many XP machines used on development.


Previous Comments:


[2006-11-07 17:11:38] diegotremper at gmail dot com

I obtained in the same error on Windows XP SP2



[2006-11-07 17:05:46] jarismar_silva at adplabs dot com dot br

I'm reopening this bug. I have found that this bug still occurs with
Oracle Client 10.2 and SuSE Enterprise Server v.9 Patch Lvl 3 / WinXP.



[2006-10-23 12:17:04] jarismar_silva at adplabs dot com dot br

I'm closing this bug, as updating to new Oracle instant client seems to
solve the problem.



[2006-10-23 12:10:12] jarismar_silva at adplabs dot com dot rb

I got this bug when working with Oracle instant client 10.2.0.1.
Upgrading to 10.2.0.2 solved the problem.



[2006-10-19 14:59:33] jarismar_silva at adplabs dot com dot br

jarismar_silva at adplabs.com.br



The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/39199

-- 
Edit this bug report at http://bugs.php.net/?id=39199edit=1

#39199 [Asn-Csd]: Cannot load Lob data with more than 4000 bytes on ORACLE 10

2006-10-23 Thread jarismar_silva at adplabs dot com dot br 
 ID:   39199
 User updated by:  jarismar_silva at adplabs dot com dot br
 Reported By:  jarismar_silva at adplabs dot com dot br
-Status:   Assigned
+Status:   Closed
 Bug Type: PDO related
 Operating System: Linux
 PHP Version:  5.2.0RC5
 Assigned To:  wez
 New Comment:

I'm closing this bug, as updating to new Oracle instant client seems to
solve the problem.


Previous Comments:


[2006-10-23 12:10:12] jarismar_silva at adplabs dot com dot rb

I got this bug when working with Oracle instant client 10.2.0.1.
Upgrading to 10.2.0.2 solved the problem.



[2006-10-19 14:59:33] jarismar_silva at adplabs dot com dot br

jarismar_silva at adplabs.com.br



[2006-10-19 14:50:44] jarismar_silva at adplabs dot com dot br

Description:

Trying to read a CLOB field with has more than 4000 bytes result on
empty stream.

Reproduce code:
---
?php
/* Table structure
CREATE TABLE test_clob (
  id  NUMBER(10),
  data CLOB
)
*/

$sDSN = 'oci:dbname=//server:1521/database;charset=UTF-8';
$sUserName = 'user';
$sPassword = 'passwd';

try {
  $oPDO = new PDO($sDSN, $sUserName, $sPassword, $aDriverOptions);
  $oStmt = $oPDO-prepare(insert into test_clob (id, data) values
(:id, EMPTY_CLOB()));
  $iID = 1;
  $oStmt-bindParam(':id', $iID);
  if ($oStmt-execute()) {
$oStmt = $oPDO-prepare(update test_clob set data=:value where
id=1);
$sData = '4000 bytes or more';
$oStmt-bindParam(':value', $sData);
if ($oStmt-execute() === false) {
  throw new Exception('Error on update clob');
}
  } else {
throw new Exception('Error on insert EMPTY_CLOB');
  }

  $oStmt = $oPDO-prepare(select data from test_clob where id =
:id);
  $oStmt-bindParam('id', $iID);
  $oStmt-execute();
  $oResult = $oStmt-fetch();
  echo 'Read '.strlen(stream_get_contents($oResult['DATA'])).'
characters br';

} catch (Exception $oE) {
  echo 'pre';print_r($oStmt-errorInfo());echo /prebr\n;
  echo $oException-getMessage().br\n;
}
$oPDO = null;

Expected result:

Read N characters (N 0)

Actual result:
--
Read 0 characters





-- 
Edit this bug report at http://bugs.php.net/?id=39199edit=1

#39199 [Asn]: Cannot load Lob data with more than 4000 bytes on ORACLE 10

2006-10-19 Thread jarismar_silva at adplabs dot com dot br 
 ID:   39199
 User updated by:  jarismar_silva at adplabs dot com dot br
-Reported By:  jarismar_silva at adplabs dot com
+Reported By:  jarismar_silva at adplabs dot com dot br
 Status:   Assigned
 Bug Type: PDO related
 Operating System: Linux
 PHP Version:  5.2.0RC5
 Assigned To:  wez
 New Comment:

jarismar_silva at adplabs.com.br


Previous Comments:


[2006-10-19 14:50:44] jarismar_silva at adplabs dot com dot br

Description:

Trying to read a CLOB field with has more than 4000 bytes result on
empty stream.

Reproduce code:
---
?php
/* Table structure
CREATE TABLE test_clob (
  id  NUMBER(10),
  data CLOB
)
*/

$sDSN = 'oci:dbname=//server:1521/database;charset=UTF-8';
$sUserName = 'user';
$sPassword = 'passwd';

try {
  $oPDO = new PDO($sDSN, $sUserName, $sPassword, $aDriverOptions);
  $oStmt = $oPDO-prepare(insert into test_clob (id, data) values
(:id, EMPTY_CLOB()));
  $iID = 1;
  $oStmt-bindParam(':id', $iID);
  if ($oStmt-execute()) {
$oStmt = $oPDO-prepare(update test_clob set data=:value where
id=1);
$sData = '4000 bytes or more';
$oStmt-bindParam(':value', $sData);
if ($oStmt-execute() === false) {
  throw new Exception('Error on update clob');
}
  } else {
throw new Exception('Error on insert EMPTY_CLOB');
  }

  $oStmt = $oPDO-prepare(select data from test_clob where id =
:id);
  $oStmt-bindParam('id', $iID);
  $oStmt-execute();
  $oResult = $oStmt-fetch();
  echo 'Read '.strlen(stream_get_contents($oResult['DATA'])).'
characters br';

} catch (Exception $oE) {
  echo 'pre';print_r($oStmt-errorInfo());echo /prebr\n;
  echo $oException-getMessage().br\n;
}
$oPDO = null;

Expected result:

Read N characters (N 0)

Actual result:
--
Read 0 characters





-- 
Edit this bug report at http://bugs.php.net/?id=39199edit=1

#37331 [Fbk-Csd]: oci_fetch_array makes Apache2 crash

2006-05-09 Thread jarismar_silva at adplabs dot com dot br 
 ID:   37331
 User updated by:  jarismar_silva at adplabs dot com dot br
 Reported By:  jarismar_silva at adplabs dot com dot br
-Status:   Feedback
+Status:   Closed
 Bug Type: OCI8 related
 Operating System: Windows XP Professional SP2
 PHP Version:  5.1.4
 New Comment:

I have upgraded my Linux Server to PHP 5.1.4. This solved my problems
with seg faults on the server.

On windows my code still crashes apache, usign OCI_ASSOC |
OCI_RETURN_LOB (with or without oci_free_statement ), using OCI_NUM
solved the problem.

So I would like to say thanks everybody. This product kicks ass !!


Previous Comments:


[2006-05-06 23:00:31] crescentfreshpot at yahoo dot com

1) On 5.1.4 I can verify your code crashes on win xp.

2) On 5.1.4 changing OCI_ASSOC to OCI_NUM does not seg fault php

3) THe reason for the crash on 5.1.2 might be related to resources not
automatically freeing. In your reproduce code add a
oci_free_statement($stmt); before the end of script and no more crash.
Again, only needed with 5.1.2.



[2006-05-06 21:29:09] [EMAIL PROTECTED]

Well, your reproduce code doesn't cause any problems here, so I still
need a reproduce code to investigate it.



[2006-05-06 15:26:08] jarismar_silva at adplabs dot com dot br

Many thanks for this fast answer. I make a mistake. My linux server is
really running PHP 5.1.2 not 5.1.4, as I spected. But, the bug with
5.1.4 really occurs in windows.

My linux server with 5.1.2 is crashing in another part of the
application (I'm still not sure about the exactly reason, but seems to
be on a call to oci_execute, following is the backtrace on php 5.1.2).
I will upgrade to 5.1.4 and look if the bug really occurs on Linux.
Real sorry for this mistake. In the future I will see the backtrace
before contacting you.

Program received signal SIGSEGV, Segmentation fault.
0x40b8d42f in kpufGetRcvInfo () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
(gdb) bt
#0  0x40b8d42f in kpufGetRcvInfo () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#1  0x40e6836f in ttcacr () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#2  0x40e63fff in ttcdrv () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#3  0x40d04289 in nioqwa () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#4  0x40adc296 in upirtrc () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#5  0x40b8c041 in kpurcsc () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#6  0x40bc7e87 in kpuexecv8 () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#7  0x40bc9a62 in kpuexec () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#8  0x40ad615e in OCIStmtExecute () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#9  0x405a47c4 in php_oci_statement_execute (statement=0x9828808,
mode=159549480)
at /usr/src/php-5.1.2/ext/oci8/oci8_statement.c:321
#10 0x405a848a in zif_oci_execute (ht=2, return_value=0x9c4f724,
return_value_ptr=0x0, this_ptr=0x0, return_value_used=1)
at /usr/src/php-5.1.2/ext/oci8/oci8_interface.c:1276
#11 0x406f9acf in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff30f0) at zend_vm_execute.h:192
#12 0x40743769 in execute (op_array=0x89aaa7c) at zend_vm_execute.h:92
#13 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff33f0) at zend_vm_execute.h:226
#14 0x40743769 in execute (op_array=0x899b99c) at zend_vm_execute.h:92
#15 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff4060) at zend_vm_execute.h:226
#16 0x40743769 in execute (op_array=0x89b09cc) at zend_vm_execute.h:92
#17 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff4790) at zend_vm_execute.h:226
#18 0x40743769 in execute (op_array=0x898e084) at zend_vm_execute.h:92
#19 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff4c50) at zend_vm_execute.h:226
#20 0x40743769 in execute (op_array=0x89aec54) at zend_vm_execute.h:92
#21 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff4d60) at zend_vm_execute.h:226
#22 0x40743769 in execute (op_array=0x89ef87c) at zend_vm_execute.h:92
#23 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff5010) at zend_vm_execute.h:226
#24 0x40743769 in execute (op_array=0x90245c4) at zend_vm_execute.h:92
#25 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff51d0) at zend_vm_execute.h:226
#26 0x40743769 in execute (op_array=0x901ad54) at zend_vm_execute.h:92
#27 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff5770) at zend_vm_execute.h:226
#28 0x40743769 in execute (op_array=0x9151a04) at zend_vm_execute.h:92
#29 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff5bf0) at zend_vm_execute.h:226
#30 0x40743769 in execute (op_array=0x9156b5c) at zend_vm_execute.h:92
#31 0x406f9626

#37331 [Fbk-Opn]: oci_fetch_array makes Apache2 crash

2006-05-06 Thread jarismar_silva at adplabs dot com dot br 
 ID:   37331
 User updated by:  jarismar_silva at adplabs dot com dot br
 Reported By:  jarismar_silva at adplabs dot com dot br
-Status:   Feedback
+Status:   Open
 Bug Type: OCI8 related
 Operating System: Windows XP Professional SP2
 PHP Version:  5.1.4
 New Comment:

Many thanks for this fast answer. I make a mistake. My linux server is
really running PHP 5.1.2 not 5.1.4, as I spected. But, the bug with
5.1.4 really occurs in windows.

My linux server with 5.1.2 is crashing in another part of the
application (I'm still not sure about the exactly reason, but seems to
be on a call to oci_execute, following is the backtrace on php 5.1.2).
I will upgrade to 5.1.4 and look if the bug really occurs on Linux.
Real sorry for this mistake. In the future I will see the backtrace
before contacting you.

Program received signal SIGSEGV, Segmentation fault.
0x40b8d42f in kpufGetRcvInfo () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
(gdb) bt
#0  0x40b8d42f in kpufGetRcvInfo () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#1  0x40e6836f in ttcacr () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#2  0x40e63fff in ttcdrv () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#3  0x40d04289 in nioqwa () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#4  0x40adc296 in upirtrc () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#5  0x40b8c041 in kpurcsc () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#6  0x40bc7e87 in kpuexecv8 () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#7  0x40bc9a62 in kpuexec () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#8  0x40ad615e in OCIStmtExecute () from
/opt/oracle/product/10gR1/lib/libclntsh.so.10.1
#9  0x405a47c4 in php_oci_statement_execute (statement=0x9828808,
mode=159549480)
at /usr/src/php-5.1.2/ext/oci8/oci8_statement.c:321
#10 0x405a848a in zif_oci_execute (ht=2, return_value=0x9c4f724,
return_value_ptr=0x0, this_ptr=0x0, return_value_used=1)
at /usr/src/php-5.1.2/ext/oci8/oci8_interface.c:1276
#11 0x406f9acf in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff30f0) at zend_vm_execute.h:192
#12 0x40743769 in execute (op_array=0x89aaa7c) at zend_vm_execute.h:92
#13 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff33f0) at zend_vm_execute.h:226
#14 0x40743769 in execute (op_array=0x899b99c) at zend_vm_execute.h:92
#15 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff4060) at zend_vm_execute.h:226
#16 0x40743769 in execute (op_array=0x89b09cc) at zend_vm_execute.h:92
#17 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff4790) at zend_vm_execute.h:226
#18 0x40743769 in execute (op_array=0x898e084) at zend_vm_execute.h:92
#19 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff4c50) at zend_vm_execute.h:226
#20 0x40743769 in execute (op_array=0x89aec54) at zend_vm_execute.h:92
#21 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff4d60) at zend_vm_execute.h:226
#22 0x40743769 in execute (op_array=0x89ef87c) at zend_vm_execute.h:92
#23 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff5010) at zend_vm_execute.h:226
#24 0x40743769 in execute (op_array=0x90245c4) at zend_vm_execute.h:92
#25 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff51d0) at zend_vm_execute.h:226
#26 0x40743769 in execute (op_array=0x901ad54) at zend_vm_execute.h:92
#27 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff5770) at zend_vm_execute.h:226
#28 0x40743769 in execute (op_array=0x9151a04) at zend_vm_execute.h:92
#29 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff5bf0) at zend_vm_execute.h:226
#30 0x40743769 in execute (op_array=0x9156b5c) at zend_vm_execute.h:92
#31 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff6220) at zend_vm_execute.h:226
#32 0x40743769 in execute (op_array=0x8bec9d4) at zend_vm_execute.h:92
#33 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfff6550) at zend_vm_execute.h:226
#34 0x40743769 in execute (op_array=0x8b768e4) at zend_vm_execute.h:92
#35 0x406f9626 in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfffa9b0) at zend_vm_execute.h:226
#36 0x40743769 in execute (op_array=0x82f8dd8) at zend_vm_execute.h:92
#37 0x406d70bd in zend_call_function (fci=0xbfffaad0, fci_cache=0x0) at
/usr/src/php-5.1.2/Zend/zend_execute_API.c:907
#38 0x406d7f58 in call_user_function_ex (function_table=0x0,
object_pp=0x0, function_name=0x0, retval_ptr_ptr=0x0,
param_count=0, params=0x0, no_separation=0, symbol_table=0x0) at
/usr/src/php-5.1.2/Zend/zend_execute_API.c:571
#39 0x40652564 in zif_call_user_func_array (ht=2,
return_value=0x8990584, return_value_ptr=0x0, this_ptr=0x0,
return_value_used=1) at
/usr/src/php-5.1.2/ext/standard/basic_functions.c:2148
#40 0x406f9acf in zend_do_fcall_common_helper_SPEC
(execute_data=0xbfffbbe0) at zend_vm_execute.h:192
#41 0x40743769 in execute (op_array

#37331 [NEW]: oci_fetch_array makes Apache2 crash

2006-05-05 Thread jarismar_silva at adplabs dot com dot br 
From: jarismar_silva at adplabs dot com dot br
Operating system: Windows XP Professional SP2
PHP version:  5.1.4
PHP Bug Type: OCI8 related
Bug description:  oci_fetch_array makes Apache2 crash

Description:

Trying to load data from table with CLOB column using oci_fetch_array with
combined values for mode, causes apache2 crash.

Reproduce code:
---
?php
$conn = oci_connect(user, password, db);

$sSQL = SELECT xml_data
 FROM   integrationvalue
 WHERE  imd_id   = 1
 AND  ilv_code = 061246652;

$stmt = oci_parse($conn, $sSQL);

oci_execute($stmt);

var_dump($stmt); // show valid resource id

$row = oci_fetch_array($stmt, OCI_ASSOC | OCI_RETURN_LOBS); // --- crash
here

echo 'pre';
print_r($row);
echo '/pre';
?

Expected result:

Must show the $stmt resource id on var_dump and and some string data into
the $row array.

Actual result:
--
My Machine is an P4 Dual core cpu (hyper threading) 2.8 Ghz, 2 Gb Ram. The
database is Oracle 10g. I'm using php_oci8.dll.

The apache log says:
Parent: child process exited with status 3221225477 -- Restarting.



-- 
Edit bug report at http://bugs.php.net/?id=37331edit=1
-- 
Try a CVS snapshot (PHP 4.4): 
http://bugs.php.net/fix.php?id=37331r=trysnapshot44
Try a CVS snapshot (PHP 5.1): 
http://bugs.php.net/fix.php?id=37331r=trysnapshot51
Try a CVS snapshot (PHP 6.0): 
http://bugs.php.net/fix.php?id=37331r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37331r=fixedcvs
Fixed in release: 
http://bugs.php.net/fix.php?id=37331r=alreadyfixed
Need backtrace:   http://bugs.php.net/fix.php?id=37331r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=37331r=needscript
Try newer version:http://bugs.php.net/fix.php?id=37331r=oldversion
Not developer issue:  http://bugs.php.net/fix.php?id=37331r=support
Expected behavior:http://bugs.php.net/fix.php?id=37331r=notwrong
Not enough info:  
http://bugs.php.net/fix.php?id=37331r=notenoughinfo
Submitted twice:  
http://bugs.php.net/fix.php?id=37331r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37331r=globals
PHP 3 support discontinued:   http://bugs.php.net/fix.php?id=37331r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37331r=dst
IIS Stability:http://bugs.php.net/fix.php?id=37331r=isapi
Install GNU Sed:  http://bugs.php.net/fix.php?id=37331r=gnused
Floating point limitations:   http://bugs.php.net/fix.php?id=37331r=float
No Zend Extensions:   http://bugs.php.net/fix.php?id=37331r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=37331r=mysqlcfg

#37331 [Opn]: oci_fetch_array makes Apache2 crash

2006-05-05 Thread jarismar_silva at adplabs dot com dot br 
 ID:   37331
 User updated by:  jarismar_silva at adplabs dot com dot br
 Reported By:  jarismar_silva at adplabs dot com dot br
 Status:   Open
 Bug Type: OCI8 related
 Operating System: Windows XP Professional SP2
 PHP Version:  5.1.4
 New Comment:

The same problem ocurr into linux server (for the same snipped code
initiali posted).
Apache error_log says:
 child pid 3294 exit signal Segmentation fault (11)

The server is Suse Linux 2.6.5-7.244-smp
The php configure command whas:
'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs'
'--disable-debug' '--disable-ipv6' '--enable-force-cgi-redirect'
'--with-zlib' '--enable-track-vars' '--enable-sigchild'
'--with-tsrm-pthreads' '--without-mysql'
'--with-oci8=/opt/oracle/product/10gR1' '--disable-rpath'
'--enable-memory-limit' '--enable-inline-optimization' '--enable-xml'
'--with-gd' '--with-jpeg-dir=/usr' '--enable-gd-native-ttf'
'--with-mcrypt' '--with-mhash' '--with-curl'


Previous Comments:


[2006-05-05 16:50:21] jarismar_silva at adplabs dot com dot br

Description:

Trying to load data from table with CLOB column using oci_fetch_array
with combined values for mode, causes apache2 crash.

Reproduce code:
---
?php
$conn = oci_connect(user, password, db);

$sSQL = SELECT xml_data
 FROM   integrationvalue
 WHERE  imd_id   = 1
 AND  ilv_code = 061246652;

$stmt = oci_parse($conn, $sSQL);

oci_execute($stmt);

var_dump($stmt); // show valid resource id

$row = oci_fetch_array($stmt, OCI_ASSOC | OCI_RETURN_LOBS); // ---
crash here

echo 'pre';
print_r($row);
echo '/pre';
?

Expected result:

Must show the $stmt resource id on var_dump and and some string data
into the $row array.

Actual result:
--
My Machine is an P4 Dual core cpu (hyper threading) 2.8 Ghz, 2 Gb Ram.
The database is Oracle 10g. I'm using php_oci8.dll.

The apache log says:
Parent: child process exited with status 3221225477 -- Restarting.







-- 
Edit this bug report at http://bugs.php.net/?id=37331edit=1

#37331 [Opn]: oci_fetch_array makes Apache2 crash

2006-05-05 Thread jarismar_silva at adplabs dot com dot br 
 ID:   37331
 User updated by:  jarismar_silva at adplabs dot com dot br
 Reported By:  jarismar_silva at adplabs dot com dot br
 Status:   Open
 Bug Type: OCI8 related
 Operating System: Windows XP Professional SP2
 PHP Version:  5.1.4
 New Comment:

Following is the sctructure of table used into the command showed on
initial code.

CREATE TABLE INTEGRATIONVALUE (
  IMD_ID NUMBER(6) NOT NULL,
  ILV_CODE VARCHAR2(40) NOT NULL,
  XML_DATA CLOB,
)


Previous Comments:


[2006-05-05 17:20:23] jarismar_silva at adplabs dot com dot br

The same problem ocurr into linux server (for the same snipped code
initiali posted).
Apache error_log says:
 child pid 3294 exit signal Segmentation fault (11)

The server is Suse Linux 2.6.5-7.244-smp
The php configure command whas:
'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs'
'--disable-debug' '--disable-ipv6' '--enable-force-cgi-redirect'
'--with-zlib' '--enable-track-vars' '--enable-sigchild'
'--with-tsrm-pthreads' '--without-mysql'
'--with-oci8=/opt/oracle/product/10gR1' '--disable-rpath'
'--enable-memory-limit' '--enable-inline-optimization' '--enable-xml'
'--with-gd' '--with-jpeg-dir=/usr' '--enable-gd-native-ttf'
'--with-mcrypt' '--with-mhash' '--with-curl'



[2006-05-05 16:50:21] jarismar_silva at adplabs dot com dot br

Description:

Trying to load data from table with CLOB column using oci_fetch_array
with combined values for mode, causes apache2 crash.

Reproduce code:
---
?php
$conn = oci_connect(user, password, db);

$sSQL = SELECT xml_data
 FROM   integrationvalue
 WHERE  imd_id   = 1
 AND  ilv_code = 061246652;

$stmt = oci_parse($conn, $sSQL);

oci_execute($stmt);

var_dump($stmt); // show valid resource id

$row = oci_fetch_array($stmt, OCI_ASSOC | OCI_RETURN_LOBS); // ---
crash here

echo 'pre';
print_r($row);
echo '/pre';
?

Expected result:

Must show the $stmt resource id on var_dump and and some string data
into the $row array.

Actual result:
--
My Machine is an P4 Dual core cpu (hyper threading) 2.8 Ghz, 2 Gb Ram.
The database is Oracle 10g. I'm using php_oci8.dll.

The apache log says:
Parent: child process exited with status 3221225477 -- Restarting.







-- 
Edit this bug report at http://bugs.php.net/?id=37331edit=1

#37331 [Fbk-Opn]: oci_fetch_array makes Apache2 crash

2006-05-05 Thread jarismar_silva at adplabs dot com dot br 
 ID:   37331
 User updated by:  jarismar_silva at adplabs dot com dot br
 Reported By:  jarismar_silva at adplabs dot com dot br
-Status:   Feedback
+Status:   Open
 Bug Type: OCI8 related
 Operating System: Windows XP Professional SP2
 PHP Version:  5.1.4
 New Comment:

Here is the backtrace, hope be usefull:

   php_oci8.dll!php_oci_fetch_row(int ht=2, _zval_struct *
return_value=0x054dca68, _zval_struct * * return_value_ptr=0x,
_zval_struct * this_ptr=0x, int return_value_used=1, void * * *
tsrm_ls=0x0147ef80, int mode=88994928, int expected_args=2)  Line
1678C
php_oci8.dll!zif_oci_fetch_array(int ht=2, _zval_struct *
return_value=0x054dca68, _zval_struct * * return_value_ptr=0x,
_zval_struct * this_ptr=0x, int return_value_used=1, void * * *
tsrm_ls=0x0147ef80)  Line 1469 + 0x27 bytes C
php5ts.dll!zend_do_fcall_common_helper_SPEC(_zend_execute_data *
execute_data=0x0520fb48, void * * * tsrm_ls=0x0147ef80)  Line 200 +
0x35 bytes  C
php5ts.dll!ZEND_DO_FCALL_SPEC_CONST_HANDLER(_zend_execute_data *
execute_data=0x, void * * * tsrm_ls=0x0147ef80)  Line 1640 +
0xe bytes   C
php5ts.dll!execute(_zend_op_array * op_array=0x0520fbf4, void * * *
tsrm_ls=0x0520fc58)  Line 92 + 0xc bytesC
kernel32.dll!7c80a1e7() 
[Frames below may be incorrect and/or missing, no symbols loaded for
kernel32.dll]   
ntdll.dll!7c9106eb()
msvcrt.dll!77c0c3c9()   
ntdll.dll!7c91056d()
msvcrt.dll!77c0c2de()   
php5ts.dll!virtual_chdir(const char * path=0x0520fc20, void * * *
tsrm_ls=0x0147ef80)  Line 622 + 0x21 bytes  C
php5ts.dll!virtual_chdir_file(const char * path=0x0520fdb0, int
(const char *, void * * *)* p_chdir=0x0147ef80, void * * *
tsrm_ls=0x0520feb8)  Line 653 + 0xc bytes   C
php5ts.dll!zend_fetch_property_address_read_helper_SPEC_CV_CONST(int
type=6600912, _zend_execute_data * execute_data=0x, void * * *
tsrm_ls=0x0064b8d0)  Line 20633 + 0x10b bytes   C
msvcrt.dll!77c262a1()   
php_mbstring.dll!OnUpdate_mbstring_internal_encoding(_zend_ini_entry
* entry=0x006c8ffd, char * new_value=0x054d, unsigned int
new_value_length=1, void * mh_arg1=0x0018, void *
mh_arg2=0x, void * mh_arg3=0x0004, int stage=7107376, void
* * * tsrm_ls=0x00ce0718)  Line 647 + 0x1e bytesC
ntdll.dll!7c9106eb()
php5ts.dll!_safe_emalloc(unsigned int nmemb=1, unsigned int size=25,
unsigned int offset=21491584)  Line 237 + 0x8 bytes C
php_mbstring.dll!zm_activate_mbstring(int type=1, int
module_number=30, void * * * tsrm_ls=0x0147ef80)  Line 979 + 0x10
bytes   C
php5ts.dll!module_registry_request_startup(_zend_module_entry *
module=0x006928a0, void * * * tsrm_ls=0x0147ef80)  Line 1835 + 0x11
bytes   C
php5ts.dll!zend_hash_apply(_hashtable * ht=0x0520ffa4, int (void *,
void * * *)* apply_func=0x, void * * * tsrm_ls=0x56433230) 
Line 666 + 0x7 bytesC
php5apache2.dll!php_handler(request_rec * r=0x0077bce0)  Line 535 +
0x5f bytes  C
php5ts.dll!php_stream_open_for_zend(const char * filename=0x0147cfc8,
_zend_file_handle * handle=0x01479018, void * * * tsrm_ls=0x0147cfc8) 
Line 918C
libhttpd.dll!6ff0155f() 
libhttpd.dll!6ff018a9() 
libhttpd.dll!6ff0d7fc() 
libhttpd.dll!6ff096e6() 
libhttpd.dll!6ff0412f() 
libhttpd.dll!6ff04382() 
libhttpd.dll!6ff1c0da() 
msvcrt.dll!77c1a3b0()   
kernel32.dll!7c80b50b() 
kernel32.dll!7c8399f3()


Previous Comments:


[2006-05-05 18:47:04] [EMAIL PROTECTED]

Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32

Once you have generated a backtrace, please submit it to this bug
report and change the status back to Open. Thank you for helping
us make PHP better.





[2006-05-05 17:55:21] jarismar_silva at adplabs dot com dot br

Following is the sctructure of table used into the command showed on
initial code.

CREATE TABLE INTEGRATIONVALUE (
  IMD_ID NUMBER(6) NOT NULL,
  ILV_CODE VARCHAR2(40) NOT NULL,
  XML_DATA CLOB,
)



[2006-05-05 17:20:23] jarismar_silva at adplabs dot com dot br

The same problem ocurr into linux server (for the same snipped code
initiali posted).
Apache error_log says:
 child pid 3294 exit signal Segmentation fault (11)

The server

#28403 [Com]: ORA dll make apache child process crash and restart Apache

2006-04-12 Thread jarismar_silva at adplabs dot com dot br 
 ID:   28403
 Comment by:   jarismar_silva at adplabs dot com dot br
 Reported By:  scouture at novo dot ca
 Status:   No Feedback
 Bug Type: OCI8 related
 Operating System: win 2003 server
 PHP Version:  4.3.7
 New Comment:

I'm having this same problem when upgrading to oracle 10g and
php5.1.2(Jan 11 2006 16:35:21).
I'm using 'extension=php_oci8.dll'.

Windows give this error signature :
szAppName : Apache.exe
szAppVer : 2.0.55.0
szModName : OraClient10.Dll
szModVer : 10.2.0.1
offset : 000ab9d3

The machine is for development purposes and is a:
Windows XP Professional SP2
P4 CPU 2.8GHz 2Gb Ram

I tried to download your patch, but your link to
http://snaps.php.net/win32/php5-win32-latest.zip is broken.


Previous Comments:


[2005-07-09 01:00:03] php-bugs at lists dot php dot net

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to Open.



[2005-07-01 02:38:27] [EMAIL PROTECTED]

If we can get some feedback about how well it's working in PHP 5, then
we can evaluate the possibility of back-porting the changes so that
they can be used with PHP 4.4



[2005-07-01 01:05:05] stuff at mikepalmer dot net

is there any chance of this being fixed in the 4.3 branch also? We have
some other issues using 5.x but can't use the 4.3.x dll on multi
processor win32 machines either. Gets a couple hits and dies. Single
processor win32 system is just fine.



[2005-06-30 19:30:15] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip

Anyone care to test the PHP 5.1 beta to see if it is running any
better?



[2005-06-30 19:27:46] scouture at novo dot ca

No more problem when running PHP with the exe instead of the .dll



The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/28403

-- 
Edit this bug report at http://bugs.php.net/?id=28403edit=1

#28403 [Com]: ORA dll make apache child process crash and restart Apache

2006-04-12 Thread jarismar_silva at adplabs dot com dot br 
 ID:   28403
 Comment by:   jarismar_silva at adplabs dot com dot br
 Reported By:  scouture at novo dot ca
 Status:   No Feedback
 Bug Type: OCI8 related
 Operating System: win 2003 server
 PHP Version:  4.3.7
 New Comment:

I have replaced the php_oci8.dll with another found at
http://pecl4win.php.net/ext.php/php_oci8.dll (labeled with #7) and now
everthing works fine.


Previous Comments:


[2006-04-12 12:04:53] jarismar_silva at adplabs dot com dot br

I'm having this same problem when upgrading to oracle 10g and
php5.1.2(Jan 11 2006 16:35:21).
I'm using 'extension=php_oci8.dll'.

Windows give this error signature :
szAppName : Apache.exe
szAppVer : 2.0.55.0
szModName : OraClient10.Dll
szModVer : 10.2.0.1
offset : 000ab9d3

The machine is for development purposes and is a:
Windows XP Professional SP2
P4 CPU 2.8GHz 2Gb Ram

I tried to download your patch, but your link to
http://snaps.php.net/win32/php5-win32-latest.zip is broken.



[2005-07-09 01:00:03] php-bugs at lists dot php dot net

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to Open.



[2005-07-01 02:38:27] [EMAIL PROTECTED]

If we can get some feedback about how well it's working in PHP 5, then
we can evaluate the possibility of back-porting the changes so that
they can be used with PHP 4.4



[2005-07-01 01:05:05] stuff at mikepalmer dot net

is there any chance of this being fixed in the 4.3 branch also? We have
some other issues using 5.x but can't use the 4.3.x dll on multi
processor win32 machines either. Gets a couple hits and dies. Single
processor win32 system is just fine.



[2005-06-30 19:30:15] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip

Anyone care to test the PHP 5.1 beta to see if it is running any
better?



The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/28403

-- 
Edit this bug report at http://bugs.php.net/?id=28403edit=1