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/pdo_oci/tests/pdo_oci_stream_2a.phpt ('PDO OCI: Inserts 10K with 1 number and 2 LOB columns (stress test)')

Script

1: <?php
2:
3:
require(dirname(__FILE__) . '/../../pdo/tests/pdo_test.inc');
4:
5:
$db PDOTest::factory();
6:
7:
$query "begin execute immediate 'drop table pdo_oci_stream_2'; exception when others then if sqlcode <> -942 then raise; end if; end;";
8:
$stmt $db->prepare($query);
9:
$stmt->execute();
10:
11:
$query "create table pdo_oci_stream_2 (id number, data1 blob, data2 blob)";
12:
$stmt $db->prepare($query);
13:
$stmt->execute();
14:
15: function 
do_insert($db$id$data1$data2)
16: {
17:     
$db->beginTransaction(); 
18:     
$stmt $db->prepare("insert into pdo_oci_stream_2 (id, data1, data2) values (:id, empty_blob(), empty_blob()) returning data1, data2 into :blob1, :blob2");
19:     
$stmt->bindParam(':id'$id);
20:     
$stmt->bindParam(':blob1'$blob1PDO::PARAM_LOB);
21:     
$stmt->bindParam(':blob2'$blob2PDO::PARAM_LOB);
22:     
$blob1 null;
23:     
$blob2 null;
24:     
$stmt->execute();
25:
26:     
fwrite($blob1$data1);  
27:     
fclose($blob1);
28:     
fwrite($blob2$data2);
29:     
fclose($blob2);
30:     
$db->commit();
31: }
32:
33:
$a1 str_repeat('a'4086);
34:
$a2 str_repeat('b'4087);
35:
$a3 str_repeat('c'4088);
36:
$a4 str_repeat('d'4089);
37:
$a5 str_repeat('e'4090);
38:
$a6 str_repeat('f'4091);
39:
$a7 str_repeat('g'4092);
40:
$a8 str_repeat('h'4093);
41:
$a9 str_repeat('i'4094);
42:
$a10 str_repeat('j'4095);
43:
44:
printf("Inserting 10000 Records ... ");
45: for(
$i=0$i<1000$i++) {
46:     
do_insert($db$i 10 1$a1$a10);
47:     
do_insert($db$i 10 2$a2$a9);
48:     
do_insert($db$i 10 3$a3$a8);
49:     
do_insert($db$i 10 4$a4$a7);
50:     
do_insert($db$i 10 5$a5$a6);
51:     
do_insert($db$i 10 6$a6$a5);
52:     
do_insert($db$i 10 7$a7$a4);
53:     
do_insert($db$i 10 8$a8$a3);
54:     
do_insert($db$i 10 9$a9$a2);
55:     
do_insert($db$i 10 10$a10$a1);
56: }
57:
printf("Done\n");
58:
59:
/* Cleanup is done in pdo_oci_stream_2b.phpt */
60: //$db->exec("drop table pdo_oci_stream_2");
61:
62:
?>
63:

Expected

Inserting 10000 Records ... 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 09:54:18
  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: Uncaught PDOException: SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12541: TNS:no listener
 (/var/php_gcov/PHP_HEAD/ext/pdo_oci/oci_driver.c:634) in /var/php_gcov/PHP_HEAD/ext/pdo/tests/pdo_test.inc:35
Stack trace:
#0 /var/php_gcov/PHP_HEAD/ext/pdo/tests/pdo_test.inc(35): PDO->__construct('oci:dbname=//lo...', 'system', 'oracle', NULL)
#1 /var/php_gcov/PHP_HEAD/ext/pdo_oci/tests/pdo_oci_stream_2a.php(5): PDOTest::factory()
#2 {main}
  thrown in /var/php_gcov/PHP_HEAD/ext/pdo/tests/pdo_test.inc on line 35
    nt secondary err code: 111
    nt OS err code: 0

Diff

001+ ***********************************************************************
001- Inserting 10000 Records ... Done
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 09:54:18
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: Uncaught PDOException: SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12541: TNS:no listener
018+  (/var/php_gcov/PHP_HEAD/ext/pdo_oci/oci_driver.c:634) in /var/php_gcov/PHP_HEAD/ext/pdo/tests/pdo_test.inc:35
019+ Stack trace:
020+ #0 /var/php_gcov/PHP_HEAD/ext/pdo/tests/pdo_test.inc(35): PDO->__construct('oci:dbname=//lo...', 'system', 'oracle', NULL)
021+ #1 /var/php_gcov/PHP_HEAD/ext/pdo_oci/tests/pdo_oci_stream_2a.php(5): PDOTest::factory()
022+ #2 {main}
023+   thrown in /var/php_gcov/PHP_HEAD/ext/pdo/tests/pdo_test.inc on line 35
024+     nt secondary err code: 111
025+     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.