Mon Nov 12 18:13:19 PST 2007
- Previous message: [Slony1-bugs] Slony 1.2.10: Deadlock on slave during execute script
- Next message: [Slony1-bugs] [Bug 8] New: SLON_DATA_FETCH_SIZE set too low
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Mon, 12 Nov 2007, Jeff Frost wrote: > On Fri, 28 Sep 2007, Christopher Browne wrote: > >> Jeff Frost <jeff at frostconsultingllc.com> writes: >>> I think the deadlocks aren't load related but speed related. That is, >>> if the acquiring of all the locks by the execute script takes longer >>> on a slower machine, the window of opportunity for one of these >>> selects to cause a deadlock seems greater, no? They do seem to happen >>> on the slower machine more regularly than the faster one. >> >> The problem had nothing to do with deadlocks, per se, but rather with >> the fact that a refactoring of the code *broke* things by taking out a >> leading "begin;" statement. >> >> It should present no *fundamental* problem if the node hits a >> deadlock; if the deadlock affects the "EXECUTE SCRIPT" event, then the >> worst that should happen is that the work gets rolled back, and ten >> seconds later, the node retries, hopefully with greater success. >> >> The fix for this has been committed to the 1.2 branch (never was a >> problem in 2.0), so that we should have this addressed RSN. > > Will this fix be in 1.2.12? Answering my own question here. From the 1.2.12 release notes: - Fixed a problem with "EXECUTE SCRIPT" (introduced in remote_worker.c version 1.124.2.13) where moving the relevant code into a subroutine at the end led to losing the "BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;" query that needs to be the first thing run... -- Jeff Frost, Owner <jeff at frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
- Previous message: [Slony1-bugs] Slony 1.2.10: Deadlock on slave during execute script
- Next message: [Slony1-bugs] [Bug 8] New: SLON_DATA_FETCH_SIZE set too low
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-bugs mailing list