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

DDLProc[xx]: Could not connect to pmX_WriteEngineServer: Connection refused

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 22.08.2, 22.08.4, 6.4.6, 23.02.3
    • 23.10
    • None
    • 2024-2

    Description

      In CS 6.4.x and CS 22.08.4, a customer's DDLProc stops working quickly after a few create tables and a stored procedure. Attaching what I have.

      More triage is needed.

      Theres a lot of other activity on the server thats unknown to what extent its effecting columnstore. see /var/log/messages and youll see salt-minion, docker, slapd, pam_unix,postfix, prometheus and more.

      Customers Facing Issue
      ERROR 1815 (HY000): Internal error: Lost connection to DDLProc

      MariaDB [test]> CREATE TABLE `t1` (
      -> `id` int(11) NOT NULL
      -> ) ENGINE=Columnstore ;
      ERROR 1815 (HY000): Internal error: Lost connection to DDLProc
      

      Work around is to mcsShutdown, clearShm and mcsStart.

      Attachments

        Issue Links

          Activity

            allen.herrera Allen Herrera created issue -
            allen.herrera Allen Herrera made changes -
            Field Original Value New Value
            Affects Version/s 22.08.4 [ 28533 ]
            Affects Version/s 6.4.6 [ 28452 ]
            Affects Version/s 22.08.2 [ 28208 ]
            allen.herrera Allen Herrera made changes -
            Description In CS 6.4.1 and CS 22.08.4, a customer's DDLProc stops working quickly after a few create tables and a stored procedure. Attaching what I have.

            *More triage is needed.*

            Theres a lot of other activity on the server thats unknown to what extent its effecting columnstore. see /var/log/messages and youll see salt-minion, docker, slapd, pam_unix,postfix, prometheus and more.

            *Customers Facing Issue*
            ERROR 1815 (HY000): Internal error: Lost connection to DDLProc
            {code:java}
            MariaDB [test]> CREATE TABLE `t1` (
            -> `id` int(11) NOT NULL
            -> ) ENGINE=Columnstore ;
            ERROR 1815 (HY000): Internal error: Lost connection to DDLProc
            {code}

            Work around is to mcsShutdown, clearShm and mcsStart.
            In CS 6.4.x and CS 22.08.4, a customer's DDLProc stops working quickly after a few create tables and a stored procedure. Attaching what I have.

            *More triage is needed.*

            Theres a lot of other activity on the server thats unknown to what extent its effecting columnstore. see /var/log/messages and youll see salt-minion, docker, slapd, pam_unix,postfix, prometheus and more.

            *Customers Facing Issue*
            ERROR 1815 (HY000): Internal error: Lost connection to DDLProc
            {code:java}
            MariaDB [test]> CREATE TABLE `t1` (
            -> `id` int(11) NOT NULL
            -> ) ENGINE=Columnstore ;
            ERROR 1815 (HY000): Internal error: Lost connection to DDLProc
            {code}

            Work around is to mcsShutdown, clearShm and mcsStart.
            alexey.vorovich alexey vorovich (Inactive) made changes -
            Assignee Roman [ drrtuy ]
            alexey.vorovich alexey vorovich (Inactive) made changes -
            Labels mcs_cs_ihme
            drrtuy Roman made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            alexey.vorovich alexey vorovich (Inactive) made changes -
            Fix Version/s 23.02 [ 28209 ]
            alexey.vorovich alexey vorovich (Inactive) made changes -
            Labels mcs_cs_ihme mcs_cs_ihme mcs_trg
            alexey.vorovich alexey vorovich (Inactive) made changes -
            Fix Version/s 23.02 [ 28209 ]
            alexey.vorovich alexey vorovich (Inactive) made changes -
            ccalender Chris Calender (Inactive) made changes -
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked lower
            suresh.ramagiri@mariadb.com suresh ramagiri made changes -
            Affects Version/s 23.02.3 [ 28901 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Fix Version/s 23.08 [ 28540 ]
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            Labels mcs_cs_ihme mcs_trg mcs_trg
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            julien.fritsch Julien Fritsch made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            allen.herrera Allen Herrera made changes -
            julien.fritsch Julien Fritsch made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            allen.herrera Allen Herrera made changes -
            leonid.fedorov Leonid Fedorov made changes -
            Assignee Roman [ drrtuy ] Denis Khalikov [ JIRAUSER48434 ]
            AirFocus AirFocus made changes -
            Labels mcs_trg mcs_trg triage
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 201614 202078
            Zendesk active tickets 201614
            julien.fritsch Julien Fritsch made changes -
            Sprint 2024-2 [ 764 ]
            julien.fritsch Julien Fritsch made changes -
            Status Stalled [ 10000 ] Needs Feedback [ 10501 ]
            julien.fritsch Julien Fritsch made changes -
            Due Date 2025-01-13
            julien.fritsch Julien Fritsch made changes -
            Assignee Denis Khalikov [ JIRAUSER48434 ] Allen Herrera [ JIRAUSER48651 ]
            julien.fritsch Julien Fritsch made changes -
            Due Date 2025-01-13 2025-02-13
            julien.fritsch Julien Fritsch made changes -
            Status Needs Feedback [ 10501 ] Closed [ 6 ]

            People

              allen.herrera Allen Herrera
              allen.herrera Allen Herrera
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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