Wed Mar 24 15:51:03 PDT 2010
- Previous message: [Slony1-general] deadlock from slony cleanup
- Next message: [Slony1-general] deadlock from slony cleanup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
>So it
looks to me like the issue was caused by a ddl script
running at the same time as a >slony cleanupEvent command. Our system
requires
some dynamic changes to our db >structure (in the form of new partitions
and
things like that) these ddl scripts could run at >any time. So, how can I
best
manage this around the cleanupEvents?
I would suggest you route all DDL changes through a SLONIK EXECUTE SCRIPT. That also insures all DDL is propagated to all slaves.
Melvin Davidson
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100324/ca6a992b/attachment.htm
- Previous message: [Slony1-general] deadlock from slony cleanup
- Next message: [Slony1-general] deadlock from slony cleanup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list