Hi guys,
I am continuing the thread from here:
1603780
since this is to treated as a separate issue.
There are many errors like the following in the Apache error_log:
[Thu Dec 14 20:18:01 2006] [error] [client 164.19.153.139] [ecid: 1166123881:10.153.159.47:29376:0:16586,0] File does not exist: /ag/oracle/appserv_1/Apache/Apache/htdocs/_vti_bin/owssvr.dll
[Thu Dec 14 20:18:01 2006] [error] [client 164.19.153.139] [ecid: 1166123881:10.153.159.47:29527:0:15701,0] File does not exist: /ag/oracle/appserv_1/Apache/Apache/htdocs/MSOffice/cltreq.asp
[Thu Dec 14 20:19:23 2006] [error] [client 164.32.1.238] [ecid: 1166123963:10.153.159.47:29527:0:15747,0] mod_plsql: /pls/apex/f HTTP-500 Error Reading Data from Client!!
[Thu Dec 14 21:09:22 2006] [warn] [client 164.20.198.77] read request line timed out
[Thu Dec 14 21:47:20 2006] [warn] [client 164.20.68.139] mod_plsql: Long running URL [pls/apex/wwv_flow.show] timed out
[Thu Dec 14 21:47:20 2006] [error] [client 164.20.68.139] [ecid: 1166128938:10.153.159.47:29490:0:20969,0] mod_plsql: /pls/apex/wwv_flow.show HTTP-500 Error Reading Data from Client!!
I receive the HTTP-500 around 600 times per day intermittently. We have 400,000 page views per day.
It happens throughout the day at various times.
Has anybody had similar problems?
The timeouts in the Apache httpd.conf look good (300 seconds) . And the requests only take a second or two, at most a few seconds before they get aborted.
Marvel.conf:
Alias /i/ "/ag/oracle/appserver_1/apex/images/"
<Directory "/ag/oracle/appserver_1/apex/images/">
AllowOverride None
Order allow,deny
Allow from all
<IfModule mod_expires.c>
ExpiresActive on
ExpiresDefault "access plus 1 hour"
</IfModule>
</Directory>
AddType text/xml xbl
AddType text/x-component htc
<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_manager.process_download
PlsqlDatabaseConnectString RAC_ODS TNSFormat
PlsqlNLSLanguage GERMAN_GERMANY.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword <pwd for APEX_PUBLIC_USER>
Allow from all
</Location>
Relevant parts of the http.conf:
ServerType standalone
Timeout 300
KeepAlive off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 20
StartServers 5
MaxClients 350
MaxRequestsPerChild 0
ExtendedStatus On
Port 80
Listen 80
UseCanonicalName On
HostnameLookups Off
LogLevel warn
We are running the two application servers (IAS 10.1.3) on a Redhat Linux box through a load balancer. The backend is an Oracle RAC 10.2.0.1 on Unix.
Regards,
~Dietmar.