PHP  
 PHP_HEAD
downloads | QA | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
 

Test Failure Report for ext/oci8/tests/lob_043.phpt ('Bug #49560 (LOB resource destructor and refcount test)')

Script

1: <?php
2:
3:
require(dirname(__FILE__).'/connect.inc');
4:
5:
// Initialization
6:
7:
$stmtarray = array(
8:     
"drop table lob_043_tab",
9:     
"create table lob_043_tab(id number, c1 clob)",
10:     
"begin 
11:        for i in 1..50000 loop
12:          insert into lob_043_tab (id, c1) values (i, i || ' abcdefghijklmnopq');
13:       end loop;
14:      end;"
,
15: );
16:
17:
oci8_test_sql_execute($c$stmtarray);
18:
19:
// Run Test
20:
21:
function f1($c)
22: {
23:     
$s oci_parse($c'select id, c1 from lob_043_tab order by id');
24:     
oci_execute($s);
25:     
$r = array();
26:     while ((
$row oci_fetch_array($sOCI_RETURN_NULLS+OCI_ASSOC+OCI_RETURN_LOBS)) !== false) {
27:         
$r[] = $row['C1'];
28:     }
29:     echo 
"f1 ended\n";
30:     return 
$r;
31: }
32:
33: function 
f2($c)
34: {
35:     
$s oci_parse($c'select id, c1 from lob_043_tab order by id');
36:     
oci_execute($s);
37:     
$r = array();
38:     while ((
$row oci_fetch_array($sOCI_RETURN_NULLS+OCI_ASSOC)) !== false) {
39:         
$r[] = $row['C1'];
40:     }
41:     echo 
"f2 ended\n";
42:     return 
$r;
43: }
44:
45: echo 
"Test 1\n";
46:
$r f1($c);
47:
/*
48:   foreach ($r as $v) {
49:   echo $v, "\n";
50:   }
51: */
52:
53:
echo "Test 2\n";
54:
$r f2($c);
55:
/*
56:   foreach ($r as $v) {
57:   echo $v->load(), "\n";
58:   }
59: */
60:
61: // Clean up
62:
63:
$stmtarray = array(
64:     
"drop table lob_043_tab"
65:
);
66:
67:
oci8_test_sql_execute($c$stmtarray);
68:
69:
oci_close($c);
70:
71:
?>
72:
===DONE===
73:

Expected

Test 1
f1 ended
Test 2
f2 ended
===DONE===

Output

***********************************************************************
Fatal NI connect error 12541, connecting to:
 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

  VERSION INFORMATION:
	TNS for Linux: Version 11.2.0.2.0 - Beta
	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
  Time: 17-JUN-2018 06:01:15
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener

Fatal error: connect.inc: Failed to connect as 'system' to 'localhost/XE': ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect.inc on line 14
    nt secondary err code: 111
    nt OS err code: 0

Diff

001+ ***********************************************************************
002+ Fatal NI connect error 12541, connecting to:
003+  (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
004+ 
005+   VERSION INFORMATION:
001- Test 1
002- f1 ended
003- Test 2
004- f2 ended
005- ===DONE===
006+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
007+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
008+   Time: 17-JUN-2018 06:01:15
009+   Tracing not turned on.
010+   Tns error struct:
011+     ns main err code: 12541
012+     TNS-12541: TNS:no listener
013+     ns secondary err code: 12560
014+     nt main err code: 511
015+     TNS-00511: No listener
016+ 
017+ Fatal error: connect.inc: Failed to connect as 'system' to 'localhost/XE': ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect.inc on line 14
018+     nt secondary err code: 111
019+     nt OS err code: 0

 

Generated at Mon, 18 Jun 2018 17:33:50 +0000 (24 hours ago)

Copyright © 2005-2018 The PHP Group
All rights reserved.