2 Oct 2003 03:09
Re: Why a Concurrent Serializable Transaction Conflict?
M. A. Sridhar <m_a_sridhar <at> yahoo.com>
2003-10-02 01:09:58 GMT
2003-10-02 01:09:58 GMT
--- 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