<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"Préformaté HTML Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.PrformatHTMLCar
{mso-style-name:"Préformaté HTML Car";
mso-style-priority:99;
mso-style-link:"Préformaté HTML";
font-family:"Courier New";
mso-fareast-language:FR;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FR" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR">Hello,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR">Configuration with three nodes, streaming mode (postgresql 9.3.3, pgpool 3.3.2, ubuntu)</span><span style="font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR"><o:p></o:p></span></p>
<p class="MsoNormal">----------------------------------------------------<o:p></o:p></p>
<p class="MsoNormal">Configuration pgpool :<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">backend_hostname0 = '172.31.4.143'<o:p></o:p></p>
<p class="MsoNormal">backend_port0 = 5432<o:p></o:p></p>
<p class="MsoNormal">backend_weight0 = 1<o:p></o:p></p>
<p class="MsoNormal">backend_data_directory0 = '/X0CPAY50_1/admin'<o:p></o:p></p>
<p class="MsoNormal">backend_flag0 = 'ALLOW_TO_FAILOVER'<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">backend_hostname1 = '172.31.4.144'<o:p></o:p></p>
<p class="MsoNormal">backend_port1 = 5432<o:p></o:p></p>
<p class="MsoNormal">backend_weight1 = 1<o:p></o:p></p>
<p class="MsoNormal">backend_data_directory1 = '/X0CPAY50_1/admin'<o:p></o:p></p>
<p class="MsoNormal">backend_flag1 = 'ALLOW_TO_FAILOVER'<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">backend_hostname2 = '172.31.4.145'<o:p></o:p></p>
<p class="MsoNormal">backend_port2 = 5432<o:p></o:p></p>
<p class="MsoNormal">backend_weight2 = 1<o:p></o:p></p>
<p class="MsoNormal">backend_data_directory2 = '/X0CPAY50_1/admin'<o:p></o:p></p>
<p class="MsoNormal">backend_flag2 = 'ALLOW_TO_FAILOVER'<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">enable_pool_hba = on<o:p></o:p></p>
<p class="MsoNormal">pool_passwd = 'pool_passwd'<o:p></o:p></p>
<p class="MsoNormal">authentication_timeout = 60<o:p></o:p></p>
<p class="MsoNormal">ssl = off<o:p></o:p></p>
<p class="MsoNormal">num_init_children = 32<o:p></o:p></p>
<p class="MsoNormal">max_pool = 4<o:p></o:p></p>
<p class="MsoNormal">child_life_time = 300<o:p></o:p></p>
<p class="MsoNormal">child_max_connections = 0<o:p></o:p></p>
<p class="MsoNormal">connection_life_time = 0<o:p></o:p></p>
<p class="MsoNormal">client_idle_limit = 0<o:p></o:p></p>
<p class="MsoNormal">connection_cache = on<o:p></o:p></p>
<p class="MsoNormal">load_balance_mode = off<o:p></o:p></p>
<p class="MsoNormal">master_slave_mode = on<o:p></o:p></p>
<p class="MsoNormal">master_slave_sub_mode = 'stream'<o:p></o:p></p>
<p class="MsoNormal">sr_check_period = 10<o:p></o:p></p>
<p class="MsoNormal">sr_check_user = 'postgres'<o:p></o:p></p>
<p class="MsoNormal">sr_check_password = 'postgres'<o:p></o:p></p>
<p class="MsoNormal">delay_threshold = 10000000<o:p></o:p></p>
<p class="MsoNormal">follow_master_command = ''<o:p></o:p></p>
<p class="MsoNormal">parallel_mode = off<o:p></o:p></p>
<p class="MsoNormal">health_check_period = 40<o:p></o:p></p>
<p class="MsoNormal">health_check_timeout = 10<o:p></o:p></p>
<p class="MsoNormal">health_check_user = 'postgres'<o:p></o:p></p>
<p class="MsoNormal">health_check_password = 'postgres'<o:p></o:p></p>
<p class="MsoNormal">health_check_max_retries = 3<o:p></o:p></p>
<p class="MsoNormal">health_check_retry_delay = 1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">failover_command = '/logiciels/pgpool/product/3.3.2/failover.sh "%d" "%h" "%p" "%D" "%m" "%H" "%M" "%P" '<o:p></o:p></p>
<p class="MsoNormal">failback_command = ''<o:p></o:p></p>
<p class="MsoNormal">fail_over_on_backend_error = off<o:p></o:p></p>
<p class="MsoNormal">search_primary_node_timeout = 10<o:p></o:p></p>
<p class="MsoNormal">recovery_user = 'postgres'<o:p></o:p></p>
<p class="MsoNormal">recovery_password = 'postgres'<o:p></o:p></p>
<p class="MsoNormal">recovery_1st_stage_command = 'basebackup.sh'<o:p></o:p></p>
<p class="MsoNormal">recovery_2nd_stage_command = ''<o:p></o:p></p>
<p class="MsoNormal">recovery_timeout = 90<o:p></o:p></p>
<p class="MsoNormal">client_idle_limit_in_recovery = 0<o:p></o:p></p>
<p class="MsoNormal">use_watchdog = off<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;padding:0cm 0cm 1.0pt 0cm">
<p class="MsoNormal" style="border:none;padding:0cm"><o:p> </o:p></p>
</div>
<p class="MsoNormal">My problem :<o:p></o:p></p>
<pre>Everything works fine except when i stop the network of the master (or unplug the server electrically) to provoke a suddenly<o:p></o:p></pre>
<pre>crash of this master and start the failover.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Initial state :<o:p></o:p></pre>
<pre>node_id | hostname | port | status | lb_weight | role<o:p></o:p></pre>
<pre>---------+--------------+------+--------+-----------+---------<o:p></o:p></pre>
<pre> 0 | 172.31.4.143 | 5432 | 2 | 0.333333 | standby<o:p></o:p></pre>
<pre> 1 | 172.31.4.144 | 5432 | 2 | 0.333333 | primary<o:p></o:p></pre>
<pre> 2 | 172.31.4.145 | 5432 | 2 | 0.333333 | standby<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Stop network for node 1 (primary) :<o:p></o:p></pre>
<pre>After the failover (the new master is node 0 and the database is ok in read/write), this is the status of pg_pool :<o:p></o:p></pre>
<pre>node_id | hostname | port | status | lb_weight | role<o:p></o:p></pre>
<pre>---------+--------------+------+--------+-----------+---------<o:p></o:p></pre>
<pre> 0 | 172.31.4.143 | 5432 | 2 | 0.333333 | standby<o:p></o:p></pre>
<pre> 1 | 172.31.4.144 | 5432 | 3 | 0.333333 | standby<o:p></o:p></pre>
<pre> 2 | 172.31.4.145 | 5432 | 2 | 0.333333 | standby<o:p></o:p></pre>
<pre>The new master (node 0) is seen like a standby role…<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>If i restart the pgpool, everything is right :<o:p></o:p></pre>
<pre>node_id | hostname | port | status | lb_weight | role<o:p></o:p></pre>
<pre>---------+--------------+------+--------+-----------+---------<o:p></o:p></pre>
<pre> 0 | 172.31.4.143 | 5432 | 2 | 0.333333 | primary<o:p></o:p></pre>
<pre> 1 | 172.31.4.144 | 5432 | 3 | 0.333333 | standby<o:p></o:p></pre>
<pre> 2 | 172.31.4.145 | 5432 | 2 | 0.333333 | standby<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">What’s append ??<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">----------------------------------------------------------------------------------------<o:p></o:p></p>
<p class="MsoNormal">Log :<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: find_primary_node: 0 node is standby<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: extended:0 query:SELECT pg_is_in_recovery()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 LOG: pid 29284: find_primary_node: primary node id is 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: starting health checking<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: health_check: 0 th DB node status: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: extended:0 query:SELECT pg_last_xlog_replay_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: extended:0 query:SELECT pg_last_xlog_replay_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: health_check: 1 th DB node status: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29334: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: health_check: 2 th DB node status: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:08 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: extended:0 query:SELECT pg_last_xlog_replay_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: extended:0 query:SELECT pg_last_xlog_replay_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:18 DEBUG: pid 29334: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:55:28 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:29 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:30 ERROR: pid 29284: connect_inet_domain_socket: select() timed out<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:30 ERROR: pid 29284: make_persistent_db_connection: connection to 172.31.4.144(5432) failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:30 ERROR: pid 29284: health check failed. 1 th host 172.31.4.144 at port 5432 is down<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:30 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:30 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:30 LOG: pid 29284: health check retry sleep time: 1 second(s)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:30 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 DEBUG: pid 29284: retrying 1 th health checking<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 DEBUG: pid 29284: health_check: 0 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 DEBUG: pid 29284: health_check: 1 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:31 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:32 ERROR: pid 29284: connect_inet_domain_socket: select() timed out<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:32 ERROR: pid 29284: make_persistent_db_connection: connection to 172.31.4.144(5432) failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:32 ERROR: pid 29284: health check failed. 1 th host 172.31.4.144 at port 5432 is down<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:32 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:32 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:32 LOG: pid 29284: health check retry sleep time: 1 second(s)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:32 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 DEBUG: pid 29284: retrying 2 th health checking<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 DEBUG: pid 29284: health_check: 0 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 DEBUG: pid 29284: health_check: 1 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:33 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:34 ERROR: pid 29284: connect_inet_domain_socket: select() timed out<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:34 ERROR: pid 29284: make_persistent_db_connection: connection to 172.31.4.144(5432) failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:34 ERROR: pid 29284: health check failed. 1 th host 172.31.4.144 at port 5432 is down<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:34 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:34 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:34 LOG: pid 29284: health check retry sleep time: 1 second(s)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:34 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 DEBUG: pid 29284: retrying 3 th health checking<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 DEBUG: pid 29284: health_check: 0 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 DEBUG: pid 29284: health_check: 1 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:35 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 ERROR: pid 29284: connect_inet_domain_socket: select() timed out<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 ERROR: pid 29284: make_persistent_db_connection: connection to 172.31.4.144(5432) failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 ERROR: pid 29284: health check failed. 1 th host 172.31.4.144 at port 5432 is down<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 LOG: pid 29284: set 1 th backend down status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler called<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: starting to select new master node<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 LOG: pid 29284: starting degeneration. shutdown host 172.31.4.144(5432)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 LOG: pid 29284: Restart all children<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29291: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29291<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29292: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29292<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29295: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29295<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29296: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29296<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29297: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29297<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29298: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29298<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29299: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29299<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29300: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29300<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29301: child received shutdown request signal 3<o:p></o:p></p>
<p class="MsoNormal">Etc….<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 DEBUG: pid 29284: failover_handler: kill 29330<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:36 LOG: pid 29284: execute command: /logiciels/pgpool/product/3.3.2/failover.sh "1" "172.31.4.144" "5432" "/X0CPAY50_1/admin" "0" "172.31.4.143" "0" "1"<o:p></o:p></p>
<p class="MsoNormal">+ failed_node_id=1<o:p></o:p></p>
<p class="MsoNormal">+ failed_host_name=172.31.4.144<o:p></o:p></p>
<p class="MsoNormal">+ failed_port=5432<o:p></o:p></p>
<p class="MsoNormal">+ failed_db_cluster=/X0CPAY50_1/admin<o:p></o:p></p>
<p class="MsoNormal">+ new_master_id=0<o:p></o:p></p>
<p class="MsoNormal">+ new_master_host_name=172.31.4.143<o:p></o:p></p>
<p class="MsoNormal">+ old_master_id=0<o:p></o:p></p>
<p class="MsoNormal">+ old_primary_node_id=1<o:p></o:p></p>
<p class="MsoNormal">+ trigger=/tmp/stopstandby<o:p></o:p></p>
<p class="MsoNormal">+ '[' 1 = 1 ']'<o:p></o:p></p>
<p class="MsoNormal">+ ssh -n -o PasswordAuthentication=no 172.31.4.143 'touch /tmp/stopstandby'<o:p></o:p></p>
<p class="MsoNormal">+ ssh -n -o PasswordAuthentication=no 172.31.4.143 'sed '\''/hot_standby/d'\'' /X0CPAY50_1/admin/postgresql.conf >>/X0CPAY50_1/admin/postgresql.conf_tmp<o:p></o:p></p>
<p class="MsoNormal"> mv /X0CPAY50_1/admin/postgresql.conf_tmp /X0CPAY50_1/admin/postgresql.conf<o:p></o:p></p>
<p class="MsoNormal"> sed '\''/wal_level/d'\'' /X0CPAY50_1/admin/postgresql.conf >>/X0CPAY50_1/admin/postgresql.conf_tmp<o:p></o:p></p>
<p class="MsoNormal"> mv /X0CPAY50_1/admin/postgresql.conf_tmp /X0CPAY50_1/admin/postgresql.conf<o:p></o:p></p>
<p class="MsoNormal"> sed '\''/max_wal_senders/d'\'' /X0CPAY50_1/admin/postgresql.conf >>/X0CPAY50_1/admin/postgresql.conf_tmp<o:p></o:p></p>
<p class="MsoNormal"> mv /X0CPAY50_1/admin/postgresql.conf_tmp /X0CPAY50_1/admin/postgresql.conf<o:p></o:p></p>
<p class="MsoNormal"> echo "wal_level = hot_standby" >> /X0CPAY50_1/admin/postgresql.conf<o:p></o:p></p>
<p class="MsoNormal"> echo "max_wal_senders = 3" >> /X0CPAY50_1/admin/postgresql.conf<o:p></o:p></p>
<p class="MsoNormal"> '<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:37 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">+ ssh -n -o PasswordAuthentication=no 172.31.4.143 'source /home/postgres/.profile;nohup /logiciels/postgres/product/9.3/bin/pg_ctl restart -D /X0CPAY50_1/admin > /dev/null 2>&1&'<o:p></o:p></p>
<p class="MsoNormal">+ exit 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:38 LOG: pid 29284: find_primary_node_repeatedly: waiting for finding a primary node<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:38 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:38 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:38 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:38 DEBUG: pid 29284: reap_handler called<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:38 DEBUG: pid 29284: reap_handler: exited due to switching<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:38 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:39 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:39 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:39 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:39 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:40 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:40 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:40 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:40 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:40 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:41 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:41 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:41 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:41 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:42 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:42 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:42 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:42 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:43 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:43 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:43 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:43 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:44 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:44 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:44 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:44 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:45 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:45 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:45 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:45 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:46 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:46 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:46 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:46 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:47 ERROR: pid 29284: s_do_auth: expecting R got E<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:47 ERROR: pid 29284: make_persistent_db_connection: s_do_auth failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:47 ERROR: pid 29284: find_primary_node: make_persistent_connection failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:47 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 LOG: pid 29284: failover: set new primary node: -1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 LOG: pid 29284: failover: set new master node: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29484: I am 29484<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29485: I am 29485<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29483: I am 29483<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29486: I am 29486<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29484: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29487: I am 29487<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29483: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29485: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29486: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29489: I am 29489<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29487: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29490: I am 29490<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29489: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29491: I am 29491<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29488: I am 29488<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29488: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29490: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29492: I am 29492<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29491: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29493: I am 29493<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29492: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29493: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29496: I am 29496<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29495: I am 29495<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29496: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29495: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29499: I am 29499<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29498: I am 29498<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29497: I am 29497<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29494: I am 29494<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29498: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29499: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29497: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29494: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29501: I am 29501<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29502: I am 29502<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29500: I am 29500<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29503: I am 29503<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29501: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29502: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29504: I am 29504<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29500: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29503: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29505: I am 29505<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29504: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29506: I am 29506<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29505: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29506: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 LOG: pid 29334: connect_inet_domain_socket: select() interrupted. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29506: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 LOG: pid 29334: connect_inet_domain_socket: select() interrupted. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29509: I am 29509<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29510: I am 29510<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29508: I am 29508<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29511: I am 29511<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29509: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29510: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29508: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29512: I am 29512<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29511: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29513: I am 29513<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 LOG: pid 29284: failover done. shutdown host 172.31.4.144(5432)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29512: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29507: I am 29507<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29514: I am 29514<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29513: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29507: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:48 DEBUG: pid 29514: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 LOG: pid 29333: pcp child process received restart request<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 LOG: pid 29284: PCP child 29333 exits with status 256 in failover()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 LOG: pid 29284: fork a new PCP child pid 29515 in failover()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: reap_handler called<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: reap_handler: call wait3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29291 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29292 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29295 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29296 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29297 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29298 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29299 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29300 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29301 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29302 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29305 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29306 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29307 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29308 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29311 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29312 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29313 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29313 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29314 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29315 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29316 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29317 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29318 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29319 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29322 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29323 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29324 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29325 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29326 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29327 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29328 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29329 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: child 29330 exits with status 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:49 DEBUG: pid 29284: reap_handler: normally exited<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:50 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:51 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:52 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:53 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:54 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:55 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:56 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:57 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:58 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:56:59 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:00 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:01 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:02 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:03 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:04 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:05 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:06 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:07 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:08 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:09 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:10 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:11 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:12 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:13 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:14 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:15 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:16 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:17 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:18 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:19 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:20 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:21 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:22 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:23 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 LOG: pid 29334: connect_inet_domain_socket: select() timed out. retrying...<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 ERROR: pid 29334: connect_inet_domain_socket: getsockopt() detected error: No route to host<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 ERROR: pid 29334: make_persistent_db_connection: connection to 172.31.4.144(5432) failed<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 DEBUG: pid 29334: check_replication_time_lag: DB node is valid but no persistent connection<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:24 ERROR: pid 29334: check_replication_time_lag: could not connect to DB node 1, check sr_check_user and sr_check_password<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: retrying 4 th health checking<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: health_check: 0 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: health_check: 1 th DB node status: 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: health_check: 2 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:29 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 LOG: pid 29334: worker process received restart request<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29284: reap_handler called<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29284: reap_handler: call wait3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 LOG: pid 29284: worker child 29334 exits with status 256<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 LOG: pid 29284: fork a new worker child pid 29516<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29284: reap_handler: normally exited<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: I am 29516<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: pool_initialize_private_backend_status: initialize backend status<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_last_xlog_replay_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:34 LOG: pid 29516: Replication of node:2 is behind 16777360 bytes from the primary server (node:0)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: I am 29514 accept fd 6<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 LOG: pid 29514: connection received: host=[local]<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: read_startup_packet: application_name: psql<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: Protocol Major: 3 Minor: 0 database: postgres user: postgres<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: Protocol Major: 3 Minor: 0 database: postgres user: postgres<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: new_connection: connecting 0 backend<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: new_connection: connecting 1 backend<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: new_connection: skipping slot 1 because backend_status = 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: new_connection: connecting 2 backend<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length: slot: 0 length: 12<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length: slot: 2 length: 12<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_do_auth: auth kind:5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: trying md5 authentication<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: DB node id: 0 salt: aca7ec4<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: trying md5 authentication<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: DB node id: 2 salt: b987b568<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 26<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 26<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: application_name value: psql<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: application_name value: psql<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 25<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 25<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: client_encoding value: UTF8<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: client_encoding value: UTF8<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 23<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 23<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: DateStyle value: ISO, DMY<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: DateStyle value: ISO, DMY<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 25<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 25<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: integer_datetimes value: on<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: integer_datetimes value: on<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 27<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 27<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: IntervalStyle value: postgres<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: IntervalStyle value: postgres<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 20<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 20<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: is_superuser value: on<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: is_superuser value: on<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 25<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 25<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: server_encoding value: UTF8<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: server_encoding value: UTF8<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 25<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 25<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: server_version value: 9.3.3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: server_version value: 9.3.3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: server_version value: 9.3.3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 35<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 35<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: session_authorization value: postgres<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: session_authorization value: postgres<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 35<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 35<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: standard_conforming_strings value: on<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: standard_conforming_strings value: on<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 0 length: 26<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length2: master slot: 2 length: 26<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 0 th backend: name: TimeZone value: Europe/Paris<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: 2 th backend: name: TimeZone value: Europe/Paris<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length: slot: 0 length: 12<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length: slot: 2 length: 12<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_do_auth: cp->info[i]:0x7f0f69c58000 pid:21632<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_do_auth: cp->info[i]:0x7f0f69c58110 pid:13051<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_send_auth_ok: send pid 13051 to frontend<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_query_in_progress: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_command_success: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_writing_transaction: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_failed_transaction: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_transaction_isolation: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_skip_reading_from_backends: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_ignore_till_sync: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: read_kind_from_one_backend: read kind from 0 th backend Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: read_kind_from_backend: kind: Z from 0 th backend<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: read_kind_from_backend: kind: Z from 2 th backend<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: read_kind_from_backend: read kind from 2 th backend Z NUM_BACKENDS: 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: ProcessBackendResponse: kind from backend: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length: slot: 0 length: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_read_message_length: slot: 2 length: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: ReadyForQuery: transaction state:^@<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: ReadyForQuery: transaction state:I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: ProcessBackendResponse: Ready For Query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: ProcessFrontendResponse: kind from frontend Q(51)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_doing_extended_query_message: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 LOG: pid 29514: statement: show pool_nodes<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_set_query_in_progress: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: nodes reporting<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_query_in_progress: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_query_in_progress: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_set_skip_reading_from_backends: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: ProcessFrontendResponse: kind from frontend X(58)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_doing_extended_query_message: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:40 DEBUG: pid 29514: pool_unset_query_in_progress: done<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_last_xlog_replay_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:44 LOG: pid 29516: Replication of node:2 is behind 16777360 bytes from the primary server (node:0)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_last_xlog_replay_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:57:54 LOG: pid 29516: Replication of node:2 is behind 16777360 bytes from the primary server (node:0)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_last_xlog_replay_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:04 LOG: pid 29516: Replication of node:2 is behind 16777360 bytes from the primary server (node:0)<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: starting health checking<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: health_check: 0 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: health_check: 1 th DB node status: 3<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: health_check: 2 th DB node status: 2<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:09 DEBUG: pid 29284: health check: clearing alarm<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: s_do_auth: auth kind: 5<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: s_do_auth: auth kind: 0<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: s_do_auth: backend key data received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: s_do_auth: transaction state: I<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: extended:0 query:SELECT pg_current_xlog_location()<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: kind: T<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: row description received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: num_fileds: 1<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: kind: D<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: data row received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: kind: C<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: Command complete received<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: kind: Z<o:p></o:p></p>
<p class="MsoNormal">2014-11-27 13:58:14 DEBUG: pid 29516: do_query: Ready for query<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please if someone can help me it will be nice.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="325" style="width:243.75pt">
<tbody>
<tr style="height:81.0pt">
<td width="325" style="width:243.75pt;padding:0cm 0cm 0cm 0cm;height:81.0pt">
<p class="MsoNormal" style="line-height:115%"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR">Cordialement,<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:115%"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"><o:p> </o:p></span></p>
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR">Sébastien RUIZ</span></b><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR">
<br>
Consultant bases de données<br>
<br>
</span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;mso-fareast-language:FR"><a href="mailto:sruiz@cyres.fr"><span style="color:blue">sruiz@cyres.fr</span></a><span style="color:black"><br>
<br>
</span></span><a href="http://www.ingensi.com/"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:blue;mso-fareast-language:FR;text-decoration:none"><img border="0" width="134" height="31" id="Image_x0020_1" src="cid:image001.jpg@01D00A4A.A227F650" alt="cid:image001.jpg@01CF6DD8.A222B1E0"></span></a><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:7.5pt">
<td width="325" style="width:243.75pt;padding:0cm 0cm 0cm 0cm;height:7.5pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;display:none;mso-fareast-language:FR"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="325" style="width:243.75pt">
<tbody>
<tr style="height:7.5pt">
<td width="160" style="width:120.0pt;border:none;border-top:solid #929395 1.0pt;padding:0cm 0cm 0cm 0cm;height:7.5pt">
<p class="MsoNormal" style="mso-line-height-alt:7.5pt"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"> </span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black"><o:p></o:p></span></p>
</td>
<td width="165" style="width:123.75pt;border:none;border-top:solid #929395 1.0pt;padding:0cm 0cm 0cm 0cm;height:7.5pt">
<p class="MsoNormal" style="mso-line-height-alt:7.5pt"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"> <o:p></o:p></span></p>
</td>
</tr>
<tr style="height:57.75pt">
<td width="160" style="width:120.0pt;padding:0cm 0cm 0cm 0cm;height:57.75pt">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR">Direction commerciale <br>
et marketing </span></b><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"><br>
140 bis, rue de Rennes 75006 Paris<br>
Tél. : </span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#EC740F;mso-fareast-language:FR">01 72 50 01 26</span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"><o:p></o:p></span></p>
</td>
<td width="165" style="width:123.75pt;padding:0cm 0cm 0cm 0cm;height:57.75pt">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR">Centre de services <br>
</span></b><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"><br>
19-21, rue Edouard Vaillant <br>
37000 Tours<br>
Tél. : </span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#EC740F;mso-fareast-language:FR">02 47 68 48 50</span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:7.5pt">
<td width="160" style="width:120.0pt;border:none;border-bottom:solid #929395 1.0pt;padding:0cm 0cm 0cm 0cm;height:7.5pt">
<p class="MsoNormal" style="mso-line-height-alt:7.5pt"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"> <o:p></o:p></span></p>
</td>
<td width="165" style="width:123.75pt;border:none;border-bottom:solid #929395 1.0pt;padding:0cm 0cm 0cm 0cm;height:7.5pt">
<p class="MsoNormal" style="mso-line-height-alt:7.5pt"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR"> <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;display:none;mso-fareast-language:FR"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="325" style="width:243.75pt">
<tbody>
<tr style="height:3.75pt">
<td width="325" style="width:243.75pt;padding:0cm 0cm 0cm 0cm;height:3.75pt"></td>
</tr>
<tr style="height:18.75pt">
<td width="325" style="width:243.75pt;padding:0cm 0cm 0cm 0cm;height:18.75pt">
<p class="MsoNormal" style="line-height:115%"><a href="http://www.cyres.fr/"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:blue;mso-fareast-language:FR;text-decoration:none"><img border="0" width="74" height="22" id="Image_x0020_2" src="cid:image002.jpg@01D00A4A.A227F650" alt="cid:image002.jpg@01CF6DD8.A222B1E0"></span></a><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR">
</span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:115%"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR">Suivez nous sur
</span><a href="https://www.linkedin.com/company/groupe-cyres"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR;text-decoration:none"><img border="0" width="22" height="22" id="Image_x0020_7" src="cid:image003.jpg@01D00A4A.A227F650" alt="Description : Description : P:\Cyres Corporate\logo 2014\Logos signatures Mail\linkedin.jpg"></span></a><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"> </span><a href="http://www.viadeo.com/fr/profile/groupe.cyres"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:blue;mso-fareast-language:FR;text-decoration:none"><img border="0" width="22" height="22" id="Image_x0020_4" src="cid:image004.jpg@01D00A4A.A227F650" alt="Description : Description : P:\Cyres Corporate\logo 2014\Logos signatures Mail\viadeo.jpg"></span></a><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"> </span><a href="https://twitter.com/CYRESGROUPE"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR;text-decoration:none"><img border="0" width="22" height="22" id="Image_x0020_8" src="cid:image005.jpg@01D00A4A.A227F650" alt="Description : Description : P:\Cyres Corporate\logo 2014\Logos signatures Mail\twitter.jpg"></span></a><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"> </span><a href="https://plus.google.com/+CyresFr/posts"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR;text-decoration:none"><img border="0" width="22" height="22" id="Image_x0020_6" src="cid:image006.jpg@01D00A4A.A227F650" alt="Description : Description : P:\Cyres Corporate\logo 2014\Logos signatures Mail\google+.jpg"></span></a><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"> </span><a href="https://www.facebook.com/cyresgroupe"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR;text-decoration:none"><img border="0" width="22" height="22" id="Image_x0020_5" src="cid:image007.jpg@01D00A4A.A227F650" alt="Description : Description : P:\Cyres Corporate\logo 2014\Logos signatures Mail\facebook.jpg"></span></a><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:18.75pt">
<td width="325" style="width:243.75pt;padding:0cm 0cm 0cm 0cm;height:18.75pt">
<p class="MsoNormal" style="line-height:115%"><span style="mso-fareast-language:FR"><a href="http://www.cyres.fr/"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D">Groupe Cyrès</span></a></span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"> | </span><span style="mso-fareast-language:FR"><a href="http://www.cyres.fr/publications/blog"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D">Blog
Cyrès</span></a></span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"> | </span><span style="mso-fareast-language:FR"><a href="http://www.ingensi.com/"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D">Ingensi</span></a></span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"> | </span><span style="mso-fareast-language:FR"><a href="http://www.hosteam.fr/"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D">Hosteam</span></a></span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"> | </span><span style="mso-fareast-language:FR"><a href="http://interactive.cyres.fr/"><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D">Interactive</span></a></span><span style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif;color:#4B4B4D;mso-fareast-language:FR"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="mso-fareast-language:FR"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>