> -----Original Message----- > From: [email protected] [mailto:baruwa- > [email protected]] On Behalf Of Andrew Colin Kissa > Sent: 23 August 2011 16:14 > To: Baruwa users list > Subject: Re: [Baruwa] mail release never completing in web interface > > > Jason, > > On 21 Aug 2011, at 9:36 AM, Jason Ede wrote: > > > That would make sense... The name of each box is different from that used > for the web interface. All of the web IP's with the hostname used on them > are in the hosts file and the broker is on the same box as the web interface > that is used. The broker isn't clustered yet as the rabbitmq documentation > on clustering (http://www.rabbitmq.com/clustering.html) doesn't seem to > work for me and I've not had time to look at it properly yet. > > > > If I run 'select distinct hostname from messages;' then I get the base > hostnames of the servers... If I then ping the name that I use for the > interface then I get same IP as for the basename... a nslookup fails though > as it's only a hosts entry... I'll try adding a proper dns zone in and see if > it > makes any difference. > > > > Surely if it was a name resolution issue then the actual release/learn > operation wouldn't be performed? > > I spend some time looking at this, you should be able to fix it by setting > > transaction-isolation = READ-COMMITTED > > in your /etc/my.cnf file. > > Let me know it that works for you. >
Hi Andrew, It seem that it really doesn't like that when you're in a master /slave configuration... :( (1598, "Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'") Jason > - Andrew > > -- > Baruwa - www.baruwa.org > > _______________________________________________ > Baruwa mailing list > [email protected] > http://lists.baruwa.org/mailman/listinfo/baruwa > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa Keep Baruwa FREE - http://pledgie.com/campaigns/12056
