> Contrary to popular opinion, I would guess this is a coding > problem and that you are using a CFTRANSACTION that calls > upon multiple tables? What is happening is two different > transactions are locking tables and getting stuck waiting > for the other transaction to release the one's its got > locked up. > > A diagram to illustrate the point: > > TRANS_1: > - SELECT FROM tbl_a > - SELECT FROM tbl_b > > TRANS_2: > - SELECT FROM tbl_b > - SELECT FROM tbl_a > > When two users fire the transactions at the same time, the > result is the error you are experiencing.
While you're probably aware of this already, it may be worth pointing out for the benefit of others that, by default, if you have a transaction that selects from two tables, it won't prevent access to those tables from another transaction selecting from the two tables in reverse order. The selection of data typically places a shared lock on that data, allowing others to select it but not to change it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
