[MCOL-4841] ExeMgr Crashes after large join - IDB-2004: Cannot connect to ExeMgr - requires restart - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 6.2.2
Fix Version/s: 6.3.1
Component/s: None
Labels:
- mcs_cs

Sprint:
2021-10, 2021-11, 2021-12, 2021-13, 2021-14, 2021-15, 2021-16, 2021-17

Description

Exemgr (sometimes primproc) crashes on large queries with joins in SkySQL and docker. Requiring a restart of the cluster/node to spin exemgr back up.

clients and users see the following when sending additional queries
ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.

Expected Results:
A graceful error of the query, ideally with a reason why (need more ram, storage, cpu etc.) that doesn't require restarting services to make other queries afterward.

Steps to reproduced attached along with a video of the crash

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

crashDockerReproductionSteps
1.0 kB
2021-08-19 20:29
DockerExemgrCrash.mov
9.62 MB
2021-08-19 20:29

Issue Links

causes

MCOL-5009 test202 causes deadlock

Closed

relates to

MCOL-4626 Columnstore cluster becomes non operational when running out of memory on a query

Closed

Activity

People

Assignee:: Daniel Lee (Inactive)

Reporter:: Allen Herrera

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2021-08-19 20:31

Updated:: 2024-07-08 01:36

Resolved:: 2022-03-25 16:40

Git Integration

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