I installed SQL Server 2017 on Ubuntu and setup an availability group with cluster type = "None".
I set the "Availability" Mode to "Synchronous commit" and tested it. It works fine. All transactions to primary are replicated to secondary.
I then changed the "Availability Mode" to "Asynchro" and insert a row on the primary. The row was inserted with success on the primary but did not replicate to the secondary.
I then try to pause and resume the data movement. By doing so, my insert got replicated to the secondary. I then inserted another row and once again, it did not replicate to secondary.
The Database status on secondary is "Synchronizing".
In the Extended even, I can see that the "Commit_policy_Target" is showing "DoNothing" when I would expect it to show "WaitForHarden".
Has anyone else experienced that strange behavior and found a way to fix it?