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/bug41069.phpt ('Bug #41069 (Oracle crash with certain data over a DB-link when prefetch memory limit used - Oracle bug 6039623)')

Script

1:     <?php
2:
3:     
require(dirname(__FILE__).'/connect.inc');
4:
5:
// Initialization
6:
7:
$stmtarray = array(
8:     
"alter session set nls_date_format = 'MM/DD/YYYY'",
9:
10:     
"drop database link bug41069_dblink",
11:
12:     
"drop table bug41069_tab",
13:
14:     
"create shared database link bug41069_dblink authenticated by $user identified by $password using '$dbase'",
15:
16:     
"create table bug41069_tab
17:     (
18:         c1  number(20),
19:         c2  varchar2(60 byte),
20:         c3  varchar2(1000 byte),
21:         c4  varchar2(255 byte),
22:         c5  varchar2(2 byte),
23:         c6  varchar2(1 byte),
24:         c7  varchar2(255 byte),
25:         c8  varchar2(50 byte),
26:         c9  date,
27:         c10 date,
28:         c12 number(20),
29:         c13 varchar2(20 byte),
30:         c15 varchar2(50 byte)
31:      )"
,
32:
33:     
"insert into bug41069_tab (c1, c2, c5, c6, c9, c10, c12, c15)    values
34:     (111, 'aaaaaaa', 'b', 'c', '01/17/2008', '01/07/2017', 2222, 'zzzzzzzzzz')"
,
35:
36:     
"insert into bug41069_tab (c1, c2, c3, c4, c5, c6, c7, c9, c10, c12, c13, c15) values
37:     (112, 'aaaaaaa', 'bbbbbbbb', 'ccccccc', 'd', 'e', 'rrrrrrr', '04/16/2007', '04/16/2007', 2223, 'xxxxxxxx', 'zzzzzzzz')"
,
38:
39:     
"insert into bug41069_tab (c1, c2, c3, c4, c5, c6, c7, c9, c10, c12, c15)    values
40:     (113, 'aaaaaaa', 'bbbbbbbbbb', 'cccccc', 'e', 'f', 'dddd', '12/04/2006', '12/04/2006', 2224, 'zzzzzzz')"
41:
);
42:                          
43:
oci8_test_sql_execute($c$stmtarray);
44:
45:
46:
// Run Tests
47:
48:
echo "Test 1: non-DB link case that always worked\n";
49:
$stid oci_parse($c'select * from bug41069_tab order by c1');
50:
oci_execute($stidOCI_DEFAULT);
51:
oci_fetch_all($stid$results0, -1OCI_ASSOC+OCI_FETCHSTATEMENT_BY_ROW);
52:
var_dump($results);
53:
54: echo 
"Test 2: Should not crash\n";
55:
$stid oci_parse($c'select * from bug41069_tab@bug41069_dblink order by c1');
56:
oci_execute($stidOCI_DEFAULT);
57:
oci_fetch_all($stid$results0, -1OCI_ASSOC+OCI_FETCHSTATEMENT_BY_ROW);
58:
var_dump($results);
59:
60:
// Cleanup
61:
62:
$c oci_new_connect($user$password$dbase);
63:
64:
$stmtarray = array(
65:     
"drop database link bug41069_dblink",
66:     
"drop table bug41069_tab"
67:
);
68:
69:
oci8_test_sql_execute($c$stmtarray);
70:
71: echo 
"Done\n";
72:
73:
?>
74:

Expected

