<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="Courier New, Courier, monospace">Additional info fresh
from the master logs:<br>
<br>
<br>
<br>
Jeff Ross<br>
</font>(26991) [Tue Mar 31 09:24:58 2020] KID (load_sync) New kid,
sync "load_sync" alive=1 Parent=26984 PID=26991 kicked=1 <br>
(18073) [Tue Mar 31 09:37:09 2020] KID (load_sync) Warning! Aborting
due to exception for metro.load_events:? Error was CTL request<br>
(18073) [Tue Mar 31 09:37:09 2020] KID (load_sync) Kid has died,
error is: CTL request Line: 4997 <br>
FATAL: terminating connection due to idle-in-transaction timeout<br>
(26991) [Tue Mar 31 09:37:09 2020] KID (load_sync) Warning! Aborting
due to exception for metro.load:? Error was DBD::Pg::st execute
failed: server closed the connection unexpectedly\n This probably
means the server terminated abnormally\n before or while
processing the request. at /usr/share/perl5/vendor_perl/Bucardo.pm
line 9945.<br>
(26991) [Tue Mar 31 09:37:09 2020] KID (load_sync) Kid has died,
error is: DBD::Pg::st execute failed: server closed the connection
unexpectedly\n This probably means the server terminated
abnormally\n before or while processing the request. at
/usr/share/perl5/vendor_perl/Bucardo.pm line 9945. Line: 5037 Main
DB state: ? Error: none DB cargotel_cargotel state: 08000 Error: 7
DB metro_metro_sync_prod state: ? Error: none <br>
(26991) [Tue Mar 31 09:37:09 2020] KID (load_sync) Ping failed for
database cargotel_cargotel<br>
(26991) [Tue Mar 31 09:37:09 2020] KID (load_sync) Kid 26991 exiting
at cleanup_kid. Sync "load_sync" metro.load Reason: DBD::Pg::st
execute failed: server closed the connection unexpectedly\n This
probably means the server terminated abnormally\n before or while
processing the request. at /usr/share/perl5/vendor_perl/Bucardo.pm
line 9945. Line: 5037 Main DB state: ? Error: none DB
cargotel_cargotel state: 08000 Error: 7 DB metro_metro_sync_prod
state: ? Error: none <br>
(26658) [Tue Mar 31 09:37:09 2020] MCP Starting check_sync_health<br>
(36716) [Tue Mar 31 09:37:19 2020] KID (load_sync) New kid, sync
"load_sync" alive=1 Parent=26984 PID=36716 kicked=1 <br>
<br>
<br>
The secondary is an EC2 box--I can ssh into and query postgres on it
no problem.<br>
<br>
<br>
<br>
-- Jeff Ross <a class="moz-txt-link-abbreviated"
href="mailto:rossj@cargotel.com" moz-do-not-send="true">rossj@cargotel.com</a><br>
<br>
<br>
<br>
</body>
</html>
<br>
<pre style="white-space:pre-wrap;color:rgb(34,34,34);background-color:rgb(255,255,255)">The contents of this e-mail and any attachments are intended solely for the use of the named addressee(s) and may contain confidential and/or privileged information. Any unauthorized use, copying, disclosure, or distribution of the contents of this e-mail is strictly prohibited by the sender and may be unlawful. If you are not the intended recipient, please notify the sender immediately and delete this e-mail.</pre>