php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #22586 dbx oracle create table gives execution time exceeded
Submitted: 2003-03-07 04:51 UTC Modified: 2003-03-07 09:10 UTC
From: steveh at brendata dot co dot uk Assigned:
Status: Not a bug Package: DBX related
PHP Version: 4.3.1 OS: Windows NT4 SP6
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
41 - 8 = ?
Subscribe to this entry?

 
 [2003-03-07 04:51 UTC] steveh at brendata dot co dot uk
When the following script is run it produces an execution timeout (30 seconds exceeded), even though the table is actually created.

<?
 function connect(){
// This function handles all connects to the oracle db
$user = "SA";
$pass = "SAPASSWORD";
$db_name = "docdb.brendata";
$link = dbx_connect(DBX_OCI8, "", $db_name, $user, $pass)
         or die("Could not connect");
return $link;
 }

function TableForActions() {
 $Result='create table I_ACTIONS ('.
 'Record varchar2(255)'.
 ',ActivityType varchar2(50)'.
 ',TaskDescription CLOB'.
 ',Document varchar2(50)'.
 ',TargetDate varchar2(20)'.
 ',AffectedProcess varchar2(50)'.
 ',CustomerRequestNumber varchar2(50)'.
 ',ContractManager_LDAP varchar2(50)'.
 ',CustomerNotification varchar2(50)'.
 ',CustomerApproval varchar2(50)'.
 ',CustomerNotificationDate varchar2(20)'.
 ',SalesMarketing_LDAP varchar2(50)'.
 ',SalesMarketingNotification varchar2(50)'.
 ',SalesMarketingNotificationDate varchar2(20)'.
 ',ResponsiblePerson_LDAP varchar2(50)'.
 ',CompletedDate varchar2(20)'.
 ')';
 return $Result; }

$result = dbx_query(connect(),TableForActions());
                                                           ?>

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-03-07 05:00 UTC] mboeren@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.


Does the dbx_query call return? var_dump $result may tell you this...
Did you try a dbx_close on the connection?
 [2003-03-07 08:30 UTC] steveh at brendata dot co dot uk
I have added a dump_var call and magically it now all works, I have removed it and it still works.  This has consistently failed for 2 days, I don't believe that the CPU load was high on the server, but for now please close this as bogus as I can no longer reproduce it (?)
 [2003-03-07 08:58 UTC] mboeren@php.net
I tested your snippet here and it worked fine. What is the rest of your setup? I used Win2K, Oracle9i, Apache 1.3.24 and PHP-4.3.1 as a cgi-application...
 [2003-03-07 08:59 UTC] mboeren@php.net
bogusified on request
 [2003-03-07 09:10 UTC] steveh at brendata dot co dot uk
The same except NT4, php and database both on the same machine.
It's working fine here as well, happily creating and dropping all the tables it should.
That's why I figure it must have been bogus, I'll find out whether anything else was hapening whilst I was trying it, but it had been dead for 2 days.
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Tue Oct 19 20:03:34 2021 UTC