Re: Why a Concurrent Serializable Transaction Conflict?

--- Tobias Downer <toby <at> mckoi.com> wrote:
> M. A. Sridhar wrote:
> > 
> > If you will allow one more follow-up: I am trying to find a way to detect
> the
> > cause of this conflict. Based on my understanding of my code, this
> conflict
> > should not occur. But since it is, I would like to obtain as much
> information
> > as possible as to where in my application the concurrent updates/deletes
> are
> > occurring. Is there any way to tell Mckoi to include additional
> information
> > in the exception message, or perhaps in a debug log when such an error
> > occurs? Since (I'm guessing) the engine maintains a history of all the
> change
> > commands that occurred in the transaction so that it can play back the
> > history at the point of commit, the engine should be able to show these
> > commands in a debug log. Is this true? If so, how would I enable such
> debug
> > output?
> > 
> > I could, of course, change the debug_level parameter to something lower
> than
> > 30, but that would log ALL commands, right? And that would be much more
> data
> > than I need here -- all I need is the commands that caused the problem to
> > occur.
> 
> To log all commands on the database, add the following property to your 
> database configuration;
> 
>    query_logging=enabled
> 
> This will cause a file to be created in the log directory that logs all 
> the commands and the connections on which the commands are executed. 
> This information should help you track down the problem.
> 
> Toby.
> 
> 
But let me restate my question. If I enable query logging, I will end up with
a very large log file, because this problem occurs only when my web
application is being subjected to a stress test. So I'm really only
interested in the state of the system at the point of the crash. So I guess
what I am looking for is a way to tell Mckoi to produce a detailed log only
when it runs into this situation.

Is that possible? 

Thanks and regards.

=====
------
M. A. Sridhar

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com