Test 1: non-DB link case that always worked
array(3) {
  [0]=>
  array(13) {
    ["C1"]=>
    string(3) "111"
    ["C2"]=>
    string(7) "aaaaaaa"
    ["C3"]=>
    NULL
    ["C4"]=>
    NULL
    ["C5"]=>
    string(1) "b"
    ["C6"]=>
    string(1) "c"
    ["C7"]=>
    NULL
    ["C8"]=>
    NULL
    ["C9"]=>
    string(10) "01/17/2008"
    ["C10"]=>
    string(10) "01/07/2017"
    ["C12"]=>
    string(4) "2222"
    ["C13"]=>
    NULL
    ["C15"]=>
    string(10) "zzzzzzzzzz"
  }
  [1]=>
  array(13) {
    ["C1"]=>
    string(3) "112"
    ["C2"]=>
    string(7) "aaaaaaa"
    ["C3"]=>
    string(8) "bbbbbbbb"
    ["C4"]=>
    string(7) "ccccccc"
    ["C5"]=>
    string(1) "d"
    ["C6"]=>
    string(1) "e"
    ["C7"]=>
    string(7) "rrrrrrr"
    ["C8"]=>
    NULL
    ["C9"]=>
    string(10) "04/16/2007"
    ["C10"]=>
    string(10) "04/16/2007"
    ["C12"]=>
    string(4) "2223"
    ["C13"]=>
    string(8) "xxxxxxxx"
    ["C15"]=>
    string(8) "zzzzzzzz"
  }
  [2]=>
  array(13) {
    ["C1"]=>
    string(3) "113"
    ["C2"]=>
    string(7) "aaaaaaa"
    ["C3"]=>
    string(10) "bbbbbbbbbb"
    ["C4"]=>
    string(6) "cccccc"
    ["C5"]=>
    string(1) "e"
    ["C6"]=>
    string(1) "f"
    ["C7"]=>
    string(4) "dddd"
    ["C8"]=>
    NULL
    ["C9"]=>
    string(10) "12/04/2006"
    ["C10"]=>
    string(10) "12/04/2006"
    ["C12"]=>
    string(4) "2224"
    ["C13"]=>
    NULL
    ["C15"]=>
    string(7) "zzzzzzz"
  }
}
Test 2: Should not crash
array(3) {
  [0]=>
  array(13) {
    ["C1"]=>
    string(3) "111"
    ["C2"]=>
    string(7) "aaaaaaa"
    ["C3"]=>
    NULL
    ["C4"]=>
    NULL
    ["C5"]=>
    string(1) "b"
    ["C6"]=>
    string(1) "c"
    ["C7"]=>
    NULL
    ["C8"]=>
    NULL
    ["C9"]=>
    string(10) "01/17/2008"
    ["C10"]=>
    string(10) "01/07/2017"
    ["C12"]=>
    string(4) "2222"
    ["C13"]=>
    NULL
    ["C15"]=>
    string(10) "zzzzzzzzzz"
  }
  [1]=>
  array(13) {
    ["C1"]=>
    string(3) "112"
    ["C2"]=>
    string(7) "aaaaaaa"
    ["C3"]=>
    string(8) "bbbbbbbb"
    ["C4"]=>
    string(7) "ccccccc"
    ["C5"]=>
    string(1) "d"
    ["C6"]=>
    string(1) "e"
    ["C7"]=>
    string(7) "rrrrrrr"
    ["C8"]=>
    NULL
    ["C9"]=>
    string(10) "04/16/2007"
    ["C10"]=>
    string(10) "04/16/2007"
    ["C12"]=>
    string(4) "2223"
    ["C13"]=>
    string(8) "xxxxxxxx"
    ["C15"]=>
    string(8) "zzzzzzzz"
  }
  [2]=>
  array(13) {
    ["C1"]=>
    string(3) "113"
    ["C2"]=>
    string(7) "aaaaaaa"
    ["C3"]=>
    string(10) "bbbbbbbbbb"
    ["C4"]=>
    string(6) "cccccc"
    ["C5"]=>
    string(1) "e"
    ["C6"]=>
    string(1) "f"
    ["C7"]=>
    string(4) "dddd"
    ["C8"]=>
    NULL
    ["C9"]=>
    string(10) "12/04/2006"
    ["C10"]=>
    string(10) "12/04/2006"
    ["C12"]=>
    string(4) "2224"
    ["C13"]=>
    NULL
    ["C15"]=>
    string(7) "zzzzzzz"
  }
}
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:02:22
  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:
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:02:22
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
001- Test 1: non-DB link case that always worked
002- array(3) {
003-   [0]=>
004-   array(13) {
005-     ["C1"]=>
006-     string(3) "111"
007-     ["C2"]=>
008-     string(7) "aaaaaaa"
009-     ["C3"]=>
010-     NULL
011-     ["C4"]=>
012-     NULL
013-     ["C5"]=>
014-     string(1) "b"
015-     ["C6"]=>
016-     string(1) "c"
017-     ["C7"]=>
018-     NULL
019-     ["C8"]=>
020-     NULL
021-     ["C9"]=>
022-     string(10) "01/17/2008"
023-     ["C10"]=>
024-     string(10) "01/07/2017"
025-     ["C12"]=>
026-     string(4) "2222"
027-     ["C13"]=>
028-     NULL
029-     ["C15"]=>
030-     string(10) "zzzzzzzzzz"
031-   }
032-   [1]=>
033-   array(13) {
034-     ["C1"]=>
035-     string(3) "112"
036-     ["C2"]=>
037-     string(7) "aaaaaaa"
038-     ["C3"]=>
039-     string(8) "bbbbbbbb"
040-     ["C4"]=>
041-     string(7) "ccccccc"
042-     ["C5"]=>
043-     string(1) "d"
044-     ["C6"]=>
045-     string(1) "e"
046-     ["C7"]=>
047-     string(7) "rrrrrrr"
048-     ["C8"]=>
049-     NULL
050-     ["C9"]=>
051-     string(10) "04/16/2007"
052-     ["C10"]=>
053-     string(10) "04/16/2007"
054-     ["C12"]=>
055-     string(4) "2223"
056-     ["C13"]=>
057-     string(8) "xxxxxxxx"
058-     ["C15"]=>
059-     string(8) "zzzzzzzz"
060-   }
061-   [2]=>
062-   array(13) {
063-     ["C1"]=>
064-     string(3) "113"
065-     ["C2"]=>
066-     string(7) "aaaaaaa"
067-     ["C3"]=>
068-     string(10) "bbbbbbbbbb"
069-     ["C4"]=>
070-     string(6) "cccccc"
071-     ["C5"]=>
072-     string(1) "e"
073-     ["C6"]=>
074-     string(1) "f"
075-     ["C7"]=>
076-     string(4) "dddd"
077-     ["C8"]=>
078-     NULL
079-     ["C9"]=>
080-     string(10) "12/04/2006"
081-     ["C10"]=>
082-     string(10) "12/04/2006"
083-     ["C12"]=>
084-     string(4) "2224"
085-     ["C13"]=>
086-     NULL
087-     ["C15"]=>
088-     string(7) "zzzzzzz"
089-   }
090- }
091- Test 2: Should not crash
092- array(3) {
093-   [0]=>
094-   array(13) {
095-     ["C1"]=>
096-     string(3) "111"
097-     ["C2"]=>
098-     string(7) "aaaaaaa"
099-     ["C3"]=>
100-     NULL
101-     ["C4"]=>
102-     NULL
103-     ["C5"]=>
104-     string(1) "b"
105-     ["C6"]=>
106-     string(1) "c"
107-     ["C7"]=>
108-     NULL
109-     ["C8"]=>
110-     NULL
111-     ["C9"]=>
112-     string(10) "01/17/2008"
113-     ["C10"]=>
114-     string(10) "01/07/2017"
115-     ["C12"]=>
116-     string(4) "2222"
117-     ["C13"]=>
118-     NULL
119-     ["C15"]=>
120-     string(10) "zzzzzzzzzz"
121-   }
122-   [1]=>
123-   array(13) {
124-     ["C1"]=>
125-     string(3) "112"
126-     ["C2"]=>
127-     string(7) "aaaaaaa"
128-     ["C3"]=>
129-     string(8) "bbbbbbbb"
130-     ["C4"]=>
131-     string(7) "ccccccc"
132-     ["C5"]=>
133-     string(1) "d"
134-     ["C6"]=>
135-     string(1) "e"
136-     ["C7"]=>
137-     string(7) "rrrrrrr"
138-     ["C8"]=>
139-     NULL
140-     ["C9"]=>
141-     string(10) "04/16/2007"
142-     ["C10"]=>
143-     string(10) "04/16/2007"
144-     ["C12"]=>
145-     string(4) "2223"
146-     ["C13"]=>
147-     string(8) "xxxxxxxx"
148-     ["C15"]=>
149-     string(8) "zzzzzzzz"
150-   }
151-   [2]=>
152-   array(13) {
153-     ["C1"]=>
154-     string(3) "113"
155-     ["C2"]=>
156-     string(7) "aaaaaaa"
157-     ["C3"]=>
158-     string(10) "bbbbbbbbbb"
159-     ["C4"]=>
160-     string(6) "cccccc"
161-     ["C5"]=>
162-     string(1) "e"
163-     ["C6"]=>
164-     string(1) "f"
165-     ["C7"]=>
166-     string(4) "dddd"
167-     ["C8"]=>
168-     NULL
169-     ["C9"]=>
170-     string(10) "12/04/2006"
171-     ["C10"]=>
172-     string(10) "12/04/2006"
173-     ["C12"]=>
174-     string(4) "2224"
175-     ["C13"]=>
176-     NULL
177-     ["C15"]=>
178-     string(7) "zzzzzzz"
179-   }
180- }
181- Done

 

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

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