Repmgr : It automatically promotes to new master but other standby stopped

I’m trying to setup postgre with repmgr and here is the rsult

enter image description here

The scenario is,

  1. i tried to spinup 1 primary and 2 standby.
  2. then i stop the primary so the postgres-2 got promoted.
  3. Unfortunately the postgres-3 got disconnected due to some reason but here is the error log enter image description here

It looks like it was able to connect but the postgres restared and didn’t come back. 4. I spin up another standby but the master it was pointing is the old one which is postgres-1 That might be the reason why it is saying !running and still primary even if the actual primary is postgres-2.

My question is how can i make other standby not disconnected every time i promoted (automatically due to failure etc.) a new primary?

here is my repmgr.conf

NET_IF=`netstat -rn | awk '/^ {thif=substr($  0,74,10); print thif;} /^default.*UG/ {thif=substr($  0,65,10); print thif;}'` NET_IP=`ifconfig $  {NET_IF} | grep -Eo 'inet (addr:)?([0-9]*\.){3}[0-9]*' | grep -Eo '([0-9]*\.){3}[0-9]*' | grep -v ''`   HOSTNAME='postgres-'$  {my_node}  cat<<EOF > /etc/repmgr.conf     node_id=$  {my_node}     node_name=$  HOSTNAME     conninfo='host=$  {NET_IP} user=repmgr password=repmgr dbname=repmgr connect_timeout=2'     data_directory='$  {PGDATA}'      log_level=INFO     log_facility=STDERR     log_status_interval=300          pg_bindir='/usr/lib/postgresql/10/bin'     use_replication_slots=1          failover=automatic     promote_command='repmgr standby promote'     follow_command='repmgr standby follow -W' EOF 

Also, I’m running using docker extending the official postgres docker image

FROM postgres:10  RUN echo "deb stretch-pgdg main 10" \           >> /etc/apt/sources.list.d/pgdg.list  # RUN ln -s /home/postgres/repmgr.conf /etc/repmgr.conf  RUN apt-get update && apt-get install wget -y RUN apt-get install net-tools -y RUN apt-get update; apt-get install -y git make postgresql-server-dev-10 libpq-dev postgresql-10-repmgr repmgr-common  #RUN wget -c -O - | tar -xz  RUN touch /etc/repmgr.conf; \     chown postgres:postgres /etc/repmgr.conf  ENV PRIMARY_NAME=localhost ENV REPMGR_USER=repmgr ENV REPMGR_DB=repmgr ENV REPMGR_PASSWORD=repmgr  COPY postgresql.replication.conf /tmp/postgresql.replication.conf  COPY scripts/*.sh /docker-entrypoint-initdb.d/ 

Lastly, here is how i check if should be register as primary or standby

PGHOST=$  {PRIMARY_NAME}  installed=$  (psql -qAt -h $  {PGHOST} repmgr -c "SELECT 1 FROM pg_tables WHERE tablename='nodes'")  if [ "$  {installed}" != "1" ]; then     echo "Registering as PRIMARY SERVER"     repmgr primary register else     my_node=$  (grep node_id /etc/repmgr.conf | cut -d= -f 2)     is_reg=$  (psql -qAt -h $  {PGHOST} repmgr -c "SELECT 1 FROM repmgr.nodes WHERE node_id=$  {my_node}")      if [ "$  {is_reg}" != "1" ] && [ $  {my_node} -gt 1 ]; then         echo "Registering as STANDBY SERVER"          pg_ctl -D $  {PGDATA} stop -m fast         rm -Rf $  {PGDATA}/*         repmgr -h $  {PRIMARY_NAME} -d repmgr standby clone --fast-checkpoint         pg_ctl -D $  {PGDATA} start &         sleep 1         repmgr -h $  {PRIMARY_NAME} -d repmgr standby register         fi fi 

here is my update for the postgres.conf

 sed -i "s/#*\(shared_preload_libraries\).*/='repmgr'/;" $  {PGDATA}/postgresql.conf sed -i "s/#port = 5432/port = 5432/g" $  {PGDATA}/postgresql.conf sed -i "s/#max_wal_senders/max_wal_senders/g"  $  {PGDATA}/postgresql.conf sed -i "s/#wal_level/wal_level/g"  $  {PGDATA}/postgresql.conf sed -i "s/#max_replication_slots/max_replication_slots/g"  $  {PGDATA}/postgresql.conf sed -i "s/#hot_standby/hot_standby/g"  $  {PGDATA}/postgresql.conf  sed -i "s/#archive_mode = off/archive_mode = on/g"  $  {PGDATA}/postgresql.conf  echo "archive_command = '/bin/true'" >>  $  {PGDATA}/postgresql.conf 

I’m using postgres:10 and repmgr-5.0

hope someone could help me on this. Thanks,

My GSA SER stopped posting backlinks

My GSA SER stopped posting backlinks

My GSA SER stopped posting backlinks.
There are no blocked engines or search engines (IP).
It is simply too slow or not at all.
Could it be the lack of private proxies? Or can I continue using the GSA’s own proxies?
My connection is fiber optic and 70Mb of Down for 20Mb of Up.
The GSA Ser seems to be choking on posting new backlinks today.
There are no serious problems with the GSA Logs.
What should I do?

‘woocommerce_add_to_cart_redirect’ hook stopped working

I am trying to redirect directly directly to checkout when user hits “add to cart” and my code worked before but somewhere along the way it stopped working and I cannot pinpoint why.

add_filter( 'woocommerce_add_to_cart_redirect', 'rd_redirect_checkout_add_cart' );  function rd_redirect_checkout_add_cart() {    return wc_get_checkout_url(); } 

So now when i hit add to cart, the page refreshes, the item gets added to cart and that is about it. If i hit it again, it again refreshes and adds to cart. No redirection happens. this is the url

