[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slony1-general
Subject:    Re: [Slony1-general] rollbacks
From:       Christopher Browne <cbbrowne () ca ! afilias ! info>
Date:       2007-06-20 15:34:01
Message-ID: 467948E9.7000106 () ca ! afilias ! info
[Download RAW message or body]

Mark wrote:
> Is it normal to have rollbacks going pretty often?
> Jun 20 11:18:01 sourceforge postgres[22285]: [3591365-2]
> "_status_reportscluster".sl_action_seq;
> Jun 20 11:18:01 sourceforge postgres[22294]: [4019490] LOG:  query:
> rollback transaction;
> Jun 20 11:18:01 sourceforge postgres[22285]: [3591366] LOG:  duration:
> 0.000318 sec
> Jun 20 11:18:01 sourceforge postgres[22285]: [3591367] LOG:  query:
> rollback transaction;
> Jun 20 11:18:01 sourceforge postgres[22294]: [4019491] LOG:  duration:
> 0.000222 sec
> Jun 20 11:18:01 sourceforge postgres[22285]: [3591368] LOG:  duration:
> 0.000209 sec
>
>
Absolutely.  There's a ROLLBACK for the read transaction each and every
SYNC that gets processed.
_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
[prev in list] [next in list] [prev in thread] [next in thread]