2.1.4版本插入数据报错Failed to connect to backend,Connection timed out

Viewed 86

Caused by: java.sql.SQLException: errCode = 2, detailMessage = (10.128.24.16)[CANCELLED]Failed to connect to backend 11389: [E110]Fail to connect Socket{id=506806161407 addr=x.x.x.x:8060:45272} (0x0x7f6f52c21800): Connection timed out
[EditLog.logInsertTransactionState():1576] edit log insert transaction take a lot time, write bdb 568 ms, write binlog 1 ms

fe timeout所有配置参数:
emote_fragment_exec_timeout_ms 30000
max_stream_load_timeout_second 259200
meta_publish_timeout_ms 1000
delete_job_max_timeout_second 300
publish_version_timeout_second 30
tablet_create_timeout_second 2
hive_metastore_client_timeout_second 10
bdbje_replica_ack_timeout_second 10
stream_load_default_precommit_timeout_second 3600
point_query_timeout_ms 10000
max_load_timeout_second 259200
min_create_table_timeout_second 30
thrift_client_timeout_ms 0
min_load_timeout_second 1
tablet_delete_timeout_second 2
check_consistency_default_timeout_second 600
broker_load_default_timeout_second 14400
backup_job_default_timeout_ms 86400000
hadoop_load_default_timeout_second 259200
max_create_table_timeout_second 3600
max_cbo_statistics_task_timeout_sec 300
be_report_query_statistics_timeout_ms 60000
tablet_further_repair_timeout_second 1200
broker_timeout_ms 10000
query_audit_log_timeout_ms 5000
spark_load_default_timeout_second 86400
backend_rpc_timeout_ms 60000
stream_load_default_timeout_second 259200
check_wal_queue_timeout_threshold 180000
commit_timeout_second 30
sync_image_timeout_second 300
query_metadata_name_ids_timeout 3
insert_load_default_timeout_second 14400
max_clone_task_timeout_sec 7200
min_clone_task_timeout_sec 180
default_get_version_from_ms_timeout_second 3
alter_table_timeout_second 2592000
bdbje_lock_timeout_second 5
catalog_try_lock_timeout_ms 5000
bdbje_heartbeat_timeout_second 30

3 Answers

这个看着可能是网络问题呀,测试下网络这块的,连接可能有问题

从报错日志来看是连接有问题,帖子长时间没更新,先close

升级了2.1.6版本,又报另一个connection out
uncategorized SQLException; SQL state [HY000]; error code [1105]; errCode = 2, detailMessage = (10.128.24.238)[CANCELLED]Failed to connect to backend 11290: [E110]Fail to read from Socket{id=3621 fd=321 addr=x.x.x.x:8060:63506} (0x0x7fd410626800): Connection timed out; nested exception is java.sql.SQLException: errCode = 2, detailMessage = (x.x.x.x)[CANCELLED]Failed to connect to backend 11290: [E110]Fail to read from Socket{id=3621 fd=321 addr=x.x.x.x:8060:63506} (0x0x7fd410626800): Connection timed out