Yes, I've been logging all SQL queries since the second bug report,
about a month ago. The logs get rolled often enough for this to not be
a problem.
The log files show that most transactions proceed predictably: The user
gets a list of articles from a section of the site, inserts new or
updated info for the article into the database, deletes the article
ordering data, then inserts new order data with the new article
included. But once in a while it just skips the last step, it doesn't
insert the new order data.
My primary suspicion is that this is somehow tied to session timeouts.
I added some logic to a few of the pages to test if session.isNew, but
didn't prevent an occurrence last night, possibly because the user's
session timed out in the middle of a multi-step process. I'm going to
add the same test to the rest of the jsp pages and see if this corrects
the problem.
Thank You,
Troy
On Dec 29, 2004, at 5:20 PM, Farhan Shah wrote:
can you log database activities to a file? it might be
costly to do but logging SQLs to a file might give you
some idea on whats going on and what enteries cause
the sql to fail/miss. Also, are you catching SQL
errors? may be logging those to a file will help too
__________________
Troy Davis
Technology Director
Metaphor Studio
538 Reading Road
Loft 200
Cincinnati, Ohio 45202
Tel: 513-723-0290
Fax: 513-723-0670
http://metaphorstudio.com
|