Document Type | Troubleshooting
Category | Patch/Upgrade
Applicable Product Versions | 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS
Document Number | TPATS005
Issue
When performing a SELECT statement on a specific table, the Internal Error with condition 'bin->distinct_cnt == 1' error continuously occurred. Although the issue was temporarily resolved by recollecting statistics, the same error repeatedly occurred afterward.
[COM-1636] [I] Internal Error with condition 'bin->distinct_cnt == 1' (stat.c:786) (pid=2885, sessid=1636, tid=1636, os_thr_id=5386)
Cause
The cause of the internal error occurring during query execution is the creation of an incorrect histogram on the column.
If there is an issue with the histogram information, the existing code handles it by allowing the query to continue through dynamic sampling.
However, in this case, due to exception handling logic, dynamic sampling did not operate, resulting in an internal error.
Solutions
Apply patch 316045a, which modifies the frequency histogram check logic.
CautionApply the patch through technical support provided by Tmax Tibero.
NoteBy recollecting statistics on the table and indexes where the error occurred, the issue can be temporarily circumvented.