Symptom
An attempt to run a repair with CALL CHECK_TABLE_CONSISTENCY('REPAIR_PARTITIONING_DATA','<schema_name>','<table_name>') fails with the error 2982 "A communication error occurred, with the HDB TcpIp Server".
The indexserver trace file shows a timeout error message:
[771099]\{361546\}[-1/-1] 2024-11-20 12:50:02.123719 i TraceContext TraceContext.cpp(01367) : UserName=SYSTEM, ApplicationUserName=XXXXXX, ApplicationName=HDBStudio, ApplicationSource=csns.sql.editor.SQLExe
cuteFormEditor$4$1.run(SQLExecuteFormEditor.java:938);, StatementHash=4a20ef4c0c15bd553fa81600dc8f9d41, StatementExecutionID=844438794792046
[771099]\{361546\}[-1/-1] 2024-11-20 12:50:02.123719 w TrexNet Channel.cpp(00510) : active SSL channel (since 1801770598mues) 114289 with request-id 8848580143244970691 {0x00fffd50880417a0: id=114289, channel={<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=72057355248478232, fd=2065, refCnt=1, local=192.168.2.224/xxxxx_tcp, remote=192.168.2.231/xxxxx_tcp, state=Connected, pending=[----]}}}} from 41006 to 192.168.2.231:xxxxx [rx-stats: sb=0,ub=0,sc=0,uc=0][tx-stats: sb=3215,ub=3186,sc=1,uc=1][buf: I/0][flush: 1732101600353334][rdit: 1801][ssl-epoch: 1] with method search with id 8848580143244970691 on host xxxxxxxx on port xxxxx from process hdbindexserver with service port xxxxx, pid 756602 and tid 771099 started at 1732101600353157: reading failed with timeout error; timeout=1800005ms (1801770383461ns elapsed)
Read more...
Environment
SAP HANA Platform Edition 2.0
Keywords
2982, A communication error occurred, with the HDB TcpIp Server, consistency, check, CHECK_TABLE_CONSISTENCY('REPAIR_PARTITIONING_DATA , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB , SAP HANA Database , HAN-DB-PER , SAP HANA Database Persistence , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview