sql server – how much data was lost after forced failover

Let’s consider a SQL Server AlwaysOn cluster with two nodes in asynchronous replication.
Is there any way to calculate how much data was lost after forced failover?

I mean in terms of time, to be able to know “I lost 1 hour of data or 1 minute”.
I have considered checking LSNs but I don’t know how to translate them into datetime.

WHMCS Domain Registration – Forced to use "wallets"?

Having just started selling Domains, I’m currently with eNom and wondering whether all registrars force you to use their own proprietary wal… | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1828014&goto=newpost

dnd 5e – What to do when I’m forced to make battle decisions by other players?

I’ve been playing a campaign of DnD that has been quite fun thus far. There has however been few instances in battles where I feel like I’m being forced to make some unoptimal moves in battle by the rest of the PC group. For example me being coerced into “tanking” in a narrow hallway, when I would’ve rather drawn the group of enemies to us, ultimately saving us from a lot of damage. The thing is, these moves I’m forced into aren’t usually “obviously dumb”, and would usually require some explaining why I would rather do it in another way (and the reason for my own tactics are based more on my personal experiences playing a lot of TRPG games.)

I usually tend to buckle because trying to explain my thoughts feels like it’s wasting time, and against several people it already feels discouraging to defend your stance (nevermind my tanking usually happens in Wild Shape since I play a druid character, so I can’t even speak in-game anyway). We’re also talking about tactics for the fight-wholesale, I’m not usually micromanaged on individual actions.

But I would be lying if it didn’t frustrate me be made to do less than ideal things, especially since the campaign we’re playing is generally seen as though.

How to deal with this? Should I just “go with the flow” of the rest of the party even when I don’t feel like it’s the best choice to speed the game along, or at least try to dig my heels a bit? If talking to the DM is the right choice, what should I say?

sql server – Disconnected replica when recovering from a forced failover

I’m evaluating desaster recovery using read-scale availability group on sql server 2019/win2019.
The cluster type is NONE.

The cluster works fine in general even when restarting replicas.

The issue arises when simulating a DR with the following action :

  1. Stop the SQL server service on the primary node.
  2. Force failover on secondary with ALTER AVAILABILITY GROUP (ag1) FORCE_FAILOVER_ALLOW_DATA_LOSS
  3. Start the SQL server service on the primary node.

When started, the primary node joins as primary and exhibits a split brain behaviour.
which seems to be fine following this doc :
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/perform-a-planned-manual-failover-of-an-availability-group-sql-server?view=sql-server-ver15#fail-over-the-primary-replica-on-a-read-scale-availability-group

When the previous primary replica recovers, it will also assume the primary role …

But the primary node can no more connect to the other node.
This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.
The same applies from the other node’s perspective.

In the sql server logs I’ve got a message like

A connection timeout has occurred while attempting to establish a connection to availability replica ‘xxxx(former secondary)’ with id (yyy). Either a networking or firewall issue exists, or the endpoint address provided for the replica is not the database mirroring endpoint of the host server instance.

Of course, there is no firewall or intermediate issue since I can connect again by drop/create the ag group.

Also, I used wireshark to get some insights into the traffic:

enter image description here

The flow looks okay, but the retransmits show some kind of “misunderstanding” between the nodes.

This seems like a software issue on sql server.

Appendix:

Sql server version:

Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64)   Jul 25 2020 11:26:55   Copyright (C) 2019 Microsoft Corporation  Enterprise Evaluation Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) 

The cluster config

    CREATE AVAILABILITY GROUP (ag1)
    WITH (CLUSTER_TYPE = NONE)
    FOR REPLICA ON
        N'replica-node1' WITH (
            ENDPOINT_URL = N'tcp://10.61.137.7:5022',
            AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,
            FAILOVER_MODE = MANUAL,
            SEEDING_MODE = AUTOMATIC,
            SESSION_TIMEOUT  = 30,
            SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL )
            ),
        N'replica-node2' WITH ( 
            ENDPOINT_URL = N'tcp://10.61.137.4:5022',
            AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,
            FAILOVER_MODE = MANUAL,
            SEEDING_MODE = AUTOMATIC,
            SESSION_TIMEOUT  = 30,
            SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL  )
            );

plotting – how to define an example of ODE that represents an undamped forced oscillator whose time evolution is described by beats

Not really a mathematica problem but here is something to get you going in the Wolfram Language.

eqn = x''(t) + (2 π 100)^2 x(t) == f(t);
ic = {x'(0) == 0, x(0) == 0};
f(t_) := Sin(110 2 π t);
sol = NDSolve(Join({eqn}, ic), {x}, {t, 0, 0.2});
Plot(Evaluate(x(t) /. First(sol)), {t, 0, 0.2})

Plot from oscillator

Here I have made an oscillator with a natural frequency of 100 Hz and then applied a force with a frequency of 110 Hz.

The equation you are after is called eqn. The initial conditions are ic and the force has been defined as f(t).

You should be able to copy and paste that into Mathematica and get the plot I have shown.

Good luck

security – Google Play services running electronics Forced Shut

How can someone that broke into my gmail, keep activating My Google Account after I deactivated the account July 29th, same day it was reopened, not by I…..
It Activated my New Phone with all being Forced Shut, due to me thinking the Google was Shut Down .
Every Permission is on in the background, running my SD and rewriting SD card, returning phone calls, stops my messages, pic going through, puts a Halt to my phone, stating Only emergency calls, or out of service area ..
May anyone help me out, my whole tablet has been compromised also, all being ran through Safari through a Mac OS X, I go to Walgreens to download the Pics of My Mom and I that just passed away, only compatible to a Mac OS X or PC, I own none…enter image description here

8 – Can users be forced to insert only plain text by default in CKEditor?

I know there is “Paste from Word” button in CKEditor, and I can limit allowed HTML tags.
But it’s very hard to explain clients to use specific button when they insert text.
As result they often insert “dirt” texts with HTML tags.

As I remember there was setting in early versions of CKEditor to force insert plain text by default but cannot find it in current version.

Is there any solution for the problem?

dnd 5e – Can Major Image and forced perspective make illusions appear larger?

In the game I’m running, the PCs are about to embark on a wilderness trek during which they will be harried by an opponent who has access to the major image spell. This opponent seeks to distract, mislead, and delay them, forcing them to spend more time and resources reaching their objective than they would otherwise.

I am trying to determine what is possible within the constraints of the major image spell description. One thing that occurred to me is that, while the spell’s effects are confined to a 20′ cube, they might seem to be spread over a much greater area by tricks of forced perspective. For example, an illusory, 20′ tall castle suspended in mid-air between the party and a distant hill might appear to be a full-size castle settled on the hill. Or a 20′ wide illusion of a wall of flames might seem to be consuming a vast span of the horizon.

Or alternatively, an illusory pit might seem to be much deeper than 20′ by “drawing” its walls and bottom in such a way as to make it seem deeper.

Can forced perspective be used with major image in this way?

Are there potential drawbacks to allowing this? Would any modifiers be appropriate for investigation checks to “disbelieve” them?

dnd 5e – Illusions and forced perspective

In the game I’m running, the PCs are about to embark on a wilderness trek during which they will be harried by an opponent who has access to the major image spell. This opponent seeks to distract, mislead, and delay them, forcing them to spend more time and resources reaching their objective than they would otherwise.

I am trying to determine what is “fair” within the constraints of the major image spell description. One thing that occurred to me is that, while the spell’s effects are confined to a 20′ cube, they might seem to be spread over a much greater area by tricks of forced perspective. For example, an illusory, 20′ tall castle suspended in mid-air between the party and a distant hill might appear to be a full-size castle settled on the hill. Or a 20′ wide illusion of a wall of flames might seem to be consuming a vast span of the horizon.

Or alternatively, an illusory pit might seem to be much deeper than 20′ by “drawing” its walls and bottom in such a way as to make it seem deeper.

Are these “fair” uses of major image? Are any modifiers appropriate for investigation checks to “disbelieve” them?