Re: [HACKERS] logical replication - still unstable after all thesemonths - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: [HACKERS] logical replication - still unstable after all thesemonths
Date
Msg-id 4818a0662c6b4d89b267ece1fd47f374@xs4all.nl
Whole thread Raw
In response to Re: [HACKERS] logical replication - still unstable after all thesemonths  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-hackers
On 2017-05-28 01:21, Mark Kirkwood wrote:
> Sorry - I see you have done this already.
> 
> On 28/05/17 11:15, Mark Kirkwood wrote:
>> Interesting - might be good to see your test script too (so we can 
>> better understand how you are deciding if the runs are successful or 
>> not).


Yes, in pgbench_derail2.sh in the cb function it says:
  if [[ "${md5_total[$port1]}" == "${md5_total[$port2]}" ]]  then    echo " ok"  else    echo " NOK"  fi

This is the final decision about success ('ok') or failure ('NOK'). (NOK 
stands for 'Not OK')

The two compared md5's (on the two ports: primary and replica) are each 
taken over a concatenation of the 4 separate md5's of the table-content 
(taken earlier in cb()).  If one or more of the 4 md5's differs, then 
that concatation-md5 will differ too.

Sorry, there is not a lot of comment







pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: [HACKERS] logical replication - still unstable after all thesemonths
Next
From: Erik Rijkers
Date:
Subject: Re: [HACKERS] logical replication - still unstable after all thesemonths