<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>
<div>
<div>No, this is on the master.</div>
<div><br>
</div>
<div>--Rob</div>
<div>
<div id="MAC_OUTLOOK_SIGNATURE"></div>
</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:12pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Melvin Davidson <<a href="mailto:melvin6925@yahoo.com">melvin6925@yahoo.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>Melvin Davidson <<a href="mailto:melvin6925@yahoo.com">melvin6925@yahoo.com</a>><br>
<span style="font-weight:bold">Date: </span>Monday, February 29, 2016 at 10:32 AM<br>
<span style="font-weight:bold">To: </span>Rob Brucks <<a href="mailto:rob.brucks@rackspace.com">rob.brucks@rackspace.com</a>>, "<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>" <<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Slony1-general] Replication Lag?<br>
</div>
<div><br>
</div>
<div>
<div>
<div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:24px">
<div>Which server are you executing the query on?</div>
<div id="yui_3_16_0_1_1456763174449_3100">If you are executing on the master, then this definitely looks like a bug.</div>
<div id="yui_3_16_0_1_1456763174449_3130">Otherwise, if you are executing on a slave, then I would say that is the source of the problem.<br>
</div>
<div id="yui_3_16_0_1_1456763174449_2974"> </div>
<font size="4"><span style="font-weight:bold;font-family:arial;color:rgb(0, 0, 255);">Melvin Davidson
</span></font><br>
<font size="3"> Cell 720-320-0155 <br>
</font><br>
<font id="yui_3_16_0_1_1456763174449_3221" style="font-weight:bold;" size="3"><span id="yui_3_16_0_1_1456763174449_3220" style="color:rgb(128, 0, 255);">I reserve the right to fantasize. Whether or not you
</span><br style="color:rgb(128, 0, 255);">
<span id="yui_3_16_0_1_1456763174449_3222" style="color:rgb(128, 0, 255);">wish to share my fantasy is entirely up to you.
</span><img data-id="5bfde3b1-75c2-e874-5bb4-b8d4966cb1cd" style="color:rgb(128, 0, 255);" src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"><br>
www.youtube.com/unusedhero<br style="color:rgb(128, 0, 255);">
</font><font id="yui_3_16_0_1_1456763174449_3224" size="3"><span id="yui_3_16_0_1_1456763174449_3223" style="font-weight:bold;font-family:courier;">Folk Alley - All Folk - 24 Hours a day
</span><span id="yui_3_16_0_1_1456763174449_3225" style="font-weight:bold;font-family:courier;"><br>
www.folkalley.com<br>
</span></font>
<div id="yui_3_16_0_1_1456763174449_3226" dir="ltr"><br>
</div>
<font size="3"><span style="font-weight:bold;font-family:courier;"></span></font><br>
<div class="qtdSeparateBR"><br>
<br>
</div>
<div style="display: block;" id="yui_3_16_0_1_1456763174449_3181" class="yahoo_quoted">
<div id="yui_3_16_0_1_1456763174449_3180" style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 24px;">
<div id="yui_3_16_0_1_1456763174449_3179" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;">
<div id="yui_3_16_0_1_1456763174449_3178" dir="ltr"><font id="yui_3_16_0_1_1456763174449_3177" face="Arial" size="2">
<hr size="1">
<b><span style="font-weight:bold;">From:</span></b> Rob Brucks <<a href="mailto:rob.brucks@rackspace.com">rob.brucks@rackspace.com</a>><br>
<b><span style="font-weight: bold;">To:</span></b> Melvin Davidson <<a href="mailto:melvin6925@yahoo.com">melvin6925@yahoo.com</a>>; "<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>" <<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>>
<br>
<b><span style="font-weight: bold;">Sent:</span></b> Monday, February 29, 2016 11:00 AM<br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [Slony1-general] Replication Lag?<br>
</font></div>
<div id="yui_3_16_0_1_1456763174449_3187" class="y_msg_container"><br>
<div id="yiv5506687343">
<div id="yui_3_16_0_1_1456763174449_3186">
<div id="yui_3_16_0_1_1456763174449_3185">
<div id="yui_3_16_0_1_1456763174449_3184">
<div style="font-family:Calibri, sans-serif;">Everything is running on the same server. One subscriber instance has been shut down.</div>
<div style="font-family:Calibri, sans-serif;"><br clear="none">
</div>
<div id="yui_3_16_0_1_1456763174449_3183">
<div id="yui_3_16_0_1_1456763174449_3192"><font face="Courier">test_db=# select * from _sloncluster.sl_status;</font></div>
<div><font face="Courier">-[ RECORD 1 ]-------------+------------------------------</font></div>
<div><font face="Courier">st_origin | 1</font></div>
<div><font face="Courier">st_received | 3</font></div>
<div><font face="Courier">st_last_event | 5000000264</font></div>
<div><font face="Courier">st_last_event_ts | 2016-02-29 09:58:24.455544-06</font></div>
<div><font face="Courier">st_last_received | 5000000175</font></div>
<div><font face="Courier">st_last_received_ts | 2016-02-29 09:43:47.461217-06</font></div>
<div><font face="Courier">st_last_received_event_ts | 2016-02-29 09:43:38.254386-06</font></div>
<div><font face="Courier">st_lag_num_events | 89</font></div>
<div><font face="Courier">st_lag_time | 00:14:55.35601</font></div>
<div id="yui_3_16_0_1_1456763174449_3182"><font face="Courier">-[ RECORD 2 ]-------------+------------------------------</font></div>
<div><font face="Courier">st_origin | 1</font></div>
<div><font face="Courier">st_received | 2</font></div>
<div><font face="Courier">st_last_event | 5000000264</font></div>
<div><font face="Courier">st_last_event_ts | 2016-02-29 09:58:24.455544-06</font></div>
<div><font face="Courier">st_last_received | 5000000176</font></div>
<div><font face="Courier">st_last_received_ts | 2016-02-29 09:43:52.284371-06</font></div>
<div><font face="Courier">st_last_received_event_ts | 2016-02-29 09:43:48.258894-06</font></div>
<div><font face="Courier">st_lag_num_events | 88</font></div>
<div><font face="Courier">st_lag_time | 00:14:45.351502</font></div>
</div>
<div style="font-family:Calibri, sans-serif;"><br clear="none">
</div>
<div style="font-family:Calibri, sans-serif;">Thanks,</div>
<div style="font-family:Calibri, sans-serif;">--Rob</div>
<div style="font-family:Calibri, sans-serif;">
<div id="yiv5506687343MAC_OUTLOOK_SIGNATURE"></div>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</span>
</body>
</html>