An error occurred while windows was synchronizing with internet time server.

  • Thread starter Thread starter sosogh
  • Start date Start date
S

sosogh

Guest
Hi

I has a SQL alwayon AG cluster(no internet) which consist of two nodes. they are (win 2016 datacenter) :
node1: 192.168.251.108
node2: 192.168.251.24

I want to setup a high-available NTP service for those two nodes.
For cost cutting , I wonder that if I could setup NTP service on both two nodes ,
and then make the "internet time server" of those two nodes point to each other .
i.e. "internet time server" of node1 is node2 , "internet time server" of node2 is node1 .

How I setup NTP service :
reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W32Time\Parameters /v Type /t REG_SZ /d NTP /f
reg add HKLM\system\CurrentControlSet\Services\W32Time\TimeProviders\NtpServer /v Enabled /t REG_DWORD /d 0x1 /f
reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W32Time\Config /v AnnounceFlags /t REG_DWORD /d 0x5 /f
net stop w32time
net start w32time

If I click "update now" on 192.168.251.24, it is always OK.

But whenever I click the "update now" on 192.168.251.108, it always throw error :
An error occurred while windows was synchronizing with 192.168.251.24


My question is that whether I miss something or what I am tring is impossble .
Thank you

the log on 192.168.251.108 is as following

