Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1549

Internal error: InetStreamSocket::readToMagic: Remote is closed

    XMLWordPrintable

Details

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

      Attachments

        Activity

          People

            Unassigned Unassigned
            kyoung-yeon ssauravy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.