Support Questions

Find answers, ask questions, and share your expertise

Network error: recv error: Connection reset by peer (error 104)

avatar
New Contributor

Hi Team, I am getting below error while running simple update statement also NTP frequently crashing. Query: UPDATE T_GOLDEN_ID_MASTER SET T_GOLDEN_ID_MASTER.GID = T_GOLDEN_PAIRS.GID FROM T_GOLDEN_ID_MASTER INNER JOIN T_GOLDEN_PAIRS ON T_GOLDEN_ID_MASTER.EMAIL = T_GOLDEN_PAIRS.LEFT1 Query submitted at: 2019-04-01 14:23:59 (Coordinator: http://x.x.x.x:25000) Query progress can be monitored at: http://x.x.x.x:25000/query_plan?query_id=1942482780696934:1be9ca8300000000 WARNINGS: Kudu error(s) reported, first error: Timed out: Failed to write batch of 21998 ops to tablet 5a3ff383cd97495d836b761efe2f7618 after 532 attempt(s): Failed to write to server: (no server available): Write(tablet: 5a3ff383cd97495d836b761efe2f7618, num_ops: 21998, num_attempts: 532) passed its deadline: Network error: recv error: Connection reset by peer (error 104) Error in Kudu table 'impala::ap_db.T_GOLDEN_ID_MASTER': Timed out: Failed to write batch of 21998 ops to tablet 5a3ff383cd97495d836b761efe2f7618 after 532 attempt(s): Failed to write to server: (no server available): Write(tablet: 5a3ff383cd97495d836b761efe2f7618, num_ops: 21998, num_attempts: 532) passed its deadline: Network error: recv error: Connection reset by peer (error 104) (1 of 66027 similar) NTP Error: Unable to read clock for last 10.258s: Service unavailable: Error reading clock. Clock considered unsynchronized I am using below Kudu configuration and rest is default configuration. maintenance_manager_num_threads = 4 memory_limit_hard_bytes = 25 GB block_cache_capacity_mb = 4GB Also I observed , query is pointing to single tablet server instead of 3 table servers, each server has 32GB RAM. Can someone please help ASAP to solve this issue ..? thank you in advance.

1 REPLY 1

avatar
Rising Star

Hi Rahul,

 

The error you encountered "Service unavailable: Error reading clock. Clock considered unsynchronized" means either the NTP is not installed, or if the clock is reported as unsynchronized, see NTP Clock Synchronization for trouble shooting.

Best,

Hao