Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
1.1.4
-
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.