ID: 19517
Comment by: aimart at tutopia dot com
Reported By: f dot labanvoye at cg70 dot fr
Status: No Feedback
Bug Type: OCI8 related
Operating System: windows 2000 and linux
PHP Version: 4.2.3
New Comment:
Thank !!!!!!!!
Cha gracias in spanishhh
Previous Comments:
------------------------------------------------------------------------
[2003-05-11 16:46:53] flop dot m at usa dot net
Hello,
I'm having the same trouble (not always, but often - when server is
receiving lots of user queries).
TNS-12154 when executing OCILogon method.
It seems that an error occurs at the same time on the Oracle side, at
least, in the sqlnet.log, some errors is logged, and I could not find
the description of that error on Oracle's web site.
Thus, I changed my OCILogon from
OCILogon('user', 'pass', 'tns alias');
to
$tns = <the actual line describing my listener from the tnsnames.ora
file>;
OCILogon('user', 'pass', $tns);
and bingo, no more crashes ;)
My guess is when PHP sends too many lookups in a short time, something
in the oci call crashs. So, is it in PHP side, or Oracle side, I don't
know.
I hope this will help to pinpoint/correct that pretty much annoying
bug.
------------------------------------------------------------------------
[2002-12-06 19:14:04] [EMAIL PROTECTED]
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
------------------------------------------------------------------------
[2002-11-26 20:14:08] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php4-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-latest.zip
------------------------------------------------------------------------
[2002-11-26 15:33:36] [EMAIL PROTECTED]
This might be an Apache 2 problem. Can you reproduce the crash with the
latest CVS release on Apache over 2.0.43?
------------------------------------------------------------------------
[2002-11-05 14:13:23] willie_gollino at hp dot com
I get this error in my apache error log when multithreading is turned
on:
[notice] child pid 28373 exit signal Segmentation fault (11)
Apache: 2.0.X (mpm worker)
OS: HP-UX 11.00 (with linker patches)
PHP: 4.2.2 dso with oci8 extension
Oracle: 8.1.6
If I set ThreadsPerChild to 1 (single threaded), I don't get any
segfaults. With ThreadsPerChild set to 2 (or higher) I get the
segmentation faults with as few as 2 concurrent requests (ab -n 10 -c 2
http://testurl/).
With particularly high load (>100 concurrent requests) Apache 2 hangs,
and has to be killed.
I also get this error message in my php log:
"PHP Warning: _oci_open_server: ORA-12154: TNS:could not resolve
service name"
On the same system, Apache 1.3.26 with PHP as CGI works perfectly.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/19517
--
Edit this bug report at http://bugs.php.net/?id=19517&edit=1
