3394300 - HANA Consistency check CHECK_TABLE_CONSISTENCY runs for so long and does not finish.

Consistency check CHECK_TABLE_CONSISTENCY runs for so long and does not finish.

When you enable debug trace by setting the following parameter value to 'debug' :
indexserver.ini -> [trace] -> table_consistency_check = debug

You can see below message in indexserver trace :
[76277]\{321582\}[135/-1] 2023-10-23 16:16:43.288345 d table_consistenc ForeignKeyChecker.cc(00177) : query with chunks: SELECT xxxxxx FROM "yyyyy"."zzzzz" ....

Or if you collect runtime dump, you can see thread with callstack like below:
7972048205[thr=54889]: JobWrk820872 at
.......
26: 0x00007f89cb37c242 in EAPI::PreparedStatementHandle::executeQuery(Execution::Context&)+0x30 at PreparedStatementHandle.cpp:164 (libhdbeapi.so)
27: 0x00007f89e0b80271 in TableConsistencyCheck::ForeignKeyChecker::executeQuery(EAPI::PreparedStatementHandle&, Execution::Context&, ltt_adp::vector<ltt::shared_ptr<TableConsistencyCheck::FieldInfo, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> >, ltt::integral_constant<bool, true> > const&)+0x30 at ForeignKeyChecker.cc:102 (libhdbtableconsistencycheck.so)
28: 0x00007f89e0b8306c in TableConsistencyCheck::ForeignKeyChecker::findChunksOnIntegerTypeColumn(ltt::basic_stringstream<char, ltt::char_traits<char> >&, ltt_adp::vector<ltt::shared_ptr<TableConsistencyCheck::FieldInfo, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> >, ltt::integral_constant<bool, true> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&)+0x378 at ForeignKeyChecker.cc:179 (libhdbtableconsistencycheck.so)
29: 0x00007f89e0b7aa9b in TableConsistencyCheck::ForeignKeyChecker::checkForeignKeyOnTablePair(ltt_adp::vector<ltt::shared_ptr<TableConsistencyCheck::FieldInfo, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> >, ltt::integral_constant<bool, true> > const&, ltt::pair3<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > > const&, ltt::vector<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > > const&)+0x1827 at ForeignKeyChecker.cc:194 (libhdbtableconsistencycheck.so)
30: 0x00007f89e0b7c9b5 in TableConsistencyCheck::checkForeignKey(TableConsistencyCheck::TableInfo&, bool, TableConsistencyCheck::Actions const&, TableConsistencyCheck::ResultEntry&, EAPI::ConnectionHandle&)+0x1691 at ForeignKeyChecker.cc:412 (libhdbtableconsistencycheck.so)
31: 0x00007f89e0bbd6b1 in TableConsistencyCheck::ForeignKeyJobNode::runCheck(Execution::Context&, Execution::JobObject&)+0x240 at Request.cc:562 (libhdbtableconsistencycheck.so)

• SAP HANA 2.0 before SPS06

Hana , Consistency , CHECK_TABLE_CONSISTENCY, chunksize_in_foreignkeycheck , table_consistency_check  , KBA , HAN-DB , SAP HANA Database , Problem