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

Problems with INSERT and SELECT operations when the number of rows falls between 100 millions and 1 billion

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 5.4.3
    • Fix Version/s: 5.4.3
    • Component/s: installation
    • Labels:
      None
    • Environment:
      1 maxscale
      3 CS nodes

      Description

      Customer reported:

      Description: During some tests, we found that working with an increasing batch of data (1K, 10K, 100K, 1M, 10M, 100M, 1B rows) the ColumnStore worked as expected till we launched a SQL statement that acts on more than 100M rows. In this case, the operation stopped with the following error:

      #1815 - Internal error: InetStreamSocket::readToMagic: Remote is closed

      The SQL statement and the corresponding log are in the attached file.

      Date/time: 2020-12-04 16:21:06
      Signal: 11

      /usr/bin/ExeMgr(+0x24ad0)[0x55ab2a6d3ad0]
      /lib64/libpthread.so.0(+0xf630)[0x7f48765ee630]
      /lib64/libjoblist.so(_ZN7joblist21DistributedEngineComm5SetupEv+0xd9d)[0x7f487621b31d]
      /lib64/libjoblist.so(_ZN7joblist21DistributedEngineComm6ListenEN5boost10shared_ptrIN11messageqcpp18MessageQueueClientEEEj+0x2cb)[0x7f487621c85b]
      /lib64/libjoblist.so(+0x10bb13)[0x7f487621cb13]
      /lib64/libboost_thread-mt.so.1.53.0(+0xd1da)[0x7f48725931da]
      /lib64/libpthread.so.0(+0x7ea5)[0x7f48765e6ea5]
      /lib64/libc.so.6(clone+0x6d)[0x7f486ff3a96d]

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration