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/drcp_scope5.phpt ('DRCP: oci_pconnect() with scope end when oci8.old_oci_close_semantics ON')

Script

1: <?php
2:
3:
require dirname(__FILE__)."/drcp_functions.inc";
4: require 
dirname(__FILE__)."/details.inc";
5:
6:
// Similar to drcp_scope3.phpt but does a commit before end of
7: // function2, allowing the table to be dropped cleanly at the end.
8:
9: // The test opens a connection within function1 and updates a table
10: // (without committing).  Another connection is opened from function
11: // 2, and the table queried.  When function1 ends, the connection from
12: // function1 is not closed, so the updated value will be seen in
13: // function2.  Also the table can't be dropped because an uncommitted
14: // transaction exists.
15:
16: // Create the table
17:
$c oci_new_connect($user,$password,$dbase);
18: @
drcp_drop_table($c);
19:
drcp_create_table($c);
20:
21: echo 
"This is with a OCI_PCONNECT\n";
22:
function1($user,$password,$dbase);
23:
24:
// Should return the OLD value
25:
function2($user,$password,$dbase);
26:
27:
// This is the first scope for the script
28:
29:
function function1($user,$password,$dbase)
30: {
31:     
var_dump($c oci_pconnect($user,$password,$dbase));
32:     
drcp_update_table($c);
33: }
34:
35:
// This is the second scope
36:
37:
function function2($user,$password,$dbase)
38: {
39:     
var_dump($c oci_pconnect($user,$password,$dbase));
40:     
drcp_select_value($c);
41:     
oci_commit($c);
42: }
43:
44:
drcp_drop_table($c);
45:
oci_close($c);
46:
47: echo 
"Done\n";
48:
49:
?>
50:

Expected

This is with a OCI_PCONNECT
resource(%d) of type (oci8 persistent connection)
Update done-- DEPT value has been set to NEWDEPT
resource(%d) of type (oci8 persistent connection)
The value of DEPT for id 105 is NEWDEPT
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 05:32:16
  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

Warning: oci_new_connect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_scope5.php on line 17
    nt secondary err code: 111
    nt OS err code: 0

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 8

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 9

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
This is with a OCI_PCONNECT


***********************************************************************
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 05:32:16
  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

Warning: oci_pconnect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_scope5.php on line 31
    nt secondary err code: 111
    nt OS err code: 0
bool(false)

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 33

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 34
Update done-- DEPT value has been set to NEWDEPT


***********************************************************************
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 05:32:16
  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

Warning: oci_pconnect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_scope5.php on line 39
    nt secondary err code: 111
    nt OS err code: 0
bool(false)

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 41

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 42

Warning: oci_fetch() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 43

Warning: oci_commit() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_scope5.php on line 41

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 26

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 27
Done

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:
006+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
001- This is with a OCI_PCONNECT
002- resource(%d) of type (oci8 persistent connection)
003- Update done-- DEPT value has been set to NEWDEPT
004- resource(%d) of type (oci8 persistent connection)
005- The value of DEPT for id 105 is NEWDEPT
006- Done
007+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
008+   Time: 17-JUN-2018 05:32:16
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+ Warning: oci_new_connect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_scope5.php on line 17
018+     nt secondary err code: 111
019+     nt OS err code: 0
020+ 
021+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 8
022+ 
023+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 9
024+ 
025+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18
026+ 
027+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
028+ 
029+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18
030+ 
031+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
032+ 
033+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18
034+ 
035+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
036+ 
037+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18
038+ 
039+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
040+ 
041+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18
042+ 
043+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
044+ 
045+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18
046+ 
047+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
048+ 
049+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18
050+ 
051+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
052+ 
053+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 18
054+ 
055+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 19
056+ This is with a OCI_PCONNECT
057+ 
058+ 
059+ ***********************************************************************
060+ Fatal NI connect error 12541, connecting to:
061+  (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)))
062+ 
063+   VERSION INFORMATION:
064+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
065+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
066+   Time: 17-JUN-2018 05:32:16
067+   Tracing not turned on.
068+   Tns error struct:
069+     ns main err code: 12541
070+     TNS-12541: TNS:no listener
071+     ns secondary err code: 12560
072+     nt main err code: 511
073+     TNS-00511: No listener
074+ 
075+ Warning: oci_pconnect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_scope5.php on line 31
076+     nt secondary err code: 111
077+     nt OS err code: 0
078+ bool(false)
079+ 
080+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 33
081+ 
082+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 34
083+ Update done-- DEPT value has been set to NEWDEPT
084+ 
085+ 
086+ ***********************************************************************
087+ Fatal NI connect error 12541, connecting to:
088+  (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)))
089+ 
090+   VERSION INFORMATION:
091+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
092+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
093+   Time: 17-JUN-2018 05:32:16
094+   Tracing not turned on.
095+   Tns error struct:
096+     ns main err code: 12541
097+     TNS-12541: TNS:no listener
098+     ns secondary err code: 12560
099+     nt main err code: 511
100+     TNS-00511: No listener
101+ 
102+ Warning: oci_pconnect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_scope5.php on line 39
103+     nt secondary err code: 111
104+     nt OS err code: 0
105+ bool(false)
106+ 
107+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 41
108+ 
109+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 42
110+ 
111+ Warning: oci_fetch() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 43
112+ 
113+ Warning: oci_commit() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_scope5.php on line 41
114+ 
115+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 26
116+ 
117+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/drcp_functions.inc on line 27
118+ Done

 

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

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