RE: [squid-users] Timeout when Querying a Database

You could try adding debug 5,5 33,5 which will increase debugging for socket
functions and client-side routines which could throw up the relevant event
that has timed out. These debug settings could cause a lot of data to be
logged in cache.log, so, if possible, have only this user using the system
during this test.

Regards,
TM

-----Original Message-----
From: Allan Liska [mailto:allan@allan.org]
Sent: Wednesday, 30 July 2003 12:32
To: squid-users@squid-cache.org
Subject: [squid-users] Timeout when Querying a Database

-----BEGIN PGP SIGNED MESSAGE-----
Hash: MD5

Hello,

i searched through the FAQ and the archives and did not see a situation that
exactly matched mine, so I am hoping someone here can help.

I have a user behind a Squid proxy who is receiving a browser timeout error
when initiating a particularly large database query. The query takes almost
2 minutes to complete, and it does complete without a problem if he bypasses
the Squid box, but when he goes through the Squid box the browser returns
the cached objects, and no database data.

Looking through the documentation it appears there may be two ways to
resolve this problem. The first is to create an always direct access list
for the remote site and have the user just pass through the Squid box with
no proxying.

The second is to increase one of the timeout values, this is where I am a
little confused. Which timeout value would I need to increase? At first
glance the variable I want to change seems to be connect_timeout, but is
there a better timeout variable to adjust in this case?

I know it may be difficult to answer this question without access to
logs/config variables, but I am just trying to get a general feel for the
right course.

Thank you all for your time.

allan
- --
Allan Liska
allan@allan.org
http://www.allan.org
http://www.hosthideout.com

-----BEGIN PGP SIGNATURE-----
Version: 2.6

iQCVAwUAPycuMCkg6TAvIBeFAQHUTgQAlX5IhLNk7RsTajFDN80us4iy+nfPuQC1
au4RIZFzqkMvWm9NEQaIb3FNtmhHXeBAT/iWcSCvi8nCGuqmgIiSPKigeXakUMMq
3Wz8ekrQ4h+duRWImIxKpyavIzBRMbVx2G8kVUd5oIF+EcKMnUas3/91qGssfSAA
qzFPXfCn5Kc=
=l8Cm
-----END PGP SIGNATURE-----

Downs MicroSystems Pty Ltd
145 Margaret Street
Toowoomba Qld 4350
Ph. (07) 4639 3344 Fax (07) 4639 3820

Important Disclaimer and Warning

Downs MicroSystems does not represent or warrant that any attached files are
free from computer viruses or other defects. The attached files are
provided, and may only be used, on the basis that the user assumes all
responsibility for any loss, damage or consequences resulting directly or
indirectly from use of the attached files. The liability of Downs
MicroSystems in any event is limited to either the resupply of the attached
files or the cost of having the attached files resupplied.

NOTE: The views expressed by the individual in this message do not
necessarily reflect those of the organisation.

Downs MicroSystems is committed to protecting the privacy of individuals,
and is bound by the principles of the Commonwealth Privacy Act (1988).
Should you wish to view our Privacy Policy, please visit
www.downsmicro.com.au.

The information contained in this message is confidential and may be legally
privileged. The message is intended solely for the addressee(s). If you are
not the intended recipient, you are hereby notified that any use,
dissemination, or reproduction is strictly prohibited and may be unlawful.
If you are not the intended recipient, please contact the sender by return
e-mail and destroy all copies of the original message.
Received on Wed Jul 30 2003 - 00:23:45 MDT