I have tried disabling all plugins, removed the redirect code, and used redirect plugin, tried everything and dont know what else to do.

Any ideas would be helpful. Thanks.

Connect-SPOService stopped working yesterday after 7pm

We have a PowerShell script that runs every hour to generate a list of SharePoint sites into a CSV file. It connects to SharePoint via these commands:

$  Username = "" $  Password = ConvertTo-SecureString -String "dumdeedum" -AsPlainText -Force $  Credential = New-Object System.Management.Automation.PSCredential -ArgumentList $  Username, $  Password Connect-SPOService -Url -Credential $  Credential 

Sometime after 7pm last night, it stopped working and generates this error:

Connect-SPOService : The sign-in name or password does not match one in the Microsoft account system. At C:\Users\username\OneDrive – Tenant\My Scripts\Test-SharePointConnection.ps1:4 char:1 + Connect-SPOService -Url https://ourtenant-admin.sharepoint.c … + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Connect-SPOService], IdcrlException + FullyQualifiedErrorId : Microsoft.SharePoint.Client.IdcrlException,Microsoft.Online.SharePoint.PowerShell.Connec tSPOService

I don’t know whether there is a fault with our SharePoint tenant or something has changed re-authentication. My suspicion is multi-factor authentication which is turned on for the account we are using but we turned that on months ago so perplexed why it might have just caused a problem.

Bluetooth Randomly Stopped

I’m using a Developer, Ubuntu shipped with it pre-installed Dell Precision 7530. Today while working, my bluetooth speakers beeped indicating they disconnected, I went to reconnect and in the bluetooth settings it’s saying “No Bluetooth Found. Plug in a dongle to use Bluetooth.” – except I’ve been using bluetooth for the entire 6 months I’ve owned the laptop so there absolutely is a dongle. I’ve restarted the computer several times, including fully off/on, and nothing. I’m at a loss. Any suggestions here?

I’ve seen other chats about bluetooth not working but they tend to be people that upgraded recently etc. – I haven’t. It just STOPPED after working fine and flawlessly.

I’m on Ubuntu 18.04 LTS.

suddenly my hdmi port stopped working

suddenly my hdmi port stopped working when i tried $ xrandr Screen 0: minimum 320 x 200, current 1920 x 1080, maximum 8192 x 8192 eDP-1 connected primary 1920×1080+0+0 (normal left inverted right x axis y axis) 309mm x 173mm 1920×1080 60.01*+ 60.01 59.97 59.96 59.93 48.01
1680×1050 59.95 59.88
1600×1024 60.17
1400×1050 59.98
1600×900 59.99 59.94 59.95 59.82
1280×1024 60.02
1440×900 59.89
1400×900 59.96 59.88
1280×960 60.00
1440×810 60.00 59.97
1368×768 59.88 59.85
1360×768 59.80 59.96
1280×800 59.99 59.97 59.81 59.91
1152×864 60.00
1280×720 60.00 59.99 59.86 59.74
1024×768 60.04 60.00
960×720 60.00
928×696 60.05
896×672 60.01
1024×576 59.95 59.96 59.90 59.82
960×600 59.93 60.00
960×540 59.96 59.99 59.63 59.82
800×600 60.00 60.32 56.25
840×525 60.01 59.88
864×486 59.92 59.57
800×512 60.17
700×525 59.98
800×450 59.95 59.82
640×512 60.02
720×450 59.89
700×450 59.96 59.88
640×480 60.00 59.94
720×405 59.51 58.99
684×384 59.88 59.85
680×384 59.80 59.96
640×400 59.88 59.98
576×432 60.06
640×360 59.86 59.83 59.84 59.32
512×384 60.00
512×288 60.00 59.92
480×270 59.63 59.82
400×300 60.32 56.34
432×243 59.92 59.57
320×240 60.05
360×202 59.51 59.13
320×180 59.84 59.32
DP-1 disconnected (normal left inverted right x axis y axis) HDMI-1 disconnected (normal left inverted right x axis y axis) tried to reboot and check but didn’t woro

Authentication to Sharepoint Online stopped working

I have a C# app using CSOM (latest version v16.1.19223.1200), and it worked fine until about mid-Aug-2019. I verified that the actual password is still valid.


using (var context = new ClientContext(SharepointFolder)) {     // Can't use current user, tried workaround linked from      var creds = System.IO.File.ReadAllLines(Path.Combine(Path.GetDirectoryName(Assembly.GetEntryAssembly().Location), "creds.txt"));     string userUpn = creds[0];     // var spassword = new System.Net.NetworkCredential(userUpn, creds[1]).SecurePassword; // tried this as well     var spassword = new SecureString();     foreach (char c in creds[1]) { spassword.AppendChar(c); }     context.Credentials = new SharePointOnlineCredentials(userUpn, spassword);      Utils.Log.Info($  "Getting page list from {context.Url}");      var pagesList = context.Web.Lists.GetByTitle("Pages");     context.Load(pagesList);     context.ExecuteQuery();  ///// throws: Microsoft.SharePoint.Client.IdcrlException  HResult=0x80048821  Message=The sign-in name or password does not match one in the Microsoft account system.      // ... } 

I’ve traced this with Fiddler, and basically got:

#   Result  Protocol Host                       URL 2   401     HTTPS    /   <<<<<<<<<< Why not the path I provided in SharepointFolder? 3   502     HTTP         /FPUrl.xml   5   200     HTTPS   /GetUserRealm.srf 7   200     HTTPS      /adfs/services/trust/2005/usernamemixed 8   200     HTTPS   /rst2.srf 

Tracing Fiddler with browser access to the same address shows me the first access to SharepointFolder, getting 302-redirected to authentication and working fine.