 |
 |
 |
 |
|
|
Date: 07/31/00
- Next message: Matthew R. MacIntyre: "[phplib] problem with oohforms"
- Previous message: Max Derkachev: "Re: [phplib] INTERBASE6 LIBRARY"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Using the script given below once a second, everything is
working fine, but when we simulate a high load on the
server (pressing the reload-button as often as possible)
connection to ORACLE breaks up. PHP says: Error on
OCIExcute (ORA-03114) you are not longer connected to
ORACLE.
Examining the error-log of Apache I've found another ORACLE
Error: failed to rollback outstanding transactions!:
ORA-12571: TNS:packet writer failure.
Trace-Files of ORACLE-Database give no hint.
When the error occurs the script cannot be executed any
more. Restarting Apache the script is executed but the error
is reproducable. Rebooting the whole box, the error cannot
be reproduced for about two or three days uptime, but comes
back afterwards.
Avoiding the PHPLIB-Objects using a plain script with
OCILogon, OCIParse, OCIExecute, OCIFetch, OCILogoff seems to
be stable but perhaps it's just using less execution time
and space on the server (cannot rely on that).
This is what we're using:
- Apache/1.3.12 (Unix) ApacheJServ/1.1.2 PHP/4.0.1pl2 PHPLib
7.2c
- Skript:
-------------------------------------8<----------------------------------------------------------------
<?php
/*
* PROMATIS AG O.Reiniger,
26.07.2000
*
*/
//
// Include necessary
PHP-Library
//
include("db_oci8.inc");
//
// Define a new
DB-Connection-Class using PHP_LIB
//
class OO_DB_Connect extends
DB_Sql {
var $ClassName =
"OO_DB_Connect";
var $Database = "ORCL";
var $User = "scott";
var $Password = "tiger";
}
//
// Instanciate Object of
DB-Connection-Clss
// (connect should be done
now)
//
$q = new OO_DB_Connect;
//
// Execute Query
//
$query = "Select bezeichnung
from rubriken";
$q->query($query);
//
// Fetch the results and
print a table containing it's content
//
echo "<TABLE>";
echo "<TR>";
$j = 0;
while ($q->next_record()) {
$j ++;
if(($j % 10) == 0) {
echo "</TR>";
echo "<TR>";
}
echo "<TD>";
echo $q->f("bezeichnung");
echo "</TD>";
}
echo "</TR>";
echo "</TABLE>";
?>
------------------------------------------------------------>8----------------------------------------------------------------
+ PHP-Config:
---------------------------------------------------------8<-------------------------------------------------------------------
./configure' '--prefix=/data/php4'
'--with-apxs=/data/apache_bms2/bin/apxs'
'--with-oci8=/ora8/app/oracle/product/8.1.6/'
'--enable-trans-sid'
'--with-xml'
------------------------------------------------------------>8----------------------------------------------------------------
+ ORACLE 8.1.6 Enterprise
Edition
+ OCI 8.1.0.0.0
Has anyone ever had similar problems ? Did you find a
workaround ? What is the cause of this problem ? Are there
any patches available ?
regards
Oliver
-- --------------------------------------- Oliver Reiniger -- Berater PROMATIS AG Badhausweg 5 76307 Karlsbad, Deutschland Tel.: +49 (7248) 926 300 -- Fax: +49 (7248) 926 119 mailto:oliver.reiniger <email protected> http://www.promatis.de--------------------------------------------------------------------- To unsubscribe, e-mail: phplib-unsubscribe <email protected> For additional commands, e-mail: phplib-help <email protected>
- Next message: Matthew R. MacIntyre: "[phplib] problem with oohforms"
- Previous message: Max Derkachev: "Re: [phplib] INTERBASE6 LIBRARY"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]