Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
23.02.4, 23.10.0
-
None
-
None
-
Validated on: Single node localstorage - EC2 - Rocky 8 - 4x16
Source: Single node localstorage - Rocky 8.8 16x256
-
2023-11, 2023-12, 2024-1
Description
The query worked on 23.02.3 but now on 23.10.0 & 23.02.4 returns
ERROR 1815 (HY000): Internal error: InetStreamSocket::readToMagic: Remote is closed
or
ERROR 1815 (HY000): Internal error: DiskJoinStep::largeReader() MCS-2035: An internal error occurred. Check the error log file & contact support.
See developer notes for reproduction tar file
Reproduction:
# Works: bash cs_package_manager.sh install enterprise 10.6.14-9 --token xxxxxxxxxxx |
# Broken: bash cs_package_manager.sh install enterprise 10.6.15-10 --token xxxxxxxxxxx |
|
|
mcsSetConfig HashJoin AllowDiskBasedJoin Y
|
mcsSetConfig RowAggregation AllowDiskBasedAggregation Y
|
mcs cluster stop
|
mcs cluster start
|
|
|
mariadb < mcs_table_ddls.sql
|
|
|
bash mock.bash edf_colstore vinci_cs_tracking_t 1600000 > tmp.sql; mariadb edf_colstore < tmp.sql; |
bash mock.bash edf_colstore pl_cs_contact_t 400000 > tmp.sql; mariadb edf_colstore < tmp.sql; |
bash mock.bash edf_colstore pl_cs_question_t 400000 > tmp.sql; mariadb edf_colstore < tmp.sql; |
bash mock.bash edf_colstore pl_cs_org_unit_t 400000 > tmp.sql; mariadb edf_colstore < tmp.sql; |
bash mock.bash edf_colstore pl_cs_question_repository_t 400000 > tmp.sql; mariadb edf_colstore < tmp.sql; |
bash mock.bash edf_colstore pl_cs_answer_repository_t 400000 > tmp.sql; mariadb edf_colstore < tmp.sql; |
bash mock.bash edf_colstore pl_cs_tracking_status_t 400000 > tmp.sql; mariadb edf_colstore < tmp.sql; |
|
|
mariadb edf_colstore < large_query.sql
|
|
|
tdebug
|
# Oct 25 14:39:08 ip-172-31-24-202 Calpont[39728]: 08.345180 |0|0|0| E 00 CAL0000: /mdb/verylongdirnameforverystrangecpackbehavior/storage/columnstore/columnstore/utils/common/conststring.h@36: assertion 'mStr || mLength == 0' failed %%10%% |
