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

Rand() Killing PrimProc Under Certain Circumstances

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.2
    • 6.2.1, 6.2.2
    • None
    • None
    • 2021-9, 2021-10

    Description

      • It occurs on some tables, but no others (flights, but not airlines)
      • Sometimes it blows up on limit1, sometimes on limit 2, sometimes on 10, sometimes on 10000
      • Errors vary. In case of dockers the cluster is hosed and requires recycling (on prem systemd repairs it).
      • Verified in 5.5.2 and 5.6.1

      To reproduce:

      Starting with the flights sample data (bts):
      https://github.com/mariadb-corporation/mariadb-columnstore-samples

      MariaDB [bts]> create table test as select *, md5(rand(1)) from flights;
      ERROR 1815 (HY000): Internal error: st: 0 TupleBPS::receiveMultiPrimitiveMessages() IDB-2035: An internal error occurred.  Check the error log file & contact support
       
      MariaDB [gjd]> use bts
      Database changed
      MariaDB [bts]> select rand() from flights limit 1;
      +---------------------+
      | rand()              |
      +---------------------+
      | 0.06580742547829396 |
      +---------------------+
      1 row in set (0.118 sec)
       
      MariaDB [bts]> select rand() from flights limit 2;
      ERROR 1815 (HY000): Internal error: TupleBPS::run() caught DistributedEngineComm::write: Broken Pipe error
      MariaDB [bts]>
      

      MariaDB [bts]> create table test as select *, md5(rand(1)) from flights;
      ERROR 1815 (HY000): Internal error: IDB-2045: At least one PrimProc closed the connection unexpectedly.
      

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              toddstoffel Todd Stoffel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.