At 5am on Saturday - I was alerted by my ISP that my site was not responding properly
to web requests properly. I looked at the error, and saw it was getting a timeout
reaching the database (MySQL on server2)
I did the ol' /sbin/shutdown -r now on server2, it came back up, and things seemed to
start going again (server had been up without a restart since I put it into place 71
days ago).
About 5 hours later, the same thing happened. This time, I moved all my MySQL
databases from server2 to server1, and completely took server2 out of production since
it seemed it was having "issues". I changed the dsn to point to localhost instead of
the external db, and moved along.
Something strange happened though... It appeared as though sometimes it would still
grab information from server2 even though it wasn't listed in the ODBC setup.
So I said, "self... maybe it is a caching issue... just restart coldfusion, that will
take care of it". ./stop ./start and away we go.
Thinking I had completed the task of taking the problem out of the system by totally
isolating it, I took it upon myself to go out with the family for a bit of R&R. What
did I return home to? A dead website. I had one email that would have ONLY resulted
in a call to the database on server 2. Ok... maybe a hard restart is in order
(/sbin/shutdown -r now) That ought to do it!
1:00AM... site crashes again. This time I look at the first error message listed in
application.log after the crash... "Retrieval of cached query failed"... "Self? What
the heck is this?" I looked on the allaire forums doing a search for the referenced
error message. One potential solution involved changing the number of queries cached
from the default 100 up to 200. I did that.
So far <knock wood> the site has continued to function since then </knock wood>.
A few issues I would hope to have answers for
1) How can cfserver seemingly grab info from a database that is no longer listed on
the ODBC Connection setup?
2) How can a cached information survive a restart of cfserver?
3) Other than seeing the suggestion on the allaire forums, why would I have guessed to
up the maximum number of cached queries... and why would this even matter?!
4) After restarting, why don't scheduled tasks resume appropriately? Why do I have to
manually touch all of the processes to get them going again????
5) Why does this type of thing always happen on a weekend when you expect thousands
and thousands of new visitors from an advertising campaign the next day?
If you made it this far - Thanks for reading - it is appreciated.
Tim Storm
FatWallet.Com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