153043 01:51:16.0367737s - RPC Caller is T-NOD-AD-SQL-1\Administrator (S-1-5-21-3160128987-2750385370-1218708669-500)
153043 01:51:16.0368748s - RPC Call Attribute is local=1, kernel=0, session=0, authentication=6, protocol=2, OpNum=0
153043 01:51:16.0369441s - RPC Call - ForceResync
153043 01:51:16.0369813s - W32TmServiceMain: ********** Time Slip Notification **********
153043 01:51:16.0371234s - ClockDispln TimeSlip: SetUnsync: LI:0 S:1 RDl:0 RDs:100000000 TSF:0x0
153043 01:51:16.0375523s - TimeProvCommand([NtpClient], TPC_TimeJumped) called.
153043 01:51:16.0376534s - ClockDispln: we're a reliable time service with no time source: LS: 0, TN: 864000000000, WAIT: 86400000
153043 01:51:16.0376389s - Peer poll: Max:3600.0000000s (special) Cur:3310.2698396s153043 01:51:16.0376629s - New:01.4194816s
153043 01:51:16.0377157s - TimeProvCommand([NtpServer], TPC_TimeJumped) called.
153043 01:51:16.0377151s - PeerPollingThread: PeerListUpdated
153043 01:51:16.0377523s - W32TmServiceMain: waiting i16.000s (64.000s)
153043 01:51:16.0377752s - PeerPollingThread: PeerListUpdated
153043 01:51:16.0377931s - PeerPollingThread: waiting 1.420s
153043 01:51:16.0378551s - PeerPollingThread: waiting 1.420s
153043 01:51:17.4585376s - PeerPollingThread: WaitTimeout
153043 01:51:17.4586001s - Polling peer 192.168.251.24,0x9 (ntp.m|0x9|0.0.0.0:123->192.168.251.24:123)
153043 01:51:17.4587468s - Peer poll: Max:3600.0000000s (special) Cur:00.0000000s
153043 01:51:17.4587912s - PeerPollingThread: waiting 3600.000s
153043 01:51:17.4595327s - ListeningThread -- DataAvailEvent set for socket 1 (0.0.0.0:123)
153043 01:51:17.4596086s - ListeningThread -- response heard from 192.168.251.24:123 <- 192.168.251.108:123
153043 01:51:17.4596553s - /-- NTP Packet:
153043 01:51:17.4596707s - | LeapIndicator: 0 - no warning; VersionNumber: 3; Mode: 4 - Server; LiVnMode: 0x1C
153043 01:51:17.4596877s - | Stratum: 2 - secondary reference (syncd by (S)NTP)
153043 01:51:17.4597019s - | Poll Interval: 6 - 64s; Precision: -23 - 119.209ns per tick
153043 01:51:17.4597232s - | RootDelay: 0x0000.0043s - 0.00102234s; RootDispersion: 0x0010.0000s - 16s
153043 01:51:17.4597466s - | ReferenceClockIdentifier: 0xC0A8FB6C - source IP: 192.168.251.108
153043 01:51:17.4597642s - | ReferenceTimestamp: 0xE1BFB3BDCD69629A - 13222921789802389300ns - 153043 01:49:49.8023893s
153043 01:51:17.4597880s - | OriginateTimestamp: 0xE1BFB4157568FA95 - 13222921877458633100ns - 153043 01:51:17.4586331s
153043 01:51:17.4598109s - | ReceiveTimestamp: 0xE1BFB41575978E26 - 13222921877459343800ns - 153043 01:51:17.4593438s
153043 01:51:17.4598335s - | TransmitTimestamp: 0xE1BFB415759B7E76 - 13222921877459403900ns - 153043 01:51:17.4594039s
153043 01:51:17.4598564s - >-- Non-packet info:
153043 01:51:17.4598721s - | DestinationTimestamp: 153043 01:51:17.4598863s - 0xE1BFB41575A807F1153043 01:51:17.4599020s - - 13222921877459595200ns153043 01:51:17.4599327s - - 153043 01:51:17.4595952s
153043 01:51:17.4599634s - | RoundtripDelay: 902000ns (0s)
153043 01:51:17.4599872s - | LocalClockOffset: 259700ns - 0:00.000259700s
153043 01:51:17.4600084s - \--
153043 01:51:17.4600456s - Packet test 8 failed (bad value for root delay or root dispersion).
153043 01:51:17.4600850s - Ignoring packet that failed tests from 192.168.251.24,0x9 (ntp.m|0x9|0.0.0.0:123->192.168.251.24:123).
153043 01:51:32.0386250s - W32TmServiceMain: timeout
153043 01:51:32.0387485s - Sample Prepared at 132229218920387295 for peer 192.168.251.24,0x9 (ntp.m|0x9|0.0.0.0:123->192.168.251.24:123)
153043 01:51:32.0387951s - W32TmServiceMain: waiting 64.000s
153043 01:51:32.0410854s - RPC Call - Query provider status
153043 01:51:32.0411497s - TimeProvCommand([NtpClient], TPC_Query) called.
153043 01:51:32.0484254s - RPC Caller is T-NOD-AD-SQL-1\Administrator (S-1-5-21-3160128987-2750385370-1218708669-500)
153043 01:51:32.0484927s - RPC Call Attribute is local=1, kernel=0, session=0, authentication=6, protocol=2, OpNum=6
153043 01:51:32.0485444s - RPC Call - Query Status
153043 01:51:32.0524038s - W32TimeHandler called: SERVICE_CONTROL_PARAMCHANGE
153043 01:51:32.0524993s - W32TmServiceMain: Param change notification
153043 01:51:32.0526745s - ReadConfig: Found provider 'NtpClient':
153043 01:51:32.0527340s - ReadConfig: 'Enabled'=0x00000001
153043 01:51:32.0527720s - ReadConfig: 'DllName'='C:\windows\system32\w32time.dll'
153043 01:51:32.0527985s - ReadConfig: 'DllName'='C:\windows\system32\w32time.dll'
153043 01:51:32.0528256s - ReadConfig: 'DllName'='C:\windows\system32\w32time.dll'
153043 01:51:32.0528544s - ReadConfig: 'InputProvider'=0x00000001
153043 01:51:32.0528885s - ReadConfig: Found provider 'NtpServer':
153043 01:51:32.0529324s - ReadConfig: 'Enabled'=0x00000001
153043 01:51:32.0529723s - ReadConfig: 'DllName'='C:\windows\system32\w32time.dll'
153043 01:51:32.0529986s - ReadConfig: 'DllName'='C:\windows\system32\w32time.dll'
153043 01:51:32.0530231s - ReadConfig: 'DllName'='C:\windows\system32\w32time.dll'
153043 01:51:32.0530514s - ReadConfig: 'InputProvider'=0x00000000
153043 01:51:32.0531930s - ReadConfig: Found provider 'VMICTimeProvider':
153043 01:51:32.0532439s - ReadConfig: 'Enabled'=0x00000001
153043 01:51:32.0532782s - ReadConfig: 'DllName'='C:\windows\System32\vmictimeprovider.dll'
153043 01:51:32.0533051s - ReadConfig: 'DllName'='C:\windows\System32\vmictimeprovider.dll'
153043 01:51:32.0533305s - ReadConfig: 'DllName'='C:\windows\System32\vmictimeprovider.dll'
153043 01:51:32.0533584s - ReadConfig: 'InputProvider'=0x00000001
153043 01:51:32.0535017s - ReadConfig: 'PhaseCorrectRate'=0x00000001 (2)
153043 01:51:32.0535461s - ReadConfig: 'UpdateInterval'=0x00000064 (2)
153043 01:51:32.0535825s - ReadConfig: 'FrequencyCorrectRate'=0x00000004 (2)
153043 01:51:32.0536132s - ReadConfig: 'PollAdjustFactor'=0x00000005 (2)
153043 01:51:32.0536428s - ReadConfig: 'LargePhaseOffset'=0x02FAF080 (2)
153043 01:51:32.0536724s - ReadConfig: 'SpikeWatchPeriod'=0x00000384 (2)
153043 01:51:32.0537009s - ReadConfig: 'HoldPeriod'=0x00000005 (2)
153043 01:51:32.0537302s - ReadConfig: 'MinPollInterval'=0x00000006 (2)
153043 01:51:32.0537593s - ReadConfig: 'MaxPollInterval'=0x0000000A (2)
153043 01:51:32.0537878s - ReadConfig: 'AnnounceFlags'=0x00000005 (2)
153043 01:51:32.0538171s - ReadConfig: 'LocalClockDispersion'=0x0000000A (2)
153043 01:51:32.0538467s - ReadConfig: 'MaxNegPhaseCorrection'=0x0000D2F0 (2)
153043 01:51:32.0538766s - ReadConfig: 'MaxPosPhaseCorrection'=0x0000D2F0 (2)
153043 01:51:32.0539054s - ReadConfig: 'EventLogFlags'=0x00000002 (2)
153043 01:51:32.0539440s - ReadConfig: 'MaxAllowedPhaseOffset'=0x00000001 (2)
153043 01:51:32.0539736s - ReadConfig: 'UtilizeSslTimeData'=0x00000001 (2)
153043 01:51:32.0540032s - ReadConfig: 'TimeJumpAuditOffset'=0x00007080 (2)
153043 01:51:32.0540362s - No params changed for local clock.
153043 01:51:32.0541744s - TimeProvCommand([NtpClient], TPC_UpdateConfig) called.
153043 01:51:32.0542957s - ReadConfig: 'AllowNonstandardModeCombinations'=0x00000001 (2)
153043 01:51:32.0543309s - ReadConfig: 'CompatibilityFlags'=0x80000000 (2)
153043 01:51:32.0543613s - ReadConfig: 'SpecialPollInterval'=0x00000E10 (2)
153043 01:51:32.0543907s - ReadConfig: 'ResolvePeerBackoffMinutes'=0x0000000F (2)
153043 01:51:32.0544200s - ReadConfig: 'ResolvePeerBackoffMaxTimes'=0x00000007 (2)
153043 01:51:32.0544488s - ReadConfig: 'EventLogFlags'=0x00000001 (2)
153043 01:51:32.0544775s - ReadConfig: 'LargeSampleSkew'=0x00000003 (2)
153043 01:51:32.0545063s - ReadConfig: 'SignatureAuthAllowed'=0x00000001 (2)
153043 01:51:32.0545370s - ReadConfig: 'Type'=NTP (2)
153043 01:51:32.0545801s - ReadConfig: 'NtpServer'=192.168.251.24,0x9 (2)
153043 01:51:32.0546200s - ReadConfig: 'ManualPeerList'(parsed)='192.168.251.24,0x9'
153043 01:51:32.0546530s - NTP client telemetry enabled: 0
153043 01:51:32.0547295s - ManualPeerListUpdate: add:0 del:0 noch:1
153043 01:51:32.0547672s - StartListeningThread completed!
153043 01:51:32.0548089s - PeerPollingThread: waiting 3585.404s
153043 01:51:32.0548700s - StartPeerPollingThread completed!
153043 01:51:32.0548991s - TimeProvCommand([NtpServer], TPC_UpdateConfig) called.
153043 01:51:32.0549622s - ReadConfig: 'AllowNonstandardModeCombinations'=0x00000001 (2)
153043 01:51:32.0549955s - ReadConfig: 'EventLogFlags'=0x00000000 (0)
153043 01:51:32.0550276s - ReadConfig: 'UnsecureTimeSyncRequestsLogThrottlePeriod'=0x05265C00 (86400000)
153043 01:51:32.0552170s - ReadConfig: failed to open 'Software\Policies\Microsoft\W32Time\Config' key, treating as non-fatal
153043 01:51:32.0552573s - ReadConfig: 'RequireSecureTimeSyncRequests'=0x00000000 (2)
153043 01:51:32.0553014s - ChainTableMaxEntries using minimum value.
153043 01:51:32.0553260s - ChainTableMaxHostEntries using minimum value.
153043 01:51:32.0553486s - ChainTableEntryTimeout using minimum value.
153043 01:51:32.0553715s - ChainLoggingRate using registry/default value.
153043 01:51:32.0554020s - StartListeningThread completed!
153043 01:51:32.0554397s - PeerPollingThread: waiting 3585.404s
153043 01:51:32.0554715s - StartPeerPollingThread completed!
153043 01:51:32.0555003s - Provider list: 0 stopped, 0 started, 3 not changed.
153043 01:51:32.0555249s - W32TmServiceMain: waiting 63.986s

Continue reading...
 
Back
Top