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/commit_002.phpt ('Test oci_commit failure')

Script

1: <?php
2:
3:
require(dirname(__FILE__).'/connect.inc');
4:
5:
// Initialization
6:
7:
$stmtarray = array(
8:     
"drop table commit_002_tab",
9:     
"create table commit_002_tab
10:      ( x int constraint commit_002_tab_check_x check ( x > 0 ) deferrable initially immediate,
11:        y int constraint commit_002_tab_check_y check ( y > 0 ) deferrable initially deferred)"
12:
);
13:
14:
oci8_test_sql_execute($c$stmtarray);
15:
16:
// Run Test
17:
18:
echo "First Insert\n";
19:
$s oci_parse($c"insert into commit_002_tab values (-1, 1)");
20:
$r = @oci_execute($sOCI_DEFAULT);
21: if (!
$r) {
22:     
$m oci_error($s);
23:     echo 
'Could not execute: '$m['message'] . "\n";
24: }
25:
$r oci_commit($c);
26: if (!
$r) {
27:     
$m oci_error($c);
28:     echo 
'Could not commit: '$m['message'] . "\n";
29: }
30:
31:
32: echo 
"Second Insert\n";
33:
$s oci_parse($c"insert into commit_002_tab values (1, -1)");
34:
$r = @oci_execute($sOCI_NO_AUTO_COMMIT);
35: if (!
$r) {
36:     
$m oci_error($s);
37:     echo 
'Could not execute: '$m['message'] . "\n";
38: }
39:
$r oci_commit($c);
40: if (!
$r) {
41:     
$m oci_error($c);
42:     echo 
'Could not commit: '$m['message'] . "\n";
43: }
44:
45:
46:
// Clean up
47:
48:
$stmtarray = array(
49:     
"drop table commit_002_tab"
50:
);
51:
52:
oci8_test_sql_execute($c$stmtarray);
53:
54:
?>
55:
===DONE===
56:

Expected

First Insert
Could not execute: ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_X) %s
Second Insert

Warning: oci_commit(): ORA-02091: %s
ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_Y) %s in %scommit_002.php on line %d
Could not commit: ORA-02091: %s
ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_Y) %s
===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:17:43
  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)))
001- First Insert
002- Could not execute: ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_X) %s
003- Second Insert
005+   VERSION INFORMATION:
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 05:17:43
009+   Tracing not turned on.
005- Warning: oci_commit(): ORA-02091: %s
006- ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_Y) %s in %scommit_002.php on line %d
007- Could not commit: ORA-02091: %s
008- ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_Y) %s
009- ===DONE===
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 (5 days ago)

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