Forum Moderators: phranque

Message Too Old, No Replies

Weird problem. Help requested!

Error Message keeps popping out (sometimes)

         

kuzjph

2:22 am on Dec 7, 2004 (gmt 0)

10+ Year Member



Hi, I'm currently trying to implement an online e-form system. The users will fill out an adobe pdf form. When submitted, the data is sent to my webserver running on Apache 2.0. After that the server side script (PHP5) and Oracle 9i client will access a remote Oracle database (Oracle 9i Release 1) on a separate server to make the necessary updates. However I have now encountered a problem, and I have no idea where this problem originates from.

When a user tries to submit the form data, an error message will sometimes appear saying that Apache has encountered a problem. When this occurs, the Oracle database is not updated. The browser on the client side will display a "Cannot find server of DNS error."

The weird thing is that sometimes the error message does not appear, the Oracle database is then updated with the user data without any problems. So in other words there is a 50-50 chance that the data can be entered into the database! Btw this problem does not occur when I submit the form data from the webserver itself.

This is the access and error logs when the oracle database is updated successfully:

i) Access Log:
172.16.1.24 - - [06/Dec/2004:11:20:02 +0800] "GET /testing2.html HTTP/1.0" 304 -
172.16.1.24 - - [06/Dec/2004:11:20:03 +0800] "GET /FORM_Oracle.pdf HTTP/1.0" 304 -
172.16.1.24 - - [06/Dec/2004:11:20:47 +0800] "POST /oracle.php HTTP/1.0" 200 297

ii) Error Log:
Empty

When the error occurs, a window appears with this message:

Apache HTTP Server
Apache HTTP Server has encountered a problem and needs to close. We are sorry for the inconvenience.

Error Signature
szAppName : Apache.exe szAppVer : 2.0.52.0 szModName : OraClient9.Dll
szModVer : 0.0.0.0 offset : 0005957f

The Error Log displays this:

[Mon Dec 06 11:40:56 2004] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Mon Dec 06 11:40:56 2004] [notice] Parent: Created child process 624
[Mon Dec 06 11:40:56 2004] [notice] Child 624: Child process is running
[Mon Dec 06 11:40:56 2004] [notice] Child 624: Acquired the start mutex.
[Mon Dec 06 11:40:56 2004] [notice] Child 624: Starting 250 worker threads.

Can anyone help me?

jdMorgan

2:28 am on Dec 7, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



kuzjph,

Welcome to WebmasterWorld!

Can anyone help me?

I think Google can [google.com].

Looks like a known PHP bug.

Jim

kuzjph

2:48 am on Dec 7, 2004 (gmt 0)

10+ Year Member



Thanks alot Jim! I'll check it out. Long live Google!

kuzjph

3:26 am on Dec 8, 2004 (gmt 0)

10+ Year Member



Problem solved. If anyone has the same problem, just downgrade from PHP 5 to PHP 4.3.4 . Once again, thanks for the help Jim.