[MCOL-1549] Internal error: InetStreamSocket::readToMagic: Remote is closed Created: 2018-07-10  Updated: 2019-07-10  Resolved: 2019-07-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.1.4
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: ssauravy Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: hang
Environment:

centos 6.9



 Description   

We have encountered the following error in Columnstore 1.1.4 combined Single Node.
CPU: 24 Core.
Memory: 28G.
Disk: External storage 1 (DBRoot1)
Data Size: 800G

---------------------
We changed some of the major Paris marts from the defaults as follows:
[Config]
VersionBufferFileSize: 100GB
AllowDiskBasedJoin: Y
MaxOutstandingRequests: 200
PmMaxMemorySmallSide: 256M
CPUniqueLimit: 90
MemoryCheckPercent: 95
MaxFileSystemDiskUsagePct: 98
NumBlocksPct: 50
TotalUmMemory: 25

[my.cnf]
max_length_for_sort_data: 2048
innodb_buffer_pool_size = 128M

-----------------------------------------

  • If you execute the same query in one session, it succeeds.
  • Perform the same query slightly slower in two sessions.
  • When executing the same query concurrently in three sessions, all three errors occur.
      The error is as follows.

The following database error occurred: [ma-3.0.5] [10.2.14-MariaDB] Internal error: InetStreamSocket :: readToMagic: Remote is closed. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)

[Symptom]

  • There is no server connection at all. The OS is not responding at all.

Generated at Thu Feb 08 02:29:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.