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.


Also, upgrade to latest version..

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Ok, it is a long process for us just upgrade our php version. We have to pass by a dev environment before going to prod so we have pass to PHP 4.3.7 in prod recently. And since that the PHP team have annonce the release of 4.3.8. :o)

But we still have the problem. Same error that the one list bellow. 

I can add that the server is a multiprocessor server (4 procs). We have a lot of hits by minutes. The error occurs every 5-10 minutes so kind of frequently. Apache and php are call via C# services and soap implementation. We do not seem to have this problem with a low volume environment (in our labs). The requests we pass via apache/phh are very simple (insert into... where, update ... where) nothing consumming.

Please tell me if you need something more. Thanks for your help.

Styve

Sounds like a threading issue to me... and you're asking for those by running apache 2 on windows (where the default processing model for apache is threaded). It sounds like either the oracle extension or oracle libraries are not threadsafe. I'll suspend this until you can come up with a clear script to reproduce this as there is no other way to find what this problem might be.

Referring to Bug #28983 (now bogus:-) ) - we reprouced that error using 
- different versions of oracle clients (8.1.7, 9i, 10g, accessing through different methods)
- different versions of php (4.2.x, 4.3.x 5.x)
- different versions of apache (1.3x, IBM http server, apache)

Conclusions: 
- Stable on Linux single and multiprocessor systems
- Stable on Windows *single* processor systems
- Crash on Windows *multi* processor systems

How to replicate the error? 
a) use the OCIlogon script from Bug #28983 
b) use a loadtest tool, e.g. OpenSTA and run 5 concurrent users calling the above php script.

You'd see the crash within a few secs :-)

I agree with derik, that it is probably related to oci.dll or php_oci8.dll.

/cheers Lukas

Running longer tests, even single-cpu systems fail. (after 7hours 1st, 1h34 2nd crash, 6h23 3rd crash...)

I'm having the same bug with PHP 4.3.4, Oracle 9i and Windows 2003 Server. So it's maybe linked to 9i and windows 2003. Will check out with 10i hoping it will fix this bug. High rated for me.

Alain Bertrand

BTW running on a dual CPU here, and it crash every 5 minutes :-(

There is a possilbe fix in the cvs version of both php4 and 5. Could you please check it out by downloading it from http://snaps.php.net/ ?

Note that I have also experimented this issue with MySql on a Xeon dual procs server.

I have find that if I run php with the .dll like 
LoadModule php4_module "d:/Program Files/php/sapi/php4apache2.dll", I get the bug.

If I run php with Action application/x-httpd-php "/php/php.exe", I don't seem to have it, so far....

Reproduced on 1.3 -> not apache related, some Oracle threading issue.

No more problem when running PHP with the exe instead of the .dll

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip

Anyone care to test the PHP 5.1 beta to see if it is running any better?

is there any chance of this being fixed in the 4.3 branch also? We have some other issues using 5.x but can't use the 4.3.x dll on multi processor win32 machines either. Gets a couple hits and dies. Single processor win32 system is just fine.

If we can get some feedback about how well it's working in PHP 5, then we can evaluate the possibility of back-porting the changes so that they can be used with PHP 4.4

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm having this same problem when upgrading to oracle 10g and php5.1.2(Jan 11 2006 16:35:21).
I'm using 'extension=php_oci8.dll'.

Windows give this error signature :
szAppName : Apache.exe
szAppVer : 2.0.55.0
szModName : OraClient10.Dll
szModVer : 10.2.0.1
offset : 000ab9d3

The machine is for development purposes and is a:
Windows XP Professional SP2
P4 CPU 2.8GHz 2Gb Ram

I tried to download your patch, but your link to http://snaps.php.net/win32/php5-win32-latest.zip is broken.

I have replaced the php_oci8.dll with another found at http://pecl4win.php.net/ext.php/php_oci8.dll (labeled with #7) and now everthing works fine.